Which set is missing version 1?
Each set included in the LEGO data has an associated version number. We want to understand the version we are looking at to learn more about the parts that are included. Before doing that, we should confirm that there aren't any sets that are missing a particular version.
Let's start by looking at the first version of each set to see if there are any sets that don't include a first version.
This exercise is part of the course
Joining Data with dplyr
Exercise instructions
- Use
filter()to extractversion1from theinventoriestable; save the filter toversion_1_inventories. - Use
anti_jointo combineversion_1_inventorieswithsetsto determine which set is missing a version 1.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Use filter() to extract version 1
version_1_inventories <- inventories %>%
___
# Use anti_join() to find which set is missing a version 1
sets %>%
___