Query tweater (2)
Apart from checking equality, you can also check for less than and greater than relationships, with <
and >
, just like in R.
con
, a connection to the tweater
database, is again available.
This exercise is part of the course
Intermediate Importing Data in R
Exercise instructions
- Create a data frame,
latest
, that selects thepost
column from thetweats
table observations where thedate
is higher than'2015-09-21'
. - Print out
latest
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Connect to the database
library(DBI)
con <- dbConnect(RMySQL::MySQL(),
dbname = "tweater",
host = "courses.csrrinzqubik.us-east-1.rds.amazonaws.com",
port = 3306,
user = "student",
password = "datacamp")
# Import post column of tweats where date is higher than '2015-09-21': latest
# Print latest