Data Cleaning Exercises

Dataset pack

Employees and department codes

Employees with hand-typed department codes and the department list.

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 Enrich without dropping rows.

employees 13 rows × 3 columns

Download employees.csv (Pro)

Data dictionary

id
Unique employee ID.
name
First name.
dept
Department code as typed; may be missing or unknown.

departments 4 rows × 2 columns

Download departments.csv (Pro)

Data dictionary

code
Unique upper-case code.
title
Department title.

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.