Complex Data Reconciliation using Python

Create a Data Reconciliation Application using Python (check attached files).

The data is for logistics, where the "Inbound Weight" should be reconciled with the "Outbound Weight".
The reconciliation is complex, and has to to loop through the Inbound and Outbound rows using below scenarios:

1) Perfect weight match one inbound to one outbound
2) Acceptable weight range match one inbound to one outbound
3) One Inbound to Multiple Adjacent Outbounds
4) One Inbound to Multiple Non-adjacent Outbounds
5) Multiple adjacent inbounds to one outbound
6) Multiple adjacent inbounds to multiple adjacent outbounds
7) Multiple adjacent inbounds to multiple non-adjacent outbounds
8) Multiple non-adjacent inbounds to one outbound
9) Multiple non-adjacent inbounds to multiple adjacent outbounds
10) Multiple non-adjacent inbounds to multiple non-adjacent outbounds
-----------------------------------------------------------------------------------------------------------------------------

The idea is to have as many Inbounds and Outbound reconciled!

We have a VBA solution however, there is a major challenge that you can check in the attachment (VBA Reconciliation Challenge).

You can check (Testing_Data_3) excel sheet to understand the difference between how we manually reconcile vs. how the VBA reconciled the records.

We understand the problem is very complicated and requires huge calculations and optimisation.