CSV 数据清理器

Clean and normalize CSV data with precision

A Python tool that detects and fixes common CSV data issues: missing values, duplicate rows, inconsistent formatting, encoding problems, and schema validation. Supports batch processing with customizable cleaning rules.

Features

• Auto-detect missing values & duplicates
• Encoding detection & conversion
• Schema validation & normalization
• Batch processing support
• Custom cleaning rule engine
• CSV/TSV/Excel input support

$ csv-cleaner inspect messy.csv

⚠ Found 47 issues in messy.csv:

[REMOVE] Row 12: duplicate of row 8 (100% match)
[FIX]   Col "email": 3 invalid formats → normalized
[FIX]   Col "date": 12 inconsistent formats
        → unified to ISO 8601
[FIX]   Col "price": $1,234.56 → 1234.56
[WARN]  Col "name": 2 rows have leading/trailing spaces

📊 Report saved: messy_cleaned_report.json
✅ Cleaned file: messy_cleaned.csv (47 issues resolved)