Generate a diff between two CSV files.
Project description
Overview
Generate a diff between two CSV files on the command-line.
Installing
pip install csvdiff
Examples
For example, suppose we have a.csv:
id,name,amount 1,bob,20 2,eva,63 3,sarah,7 4,jeff,19 6,fred,10
and a matching file after some changes, b.csv:
id,name,amount 1,bob,23 3,sarah,7 4,jeff,19 5,mira,81 6,fred,13
Now we can ask for a summary of differences:
$ csvdiff --summary -k id a.csv b.csv 1 rows removed (20.0%) 1 rows added (20.0%) 2 rows changed (40.0%)
Or look at the full diff, using YAML rather than JSON (the default) to make it more readable:
$ csvdiff --yaml -k id a.csv b.csv removed: - amount: '63' id: '2' name: eva added: - amount: '81' id: '5' name: mira changed: - fields: amount: from: '10' to: '13' key: - '6' - fields: amount: from: '20' to: '23' key: - '1'
It gives us the full listing of added and removed rows, as well as a listing of what fields changed for that shared a key.
For more usage options, run csvdiff --help.
License
BSD license
History
0.1.0 (2014-03-15)
First release on PyPI.
Generates a JSON or YAML difference between two CSV files
Specify multiple key components with -k
Can provide a difference summary
Assumes files use standard comma-separation, double-quoting and a header row with field names
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
Built Distribution
Hashes for csvdiff-0.1.0-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e0c76251ce5bd0caca1d6d531d0c725e4eaa8206ffb9342e591854a215124c8a |
|
MD5 | d8b5c6d1d573145ebe06ae2f2c7d7465 |
|
BLAKE2b-256 | dcfe1095a2fbb9c32132aa1792b2a86789579cdbf1e48e1ff3c546a615f1cd6d |