Apply automated fixes to clean data quality issues.
Usage
goldencheck fix data.csv # safe mode (default)
goldencheck fix data.csv --mode moderate # + case standardization
goldencheck fix data.csv --mode aggressive --force # + type coercion
goldencheck fix data.csv --dry-run # preview without writing
goldencheck fix data.csv -o cleaned.csv # custom output path
Modes
| Mode | Fixes | Risk |
|---|---|---|
safe (default) | Trim whitespace, remove invisible chars, normalize Unicode, fix smart quotes/encoding | Zero data loss |
moderate | Safe + standardize enum case (match dominant casing) | Minimal — formatting only |
aggressive | Moderate + coerce string→numeric types. Requires --force | Data modification |
Output
Fixes applied (safe mode):
name: trim_whitespace (150 rows)
description: remove_invisible_chars (3 rows)
notes: fix_smart_quotes (12 rows)
Total: 165 row-fixes across 3 operations
Written to: data_fixed.csv
Behavior
- Default output:
{filename}_fixed.csv - Never overwrites the input file
--dry-runshows the fix summary without writing- If no fixes needed: prints “No issues found — file is clean”
- Excel input → CSV output (with warning)