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
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")) %>%
___