Course
Joining Data with dplyr
BasicSkill Level
Updated 05/2023RData Manipulation4 hr13 videos49 Exercises4,200 XP81,091Statement of Accomplishment
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Loved by learners at thousands of companies
Training 2 or more people?
Try DataCamp for BusinessCourse Description
Prerequisites
Data Manipulation with dplyr1
Joining Tables
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.
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
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
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.
Joining Data with dplyr
Course Complete
Earn Statement of Accomplishment
Add this credential to your LinkedIn profile, resume, or CVShare it on social media and in your performance reviewEnroll Now
FAQs
What types of joins does this course teach?
You will learn six joins total: four mutating joins (inner, left, right, and full) and two filtering joins (semi and anti).
What datasets are used in this course?
You work with a LEGO dataset from Rebrickable covering sets, parts, themes, and colors, and with Stack Overflow data on nearly 300,000 R-tagged questions.
What prior R knowledge do I need?
You should be familiar with dplyr for data manipulation and the tidyverse. Prior completion of Data Manipulation with dplyr is recommended.
When would I use filtering joins like semi join and anti join?
Semi joins keep rows that have a match in another table, and anti joins keep rows that do not. They are useful for filtering data without adding extra columns.
How long does this course take to complete?
The course has 4 chapters and 49 exercises. Most learners finish it in about 3.5 hours.
Join over 19 million learners and start Joining Data with dplyr today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Grow your data skills with DataCamp for Mobile
Make progress on the go with our mobile courses and daily 5-minute coding challenges.