1. Learn
  2. /
  3. Courses
  4. /
  5. Joining Data with dplyr

Exercise

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.

Instructions

100 XP
  • Connect the parts and inventory_parts tables by their part numbers using an inner join.