Planning for Week 5

High Level Topic Summary

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.


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.