Data and databases

Data Analysis with Python (pandas, polars, DuckDB)

The planned outline of 17 modules. Lessons are written, run and reviewed before they are published.

Coming soon 17 modules

Before this track

Python

Planned outline

Module 1
The data-analysis workflow and your toolkit
Coming soon
Module 2
pandas foundations
Coming soon
Module 3
Loading data: CSV, Excel, JSON, Parquet and databases
Coming soon
Module 4
Cleaning: missing values, duplicates, types and text
Coming soon
Module 5
Summaries, group-by and pivot tables
Coming soon
Module 6
Combining data: concat and joins
Coming soon
Module 7
Reshaping: tidy data, melt, pivot and MultiIndex
Coming soon
Module 8
Dates and time series
Coming soon
Module 9
Text extraction and categorical data
Coming soon
Module 10
Visualising data with matplotlib
Coming soon
Module 11
Statistics an analyst uses every week
Coming soon
Module 12
polars: expressions, lazy queries and speed
Coming soon
Module 13
DuckDB: SQL on DataFrames and files
Coming soon
Module 14
Performance and scale
Coming soon
Module 15
Data-quality checks you can automate
Coming soon
Module 16
Reporting and communicating results
Coming soon
Module 17
Analyst interviews and take-home assignments
Coming soon

Related tools

CSV Editor & Viewer Open, fix and save CSV files in a spreadsheet grid — large files included. Excel to CSV Converter Turn any sheet into clean CSV — every sheet at once, title rows and merged cells fixed. Chart Maker (Graph from Data) Paste a table, pick a suggested chart, download it — all in your browser. Remove Duplicate Rows (CSV/Excel) Find and remove repeated rows by the columns that matter, with a file of what was removed. Mock Data Generator Design the columns, link the tables, and download up to a million rows of test data.

Official documentation

pandas.pydata.org/docs (pandas.pydata.org)
docs.pola.rs (docs.pola.rs)
duckdb.org/docs (duckdb.org)
matplotlib.org/stable (matplotlib.org)

More in Data and databases