Demo with synthetic data ("Sample Co 001 Limited" and so on; no real people or figures).
Compares two datasets (two CSVs, two workbooks, or two sheets) by a key column. Values are normalised first, so formatting noise isn't reported as a difference. Rows with a mistyped key can be paired by fuzzy-matching a name column. The output is an Excel report with differences highlighted and summary sheets.
Python with pandas, openpyxl and rapidfuzz; 32 pytest tests passing.
https://github.com/SheldonZhuang/sheldontek-excel-reconcile-demo
0 likes · 0 views · Oct 26, 2026
Demo: two datasets reconciled by key with normalisation and fuzzy matching; the Excel report highlights real differences. 32 tests pass.
