Learning path · Python
pandas practitioner: cleaning with Python
Override the pandas defaults that change results: null-key merges, whitespace, NA strings, float money and unstable sorts.
- 1.
- 2.
Exercise · beginner
Keep identifiers as text and parse yes/no flagsIdentifiers stay strings; flags become booleans.
- 3.
- 4.
- 5.
Exercise · beginner
Normalize names without changing lettersStrip the right characters; normalize to NFC.
- 6.
- 7.
Exercise · intermediate · Pro
Sum amounts by currency, without convertingLocale-aware amounts, totals per currency.
- 8.
- 9.
Exercise · advanced · Pro
Fill gaps with a median learned from training data onlyMedian imputation without leakage.
- 10.
Exercise · intermediate · Pro
Resolve customer records by normalized emailStable sorts for survivor rules.