SKILL
Python for Data (Pandas Basics)
Read CSVs, clean columns, filter rows, and run simple aggregations without becoming a programmer
Beginner
Read a CSV, check info and dtypes, show head and describe
Intermediate
Filter rows, groupby aggregation, handle missing values with written reasoning
Advanced
Merge tables, apply custom functions, export reproducible clean data
Practice task
Clean a 1000-plus-row CSV: rename columns, handle missing values, drop duplicates, standardise dates and currency, produce 3 summary statistics — keep the script, the cleaned file, and a note of your cleaning decisions
Pass test
Pass test: rerun the script from scratch. You pass if output is deterministic, no duplicate rows remain, the date column is datetime typed, the 3 summary statistics are plausible, and the decision log explains why rows were dropped or filled.
Portfolio evidence
Notebook plus cleaned.csv plus a log of every cleaning decision
Common mistake
Copy-pasting code without understanding each line, never checking dtypes so numeric columns read as text
USED IN THESE ROLES
STUCK OR UNSURE?
bring your learning to a 1-on-1All materials are free to study. If positioning, portfolio, or apply strategy stalls, we dissect it together.