12. How do you clean a messy dataset?
MediumAnalysis & visualization
Technical
Show model answer
Profile it first: types, ranges, missing values, duplicates and outliers. Fix formats, standardise categories, decide how to treat missing values (drop, impute, or flag) based on why they are missing, and document every step so the work is reproducible.
Validate the result against known totals or a source of truth.