R Data Frames - dplyr vs sqldf

In my previous post I looked at the speed of importing data using five different methods. The fastest of these was fread from the data.table package, which outperformed base R read.csv, base R readRDS, read_csv from Hadley Wickham's readr and also importing the same data from an…

Faster Import with R Redux

Sometime ago I wrote a post comparing the speed of importing datasets based on their format. In that post I compared read.csv and fread, from the data.table package, for importing CSV files and also an R SQL query to read the same data from an SQLite database. The…