Data Cleaning Exercises

Dataset pack

Household survey counts

Survey answers with a required adult count and an optional children count.

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 Whole numbers that can be missing.

households 17 rows × 3 columns

Download households.csv (Pro)

Data dictionary

id
Unique household ID.
adults
Number of adults as text.
children
Number of children as text (optional).

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.