Data Cleaning Exercises

Dataset pack

Pasted part codes

Part codes typed or pasted from documents, some with typographic dashes, and the parts catalog.

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 Dashes that only look the same.

parts 18 rows × 2 columns

Download parts.csv (Pro)

Data dictionary

id
Unique row ID.
part_code
Part code as entered.

catalog 5 rows × 1 columns

Download catalog.csv (Pro)

Data dictionary

code
Approved part code (ASCII hyphen).

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.