CSV Wizard

A fast, zero-dependency Python CLI tool for cleaning, merging, analyzing, and converting CSV data.

No external libraries required - runs with Python 3.6+ standard library only.

Features

• Clean: Remove duplicates, trim whitespace, fill missing values, normalize case
• Merge: Combine multiple CSV files (even with different columns)
• Report: Generate data quality reports with statistics per column
• Convert: Export to JSON, JSONL, TSV, or Markdown

Quick Start

# Clean a messy CSV file
python csv_wizard.py clean messy_data.csv -o clean_data.csv

# Clean with options
python csv_wizard.py clean data.csv -o clean.csv --fill "N/A" --normalize-case

# Merge multiple files
python csv_wizard.py merge jan.csv feb.csv mar.csv -o combined.csv --dedup

# Generate a data quality report
python csv_wizard.py report sales.csv -o report.txt

# Convert to JSON
python csv_wizard.py convert data.csv -o data.json --format json

# Convert to Markdown table
python csv_wizard.py convert data.csv -o data.md --format markdown

Example

Input (messy_sales.csv):

Name,Email,Amount,City
  John Smith ,john@example.com, 150.00 ,New York
jane doe,jane@example.com,200.50,  los angeles
  John Smith ,john@example.com, 150.00 ,New York    <- duplicate

Command:

python csv_wizard.py clean messy_sales.csv -o cleaned.csv --normalize-case

Output (cleaned.csv):

Name,Email,Amount,City
John Smith,john@example.com,150.00,New York
Jane Doe,jane@example.com,200.50,Los Angeles

Result: duplicates removed, whitespace trimmed, case normalized.

Commands

Command	Description
clean	Remove duplicates, trim whitespace, fill blanks
merge	Combine multiple CSV files into one
report	Generate column-level statistics and quality metrics
convert	Convert CSV to JSON, JSONL, TSV, or Markdown

Requirements

• Python 3.6+
• No external dependencies