Data Cleaning Exercises

Dataset pack

US addresses with mixed state formats

Addresses where the state is a code or a full name in mixed case.

Fictional data · UTF-8 CSV, every value quoted so padding and leading zeros survive; empty fields are missing values · free for personal and classroom practice · practise it in Map known variants, keep the rest.

addresses 10 rows × 3 columns

Download addresses.csv (Pro)

Data dictionary

id
Unique address ID.
city
City.
state
State code or full name as typed; may be missing.

Values are shown in quotes so leading and trailing spaces are visible. ∅ means the cell is missing. Exercises are also graded on hidden datasets that are never published.