Analyzing Data with SQL
The magic of paste0 & sqldf
Utilize the paste0 function to paste pre-set values into a string and then pass that string into a sqldf query.
Using SQL in R
Thanks to the sqldf package, using SQL in R to analyze & transform data is seamless. This post offers a tutorial & best practices.