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
Exercise instructions
- Left join the
star_destroyer
andmillennium_falcon
tables on thepart_num
andcolor_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 %>%
___