Merging rows

Merge rows with filtering joins

While mutating joins actually merge the two data sets, filtering joins use information in one data set to filter observations in another data set.

Learning objectives

• Conduct filtering joins
• Bind columns and rows
• Familarize with set operations

Pre-meeting

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

• Read R4DS2 21.3.3 - 21.5

Class meeting

• Join with multiple columns as keys
• semi_join()
• anti_join()
• add_rows(), bind_rows()
• bind_cols()
• Set operations
• Slides and Code

Homework after the class meeting

Wrap up this lesson

• Complete the exercises

For next class meeting

• Update {dplyr} to version 1.1.0
• Read R4DS2 14