AI-Driven Excel Comparator

Заказчик: AI | Опубликовано: 19.04.2026
Бюджет: 15 $

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.