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 extractversion
1
from theinventories
table; save the filter toversion_1_inventories
. - Use
anti_join
to combineversion_1_inventories
withsets
to 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 %>%
___