PYTHON / PANDAS • SAMPLE COLLEGE DATA

Pandas in motion

Follow the highlighted input rows as each result is built. Hover any row to trace it; click a result row to jump to that step. Columns are shaded by the table they came from: blue = left, orange = right, green = key, yellow = created by the operation.

Question we can now answer

Input tables

Edit or generate input data

One row per line, comma-separated; the first line is the header. Leave a cell empty or write NA for a missing value. The result, steps, and setup code recompute from whatever you enter.

Result

NA = missing, not zero. Index omitted except in the index-alignment example. ⚷ marks key columns. Cell colours show which input table each column came from (legend above).

Python syntax

Sample data setup — copy before running the code

Results, steps, and setup code are computed in the browser from the displayed data with a small pandas-behaviour engine (checked against pandas 2.2.3 on the sample data). Anti joins use a version-compatible filtering pattern. Link to a technique with the address bar (e.g. #left-join).
Reference: pandas merge · Combining tables · Reshaping · GroupBy