Shop-Floor Defect Data Analysis Assistant

What Problem It Addresses

Shop-floor inspections, process defects, and finished-goods inspection ledgers often live in Excel, CSV, Word, or PDF files with inconsistent headers, merged cells, and ambiguous counting rules. This skill turns those on-site quality records into a reviewable analysis, without turning into a heavyweight quality-statistics system.

How It Works

The skill follows a fixed workflow: parse_data.py reads the file structure and identifies sheets, headers, and key fields; clean_data.py handles blank rows, missing values, duplicates, and merged cells; analyze_data.py aggregates defect types, splits results by process/shift/product, and extracts TOP3 frequent defects; generate_charts.py produces an HTML report.
Its key behavior is interactive: when records only show pass/fail, lack defect counts, or have too few rows, it asks for confirmation before calculating. The output includes a data overview, Markdown tables, HTML charts, and prioritized corrective suggestions.

Scope and Limitations

It is intended for shop-floor nonconformances, process defects, inspection records, and finished-goods ledgers. It does not cover supplier quality, customer complaints, SPC control charts, CPK calculations, cost accounting, monthly summaries, or 8D reports. The output is deliberately lightweight for pasting into Feishu, WPS, or other documents.