Differences between Batman and Star Wars
In the video, you compared two sets. Now, you'll compare two themes, each of which is made up of many sets.
First, you'll need to join in the themes
. Recall that doing so requires going through the sets
first. You'll use the inventory_parts_joined
table from the video, which is already available to you in the console.
inventory_parts_joined <- inventories %>%
inner_join(inventory_parts, by = c("id" = "inventory_id")) %>%
arrange(desc(quantity)) %>%
select(-id, -version)
This exercise is part of the course
Joining Data with dplyr
Exercise instructions
- In order to join in the themes, you'll first need to combine the
inventory_parts_joined
andsets
tables. - Then, combine the first join with the
themes
table, using the suffix argument to clarify which table eachname
came from ("_set"
or"_theme"
).
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Start with inventory_parts_joined table
inventory_parts_joined %>%
# Combine with the sets table
___ %>%
# Combine with the themes table
___