Metadata-Version: 2.4
Name: csv-merger-cleaner
Version: 1.0.0
Summary: Merge, deduplicate, and clean CSV files from the command line
Author: hanu-14
License: MIT
Project-URL: Homepage, https://github.com/hanu-14/csv-merger-cleaner
Keywords: csv,merge,deduplicate,data-cleaning,cli
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Requires-Python: >=3.8
Description-Content-Type: text/markdown
Requires-Dist: chardet>=3.0

# CSV Merger & Cleaner

Merge multiple CSV files, remove duplicates, fill missing values, and generate statistics.

## Install

```bash
pip install csv-merger-cleaner
```

## Usage

Merge two files:
```bash
csv-merge -i file1.csv file2.csv -o merged.csv
```

Merge and deduplicate by email:
```bash
csv-merge -i *.csv --dedup email -o cleaned.csv
```

Merge all CSVs, dedup by name+phone, show stats:
```bash
csv-merge -i data/*.csv --dedup name,phone --stats
```

Fill empty cells:
```bash
csv-merge -i input.csv --fill "N/A" -o output.csv
```

## Features

- Merge multiple CSV files into one
- Auto-detect encoding (UTF-8, Latin-1, CP1252)
- Deduplicate by single or multiple columns
- Fill empty cells with custom value
- Generate detailed statistics
- Preserve all columns across files
