Learning path

Pandas

Load, clean, filter, group and join tables of data in Python, explained step by step with animated tables.

Start with lesson 1

1

Pandas Introduction

What Pandas is, the two building blocks Series and DataFrame, and your first look at a table of data.
2 min read
2

Reading and Writing Data

Load CSV and Excel files into a DataFrame, check them with info(), and save your results back to a file.
3 min read
3

Selecting Rows and Columns

Choose columns, and pick rows by label with loc or by position with iloc.
2 min read
4

Filtering Data

Keep only the rows you need with conditions, combine them with & and |, and use isin, between and query.
2 min read
5

Cleaning Data

Find and fix missing values, duplicates, wrong types and messy text, the work that takes most of a data analyst's day.
3 min read
6

New Columns, Sorting and Counting

Create columns from calculations and conditions, transform values with map and apply, sort, rank and count.
2 min read
7

Grouping and Summarising with groupby

Answer "per city", "per month", "per product" questions with groupby, agg and pivot tables.
2 min read
8

Merging Tables and a Mini Project

Join tables with merge, stack them with concat, then answer real business questions in a small sales analysis project.
2 min read
9

Merging Tables and a Mini Project

Join tables with merge, stack them with concat, then answer real business questions in a small sales analysis project.
2 min read