Joining parts and inventories
The LEGO data has many tables that can be joined together. Often times, some of the things you care about may be a few tables away (we'll get to that later in the course). For now, we know that parts
is a list of all LEGO parts, and a new table, inventory_parts
, has some additional information about those parts, such as the color_id
of each part you would find in a specific LEGO kit.
Let's join these two tables together to observe how joining parts
with inventory_parts
increases the size of your table because of the one-to-many relationship that exists between these two tables.
This exercise is part of the course
Joining Data with dplyr
Exercise instructions
- Connect the
parts
andinventory_parts
tables by their part numbers using an inner join.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Combine the parts and inventory_parts tables
parts %>%
___