What colors are included in at least one set?
Besides comparing two sets directly, you could also use a filtering join like semi_join to find out which colors ever appear in any inventory part. Some of the colors could be optional, meaning they aren't included in any sets.
The inventory_parts and colors tables have been preloaded for you.
This exercise is part of the course
Joining Data with dplyr
Exercise instructions
- Use the
inventory_partstable to find the colors that are included in at least one set.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Use inventory_parts to find colors included in at least one set
colors %>%
___