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")
Questo esercizio fa parte del corso
Joining Data with dplyr
Istruzioni dell'esercizio
- Left join the
star_destroyerandmillennium_falcontables on thepart_numandcolor_idcolumns with the suffixes_falconand_star_destroyer.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
# Combine the star_destroyer and millennium_falcon tables
millennium_falcon %>%
___