Data Cleaning Exercises

Dataset pack

Account updates from several systems

The same accounts sent by several systems with different update times and priorities.

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 Pick one surviving record per account.

records 13 rows × 4 columns

Download records.csv

Data dictionary

id
Unique record ID.
account
Account number with leading zeros.
updated
ISO 8601 timestamp with an explicit offset; the same instant may be written with different offsets.
priority
Whole-number priority of the sending system; higher wins.
idaccountupdatedpriority
"rllcz""000064""2026-03-10T23:15:00Z""9"
"rsilp""000458""2026-03-11T00:15:00+01:00""10"
"r35yg""000064""2026-02-01T00:00:00Z""3"
"rwy4c""000875""2026-03-10T23:15:00Z""1"
"reqt9""000064""2026-01-15T08:00:00Z""9"
"r3mue""000748""2026-02-01T12:30:00Z""2"

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.