This project demonstrates how to automate Excel data cleaning,
calculation, and reporting using Python and Pandas.
Reads multi-sheet Excel data
Handles missing values
Calculates sales, discounts, and profit
Generates automated Excel reports
Creates region-wise summary
Python Pandas Excel
Install dependencies:
pip install -r requirements.txt
python excel_automation.py
This project is open-source and available under the MIT License.