# Data Cleaning

> It finds bad or missing values and fixes them.

**Field:** Data Engineering  
**Category:** Processing  
**Also known as:** Data Cleansing, Data Scrubbing

## Think of it like

It is like sorting a toy box. You throw out broken toys and put lost pieces back where they go.

## 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.

## 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.

## Common mistake

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

## Three principles

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

## Related terms

- [Data Transformation](https://learn.benibix.com/term/data/data-transformation)
- [Data Deduplication](https://learn.benibix.com/term/data/data-deduplication)
- [Data Pipeline](https://learn.benibix.com/term/data/data-pipeline)
- [Structured Data](https://learn.benibix.com/term/data/structured-data)

---

Source: https://learn.benibix.com/term/data/data-cleaning
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-19
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
