| name | csv-taxonomy-consolidation |
| description | Consolidate multiple CSV spreadsheets into a normalized taxonomy with deduplication, column mapping, hierarchy alignment, and audit reports. |
| tags | ["csv","taxonomy","spreadsheet","deduplication","pandas","hierarchy"] |
CSV Taxonomy Consolidation
When to Use
Use when the user has multiple CSV files or spreadsheets that need schema mapping, duplicate merging, taxonomy hierarchy cleanup, or reproducible audit reports.
Do Not Use When
Do not use for plotting figures, PDF conversion, GitHub workflow work, or prose rewriting.
Required Inputs
Input CSV paths, key columns, target taxonomy schema, merge rules, and output format.
Workflow
- Profile columns, encodings, row counts, and duplicate keys.
- Map source columns to a canonical taxonomy schema.
- Merge records with deterministic conflict rules and hierarchy validation.
- Write consolidated CSV plus an audit report.