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

Exercise

Left joining two sets by color

In the videos and the last exercise, you joined two sets based on their part and color. What if you joined the datasets by color alone? As with the last exercise, the Millennium Falcon and Star Destroyer sets have been created and preloaded for you:

millennium_falcon <- inventory_parts_joined %>%
  filter(set_num == "7965-1")

star_destroyer <- inventory_parts_joined %>%
  filter(set_num == "75190-1")

Instructions 1/3

undefined XP
    1
    2
    3
  • Sum the quantity column by color_id in the Millennium Falcon dataset.