Highlights
- Replaced 3 hours of weekly manual spreadsheet work
- Merges data from 3 separate CSV sources
- Automated Monday morning email delivery via cron
- Formatted Excel output with summary tables and charts
- Error notifications for missing or malformed source files
About This Project
A Python automation tool built for a small retail business that was manually compiling weekly sales reports from CSV exports across their POS system, inventory tracker, and accounting software.
The script ingests CSVs from a shared folder, merges and cleans the data using Pandas, and generates formatted Excel reports with summary tables and basic charts. Reports are emailed automatically every Monday morning via a scheduled cron job. Error handling notifies the business owner if any source file is missing or malformed.
Tech Stack
PythonPandasSendGridBashLinux