Data Cleaning Exercises

Dataset pack

Visits with partly recorded durations

Visit records where some durations weren't recorded and some were typed as words.

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 with coverage by region.

visits 19 rows × 3 columns

Download visits.csv (Pro)

Data dictionary

id
Unique visit ID.
region
Region as typed; may be missing.
minutes
Duration in whole minutes; may be missing or malformed.

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.