Skip to interview prep
Apexed

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.

How do you clean a messy dataset — Data & analytics interview question — Apexed