Data Cleaning Exercises

Dataset pack

Timesheet submissions

Timesheet entries with resubmissions, and the staff list that assigns each employee to a team.

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 Payroll hours per team.

entries 17 rows × 5 columns

Download entries.csv (Pro)

Data dictionary

id
Unique entry ID.
employee
Employee code.
day
Work day, YYYY-MM-DD.
hours
Hours worked as text.
submitted_at
Submission time, ISO 8601 with offset.

staff 4 rows × 2 columns

Download staff.csv (Pro)

Data dictionary

employee
Employee code (unique).
team
Team.

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.