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, \t for TSV)
• --encoding — File encoding (default: utf-8)
• --has-header / --no-header — Column header handling
• --output / -o — Output file path