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

Exercise

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.

Instructions

100 XP
  • Use the inventory_parts table to find the colors that are included in at least one set.