Data Cleaning Exercises

Dataset pack

Names in mixed Unicode forms

Names copied from several sources: composed and decomposed accents, no-break and ideographic spaces.

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 Normalize names without changing letters.

people 9 rows × 2 columns

Download people.csv

Data dictionary

id
Unique person ID.
name
Full name; may carry unusual whitespace at either end and use different Unicode forms for accents.
idname
"pxbny""François Côté\t"
"pyy5h""plain name\t"
"pyxap""Ölçer Çağlar\t"
"p4oqr"" Zoë Brontë  "
"pw9op"" Müller & Söhne\t"
"p49xg""\tNguyễn Văn An "

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.