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")
Cet exercice fait partie du cours
Joining Data with dplyr
Instructions
- Left join the
star_destroyerandmillennium_falcontables on thepart_numandcolor_idcolumns with the suffixes_falconand_star_destroyer.
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
# Combine the star_destroyer and millennium_falcon tables
millennium_falcon %>%
___