- 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.