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, et al., 2023):

Joining tables with dplyr from Posit cheatsheets.

Figure 8.3: Joining tables with dplyr from Posit 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, 2023):


[08_join.Rmd updated on 2024-07-08 15:53:40.139857 by hn.]


Wickham, H. (2023). tidyverse: Easily install and load the ’tidyverse’. Retrieved from https://tidyverse.tidyverse.org
Wickham, H., François, R., Henry, L., Müller, K., & Vaughan, D. (2023). 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