sqldf examples

I have become very interested in learning more about sqldf. Having used various databases software programs over the year, such as, mysql and sqlite. I have used PROC SQL in SAS for a long time. I have ventured into distributed databases such as crate, that uses SQL.

I have often suggested the building of the sqlite db of the airline data from the 2009 Data Expo Airline on-time performance.

My work in progress, sqldf Examples Rnotebook.

In this notebook I hope to:

1. Give some good examples of data sets in R to perform some basic queries.

a. diamonds

b. gapminder

c. nycflights13

2. Give some examples of base R functions that can be run on a dataframe or other data structures such as a data.table or a tribble.

3. Give some examples of the R package sqldf.

4. To give some examples of accessing an sql database from within R using a connection to an sql db.

5. Finally, I want to give some examples and some suggestions about learning to use the tidyverse and dplyr in particular.