Catalog / dplyr Data Transformation Cheatsheet
dplyr Data Transformation Cheatsheet
A comprehensive cheat sheet for data manipulation using dplyr, covering essential functions for summarizing, grouping, manipulating, extracting, and combining data.
Summarizing and Grouping Data
Summarizing Cases
Example:
|
|
Common Summary Functions: |
Example:
|
Grouping Cases
Example:
|
|
|
Example:
|
Counting Cases
Example:
|
|
Example:
|
Alternatives: |
Manipulating Cases
Extracting Cases
Example:
|
|
Example:
|
Example:
|
Example:
|
Arranging Cases
Example:
|
|
Example:
|
Adding Cases
Example:
|
|
Manipulating Variables
Extracting Variables
Example:
|
|
Example:
|
Example:
|
Making New Variables
Example:
|
|
Example:
|
Manipulating Multiple Variables at Once
Example:
|
|
Example:
|
Combining Tables
Combining Variables
Example:
|
Ensure tables have the same number of rows and are ordered correctly. |
Combining Cases
Example:
|
Can add a column indicating the source table using Example:
|
Relational Data (Joins)
Example:
|
|
|
|
|
|