Calendar
Note: future dates on this schedule are approximate and subject to change.
Beginning data wrangling
- August 25
- Course introduction and motivation
- slides (html), slides (pdf), Class Activity
- Install R, RStudio
- Software installation
- August 27
- Data wrangling fundamentals
- slides (html), slides (pdf), Class Activity
- Reading for Friday’s class
- Chapter 3, R4DS, Chapter 4.1, MDSR
- August 29
- Data wrangling fundamentals
- slides (html), slides (pdf), Warmup, Class Activity, Class activity solutions
- Homework 1 released
- HW 1
Complete the Git and GitHub setup and example assignment for Monday’s class
Reshaping data
- September 1
- Complete the Git and GitHub setup and example assignment
- Reading for Wednesday’s class
- Chapter 6.1-6.2, MDSR
- September 3
- Reshaping data (pivoting)
- slides (html), slides (pdf), Warmup, Class Activity, Class activity solutions
- Reading for Friday’s class
- Chapter 5, R4DS
- September 5
- Reshaping data (pivoting)
- slides (html), slides (pdf), Warmup, Class Activity, Class activity solutions
- Reading for Monday’s class
- Chapter 5, MDSR
- Homework 2 released
- HW 2
Joins and beginning iteration
- September 8
- Reading for Wednesday’s class
- Chapter 26.2, R4DS
- September 10
- Data wrangling across columns
- slides (html), slides (pdf), warmup, Class Activity, Class activity solutions
- Reading for Friday’s class
- Chapter 25.2, R4DS
- September 12
- Data wrangling across columns, functions
- slides (html), slides (pdf), warmup, Class Activity, Class Activity solutions
- Homework 3 released
- HW 3
Functions and iteration
- September 15
- Vector functions
- slides (html), slides (pdf), warmup, Class Activity, Class Activity solutions
- Reading for Wednesday’s class
- Chapter 25.3, R4DS
- September 17
- Data frame functions
- slides (html), slides (pdf), warmup, Class Activity, Class Activity solutions
- Reading for Friday’s class
- Chapter 26.3, R4DS
- September 19
- Iteration with map
- slides (html), slides (pdf), Class Activity
- Homework 4 released
- HW 4
Simulation and iteration
- September 22
- Introduction to simulation
- slides (html), slides (pdf)
- Reading for Wednesday’s class
- Section 27.5, R4DS, Chapter 5, Advanced R
- September 24
- Probability simulations
- slides (html), slides (pdf), Class Activity, Class Activity solutions
- September 26
- Probability simulations
- Class Activity, Class Activity solutions
- Homework 5 released
- HW 5
Functions and lists
- September 29
- Reading for Wednesday’s class
- Section C.2, MDSE, Sections 6.1 - 6.4, Advanced R
- Exam 1 review questions
- review questions, review solutions
- October 1
- Functions + function scoping
- slides (html), slides (pdf), warmup, Class Activity
- October 3
- Exam 1 review
- notes
Exam 1
- October 6
- Exam 1
- October 8
- Discuss exam 1
- Reading for Friday’s class
- Sections 14.1 - 14.3, R4DS
- October 10
- Intro to text data and strings
- slides (html), slides (pdf), warmup, Class Activity
- Reading for Wednesday’s class
- Sections 15.1 - 15.3, R4DS
Text as data
- October 13
- No class
- October 15
- Regular expressions
- slides (html), slides (pdf), warmup
- Reading for Friday’s class
- Sections 15.4 - 15.7, R4DS
- October 17
- Regular expressions
- slides (html), slides (pdf), Class Activity, Class Activity solutions
- Homework 6 released
- HW 6
Web scraping
- October 20
- Intro to web scraping
- slides (html), slides (pdf), Class Activity, Class Activity solutions
- Reading for Wednesday’s class
- Chapter 24, R4DS
- October 22
- Web scraping and wrangling
- slides (html), slides (pdf), warmup, Class Activity
- October 24
- Web scraping and wrangling
- slides (html), slides (pdf), warmup, Class Activity, activity solutions
- Homework 7 released
- HW 7
SQL and relational data
- October 27
- Intro to SQL
- slides (html), slides (pdf), Class Activity, activity solutions
- Reading for Wednesday’s class
- Chapter 21, R4DS, Chapter 15, MDSR
- October 29
- SQL activity – murder mystery
- Class Activity
- October 31
- SQL and relational data
- slides (html), slides (pdf), handout
- Homework 8 released
- HW 8
SQL and relational data
- November 3
- November 5
- HW 8 work time
- Exam 2 review questions
- practice questions, practice question solutions
- Additional SQL practice
- Select Star SQL
- November 7
- HW 8 work time
Exam 2
- November 10
- Work day
- Project released
- Project
- November 12
- Exam 2 review day
- review slides
- November 14
- Exam 2
Intro to Python
- November 17
- Intro to Python
- slides (html), slides (pdf), warmup, Class Activity
- November 19
- Python arrays and lists
- Class Activity
- November 21
- Data wrangling in Python
- slides (html), slides (pdf), Class Activity
More Python
- November 24
- Data wrangling in Python
- Homework 9 released (optional)
- HW 9
- November 26
- No class
- November 28
- No class
Semester wrap-up
- December 1
- Project work time
- December 3
- Project work time
- December 5
- Project work time