Python in Excel tutorial
Compare two Excel tables with Python in Excel, identify missing records, and calculate differences using pandas.
About this tutorial
This tutorial uses Python in Excel to group and compare two datasets, keep records that exist on only one side, and calculate value differences.
It is a compact pattern that can be reused for accounting reconciliations and other data-quality checks.
Read the Excel tables into Python and aggregate the values by the reconciliation key.
Use an outer merge so missing records on either side remain visible.
Calculate the difference and filter the result to the items that need attention.