Skip to main content

Merge, deduplicate, and clean CSV files from the command line

Project description

CSV Merger & Cleaner

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

Install

pip install csv-merger-cleaner

Usage

Merge two files:

csv-merge -i file1.csv file2.csv -o merged.csv

Merge and deduplicate by email:

csv-merge -i *.csv --dedup email -o cleaned.csv

Merge all CSVs, dedup by name+phone, show stats:

csv-merge -i data/*.csv --dedup name,phone --stats

Fill empty cells:

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

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

csv_merger_cleaner-1.0.0.tar.gz (3.6 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

csv_merger_cleaner-1.0.0-py3-none-any.whl (4.2 kB view details)

Uploaded Python 3

File details

Details for the file csv_merger_cleaner-1.0.0.tar.gz.

File metadata

  • Download URL: csv_merger_cleaner-1.0.0.tar.gz
  • Upload date:
  • Size: 3.6 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.11.6

File hashes

Hashes for csv_merger_cleaner-1.0.0.tar.gz
Algorithm Hash digest
SHA256 54aa86d0c04d83bfd3b4f3bc5d39aa3bb1512cbc524e48c6e743fb88dfd35370
MD5 051f42c34c8ee07624a3061dc25db473
BLAKE2b-256 5259afa4e83752b5b7763ff8d4daf91c861d5cf8304ab659d8de65dc2e3cc08f

See more details on using hashes here.

File details

Details for the file csv_merger_cleaner-1.0.0-py3-none-any.whl.

File metadata

File hashes

Hashes for csv_merger_cleaner-1.0.0-py3-none-any.whl
Algorithm Hash digest
SHA256 99888c6d0b16c1836b9adddeda3bccefd7ea2db34a38e2ef8756632d77ac6127
MD5 f4022c8359b40f530d4a25e77eb9bf85
BLAKE2b-256 61af9d9609243e20bb4c230a094c090df68d57048b955598d4616e6557e26f48

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page