This module covers the core data manipulation operations youโll use in nearly every analysis: creating and transforming columns, aggregating data across groups, and combining multiple tables with joins. By the end of Week 4, youโll be able to go from a raw table to a meaningful summary in a few lines of pandas code.
Learning Objectives
By the end of this module, you will:
- Create and modify columns using assignment, arithmetic, and string operations
- Summarize data using
.groupby() and .agg() with multiple aggregation functions
- Join two DataFrames on a key column using
pd.merge()
- Choose the correct join type (inner, left, right, outer) for a given analytical need
Module Resources
Lecture
| ๐ Week 4 Slides |
View slides |
| ๐ป Week 4 Data Detective |
 |