Get startedGet started for free

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

View Course

Exercise instructions

  • Connect the parts and inventory_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 %>%
  ___
Edit and Run Code