Data Cleaning Exercises

Dataset pack

Sales and a fiscal calendar

Monthly sales to be reported by a fiscal year that starts in April, with the finance calendar table.

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 Map months to fiscal quarters.

sales 17 rows × 3 columns

Download sales.csv (Pro)

Data dictionary

id
Unique sale ID.
month
Month as YYYY-MM.
amount
Sale amount as text.

fiscal 21 rows × 2 columns

Download fiscal.csv (Pro)

Data dictionary

month
Month YYYY-MM.
fiscal_quarter
Fiscal quarter label.

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.