Skip to content
BENIBIX Learn

Data Cleaning

Data⚙️ ProcessingData Transformation

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

Data cleaning finds and fixes values in a table that are wrong, missing or messy. It trims spaces, fixes spelling, sets one format for dates and fills or flags gaps. It also removes rows that cannot be right, such as an age of 300. Each rule should be written down, so the same fix runs every time. Cleaning is part of transformation.

Common mistake

Fixing values by hand in a spreadsheet. The fix is lost the next time the data loads.

Key takeaways

  1. 1
    Find bad values. Wrong, missing or messy.
  2. 2
    One format. Dates, names and codes match.
  3. 3
    Rules in code. The same fix runs every time.