How to use SQL within R and some performance comparisons | R Programming
There can be advantages of calling SQL from R. This Rstats tutorial shows you how to make use of RSQLite, and we also benchmark performance to dplyr and datatable to see if there is any speed difference! Subscribe to learn more about R and how you can make your code faster. 💿
00:00 Introduction and dataset
01:15 Setting up RSQLite
02:21 Translating R code to SQL
03:28 Benchmarking SQL vs dplyr & data.table
📚 Get the code here: https://github.com/MaximeRivest/dds/b...
🏎️ R performance playlist • R Programming - Performance
🧮 dplyr playlist • dplyr
#R #Rprogramming #SQL #Rtutorial #RStats #performance #RStudio #datascience #DDS #DDSR #datatable #dplyr
