Data Analyst

Write your first Python program and print to the screen.

Numbers, strings, booleans — the building blocks.

Arithmetic, powers, the math module — Python as a calculator.

Slicing, methods, and f-strings — text manipulation done right.

Make decisions and repeat yourself — but only on purpose.

Loop until a condition fails. Bail out or skip with break/continue.

Collections of things, and how to walk through them.

Carve up lists and strings with [start:stop:step].

Two more collections: tuples are fixed, sets are unique.

Key → value pairs. The most important data structure in Python.

Empty things are False. `is` vs `==`. The infamous None.

The Pythonic ways to iterate — count, pair, sequence.

Bundle up logic so you can reuse it.

Lists of dicts, dicts of lists — modelling real-world data.

Filter and transform in one line — the Pythonic way.

Catch what could go wrong, recover gracefully.

Parse and produce JSON — the universal data format.

Today, deltas, parsing, formatting — without losing your mind.

Vectorized math in Python. Auto-installs NumPy in your browser on first run.

DataFrames in your browser. Auto-installs pandas on first run.

The two objects you'll use every day — a labeled column (Series) and a labeled table (DataFrame) — plus loc/iloc selection.

Real datasets arrive dirty: missing cells, wrong dtypes, duplicate rows. Fix them with isna/fillna/dropna, to_numeric, rename and drop_duplicates.

Slice rows with boolean masks, read them cleanly with query(), then rank with sort_values and head() to answer top-N questions.

Split rows into groups, aggregate each with sum/mean/count, compute several stats at once with named agg, and sort the summary.

Stitch two tables together on a key with merge (inner vs left), understand which rows survive, and stack frames with concat.

Split-apply-combine — the pattern behind every real data analysis.

Combine dataframes like SQL joins — with inner, left, outer, and validation.

Pandas time series tutorial: use DatetimeIndex, resampling, rolling windows, and grouped time-based analysis.

A real database in a single file. Perfect for learning SQL end-to-end.

INNER, LEFT, RIGHT, FULL — with a concrete users-and-orders example.

Real charts that ship — line, bar, distribution, heatmap.