Data Management With R (latest version)
(click here for spring24 version of this website)
JSON data and APIs
17
17.
Nested Dataframes
Intro
Some computer basics
1
1.
What is an "operating system"
2
2.
Working with files
3
3.
Chrome Extensions
Into to Coding With AI
4
4.
AI in Everyday Use
5
5.
Coding with AI - an overview
Intro to R packages
6
6.
Intro to R packages
Intro to Quarto
7
7.
Intro to Quarto
Intro to tidyverse
8
8.
What is the "tidyverse"
9
9.
tibbles and tribbles
10
10.
Using pipes, i.e. %>% and |>
11
11.
stringr tutorial
Working with files
12
12.
Working with files
JSON data and APIs
13
13.
Intro to JSON data
14
14.
Creating, editing and validating JSON files
15
15.
DATA TYPES IN JSON
16
16.
Using JSON in R with jsonlite package
17
17.
Nested Dataframes
18
18.
assignment - weather API
Regular Expressions
19
19.
regular expressions (regex)
20
20.
Practice with Regular Expressions
Bash
21
21.
Intro to Command Line Interfaces (CLIs)
22
22.
How to run the Bash Shell
23
23.
Working with the Bash Shell.
Intro to dplyr
24
24.
dplyr - getting and viewing the data
25
25.
dplyr - select
visualizations with ggplot2
26
26.
Intro to ggplot2
Intro to SQL
27
27.
SQL Select
Relational databases and SQL (no dplyr knowledge needed)
28
Different categories of databases
29
29.
Get the data - "books database" and other tables
30
30.
Relational Databases and SQL (using R)
31
31.
Inner Joins.
32
32.
aggregate functions, group by, having
33
33.
more joins (cross/left/right/full), subqueries, set operations, case, self joins
34
34.
Common Table Expressions (CTE)
35
35.
other commands: update/delete, create/drop/insert
36
36.
SQL "window" functions
37
37.
Working directly with databases in R
38
38.
What is a Database?
Web Scraping
39
39.
How a webpage gets to your browser
40
40.
Web Scraping with R
41
41.
Scraping Dynamic (JavaScript) Websites
42
42.
CSS Selector Questions
Questions
43
43.
"Cleaning" data
Appendices
44
44.
Topics
45
45.
Bibliography
46
46.
Where to find datasets
47
47.
Where to find APIs
48
48.
Additional topics
JSON data and APIs
17
17.
Nested Dataframes
17
17.
Nested Dataframes
A “nested dataframe” can contain
16
16.
Using JSON in R with jsonlite package
18
18.
assignment - weather API