{ "info": { "author": "David Winterbottom", "author_email": "david.winterbottom@gmail.com", "bugtrack_url": null, "classifiers": [], "description": "================================\ncsvfilter - Simple CSV filtering\n================================\n\nA simple wrapper around Python's CSV module to provide a command-line tool for\nfiltering columns from a CSV file. This is useful as standard tools like awk\ncan't easily handle the quoting and escaping used in CSV files. \n\nBasically, it's a bit like ``cut`` but for CSVs.\n\nInstall\n-------\n\nFrom PyPi::\n\n pip install csvfilter\n\nUse\n---\n\nPluck fields 1, 3 and 5 from ``in.csv``::\n\n csvfilter -f 1,3,5 in.csv > out.csv\n\nPluck all fields apart from column 2 from STDIN::\n\n cat in.csv | csvfilter -f 2 -i > out.csv\n\nConvert pipe-separated file to comma-separated (by default, output is \ncomma-separated)::\n\n csvfilter -d\"|\" in.psv > out.csv \n\nSkip that pesky header row::\n\n cat in.csv | csvfilter --skip=1\n\nAs you can see, CSV data can be supplied through STDIN or by running ``csvfilter`` directly on a\nfile.\n\nHelp is in the usual place::\n\n $ csvfilter --help\n\n Usage: csvfilter [options] [inputfile]\n\n Source: https://github.com/codeinthehole/csvfilter/\n\n Options:\n -h, --help show this help message and exit\n -f FIELDS, --fields=FIELDS\n Specify which fields to pluck\n -s SKIP, --skip=SKIP Number of rows to skip\n -d DELIMITER, --delimiter=DELIMITER\n Delimiter of incoming CSV data\n -q QUOTECHAR, --quotechar=QUOTECHAR\n Quotechar of incoming CSV data\n\n -i, --inverse Invert the filter - ie drop the selected fields\n --out-delimiter=OUT_DELIMITER\n Delimiter to use for output\n --out-quotechar=OUT_QUOTECHAR\n Quote character to use for output\n\nReport issues\n-------------\n\nUse the `Github issue tracker`_ or, better still...\n\n.. _`Github issue tracker`: https://github.com/codeinthehole/csvfilter/issues\n\nContribute\n----------\n\nAfter cloning, install the testing requirements::\n\n pip install -r requirements.txt\n\nInstall the package in 'develop' mode to bring the executable onto your path::\n\n ./setup.py develop\n\nRun the tests with::\n\n nosetests\n\nand, if it helps, use the fixture files to test your amendments::\n\n cat fixtures/au.csv | csvfilter -f 3,1,2 -s 1\n csvfilter fixutres/au.csv -f 1,2 -i\n\nHave fun.", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/codeinthehole/csvfilter", "keywords": null, "license": "MIT", "maintainer": null, "maintainer_email": null, "name": "csvfilter", "package_url": "https://pypi.org/project/csvfilter/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/csvfilter/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://github.com/codeinthehole/csvfilter" }, "release_url": "https://pypi.org/project/csvfilter/0.3.1/", "requires_dist": null, "requires_python": null, "summary": "A command-line utility and Python API for manipulating CSV data, eg plucking columns and reordering them. It's a bit like the unix utility 'cut'", "version": "0.3.1" }, "last_serial": 1356585, "releases": { "0.1": [ { "comment_text": "", "digests": { "md5": "ea91b40e85fab66684c446d0a95c4be4", "sha256": "796c6a6e7b6add0307591cbc6f0c770beac94e78cd7c588bbb59960d1a294064" }, "downloads": -1, "filename": "csvfilter-0.1.tar.gz", "has_sig": false, "md5_digest": "ea91b40e85fab66684c446d0a95c4be4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3236, "upload_time": "2012-03-13T23:53:29", "url": "https://files.pythonhosted.org/packages/b3/80/7423f4b6a676701ca0641c260a965e07dc1f49596c215fb59c3db8d74396/csvfilter-0.1.tar.gz" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "325581c13aee9f623d616fd21be7a111", "sha256": "c40d5987740dbedc3641405130fc5ee6ebcc85c00144f4f163d58fbd4466dc7c" }, "downloads": -1, "filename": "csvfilter-0.1.1.tar.gz", "has_sig": false, "md5_digest": "325581c13aee9f623d616fd21be7a111", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3432, "upload_time": "2012-03-13T23:56:18", "url": "https://files.pythonhosted.org/packages/64/67/644cde525cca4b409a67db55ffc4b2ca64c24fecbfba4ca091d348d06e9c/csvfilter-0.1.1.tar.gz" } ], "0.2": [ { "comment_text": "", "digests": { "md5": "9bd275db9a3f62b6e4875a30d521c958", "sha256": "14d1e6e851f9a5e49ba601d51fd7910cb381ea5cac16ba25e2264caf59a65457" }, "downloads": -1, "filename": "csvfilter-0.2.tar.gz", "has_sig": false, "md5_digest": "9bd275db9a3f62b6e4875a30d521c958", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3765, "upload_time": "2012-04-01T16:43:01", "url": "https://files.pythonhosted.org/packages/97/7e/9c041d5c98d9d2f5d68f2283fdffa779ed0262553e259d55558dd597f1f6/csvfilter-0.2.tar.gz" } ], "0.2.1": [ { "comment_text": "", "digests": { "md5": "9a2d40930f90a5301602d7f03aa4353f", "sha256": "7637a8de103b430c1682c7aefd675f1f24f1beaa3bc1141a27a5287dcb6fc5b8" }, "downloads": -1, "filename": "csvfilter-0.2.1.tar.gz", "has_sig": false, "md5_digest": "9a2d40930f90a5301602d7f03aa4353f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3727, "upload_time": "2012-04-01T23:10:15", "url": "https://files.pythonhosted.org/packages/00/db/67136b1a134820f57e9ac33afde521b6b0d944de42105d2df2a3f421fa3c/csvfilter-0.2.1.tar.gz" } ], "0.2.2": [ { "comment_text": "", "digests": { "md5": "43c79c9d7fe905c08c445e86a6ffcc62", "sha256": "56d8e0048fd7831c1aee23adb9a1e94e4e5179f20edfe72228924a6c4fc3cb06" }, "downloads": -1, "filename": "csvfilter-0.2.2.tar.gz", "has_sig": false, "md5_digest": "43c79c9d7fe905c08c445e86a6ffcc62", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3903, "upload_time": "2012-04-12T22:25:24", "url": "https://files.pythonhosted.org/packages/3e/20/2a8a9231a50c90cda99e53b7b9a2375631cfb421570d7fddc62c99a17bca/csvfilter-0.2.2.tar.gz" } ], "0.3": [ { "comment_text": "", "digests": { "md5": "f81f062c6423b6c02b4188b923746619", "sha256": "6e9c239fb87e47c73c511489ca41435aad78e68e38cc299e541604a5650d6902" }, "downloads": -1, "filename": "csvfilter-0.3.tar.gz", "has_sig": false, "md5_digest": "f81f062c6423b6c02b4188b923746619", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3909, "upload_time": "2013-12-26T22:01:37", "url": "https://files.pythonhosted.org/packages/93/c0/c2133871c1d462cc9465017efdc0c42c656e48c49bdd6a1d0e6ff4e0ba9f/csvfilter-0.3.tar.gz" } ], "0.3.1": [ { "comment_text": "", "digests": { "md5": "212b04b081276faf790f5d8a661b5553", "sha256": "281f2a3317e28f1c9423105ac93cea93105553437a50b56ab53b23110ce42654" }, "downloads": -1, "filename": "csvfilter-0.3.1.tar.gz", "has_sig": false, "md5_digest": "212b04b081276faf790f5d8a661b5553", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3985, "upload_time": "2014-12-21T21:33:14", "url": "https://files.pythonhosted.org/packages/03/75/acc4463724acdc3d70d9ff9105878019e24208447553f836f06324221673/csvfilter-0.3.1.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "212b04b081276faf790f5d8a661b5553", "sha256": "281f2a3317e28f1c9423105ac93cea93105553437a50b56ab53b23110ce42654" }, "downloads": -1, "filename": "csvfilter-0.3.1.tar.gz", "has_sig": false, "md5_digest": "212b04b081276faf790f5d8a661b5553", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3985, "upload_time": "2014-12-21T21:33:14", "url": "https://files.pythonhosted.org/packages/03/75/acc4463724acdc3d70d9ff9105878019e24208447553f836f06324221673/csvfilter-0.3.1.tar.gz" } ] }