# Planning for Week 5

## High Level Topic Summary

> - Transformations and Tidy Data Normalization
>     - Constraints Review
>     - Melt and Pivot
>     - Common Normalization
>     - Recognizing Messy Data

## Readings for the week

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

## Projected Class and Homework

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

## Tuesday Problem Day

Practice with both combinations and joins as well as melt and pivot.


## Progression

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.