Pandas Crash Course

The most important library in this course. DataFrames, selection, filtering, grouping, joining, pivoting — the spreadsheet superpowers.

Toolkit 8 lessons ~75 min

Lessons in this module

1. DataFrames — Python's spreadsheet · 9 min
   Create a DataFrame, inspect it, and learn the vocabulary.
2. Selecting rows and columns — loc and iloc · 9 min
   Pull out the slice of data you actually want.
3. Sorting, counting, and ranking · 7 min
   sort_values, value_counts, rank — the simple stuff you'll use a hundred times a day.
4. Aggregation — sum, mean, agg · 8 min
   How to summarise. Series methods, DataFrame methods, and .agg().
5. groupby — the move that pays for the course · 10 min
   Split → apply → combine. Replace your SUMIFS forever.
6. Pivot tables — pivot_table() · 8 min
   The Excel pivot table, one function call.
7. Joining and merging — pandas's VLOOKUP · 9 min
   merge, concat, join — three ways to combine DataFrames.
8. Applying functions — apply, map, vectorisation · 7 min
   Run a function across every row or every cell, and when to skip it.