Data Cleaning Exercises

Dataset pack

Accounts with soft deletes

An accounts table that keeps deleted accounts, marked with a deletion timestamp.

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 Soft-deleted rows are not live data.

accounts 16 rows × 4 columns

Download accounts.csv (Pro)

Data dictionary

id
Unique account ID.
email
Email as typed.
plan
Plan name as typed.
deleted_at
Deletion time; empty for live accounts.

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.