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)

Deze oefening maakt deel uit van de cursus

Joining Data with dplyr

Cursus bekijken

Oefeninstructies

Combine the star_wars_parts table with the batman_parts table; use the suffix argument to include the "_batman" and "_star_wars" suffixes.
Replace all the NA values in the n_batman and n_star_wars columns with 0s.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

batman_parts %>%
  # Combine the star_wars_parts table 
  ___ %>%
  # Replace NAs with 0s in the n_batman and n_star_wars columns 
  ___

Code bewerken en uitvoeren