Get startedGet started for free

Left joining two sets by part and color

In the video, you learned how to left join two LEGO sets. Now you'll practice your ability to do this looking at two new sets: the Millennium Falcon and Star Destroyer sets. We've created these for you and they have been preloaded for you:

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

This exercise is part of the course

Joining Data with dplyr

View Course

Exercise instructions

  • Left join the star_destroyer and millennium_falcon tables on the part_num and color_id columns with the suffixes _falcon and _star_destroyer.

Hands-on interactive exercise

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

# Combine the star_destroyer and millennium_falcon tables
millennium_falcon %>%
  ___
Edit and Run Code