Skip to content

dineshlabx/advanced_excel_automation

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Advanced Excel Automation using Python

This project demonstrates how to automate Excel data cleaning,

calculation, and reporting using Python and Pandas.

Project Features

Reads multi-sheet Excel data

Handles missing values

Calculates sales, discounts, and profit

Generates automated Excel reports

Creates region-wise summary

Technologies Used

Python Pandas Excel

How to Run

Install dependencies:

pip install -r requirements.txt

Run the script:

python excel_automation.py

Output

processed_sales.xlsx

Author

Dinesh Pandiyan B

License

This project is open-source and available under the MIT License.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages