Data Cleaning Exercises

Dataset pack

Staff directory names

Staff names with mixed case and accents in two Unicode forms.

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 A sort order written down exactly.

directory 15 rows × 2 columns

Download directory.csv (Pro)

Data dictionary

id
Unique staff ID.
name
Name as typed.

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.