CSV cleanup with reconciled totals and exceptions by Jasper AddymanCSV cleanup with reconciled totals and exceptions by Jasper Addyman

CSV cleanup with reconciled totals and exceptions

Portfolio project
Jasper Addyman
Original studio demonstration using fictional order data. I cleaned a deliberately inconsistent CSV, standardised fields, checked dates and identified exact duplicates. Conflicting IDs and an invalid date were held in a separate exceptions file for review. The reconciliation accounts for every source row: 8 input rows produced 4 clean records, 2 exact duplicates and 2 exceptions. The handover includes the original input, clean output, duplicate and exception reports, a repeatable cleanup script and notes explaining the rules.

0 likes · 1 view · Nov 10, 2026

CSV demo reconciling every row into clean records, exact duplicates and exceptions for review.

Tags