Joining Data in R using dplyr

Offered By
Coursera Project Network
In this Guided Project, you will:

Perform different join operations using the merge() function

Perform different join operations using dplyr join functions

Clock2 hours
IntermediateIntermediate
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

You will need to join or merge two or more data sets at different points in your work as a data enthusiast. The dplyr package offers very sophisticated functions to help you achieve the join operation you desire. This project-based course, "Joining Data in R using dplyr" is for R users willing to advance their knowledge and skills. In this course, you will learn practical ways for data manipulation in R. We will talk about different join operations and spend a great deal of our time here joining the sales and customers data sets using the dplyr package. By the end of this 2-hour-long project, you will perform inner join, full (outer) join, right join, left join, cross join, semi join, and anti join using the merge() and dplyr functions. This project-based course is an intermediate-level course in R. Therefore, to get the most of this project, it is essential to have prior experience using R for basic analysis. I recommend that you complete the project titled: "Data Manipulation with dplyr in R" before you take this current project.

Skills you will develop

  • Data Management
  • Data Manipulation
  • Joins
  • R Programming
  • dplyr

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Getting Started

  2. Create and Clean data sets

  3. Inner Join - Part 1

  4. Inner Join - Part 2

  5. Inner Join - Part 3

  6. Full (Outer) Join

  7. Left Join

  8. Optional Practice Task: Right Join

  9. Optional Cummulative Task: Cross, Semi & Anti Join

  10. Wrap up

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.