Data Cleaning Exercises

Dataset pack

Member numbers from a spreadsheet

Member numbers and points that passed through a spreadsheet, with float-formatting artefacts.

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 IDs that went through a spreadsheet.

members 16 rows × 3 columns

Download members.csv (Pro)

Data dictionary

row_id
Unique row ID.
member_no
Member number as exported.
points
Loyalty points 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.