Multi-Report Generator (PyQt5)

A Python desktop application for generating multiple business reports from CSV files with Excel export. Built with PyQt5 and Pandas, featuring a modern dark-mode GUI using qdarkstyle.

Features

• Multi-Report Generation: Generate Inventory, Sales, HR, Marketing, and Feedback reports from CSV files.
• Excel Export: Reports are saved automatically as .xlsx files.
• Clean GUI: Dark-mode interface for easy navigation and usability.
• Real-Time Logging: Status messages and errors are displayed in the UI and saved to automation_log.txt.
• Data Aggregation: Calculates totals, averages, revenue, ROI, and more depending on report type.

🛠️ Technologies Used

• Language: Python 3.x
• GUI Framework: PyQt5
• Data Analysis: Pandas
• Excel Export: OpenPyXL
• UI Styling: qdarkstyle

Installation and Setup

1. Clone the Repository:

   git clone [YOUR_REPO_URL]
   cd [YOUR_REPO_NAME]

2. Install Dependencies:

   pip install pandas pyqt5 qdarkstyle openpyxl

3. Run the Application:

   python main.py

Quick Start

1. Click Browse to select your CSV file.
2. Choose the desired report type from the dropdown.
3. Click Generate Report – the Excel file will be saved automatically.
4. Check the automation_log.txt for detailed logs.

Supported Reports & Required Columns

Report Type	Required Columns
Inventory	Category, Brand, Price, Stock
Sales	Date, Product, Quantity, Price
HR	Department, Status, Salary, Join Date
Marketing	Campaign, Clicks, Conversions, Spend
Feedback	Date, Category, Rating

Future Enhancements

• Chart & graph visualization
• Batch CSV processing
• Database support (SQLite/MySQL)
• PDF export
• Web-based version

---

Git Commands for Finalizing Project

git add .
git commit -m "feat: Final project completion with PyQt5 GUI and multi-report generator"
git push