Data Cleaning Exercises

Dataset pack

Site visits by region

Visits with blank or missing regions and durations that are sometimes not recorded.

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 Label unknown categories, keep missing numbers missing.

visits 15 rows × 3 columns

Download visits.csv

Data dictionary

id
Unique visit ID.
region
Region name; may be padded, blank or missing.
duration_min
Duration in whole minutes; may be padded, blank or missing; 0 is a real duration.
idregionduration_min
"vplbs""East"" 80 "
"vivo8""\tEast""108"
"v08ub"""∅
"vtj0d""South""0"
"v59m5"" North"" 66 "
"vo7m1"∅""

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.