Data Cleaning Exercises

Dataset pack

Web form checkboxes

Sign-ups from a web form that exports checkboxes as on or nothing.

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 An unticked checkbox is blank.

signups 14 rows × 4 columns

Download signups.csv (Pro)

Data dictionary

id
Unique sign-up ID.
email
Email as typed.
newsletter
Newsletter checkbox (on, off or blank).
terms
Terms checkbox (on or blank).

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.