Datasets in R: Transforming Data
“Organizations store data in various ways. The R programming language offers a strAIghtforward interface to work with data in relational databases and transform it to the format you need for analysis.
In this course you ll learn how to connect to relational databases using the APIs provided in the Database Interface package (DBI) in R. You ll connect to SQLite data and perform create read update and delete (CRUD) operations on your database tables.
You ll also use R functions to mutate and transform data. You ll practice renaming columns changing variable types and creating new columns from derived data.
You ll examine the tidyverse universe of data science packages and work with data in the wide and long formats.
Once you ve completed this course you ll have a strong foundation in basic data manipulation and transformation using the R programming language.”