Import all tables
Next to the users
, we're also interested in the tweats
and comments
tables. However, separate dbReadTable()
calls for each and every one of the tables in your database would mean a lot of code duplication. Remember about the lapply()
function? You can use it again here! A connection is already coded for you, as well as a vector table_names
, containing the names of all the tables in the database.
This exercise is part of the course
Intermediate Importing Data in R
Exercise instructions
- Finish the
lapply()
function to import theusers
,tweats
andcomments
tables in a single call. The result, a list of data frames, will be stored in the variabletables
. - Print
tables
to check if you got it right.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Load the DBI package
library(DBI)
# Connect to the MySQL database: con
con <- dbConnect(RMySQL::MySQL(),
dbname = "tweater",
host = "courses.csrrinzqubik.us-east-1.rds.amazonaws.com",
port = 3306,
user = "student",
password = "datacamp")
# Get table names
table_names <- dbListTables(con)
# Import all tables
tables <- lapply(___, ___, conn = con)
# Print out tables