How to merge information in R using R combine, dplyr, or data.table


< img src=",70"alt =" "> R has a number of fast, sophisticated ways to sign up with data frames by a typical column. I want to show you three of them:

  • base R’s combine() function,
  • dplyr’s sign up with household of functions, and
  • data.table’s bracket syntax.

Get and import the data For this example I’ll utilize among my favorite demo information sets– flight hold-up times from the U.S. Bureau of Transportation Data. If you want to follow along, head to and download information for the time frame of your option with the columns Flight Date, Reporting_Airline, Origin, Location, and DepartureDelayMinutes. Likewise get the lookup table for Reporting_Airline.

Or, download these two data sets– plus my R code in a single file and a PowerPoint describing different types of data merges– here:


Includes several data files, a PowerPoint, and R script to accompany InfoWorld short article. Sharon Machlis

To check out in the file with base R, I ‘d first unzip the flight hold-up file and after that import both flight hold-up data and the code lookup file with read.csv(). If you’re running the code, the delay file you downloaded will likely have a various name than in the code listed below. Also, keep in mind the lookup file’s unusual.csv _ extension.unzip (“673598238_T_ONTIME_REPORTING. zip”)mydf IDG A left sign up with keeps all rows in the left data frame and only matching rows from the right
data frame. The code to import and merge both data sets using left_join()is below. It begins by filling the dplyr and readr bundles and after that checks out in the two files with read_csv(). When using read_csv(), I don’t need to unzip the file first.library(dplyr) library(readr )mytibble

Leave a Reply

Your email address will not be published. Required fields are marked *