Python Automation Tool -- 2

I need a small Python application that can open an Excel workbook, reshape or reformat the data exactly the way I describe, and then produce a clear, publication-ready graphical report with a single click. The flow I have in mind is simple: a button-based GUI lets the user choose an .xlsx file; Pandas and openpyxl handle the import; the data are transformed to the new structure or units I specify; Matplotlib builds the chart; and the finished report is saved both back into an updated workbook and as a standalone PDF.

Clean, well-commented code is essential because I’ll want to maintain the project internally later. Please keep external dependencies to a minimum, organise functions logically, and name variables sensibly. After delivery, I’d appreciate a quick walk-through and a short support window for any minor tweaks.

Deliverables
• Source code (.py) and any helper modules
• Executable or runnable package with a simple GUI
• Sample output: updated Excel file plus PDF containing the chart
• Brief usage notes or README

Acceptance will be based on the tool opening a sample file I provide, transforming the data without errors, and generating a graphical report that matches the agreed layout. I’m happy to answer questions quickly so you can keep momentum—let’s build something that saves my team a lot of manual effort.