HomeRJoining Data with dplyr

# Joining Data with dplyr

4+
41 reviews
Beginner

Learn to combine data across multiple tables to answer more complex questions with dplyr.

4 Hours13 Videos49 Exercises
65,118 LearnersStatement of Accomplishment

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
Training 2 or more people?Try DataCamp For Business

## Course Description

### .css-1goj2uy{margin-right:8px;}Group.css-gnv7tt{font-size:20px;font-weight:700;white-space:nowrap;}.css-12nwtlk{box-sizing:border-box;margin:0;min-width:0;color:#05192D;font-size:16px;line-height:1.5;font-size:20px;font-weight:700;white-space:nowrap;}Training 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more
Try DataCamp for BusinessFor a bespoke solution book a demo.

### In the following Tracks

Certification Available

#### Data Analyst with R

Go To Track
Certification Available

Go To Track

Go To Track
1. 1

### Joining Tables

Free

Get started with your first joining verb: inner-join! You'll learn to join tables together to answer questions about the LEGO dataset, which contains information across many tables about the sets, parts, themes, and colors of LEGOs over time.

Play Chapter Now
The inner_join verb
50 xp
What columns would you join on?
50 xp
Joining parts and part categories
100 xp
Joining with a one-to-many relationship
50 xp
Joining parts and inventories
100 xp
Joining in either direction
100 xp
Joining three or more tables
50 xp
Joining three tables
100 xp
What's the most common color?
100 xp
2. 2

### Left and Right Joins

Learn two more mutating joins, the left and right join, which are mirror images of each other! You'll learn use cases for each type of join as you explore parts and colors of LEGO themes. Then, you'll explore how to join tables to themselves to understand the hierarchy of LEGO themes in the data.

3. 3

### Full, Semi, and Anti Joins

In this chapter, you'll cover three more joining verbs: full-join, semi-join, and anti-join. You'll then use these verbs to answer questions about the similarities and differences between a variety of LEGO sets.

4. 4

### Case Study: Joins on Stack Overflow Data

Put together all the types of join you learned in this course to analyze a new dataset: Stack Overflow questions, answers, and tags. This includes calculating and visualizing trends for some notable tags like dplyr and ggplot2. You'll also master one more method for combining tables, the bind_rows verb, which stacks tables on top of each other.

### GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more

### In the following Tracks

Certification Available

#### Data Analyst with R

Go To Track
Certification Available

Go To Track

#### Data Manipulation with R

Go To Track

Datasets

Collaborators

DataCamp Content Creator

Course Instructor

DataCamp offers interactive R, Python, Spreadsheets, SQL and shell courses. All on topics in data science, statistics, and machine learning. Learn from a team of expert teachers in the comfort of your browser with video lessons and fun coding challenges and projects.
See More

## Don’t just take our word for it

*4
from 41 reviews
56%
17%
7%
10%
10%
Sort by
• Susana S.
2 months

The lesson is very well designer. I found that some of the exercise questions were not clear; both the questions as well as the hint suggestions. Some times there is only um ) or something missing and the hint dies not help to solve that problem . You could add a standard suggestion to review the signaling.

• Mary C.
3 months

This was an excellent course! I wish I knew how to search courses by author to find more by the same person / team.

• Reyno A.
4 months

It's very intuitive

• Konstantinos T.
5 months

Very good explanation!

• Elisha V.
5 months

The tutorial is empowering and hands-on, and since finishing the course, I have been joining data like never before. Thank you @DataCamp. I am enjoying my courses and would love to keep up the momentum.

"The lesson is very well designer. I found that some of the exercise questions were not clear; both the questions as well as the hint suggestions. Some times there is only um ) or something missing and the hint dies not help to solve that problem . You could add a standard suggestion to review the signaling."

Susana S.

"This was an excellent course! I wish I knew how to search courses by author to find more by the same person / team."

Mary C.

"It's very intuitive"

Reyno A.