8.5 Resources

This section provides some pointers on resources related to joining data.

8.5.1 Help on joining tables

For more details on joining data tables with the two-table verbs of the dplyr package (Wickham, François, Henry, & Müller, 2022):

Joining tables with dplyr from RStudio cheatsheets.

Figure 8.3: Joining tables with dplyr from RStudio cheatsheets.

Read and follow the links on Wikipedia:Join_SQL for additional information.

8.5.2 Miscellaneous

For animated images of common data transformations (e.g., by using mutating or filtering joins), see

For more general information on various tidyverse topics (Wickham, 2019c):


[08_join.Rmd updated on 2022-07-15 18:31:57 by hn.]


Wickham, H. (2019c). tidyverse: Easily install and load the ’tidyverse’. Retrieved from https://CRAN.R-project.org/package=tidyverse
Wickham, H., François, R., Henry, L., & Müller, K. (2022). Dplyr: A grammar of data manipulation. Retrieved from https://CRAN.R-project.org/package=dplyr
Wickham, H., & Grolemund, G. (2017). R for data science: Import, tidy, transform, visualize, and model data. Retrieved from http://r4ds.had.co.nz