datarecon

Compare two datasets and get an explanation of why they differ, not just a list of mismatched cells.

from datarecon import reconcile

result = reconcile(
    "source.csv", "warehouse_export.csv",
    key="student_id",
    rules={"score": {"tolerance": 0.01}},
    treat_as_equal={"case", "whitespace"},
)
print(result.summary())
result.to_excel("reconciliation.xlsx")

datarecon compare source.csv target.csv --key student_id -o report.xlsx --fail-on-diff

What it detects

Also reported: rows missing on either side, duplicate keys, null keys, columns present on only one side.

Key values are matched after trimming, case folding and stripping leading zeros. Files are read as strings so no information is lost before comparison.

Development

pip install -e ".[dev]"
pytest