Python Automation for Excel Reporting
Budget: ₹12,500 – ₹37,500 INR
I need a skilled Python developer to automate our daily Excel reporting process with precision and performance.
Key Tasks:
- Read & merge multiple Excel workbooks from a folder.
- Data cleaning: remove duplicates, handle missing values (mean/mode fill), normalize column formats.
- Apply business logic: group by product, category, and date (customizable).
- Generate visual charts (using Matplotlib/Seaborn) for trends and KPIs.
- Export final summary to well-formatted Excel and PDF.
- (Optional) Send output via email.
Bonus: GUI-based script using Tkinter or PyQt is a plus.
Requirements:
- Experience in Python, Pandas, and Excel automation.
- Portfolio or demo is a plus.
- Explain your logic with code comments preferred.
Let's make this process 10x faster and error-free!
Key Tasks:
- Read & merge multiple Excel workbooks from a folder.
- Data cleaning: remove duplicates, handle missing values (mean/mode fill), normalize column formats.
- Apply business logic: group by product, category, and date (customizable).
- Generate visual charts (using Matplotlib/Seaborn) for trends and KPIs.
- Export final summary to well-formatted Excel and PDF.
- (Optional) Send output via email.
Bonus: GUI-based script using Tkinter or PyQt is a plus.
Requirements:
- Experience in Python, Pandas, and Excel automation.
- Portfolio or demo is a plus.
- Explain your logic with code comments preferred.
Let's make this process 10x faster and error-free!
Related categories:
Python
Data Processing
Accounting
Excel
Software Architecture
PostgreSQL
Data Visualization
Data Analysis
Automation
Pandas