DebugJuniorData / MLAuto-graded
Reconcile a bank ledger against a payments export
An everyday data chore: cleaning two messy record sets and telling genuine mismatches apart from formatting differences.Two systems disagree. Finance hands you a bank ledger and a payments export that are supposed to describe the same transactions, and they do not line up: the dates are in different formats, the money column is formatted inconsistently, a few transaction IDs appear twice, and some entries are genuinely missing from one side. Write a reconciler that normalises both files and produces a precise account of what matches, what differs and what is absent.20 min
python
You're done when
- A reconciler exists in
reconcile.pyand runs to completion on the two supplied files. - Dates and money are normalised across both sources before anything is compared.
- Amount mismatches are reported on normalised values, so formatting differences are not mistaken for real discrepancies.
- Duplicate transaction IDs are handled rather than silently collapsing or double-counting.
- Entries present on only one side are reported as missing, not quietly dropped.
What it measures
PythonTurning two messy real-world files into comparable data without losing rows along the way.
Data qualitySeparating a genuine discrepancy from a formatting artefact, which is the entire difficulty of reconciliation.
Precision in reportingProducing a difference report someone in finance could act on, rather than a count of mismatches.
Your environment
Terminal + editorA full shell in the browser
Claude CodePre-authenticated, no key setup
Isolated microVMYours alone, wiped afterwards
Start this lab
20 min
Start labYou'll sign in to Anthropos to start. The lab opens in a private cloud workspace with Claude Code ready to use.AI Labs is part of Anthropos Workforce. Not on your plan yet? Book a demo