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")
Latihan ini adalah bagian dari kursus
Joining Data with dplyr
Petunjuk latihan
- Left join the
star_destroyerandmillennium_falcontables on thepart_numandcolor_idcolumns with the suffixes_falconand_star_destroyer.
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
# Combine the star_destroyer and millennium_falcon tables
millennium_falcon %>%
___