Exercise

Finding an observation that doesn't have a match

Left joins are really great for testing your assumptions about a data set and ensuring your data has integrity.

For example, the inventories table has a version column, for when a LEGO kit gets some kind of change or upgrade. It would be fair to assume that all sets (which joins well with inventories) would have at least a version 1. But let's test this assumption out in the following exercise.

Instructions

100 XP

Use a left_join to join together sets and inventory_version_1 using their common column.
filter for where the version column is NA using is.na.

Take Hint (-30 XP)