1. Learn
  2. /
  3. Courses
  4. /
  5. Joining Data with dplyr

Exercise

What's the most common color?

Now let's join an additional table, colors, which will tell us the color of each part in each set, so that we can answer the question, "what is the most common color of a LEGO piece?"

Instructions 1/2

undefined XP
    1
    2
  • Inner join the colors table using the color_id column from the previous join and the id column from colors; use the suffixes "_set" and "_color".