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

  • read Chapter 13: Relational data (Wickham & Grolemund, 2017);

  • study the vignette vignette("two-table") for two-table verbs, and vignette("dplyr") for one-table verbs of dplyr;

  • study the documentation for ?left_join, ?right_join, ?full_join, ?inner_join, etc.;

  • study https://dplyr.tidyverse.org and its examples;

  • study (the second page of) the RStudio cheatsheet on data transformation:

Joining data with 2-table verbs of **dplyr**. 
(summary from [RStudio cheatsheets](https://www.rstudio.com/resources/cheatsheets/#dplyr)).

Figure 8.3: Joining data with 2-table verbs of dplyr. (summary from RStudio cheatsheets).

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

8.5.2 Miscellaneous

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


[08_join.Rmd updated on 2020-11-20 16:56:13 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. (2020). 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