Recipe
Recipe: Messy CSV → clean data
Strip BOMs, normalize headers, dedupe rows, and export sanitized CSV in one pass.
Ingredients
- A CSV file with inconsistent headers, blank rows, or duplicate entries
- Meridian installed and authenticated
- Terminal access (PowerShell or bash)
Steps
- Drop the file — place your CSV in
~/meridian/inbox/ - Run the cleaner:
meridian clean-csv --input messy.csv --output clean.csv
- Review the report — Meridian prints rows dropped, headers normalized, and encoding fixed.
- Verify output — open
clean.csvin your spreadsheet app.
Flags
| Flag | Purpose |
|---|---|
| --dedupe | Remove duplicate rows by content hash |
| --trim | Strip leading/trailing whitespace from every cell |
| --lowercase-headers | Normalize all column names to lowercase |
Tip: Chain withmeridian validate-csvto enforce schema constraints after cleaning.