Full joining Batman and Star Wars LEGO parts
Now that you've got separate tables for the pieces in the batman
and star_wars
themes, you'll want to be able to combine them to see any similarities or differences between the two themes. The aggregating from the last exercise has been saved as batman_parts
and star_wars_parts
, and is preloaded for you.
batman_parts <- batman %>%
count(part_num, color_id, wt = quantity)
star_wars_parts <- star_wars %>%
count(part_num, color_id, wt = quantity)
This exercise is part of the course
Joining Data with dplyr
Exercise instructions
- Combine the
star_wars_parts
table with thebatman_parts
table; use the suffix argument to include the"_batman"
and"_star_wars"
suffixes. - Replace all the NA values in the
n_batman
andn_star_wars
columns with 0s.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
batman_parts %>%
# Combine the star_wars_parts table
___ %>%
# Replace NAs with 0s in the n_batman and n_star_wars columns
___