⚙️Data Cleaning
Also known as Data Cleansing, Data Scrubbing
It finds bad or missing values and fixes them.
Think of it like
It is like sorting a toy box. You throw out broken toys and put lost pieces back where they go.
Example
A signup form saved "UK", "U.K." and "United Kingdom". Cleaning turns all three into "GB", so the count by country is right.
Why it matters
Messy values split one group into many and make totals wrong. Clean data is what makes a report true.
Definition
Common mistake
Key takeaways
- 1Find bad values. Wrong, missing or messy.
- 2One format. Dates, names and codes match.
- 3Rules in code. The same fix runs every time.