Personal Project
Web Scraping & Automated Report Generation Tool
A Python app with a Tkinter GUI that scrapes data, processes it in Excel, and generates Word reports.
📍 Overview: This project combines web scraping, Excel data processing, and Word document generation into a single Python application with a Tkinter GUI. It automates data extraction, refines it with predefined filters, and produces formatted Word reports.
🔧 Features:
- Web Scraping & Excel Handling: Automatically scrapes websites to download and filter Excel files using custom logic and Pandas.
- Word Report Generator: Generates pre-formatted Word documents from filtered data or manual input, including branding and structured sections.
- User-Friendly GUI: A simple Tkinter interface allows for manual file selection or URL-based downloads.
🧰 Tech Stack:
- Language: Python.
- Libraries: `requests`, `BeautifulSoup`, `pandas`, `openpyxl`, `python-docx`, `tkinter`.
📚 Key Learnings: Building end-to-end automation pipelines, programmatically handling Excel and Word formats, integrating GUI elements, and parsing web-based data.