- Transformations and Tidy Data Normalization
- Constraints Review
- Melt and Pivot
- Common Normalization
- Recognizing Messy Data
| Day | Reading | Reading Questions |
|---|---|---|
| Monday | Chapter 9, 9.1, 9.2 | 9.16, 9.18, 9.20 |
| Tuesday | - | |
| Wednesday | Chapter 9, 9.3 | none |
| Friday | Chapter 9, 9.4 | TBD |
| HW | Day Out | Day Due | Contents |
|---|---|---|---|
| HW_2.3 | Monday | Wednesday | Melt and Pivot |
| HW_2.4 | Wednesday | Friday | Normalization I |
| HW_2.5 | Friday | Monday | Normalization II |
Practice with both combinations and joins as well as melt and pivot.
Goal of the week is to understand and be able to use operations that transform row-column data into altered structures. To do this, we need to understand the operations themselves, as well as to apply them in settings where they are needed–namely to take data in messy form and to normalize them.