Bill of Materials Cleaner (Python Automation)

A Python script that turns a messy parts list into a clean bill of materials in one command. The screenshot shows a real run: 8 raw rows with duplicate part numbers in different cases, comma decimals ("2,50"), extra spaces, a blank row and a missing supplier were cleaned into 5 merged parts with line totals and a BOM total of $43.10. What it does: - Merges duplicate part numbers and adds up quantities - Fixes decimal commas and normalises text and capitalisation - Skips blank rows and flags missing suppliers as UNKNOWN - Calculates line totals and the overall BOM cost - Exports a clean CSV ready for Excel or your ERP Tools: Python 3 standard library (csv), no extra installs.
Published
automation bom-bill-of-materials python