Data Cleaning Exercises

Dataset pack

Event timestamps with and without offsets

Timestamps from devices, some with offsets, some without, some malformed.

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 Timestamps need an offset.

events 11 rows × 2 columns

Download events.csv

Data dictionary

id
Unique event ID.
raw_ts
Timestamp text; may lack an offset or be malformed or missing.
idraw_ts
"evsk9z""2026-01-15T09:00:00+15:00"
"evp3vk""2026-11-01T05:30Z"
"evs5xu""2026-06-30T23:59:59.123456"
"eve3p8""yesterday"
"evl74h""2026-06-30T23:59:59.5+05:30"
"evff5w""2026-11-01T01:30:00"

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.