Datasets in R: Transforming Data
R Programming 4.0+
| Intermediate
- 14 Videos | 1h 58m 53s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this courseconnect to an in-memory SQLite database and create tablesquery database tables with dbGetQuery() and dbSendQuery()perform create, read, update, and delete operations on tablesdelete and rename columns in an R data framechange data types for variables in a data frameuse the transform() function to transform data in data frames
-
use apply() to iterate over and perform operations on data framesapply transformations on dataframes using mutate() and if_else()use the stack() and unstack() functions to reformat data framesuse the melt() and dcast() functions to reformat data framesreformat a real-world datasetuse spread() and gather() to reformat data framessummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview2m 5sUP NEXT
-
2.Working with an In-memory SQLite Table9m 9s
-
3.Connecting to and Retrieving Results from SQLite11m 1s
-
4.Updating Results with a Persistent Database11m 20s
-
5.Dropping and Renaming Columns7m 20s
-
6.Changing Column Data Types9m 50s
-
7.Transforming Data Using the Transform Function5m 54s
-
8.Transforming Data Using the Apply Function Family13m 7s
-
9.Transforming Data Using if_else() and mutate()11m 44s
-
10.Wide Form and Long Form: Using stack() and unstack()10m 32s
-
11.Wide Form and Long Form: Using melt() and dcast()7m 36s
-
12.melt() and dcast() on a Real Dataset6m 51s
-
13.Wide Form and Long Form: Using gather() and spread()9m 58s
-
14.Course Summary2m 28s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.