CSV Data Processor#

Transform, filter, clean, and convert delimited data files. No external dependencies — uses Python csv/JSON stdlib only.

Quick Start#

bash

# 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#

bash

python3 skills/csv-data-processor/scripts/csv_view.py data.csv --head 10 --stats

Filter Rows#

bash

python3 skills/csv-data-processor/scripts/csv_filter.py data.csv --where "price > 100" --sort price --limit 20

Merge Files#

bash

python3 skills/csv-data-processor/scripts/csv_merge.py sales_2024.csv sales_2025.csv --output combined.csv

Join on Column#

bash

python3 skills/csv-data-processor/scripts/csv_join.py left.csv right.csv --on user_id --output joined.csv

Clean Data#

bash

python3 skills/csv-data-processor/scripts/csv_clean.py dirty.csv --dedupe --fill-missing N/A --output clean.csv

Statistics#

bash

python3 skills/csv-data-processor/scripts/csv_stats.py data.csv --numeric age,revenue

Scripts#

ScriptPurposecsv_view.pyPreview, head/tail, summary statscsv_filter.pyFilter rows, sort, select columnscsv_merge.pyConcatenate multiple CSV filescsv_join.pyJoin/merge on shared columnscsv_convert.pyConvert CSV ↔ JSON ↔ SQLcsv_clean.pyDedupe, fill missing, fix encodingcsv_stats.pyNumeric stats, value counts, histograms

Key Options#

All scripts accept:

• --delimiter — Field delimiter (default: , for CSV, \t for TSV)
• --encoding — File encoding (default: utf-8)
• --has-header / --no-header — Column header handling
• --output / -o — Output file path