April 2018
Beginner
238 pages
7h 13m
English
To install and load the libraries, we will use:
install.packages("dbplyr", repos='http://cran.us.r-project.org')install.packages("RSQLite", repos='http://cran.us.r-project.org')library(dplyr)library(RSQLite)# connect (and create) our in memory database con <- DBI::dbConnect(RSQLite::SQLite(), path = ":memory:")# load the iris dataset install.packages("datasets", repos='http://cran.us.r-project.org') library(datasets) data(iris) summary(iris)
You will get the following result:

Next we populate our database table as follows:
# populate a database table, iris, with the information from the iris DataFrame copy_to(con, iris, "iris", ...