Mastering Data Analysis with R

Merging datasets

Besides the previously described elementary actions on a single dataset, joining multiple data sources is one of the most used methods in everyday action. The most often used solution for such a task is to simply call the merge S3 method, which can act as a traditional SQL inner and left/right/full outer joiner of operations—represented in a brief summary by C.L. Moffatt (2008) as follows:

The dplyr package provides some easy ways for doing the previously presented join operations right from R, in an easy way:

• inner_join: This joins the variables of all the rows, which are found in both datasets
• left_join: This includes all the rows ...