Python Desktop Automation App

I need a compact desktop program written in Python that can automatically scrape data from a predefined set of web pages, clean or transform that information, and store it in a tidy format (CSV or SQLite—whichever you feel is more robust for the job). A simple GUI is required so I can paste in or update target URLs, press a single button, and watch the progress log inside the window while the app does the heavy lifting.

Core workflow
• Fetch the pages I specify, even if they sit behind basic HTTP auth or require a user-agent header.
• Parse the relevant tables, lists, or JSON responses and strip out anything I don’t need.
• Save the cleaned dataset locally, overwriting or versioning based on a toggle in the settings pane.

I’m comfortable with widely used Python libraries such as requests, BeautifulSoup, pandas, and PyQt/Tkinter, so feel free to lean on them. The finished tool should run on Windows 10+ without me having to install Python separately (an auto-contained EXE via PyInstaller is fine).

Deliverables
1. Compiled executable and full, well-commented source code
2. README covering setup, usage, and how to add new scrape targets
3. Brief hand-off call or video walkthrough to be sure everything is clear

Acceptance criteria
• GUI launches cleanly, no console pop-ups
• Scrape, transformation, and save steps complete in one click without errors
• Output matches the structure we agree on for at least three test sites I provide

If you have questions about edge cases—rate limiting, CAPTCHA, or proxies—let’s talk early so we build the right safeguards from the start. Looking forward to seeing how you’d tackle this.