Get startedGet started for free

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?"

This exercise is part of the course

Joining Data with dplyr

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Add an inner join for the colors table
sets %>%
  inner_join(inventories, by = "set_num") %>%
  inner_join(inventory_parts, by = c("id" = "inventory_id")) %>%
  ___
Edit and Run Code