Python for Data
Load, clean, chart and explain real data with Python, numpy and pandas. Units 1 and 2 use plain Python.
Data in Plain Python
Read CSV files and summarise rows with plain Python lists and dictionaries.
Cleaning and Shaping
Fix missing values, wrong types and duplicate rows before you count anything.
Arrays with numpy
Use numpy arrays to do maths on a whole column at once.
Series and DataFrames
Build pandas tables and pick out the rows and columns you need.
Getting Data In
Load CSV and JSON files into pandas and check what arrived.
Filtering and Deriving
Filter pandas rows with conditions and add columns that answer questions.
Grouping and Aggregating
Group pandas rows by category to get counts, totals and averages.
Combining Tables
Join two pandas tables on a shared column and reshape the result.
Time Series
Turn text into pandas dates, then track totals by week or month.
Visualising and Reporting
Pick the right chart and write up what your data shows.