Data Cleaning Exercises

Dataset pack

Event dates in several locales

Event dates written as ISO dates or slash dates, with a per-row locale that is sometimes missing.

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 Parse dates by declared locale.

events 8 rows × 3 columns

Download events.csv

Data dictionary

id
Unique event ID.
raw_date
ISO date or slash date as text; may be missing.
locale
en-US, en-GB, another locale, or missing.
idraw_datelocale
"evvsoj""04/08/2025""en-GB"
"evkcwt""02/12/2025""en-GB"
"evsig0""2025-06-05""en-US"
"evrwhn""6/20/2025"∅
"evsr70""05/12/2025""en-GB"
"eva355""2026/04/03""en-GB"

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.