A Python tool I built for a manufacturing employer to turn their raw "reject square footage" export into clean, grouped reports and charts.
It reads the plant's RejectSqFtReport.xlsx, cleans and renames the columns,
then uses pandas to group remakes four ways — by shift, employee,
station, and reject code — and either exports each breakdown to its own
.xlsx or plots it as a bar chart with matplotlib.
Python · pandas · matplotlib · openpyxl
pip install pandas matplotlib openpyxl
python Cardinal_Report.pyIt asks whether to write the grouped Excel files, then which report to chart
(code, station, employee, or shift).
Turned a manual, error-prone spreadsheet task into a repeatable script — real data cleaning and reporting for an actual production floor.