Data Cleaning Exercises

Dataset pack

Visits with accented city names

Visit logs from two systems that encode accented letters differently.

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 Composed and decomposed accents.

visits 17 rows × 2 columns

Download visits.csv (Pro)

Data dictionary

id
Unique visit ID.
city
City name as logged (composed or decomposed accents).

cities 4 rows × 2 columns

Download cities.csv (Pro)

Data dictionary

city
City name in NFC (unique).
region
Country code.

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.