Data Cleaning Exercises

Dataset pack

Store-by-month sheet

A wide sheet with one column per month and gaps where stores didn't report.

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 Totals per month from a wide sheet.

sales 10 rows × 4 columns

Download sales.csv (Pro)

Data dictionary

store
Unique store code.
jan
January sales as text.
feb
February sales as text.
mar
March sales as text.

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.