Merging columns

Merge columns with mutating joins

Often, we have data spread across multiple data sets that need to be merged into a single data set. We’ll do this in a way that merges columns using mutating join functions from {dplyr}.

Learning objectives

• Understand the concept of a key column
• Conduct inner joins
• Conduct outer joins

Pre-meeting

To prepare for this class meeting, please do the following:

• Read R4DS2 21.1 - 21.3.2

Class meeting

• Introduce merging data
• Key columns
• inner_join()
• full_join()
• left_join()
• right_join()
• Slides and Code

Homework after the class meeting

Wrap up this lesson

• Complete the exercises

For next class meeting

• Read R4DS2 21.3.3 - 21.5