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