Datasets in R: Transforming Data

R Programming 4.0+    |    Intermediate
  • 14 Videos | 2h 4m 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 course
    connect to an in-memory SQLite database and create tables
    query database tables with dbGetQuery() and dbSendQuery()
    perform create, read, update, and delete operations on tables
    delete and rename columns in an R data frame
    change data types for variables in a data frame
    use the transform() function to transform data in data frames
  • use apply() to iterate over and perform operations on data frames
    apply transformations on dataframes using mutate() and if_else()
    use the stack() and unstack() functions to reformat data frames
    use the melt() and dcast() functions to reformat data frames
    reformat a real-world dataset
    use spread() and gather() to reformat data frames
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 5s
    UP NEXT
  • Playable
    2. 
    Working with an In-memory SQLite Table
    9m 9s
  • Locked
    3. 
    Connecting to and Retrieving Results from SQLite
    11m 1s
    FREE ACCESS
  • Locked
    4. 
    Updating Results with a Persistent Database
    11m 20s
    FREE ACCESS
  • Locked
    5. 
    Dropping and Renaming Columns
    7m 20s
    FREE ACCESS
  • Locked
    6. 
    Changing Column Data Types
    9m 50s
    FREE ACCESS
  • Locked
    7. 
    Transforming Data Using the Transform Function
    5m 54s
    FREE ACCESS
  • Locked
    8. 
    Transforming Data Using the Apply Function Family
    13m 7s
    FREE ACCESS
  • Locked
    9. 
    Transforming Data Using if_else() and mutate()
    11m 44s
    FREE ACCESS
  • Locked
    10. 
    Wide Form and Long Form: Using stack() and unstack()
    10m 32s
    FREE ACCESS
  • Locked
    11. 
    Wide Form and Long Form: Using melt() and dcast()
    7m 36s
    FREE ACCESS
  • Locked
    12. 
    melt() and dcast() on a Real Dataset
    6m 51s
    FREE ACCESS
  • Locked
    13. 
    Wide Form and Long Form: Using gather() and spread()
    9m 58s
    FREE ACCESS
  • Locked
    14. 
    Course Summary
    2m 28s
    FREE ACCESS

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.

YOU MIGHT ALSO LIKE

COURSE Data Nuts & Bolts: Fundamentals of Data
COURSE Database Fundamentals: Database Concepts
COURSE SRE Data Pipelines & Integrity: Data Pipelines
Likes 31 Likes 31