Transform large and complex data sets using base R and popular package ecosystems like tidyverse and data.table. See how these packages compare in terms of speed and usability. Master dplyr verbs quickly and build data processing pipelines for modelling and plotting. Unleash the power of data.table with lightning fast merges and queries.

Data Transformation Intro

course-r-advanced-data-transformation#01-introduction

course-r-advanced-data-transformation#01-introduction#01-introduction

course-r-advanced-data-transformation#01-introduction#01-introduction#recipe

The 3 Doors of Data Transformation

course-r-advanced-data-transformation#01-introduction#01-introduction#section-introduction

Introduction

course-r-advanced-data-transformation#01-introduction#01-introduction#section-the-base-r-package-ecosystem

The base R Package Ecosystem

course-r-advanced-data-transformation#01-introduction#01-introduction#section-the-tidyverse-package-ecosystem

The tidyverse Package Ecosystem

course-r-advanced-data-transformation#01-introduction#01-introduction#section-the-data.table-package-ecosystem

The data.table Package Ecosystem

course-r-advanced-data-transformation#01-introduction#01-introduction#section-pros-and-cons

Pros and Cons

course-r-advanced-data-transformation#01-introduction#01-introduction#quiz-1

Quiz: Which Package Ecosystem to Choose with Storage Backends?

course-r-advanced-data-transformation#01-introduction#01-introduction#quiz-2

Quiz: Which Package Ecosystem to Choose for Stability?

course-r-advanced-data-transformation#01-introduction#01-introduction#quiz-3

Quiz: Which Package Ecosystem to Choose for Large Data Sets?

Discover use cases which require data transformation and the main tools available through base-R, tidyverse and data.table.

Data Transformation with base-R

course-r-advanced-data-transformation#02-data-wrangling-with-base-r

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#01-inspecting-data-structures

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#01-inspecting-data-structures#recipe

Inspecting Data Structures

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#01-inspecting-data-structures#section-interactive-inspection-with-view

Interactive Inspection with View()

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#01-inspecting-data-structures#quiz-1

Quiz: Interactive Inspection with View()

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#01-inspecting-data-structures#exercise-02-01-02

Exercise: Interactive Inspection with View()

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#01-inspecting-data-structures#section-examining-data-structures-with-str

Examining Data Structures with str()

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#01-inspecting-data-structures#quiz-2

Quiz: Examining Data Structures with str()

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#01-inspecting-data-structures#quiz-3

Quiz: Interpret the Output of str()

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#02-filter-data-using-subset

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#02-filter-data-using-subset#recipe

Filter Data Using Subset

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#02-filter-data-using-subset#section-extract-vectors-by-indices

Extract Vectors by Indices

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#02-filter-data-using-subset#exercise-02-02-01

Exercise: Subset Vectors by Indices

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#02-filter-data-using-subset#section-apply-logical-vectors-for-subsetting

Apply Logical Vectors for Subsetting

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#02-filter-data-using-subset#exercise-02-02-02

Exercise: Apply Logical Vectors for Subsetting

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#02-filter-data-using-subset#section-select-multiple-dimensions-by-indices

Select Multiple Dimensions by Indices

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#02-filter-data-using-subset#exercise-02-02-03

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#02-filter-data-using-subset#section-select-multiple-dimensions-with-logical-vectors

Select Multiple Dimensions with Logical Vectors

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#02-filter-data-using-subset#exercise-02-02-04

Exercise: Subset the Titanic Survival Data Frame

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#02-filter-data-using-subset#section-apply-the-subset-function-on-data-frames

Apply the subset() Function on Data Frames

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#02-filter-data-using-subset#exercise-02-02-05

Exercise: Apply the subset() Function

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#03-the-apply-function-family

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#03-the-apply-function-family#recipe

The Apply Function Family

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#03-the-apply-function-family#section-introduction

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#03-the-apply-function-family#section-the-lapply-function

The lapply() Function

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#03-the-apply-function-family#exercise-02-03-01

Exercise: Search Data Frame Columns with lapply()

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#03-the-apply-function-family#section-use-sapply-with-vectors

Use sapply() with Vectors

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#03-the-apply-function-family#section-use-sapply-with-data-frames

Use sapply() with Data Frames

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#03-the-apply-function-family#exercise-02-03-02

Exercise: Search Data Frame Columns with sapply()

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#04-split-apply-combine

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#04-split-apply-combine#recipe

The Split-Apply-Combine Strategy

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#04-split-apply-combine#section-split-data-by-factors

Split Data by Factors

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#04-split-apply-combine#exercise-02-03-01

Exercise: Use split() on a Data Frame

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#04-split-apply-combine#section-use-lapply-on-split-data

Use lapply() on Split Data

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#04-split-apply-combine#exercise-02-03-02

Exercise: Use lapply() on Split Data

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#04-split-apply-combine#section-the-unsplit-function

The unsplit() Function

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#04-split-apply-combine#exercise-02-03-03

Exercise: Split–Apply–Combine

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#05-group-aggregate

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#05-group-aggregate#recipe

Calculate Aggregates by Groups

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#05-group-aggregate#section-group-summarize

Group / Summarize

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#05-group-aggregate#exercise-02-05-01

Exercise: Aggregate Using Vectors

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#05-group-aggregate#exercise-02-05-02

Exercise: Aggregate Using Formulas

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#05-group-aggregate#section-the-table-function

The table() Function

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#05-group-aggregate#exercise-02-05-03

Exercise: Create a table()

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#06-bind-data-sets-together

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#06-bind-data-sets-together#recipe

Bind Data Sets Together

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#06-bind-data-sets-together#section-introduction

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#06-bind-data-sets-together#section-bind-rows-together

Bind rows together

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#06-bind-data-sets-together#exercise-02-06-01

Exercise: Bind rows together

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#06-bind-data-sets-together#section-bind-columns-together

Bind columns together

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#06-bind-data-sets-together#exercise-02-06-02

Exercise: Bind columns together

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#07-join-bind-union

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#07-join-bind-union#recipe

Join Data Sets

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#07-join-bind-union#section-introduction

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#07-join-bind-union#section-inner-join

Inner Join

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#07-join-bind-union#exercise-02-06-01

Exercise: Inner Join

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#07-join-bind-union#section-outer-join

Outer Join

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#07-join-bind-union#exercise-02-06-02

Exercise: Left Outer Join

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#07-join-bind-union#section-full-outer-join

Full (Outer) Join

course-r-advanced-data-transformation#02-data-wrangling-with-base-r#07-join-bind-union#exercise-02-06-03

Exercise: Full Join

Learn data wrangling functions available in base-R to filter, split and aggregate data.

Tidy Data Transformation Level 2

course-r-advanced-data-transformation#03-tidy-data-transformation

course-r-advanced-data-transformation#03-tidy-data-transformation#01-group-aggregate

course-r-advanced-data-transformation#03-tidy-data-transformation#01-group-aggregate#recipe

Group and Aggregate

course-r-advanced-data-transformation#03-tidy-data-transformation#01-group-aggregate#section-the-summarise-function

The summarise() Function

course-r-advanced-data-transformation#03-tidy-data-transformation#01-group-aggregate#exercise-03-01-01

Exercise: The summarise() Function

course-r-advanced-data-transformation#03-tidy-data-transformation#01-group-aggregate#section-calculate-multiple-statistics-with-summarise

Calculate Multiple Statistics with summarise()

course-r-advanced-data-transformation#03-tidy-data-transformation#01-group-aggregate#exercise-03-01-02

Exercise: Calculate Multiple Statistics with summarise()

course-r-advanced-data-transformation#03-tidy-data-transformation#01-group-aggregate#section-the-mutate-function

The mutate() Function

course-r-advanced-data-transformation#03-tidy-data-transformation#01-group-aggregate#exercise-03-01-03

Exercise: The mutate() Function

course-r-advanced-data-transformation#03-tidy-data-transformation#01-group-aggregate#section-use-group_by-with-a-single-variable

Use group_by() with a Single Variable

course-r-advanced-data-transformation#03-tidy-data-transformation#01-group-aggregate#exercise-03-01-04

Exercise: Use group_by() with a Single Variable

course-r-advanced-data-transformation#03-tidy-data-transformation#01-group-aggregate#section-use-group_by-with-multiple-variables

Use group_by() with Multiple Variables

course-r-advanced-data-transformation#03-tidy-data-transformation#01-group-aggregate#exercise-03-01-05

Exercise: Use group_by() with Multiple Variables

course-r-advanced-data-transformation#03-tidy-data-transformation#01-group-aggregate#section-the-ungroup-function

The ungroup() Function

course-r-advanced-data-transformation#03-tidy-data-transformation#01-group-aggregate#exercise-03-01-06

Exercise: The ungroup() Function

course-r-advanced-data-transformation#03-tidy-data-transformation#02-reshape-pivot-data

course-r-advanced-data-transformation#03-tidy-data-transformation#02-reshape-pivot-data#recipe

Reshape and Pivot Data

course-r-advanced-data-transformation#03-tidy-data-transformation#02-reshape-pivot-data#section-the-pivot_longer-function

The pivot_longer() Function

course-r-advanced-data-transformation#03-tidy-data-transformation#02-reshape-pivot-data#exercise-03-02-02

Exercise: Tidy Table Using pivot_longer()

course-r-advanced-data-transformation#03-tidy-data-transformation#02-reshape-pivot-data#exercise-03-02-03

Exercise: Tidy Another Table Using pivot_longer()

course-r-advanced-data-transformation#03-tidy-data-transformation#02-reshape-pivot-data#section-name-transformations-with-pivot_longer

Name Transformations with pivot_longer()

course-r-advanced-data-transformation#03-tidy-data-transformation#02-reshape-pivot-data#section-the-pivot_wider-function

The pivot_wider() Function

course-r-advanced-data-transformation#03-tidy-data-transformation#02-reshape-pivot-data#exercise-03-02-06

Exercise: Transfrom Data Sets with pivot_wider()

course-r-advanced-data-transformation#03-tidy-data-transformation#03-separate-columns

course-r-advanced-data-transformation#03-tidy-data-transformation#03-separate-columns#recipe

Separate, Unite and Extract Columns

course-r-advanced-data-transformation#03-tidy-data-transformation#03-separate-columns#section-separate-columns

Separate Columns

course-r-advanced-data-transformation#03-tidy-data-transformation#03-separate-columns#exercise-03-03-01

Exercise: Separate

course-r-advanced-data-transformation#03-tidy-data-transformation#03-separate-columns#section-unite-columns

Unite Columns

course-r-advanced-data-transformation#03-tidy-data-transformation#03-separate-columns#exercise-03-03-02

Exercise: Unite Columns

course-r-advanced-data-transformation#03-tidy-data-transformation#03-separate-columns#section-extract-parts-from-columns

Extract Parts from Columns

course-r-advanced-data-transformation#03-tidy-data-transformation#03-separate-columns#exercise-03-03-03

Exercise: Extract

course-r-advanced-data-transformation#03-tidy-data-transformation#04-join-datasets

course-r-advanced-data-transformation#03-tidy-data-transformation#04-join-datasets#recipe

course-r-advanced-data-transformation#03-tidy-data-transformation#04-join-datasets#section-mutating-join-types

Mutating Join Types

course-r-advanced-data-transformation#03-tidy-data-transformation#04-join-datasets#quiz-1

Quiz: Mutating Join Types

course-r-advanced-data-transformation#03-tidy-data-transformation#04-join-datasets#quiz-2

course-r-advanced-data-transformation#03-tidy-data-transformation#04-join-datasets#section-left--and-right-join

Left- and Right Join

Learn to use the basic dplyr verbs to filter rows, select columns and sort/arrange datasets in combination with  the pipe <code>%>%</code> operator. Tidy your data with more complex transformations and apply various join operators.