Join or merge multiple CSVs.
Project description
csvblend: Python CSV Merge Library
Join or merge multiple CSVs.
csvblend is a Python library to merge multiple CSVs based on a list of columns efficiently.
NOTE: csvblend requires SQLite version 3.24.0 (2018-06-04) or better:
python -c 'import sqlite3; print(sqlite3.sqlite_version)'
Basic merge usage:
>>> from csvblend import MergeFiles
>>> columns = ["field1", "field2", "field3"]
>>> indexes = ["field1"]
>>> with MergeFiles(columns, indexes) as mf:
... with open("csvfile1") as fp:
... mf.merge(fp)
... with open("csvfile2") as fp:
... mf.merge(fp)
... with open("csvfile3") as fp:
... mf.merge(fp)
... for row in mf.rows():
... print(row)
Features | Installation | Usage | Contributing | License
Features
- SQLite (RDBMS) under the hood.
- Affected row count (created or updated) -- show changes between CSVs.
- No external dependencies.
csvblend officially supports Python 3.8+.
Installation
To install csvblend, simply run:
$ pip install -U csvblend
✨🖇✨
Usage
For documentation, see ./docs/README.md.
Contributing
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
License
This project is licensed under the MIT License.
