Data Cleaning Exercises

Dataset pack

Hotel bookings and room states

Bookings typed by front-desk staff, and the room list with each room's current state.

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 Validate against the referenced record.

bookings 14 rows × 3 columns

Download bookings.csv (Pro)

Data dictionary

booking_id
Unique booking ID.
room
Room number as typed.
nights
Number of nights as text.

rooms 6 rows × 2 columns

Download rooms.csv (Pro)

Data dictionary

room
Room number (upper case, unique).
state
open, closed or maintenance.

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.