1. Learn
    2. /
  2. Courses
    3. /
  3. Intermediate Importing Data in R

Exercise

Be polite and ...

Every time you connect to a database using dbConnect(), you're creating a new connection to the database you're referencing. RMySQL automatically specifies a maximum of open connections and closes some of the connections for you, but still: it's always polite to manually disconnect from the database afterwards. You do this with the dbDisconnect() function.

The code that connects you to the database is already available, can you finish the script?

Instructions

100 XP
  • Using the technique you prefer, build a data frame long_tweats. It selects the post and date columns from the observations in tweats where the character length of the post variable exceeds 40.
  • Print long_tweats.
  • Disconnect from the database by using dbDisconnect().