pandas
pandas
Load real data into DataFrames, select and reshape it, clean missing values, group rows, and join datasets without losing track of what changed.
What you'll practice
- DataFrames
- Selection
- Grouping
- Joins
- Cleaning
Lessons
7 lessons, in order
Messy tables in. Clear answers out.
- 01pandas DataFrames: labeled tables that computeBuild a DataFrame, add calculated columns, inspect its shape and dtypes, and load the same structure from CSV text.10 min
- 02Selecting rows and columns with confidenceUse brackets, loc, iloc, boolean masks, and query to pull out exactly the rows and columns you mean.11 min
- 03Group rows and summarizeSplit a table into groups, aggregate each one, and use transform when the group total needs to travel back to every row.11 min
- 04Join related tables without losing rowsMerge DataFrames on a shared key, choose how unmatched rows survive, validate the relationship, and stack tables with concat.11 min
- 05Clean messy data deliberatelyInspect missing values, remove duplicates, normalize text, and convert columns to the types your analysis actually needs.12 min
- 06Work with dates and time seriesParse date strings, use a DatetimeIndex, resample calendar periods, and compute rolling windows without losing the time order.12 min
- 07Reshape wide and long tablesMove values between rows and columns with pivot and melt, and use pivot_table when the same cell appears more than once.11 min