Module 06: Combining Data

1. Prepare (due Mon 10/9)
   1. Content below
   2. Canvas quizzes
2. Peer Instructions – See on the class forum
3. Homework (due Sun 10/15) [Link]
4. Worked Example [Link]

Content (Slides in the Box Folder)

06.A – Summarizing Data

1. Read Section 3.8 Aggregating and Grouping from Python Data Science Handbook.
2. Read Section 3.9 Pivot Tables from Python Data Science Handbook.

06.B – Merging Data

1. Read Section 3.6 Concat and Append from Python Data Science Handbook. Please note that the join_axes optional parameter mentioned in this section has been deprecated from the Pandas library, you can skip over the details on this parameter.
2. Read Section 3.7 Merge and Join from Python Data Science Handbook
3. Record Linkage (8 min.)
4. Fuzzy Matching (21 min.)

Optional Supplements

• Pandas Group by: split-apply-combine user guide
• Pandas Reshaping and pivot tables user guide
• Pandas Merge, join, concatenate, and compare user guide