See how to join two data sets by one or more common columns using base R’s merge function, dplyr join functions, and the speedy data.table package.

I’ll load data.table and import my CSV file using data.table’s fread() function. In the code below, I’m saving the data into a data table called mydt.