Data Cleaning Exercises

Dataset pack

Employee hierarchy

Employees with a reference to their manager in the same table.

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 Look up a table in itself.

employees 11 rows × 3 columns

Download employees.csv (Pro)

Data dictionary

id
Unique employee ID.
name
Employee name.
manager_id
ID of the employee's manager.

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.