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
21
43.
"Cleaning" data
Bash
22
21.
Intro to Command Line Interfaces (CLIs)
23
22.
How to run the Bash Shell
24
23.
Working with the Bash Shell.
Intro to dplyr
25
24.
dplyr - getting and viewing the data
26
25.
dplyr verbs - select, filter, etc.
visualizations with ggplot2
27
26.
Intro to ggplot2
Intro to SQL
28
27.
SQL Select
Relational databases and SQL (no dplyr knowledge needed)
29
Different categories of databases
30
29.
Get the data - "books database" and other tables
31
30.
Relational Databases and SQL (using R)
32
31.
Inner Joins.
33
32.
aggregate functions, group by, having
34
33.
more joins (cross/left/right/full), subqueries, set operations, case, self joins
35
34.
Common Table Expressions (CTE)
36
35.
other commands: update/delete, create/drop/insert
37
36.
SQL "window" functions
38
37.
Working directly with databases in R
39
38.
What is a Database?
Web Scraping
40
39.
How a webpage gets to your browser
41
40.
Web Scraping with R
42
41.
Scraping Dynamic (JavaScript) Websites
43
42.
CSS Selector Questions
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
The contents of this section was moved to the end of the previous section.
16
16.
Using JSON in R with jsonlite package
18
18.
assignment - weather API