Datasets in R: Transforming Data

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. 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.