Link Search Menu Expand Document

Participants are expected to have some experience with basic data manipulation using R. If you are new to R and dplyr package, consider attending our beginner R worksops first. See the UBC library Research Commons event calendar.

Learning objectives

This workshop will introduce how to work with multiple data frames in R. At the end of this workshop, you will be able to:

  1. Understand the need to work with multiple data frames.
  2. Identify primary keys and foreign keys for data frames.
  3. Use different join functions to gain insights from multiple data frames.


0:00 - 0:05 Welcome and using Zoom
0:05 - 0:15 Warm-up
0:15 - 0:35 Keys
0:35 - 0:55 Joins
0:55 - 1:00 Wrap-up and Discussion
1:00 - 1:30 Optional Q & A


The following R markdown files contain R code used during the workshop. Please download the first file and open it with R Studio. The second file contains answers to exercises in the first file.


This workshop was developed by Ashley Yue Mao (Author).