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_destroyerandmillennium_falcontables on thepart_numandcolor_idcolumns with the suffixes_falconand_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 %>%
___