CSV Data Processor
Process, filter, merge, clean, convert, and analyze CSV or delimited data files, supporting CSV, TSV, JSON, and SQL formats with customizable options.
CSV Data Processor
Transform, filter, clean, and convert delimited data files. No external dependencies — uses Python csv/JSON stdlib only.
Quick Start
# View first 10 rows
python3 skills/csv-data-processor/scripts/csv_view.py data.csv
# Filter rows
python3 skills/csv-data-processor/scripts/csv_filter.py data.csv --where "age > 25"
# Convert to JSON
python3 skills/csv-data-processor/scripts/csv_convert.py data.csv --to json
Common Commands
Preview Data
python3 skills/csv-data-processor/scripts/csv_view.py data.csv --head 10 --stats
Filter Rows
python3 skills/csv-data-processor/scripts/csv_filter.py data.csv --where "price > 100" --sort price --limit 20
Merge Files
python3 skills/csv-data-processor/scripts/csv_merge.py sales_2024.csv sales_2025.csv --output combined.csv
Join on Column
python3 skills/csv-data-processor/scripts/csv_join.py left.csv right.csv --on user_id --output joined.csv
Clean Data
python3 skills/csv-data-processor/scripts/csv_clean.py dirty.csv --dedupe --fill-missing N/A --output clean.csv
Statistics
python3 skills/csv-data-processor/scripts/csv_stats.py data.csv --numeric age,revenue
Scripts
| Script | Purpose |
|---|---|
csv_view.py | Preview, head/tail, summary stats |
csv_filter.py | Filter rows, sort, select columns |
csv_merge.py | Concatenate multiple CSV files |
csv_join.py | Join/merge on shared columns |
csv_convert.py | Convert CSV ↔ JSON ↔ SQL |
csv_clean.py | Dedupe, fill missing, fix encoding |
csv_stats.py | Numeric stats, value counts, histograms |
Key Options
All scripts accept:
--delimiter— Field delimiter (default:,for CSV,\tfor TSV)--encoding— File encoding (default: utf-8)--has-header/--no-header— Column header handling--output/-o— Output file path
Related skills
- Downloads
- 1.1kAll time
- Security audit
- Review
- Last updated
- 6mo ago
- Current version
- v1.0.0
- License
- MIT-0
