field-validation

What problem does it solve?

This Skill helps data teams ensure CSV/Excel data quality for vehicle insurance by validating required fields, data formats, and detecting issues. It reduces manual review time and prevents faulty data from entering dashboards or reports.

Core Features & Use Cases

• Load & inspect data from CSV/Excel files (e.g., data/车险清单_2025.csv)
• 4-layer validation workflow: Layer 1 - Required fields; Layer 2 - Formats; Layer 3 - Reasonableness; Layer 4 - Cross-field consistency
• Quality reporting: generate a concise quality report highlighting gaps, format errors, and suggested fixes
• Use Case: Before monthly reporting, validate that key fields exist and have valid values to ensure accurate KPIs

Quick Start

Load your dataset (e.g., data/insurance_claims.csv) and run the field-validation workflow to produce a quality report. You can adapt the example to your own dataset.