Data Cleaning Exercises

Dataset pack

Monthly meter readings

Long-format readings per entity and month, where some months were never reported and some report zero.

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 Pivot monthly values, keeping zeros and gaps apart.

readings 17 rows × 3 columns

Download readings.csv (Pro)

Data dictionary

entity
Entity being measured.
month
Jan, Feb or Mar.
value
Whole-number reading; 0 is a real reading.

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.