AI-Driven Excel Comparator
Budget: $10 – $15 USD
I have two Excel workbooks that do not share the same column headers. Alongside them is a separate mapping file that tells the AI which column in file-A corresponds to which column in file-B.
What I need you to build is a small AI-assisted agent—Python with pandas / openpyxl is fine, but feel free to use any modern data-processing stack—that:
• Reads both workbooks and the mapping file, even when the headers differ.
• Performs a full comparison, returning every missing row or column and every cell whose mapped values differ.
• Generates a concise, human-readable summary report (this is the only required output) that lists those discrepancies.
Extra care is needed around stray spaces or data that has been moved inside a row; the agent shouldn’t “fix” these automatically. Instead, flag them clearly in the report so I can review and decide.
I’ll provide the two Excel files and the mapping table once we start. Please structure your solution so I can drop in future files and rerun the script. A brief README explaining how to execute it will be appreciated.
What I need you to build is a small AI-assisted agent—Python with pandas / openpyxl is fine, but feel free to use any modern data-processing stack—that:
• Reads both workbooks and the mapping file, even when the headers differ.
• Performs a full comparison, returning every missing row or column and every cell whose mapped values differ.
• Generates a concise, human-readable summary report (this is the only required output) that lists those discrepancies.
Extra care is needed around stray spaces or data that has been moved inside a row; the agent shouldn’t “fix” these automatically. Instead, flag them clearly in the report so I can review and decide.
I’ll provide the two Excel files and the mapping table once we start. Please structure your solution so I can drop in future files and rerun the script. A brief README explaining how to execute it will be appreciated.