Data Pipeline with R
Motivation
Introduction
1
Rstudio
1.1
Introduction
1.2
What is an IDE?
1.3
Rstudio Cloud
1.3.1
Create an account
1.3.2
Create a New Project
1.3.3
Create an Rmd file
1.4
Environment
1.4.1
Top left-hand panel
1.4.2
Bottom left-hand panel
1.4.3
Top right-hand panel
1.4.4
Bottom right-hand panel
1.4.5
Primary toolbar
2
Markdown
2.1
Introduction
2.2
Create a new document
2.3
Markdown
2.3.1
YAML
2.3.2
R code
2.3.3
Embedding an image
2.3.4
Syntax
2.3.5
Equation
2.4
Reproducible research
3
Git
3.1
Introduction
3.2
Github
3.2.1
Create a GitHub account
3.2.2
Create a GitHub repository
3.2.3
Connect GitHub on RStudio Cloud
3.3
Lower Camel Case
3.4
Pull, Commit, Push
3.4.1
Git config
4
Managing references
4.1
Introduction
4.2
Zotero
4.3
Better BibTeX
4.4
YAML
4.5
Citr
4.6
Citations
5
R
5.1
Introduction
5.2
R
5.3
R Grammar
5.3.1
Package::function()
5.3.2
Library(package)
5.3.3
Piping
5.4
R terminology
5.4.1
Tidy Data
5.4.2
Dense summary
5.5
Data nomenclature
6
Data Wrangling 1/4
6.1
Introduction
6.2
Importing data
6.2.1
From a .csv file
6.2.2
From a statistical software
6.2.3
From a Google sheet
6.2.4
For almost anything at the C++ speed
7
Data Wrangling 2/4
7.1
Introduction
7.2
Adding & Deleting Variables
7.3
Subsetting a dataset
7.4
Sorting data
8
Data Wrangling 3/4
8.1
Introduction
8.2
Long and wide form
8.2.1
From Long to Wide
8.2.2
From Wide to Long
9
Data Wrangling 4/4
9.1
Introduction
9.2
Merging datasets
10
Data Visualization
10.1
Foundations
10.1.1
What makes an effective visualization?
10.1.2
What makes an ineffective visualization?
10.2
Getting your hands dirty
10.2.1
Bar chart
10.2.2
Line chart
10.2.3
Bubble chart
10.2.4
Maps
10.2.5
Esquisse
11
Dashboards
11.1
Introduction
11.2
Getting Started
11.3
Layout
11.3.1
Chart Stack Fill
11.3.2
Chart Stack Scrolling
11.3.3
Focal Chart Top
11.3.4
Focal Chart Left
11.3.5
Tabsets
11.4
Components
11.4.1
Value Boxes
11.4.2
Gauges
11.5
Sizing
11.6
Multiple Pages
11.7
Storyboards
11.7.1
Storyboard Basics
11.7.2
Storyboard Pages
11.7.3
Commentary
12
API and Packages
12.1
Introduction
12.2
WDI
12.2.1
Database description
12.2.2
Functions
12.2.3
tl;dr
12.3
OECD
12.3.1
Database description
12.3.2
Functions
12.3.3
tl;dr
12.4
spiR
12.4.1
Database description
12.4.2
Functions
12.4.3
tl;dr
12.5
statcanR
12.5.1
Database description
12.5.2
Functions
12.5.3
tl;dr
12.6
EpiBibR
12.6.1
Database description
12.6.2
Functions
12.6.3
tl;dr
12.7
coronavirus
12.7.1
Database description
12.7.2
Functions
12.7.3
tl;dr
References
www.warin.ca
Data Pipeline with R
References