skills.rest
CBoser
CBoserCOMMUNITY
Explore all skills by this author →
GitHub

csv-validator

Validate BOM CSV files for ECIR tool compatibility and fix issues.

Updated Aug 27, 2026
Search Tags:#CLI#pandas#validate#CSV#data-quality#data-cleaning#ECIR
One-click install
npx skills add https://github.com/CBoser/ConstructionPlatform --skill csv-validator
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: csv-validator
Source: https://github.com/CBoser/ConstructionPlatform/tree/main/docs/archive/skills/claude_skills/ECIR_Processing/csv-validator/csv-validator
Command: npx skills add https://github.com/CBoser/ConstructionPlatform --skill csv-validator

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, and includes scripts (resource) components.

What problem does it solve?

Validates and fixes BOM CSV files to ensure compatibility with the ECIR tool, catching missing columns, invalid data types, duplicates, and common formatting issues that would break ECIR comparisons.

Core Features & Use Cases

  • Normalize and validate required columns (Category, Item, Quantity, UnitCost)
  • Detect non-numeric values, duplicates, and empty fields; offer actionable remediation
  • Prepare ECIR-ready CSVs by auto-fixing common issues, or report issues for manual correction
  • Use Case: Before ECIR comparisons, run the validator to ensure inputs won't fail and optionally produce a fixed CSV

Quick Start

Use the validator to inspect a BOM CSV:

  • Validate: python scripts/validate_bom_csv.py path/to/bom.csv
  • Validate and fix: python scripts/validate_bom_csv.py path/to/bom.csv --fix path/to/bom_fixed.csv
  • Quiet/summary: python scripts/validate_bom_csv.py path/to/bom.csv --quiet

Frequently Asked Questions about csv-validator

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I validate a CSV file before using it with ECIR?▼

CSV validation checks your BOM file for required columns, data types, duplicates, and formatting issues that would break ECIR comparisons. Run the validator against your CSV to identify problems and optionally auto-fix them into an ECIR-ready file.

Can I automatically fix common CSV formatting issues?▼

Yes, the validator normalizes column names, converts non-numeric values, removes rows with empty required fields, and detects duplicates. Use the --fix flag to write a corrected CSV directly.

What columns are required for ECIR compatibility?▼

ECIR-ready CSVs must include Category, Item, Quantity, and UnitCost columns. The validator checks for these required fields and reports missing or malformed columns before ECIR processing.

Do I need pandas installed to run the CSV validator?▼

Yes, pandas is a required dependency. The validator uses pandas to parse, validate, and normalize your BOM CSV data before outputting results.

What happens if my CSV has duplicate rows or empty values?▼

The validator detects duplicates and rows with empty required fields, reporting them as validation failures. With --fix enabled, it removes these problematic rows to produce a clean, valid output CSV.

Related Skills

Explore More Data & Analytics Skills→
synqingsynqing
15

kicad-part-picker

Map schematic symbols to footprints and generate BOMs in CSV/YAML formats.

Community
Intermediate
htuzelhtuzel

Analyzing Spreadsheets

Analyze Excel and CSV spreadsheet data for trends and KPI insights.

Community
Intermediate
nahisahonahisaho
12

change-impact-analyzer

Analyze proposed changes to detect breaking changes and generate impact reports.

Community
Advanced
cdxgencdxgen
1.0k

cyclonedx-spec-reviewer

Review cdxgen changes for CycloneDX schema compliance and semantic correctness.

Official
Advanced