Develop Data Reconciliation Application using Python
Budget: $250 – $750 USD
Need a great developer to create a Data Reconciliation Application using Python (check attached).
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 rows using below scenarios:
1) Perfect weight match one inbound to one outbound
2) Acceptable weight range match one inbound to one outbound
3) Multiple adjacent inbounds to one outbound
4) Multiple adjacent inbounds to multiple adjacent outbounds
5) Multiple adjacent inbounds to multiple non-adjacent outbounds
6) Multiple non-adjacent inbounds to one outbound
7) Multiple non-adjacent inbounds to multiple adjacent outbounds
8) Multiple non-adjacent inbounds to multiple non-adjacent outbounds
-----------------------------------------------------------------------------------------------------------------------------
2 files attached:
1. Reconciliation Process (2 tabs)
2. Testing_Data_1 (2 tabs, pre-reconciliation and post-reconciliation)
You need to get the same results as in the Post-Reconciliation tab
-----------------------------------------------------------------------------------------------------------------------------
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 rows using below scenarios:
1) Perfect weight match one inbound to one outbound
2) Acceptable weight range match one inbound to one outbound
3) Multiple adjacent inbounds to one outbound
4) Multiple adjacent inbounds to multiple adjacent outbounds
5) Multiple adjacent inbounds to multiple non-adjacent outbounds
6) Multiple non-adjacent inbounds to one outbound
7) Multiple non-adjacent inbounds to multiple adjacent outbounds
8) Multiple non-adjacent inbounds to multiple non-adjacent outbounds
-----------------------------------------------------------------------------------------------------------------------------
2 files attached:
1. Reconciliation Process (2 tabs)
2. Testing_Data_1 (2 tabs, pre-reconciliation and post-reconciliation)
You need to get the same results as in the Post-Reconciliation tab
-----------------------------------------------------------------------------------------------------------------------------