{ "info": { "author": "Phil Adams", "author_email": "philadams.net@gmail.com", "bugtrack_url": null, "classifiers": [], "description": "pluckr\n======\n\nPluck columns from csv files in the commandline. Like cut or awk, but without\nchoking on delimiter escaping.\n\ninstall\n-------\n\n`pip install pluckr`. Done.\n\nusage\n-----\n\nGrab columns 2 and 3 from stdin (`-f` is one-indexed):\n\n pluckr -f 2,3 < sample1.csv\n\nOr straight from a file:\n\n pluckr -f 2,1 sample1.csv\n\nYour requested order is retained:\n\n pluckr -f 1,2 sample1.csv != pluckr -f 2,1 sample1.csv\n\nYou can use Python's negative indices... grab the first and last cols:\n\n pluckr -f 1,-1 sample1.csv\n\nAnd you can mix in ranges for column selection:\n\n pluckr -f 2,4-6,9 sample1.csv\n\nCan't be sure which columns exist or what their indices are?\n\n pluckr --names sample1.csv\n\nFields that don't exist (e.g. `-f11111`) will be ignored.\n\nPreprended line numbers can be helpful:\n\n cat sample1.csv | pluckr --line-numbers\n\nSkip header row(s):\n\n cat sample1.csv | pluckr -s1\n\nGrab all but the 2nd column (drop columns instead of selecting them):\n\n pluckr -f 1 -i < sample2.csv\n\nRead (and write) various delimiters:\n\n pluckr -d, --out-delimiter=\\| < with-commas.csv > with-pipes.csv\n\nNote that passing tabs as arguments can be awkward; in a pinch, use:\n\n pluckr -d $'\\t'\n\nhelp\n----\n\nVia `--help`:\n\n usage: pluckr [-h] [-f FIELDS] [-i] [-d DELIMITER] [-q QUOTECHAR] [-s SKIP]\n [-l] [-n]\n [infile]\n\n Grab columns from csv input. http://github.com/philadams/pluckr\n\n positional arguments:\n infile input file (.csv)\n\n optional arguments:\n -h, --help show this help message and exit\n -f FIELDS ordered list of columns to retain; one-indexed\n -i, --inverse invert column retention: drop those in -f\n -d DELIMITER, --delimiter DELIMITER\n field delimiter when reading infile\n -q QUOTECHAR, --quotechar QUOTECHAR\n field quotechar when reading infile\n -s SKIP, --skip SKIP number of rows to skip\n -l, --line-numbers prepend line numbers to output\n -n, --names print column names; assumes one header row\n\ntests\n-----\n\nThis project uses [roundup](https://github.com/bmizerany/roundup) for testing.\nRun tests with `make test`.\n\nfuture\n------\n\n- allow -f to take columns by name when there's a header row?\n- implement --out-x for output delimiters etc.\n- json output? or, contribute a cli to kennethreitz/tablib\n- add out delimiter support\n- add out quotechar support", "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/philadams/pluckr", "keywords": null, "license": "LICENSE.txt", "maintainer": null, "maintainer_email": null, "name": "pluckr", "package_url": "https://pypi.org/project/pluckr/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/pluckr/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://github.com/philadams/pluckr" }, "release_url": "https://pypi.org/project/pluckr/0.0.9/", "requires_dist": null, "requires_python": null, "summary": "Pluck columns from CSV files in the command line. Like cut or awk, but doesn't choke on delimiter escaping.", "version": "0.0.9" }, "last_serial": 1441657, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "fde18827c7d2312949e22009aff0384a", "sha256": "54a7602a5c8dcf74886b718d0016550c077c8520fd40af147b7878b6176237b8" }, "downloads": -1, "filename": "pluckr-0.0.1.tar.gz", "has_sig": false, "md5_digest": "fde18827c7d2312949e22009aff0384a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1002, "upload_time": "2013-01-07T17:07:23", "url": "https://files.pythonhosted.org/packages/14/ca/f6a11464bb7346b2b55f15822b91c7111080b43560ed622f1fdec4ce77e9/pluckr-0.0.1.tar.gz" } ], "0.0.2": [ { "comment_text": "", "digests": { "md5": "a07d03c9629515084410cfbb4f4acddd", "sha256": "3e75989f5c0f3113c1a1e72f363d0887dc83c6a99a482b4542cb0e95a5f8d881" }, "downloads": -1, "filename": "pluckr-0.0.2.tar.gz", "has_sig": false, "md5_digest": "a07d03c9629515084410cfbb4f4acddd", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2296, "upload_time": "2013-02-21T14:04:30", "url": "https://files.pythonhosted.org/packages/75/df/82a52733b7fab2fb2ba8de9b93e12dedd36793b095f7498d5dec1a8d072b/pluckr-0.0.2.tar.gz" } ], "0.0.3": [ { "comment_text": "", "digests": { "md5": "eac33d7aee0eea4bc2ec715f323daf9e", "sha256": "233dd6d01a64638c38bdf1d3ce3d05c4403c03d5e0a679d2ed0e0c6a3e5701c0" }, "downloads": -1, "filename": "pluckr-0.0.3.tar.gz", "has_sig": false, "md5_digest": "eac33d7aee0eea4bc2ec715f323daf9e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2452, "upload_time": "2013-04-28T22:36:37", "url": "https://files.pythonhosted.org/packages/7d/3b/79f09e98bb4629909cf2760be9e47d3066f5df32556e7d8eee05ca48fc61/pluckr-0.0.3.tar.gz" } ], "0.0.4": [ { "comment_text": "", "digests": { "md5": "0e43bd6fc3cd85721dcd7856a3bbab69", "sha256": "d8ced7e68d09c8a8df0718890a5932cd7547b53b6dd315ac1556d7fea001ce47" }, "downloads": -1, "filename": "pluckr-0.0.4.tar.gz", "has_sig": false, "md5_digest": "0e43bd6fc3cd85721dcd7856a3bbab69", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2522, "upload_time": "2014-01-14T16:35:33", "url": "https://files.pythonhosted.org/packages/c9/61/bcf0f3d6467bf207c20dd622e58b39ce786bd53508dc86339bd404d953f8/pluckr-0.0.4.tar.gz" } ], "0.0.5": [ { "comment_text": "", "digests": { "md5": "b994023cba064984cfe1fd32cd4a1ff4", "sha256": "081d21d2e23cb6c6966c97b32522154d7ce3d0c5b52872dea58d4d33cfffe2e4" }, "downloads": -1, "filename": "pluckr-0.0.5.tar.gz", "has_sig": false, "md5_digest": "b994023cba064984cfe1fd32cd4a1ff4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2673, "upload_time": "2014-01-17T17:49:45", "url": "https://files.pythonhosted.org/packages/52/39/14b884bcbf68703617df650bae3d054cf161729ad36fbcdf16135a2bc005/pluckr-0.0.5.tar.gz" } ], "0.0.6": [ { "comment_text": "", "digests": { "md5": "521e26c277a225c3d7dfa2cdde43d456", "sha256": "e27235c81e867ad257ffc7eeb88a87e203dfdd307169ceffa96df57214c1c542" }, "downloads": -1, "filename": "pluckr-0.0.6.tar.gz", "has_sig": false, "md5_digest": "521e26c277a225c3d7dfa2cdde43d456", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2985, "upload_time": "2014-01-22T21:19:43", "url": "https://files.pythonhosted.org/packages/62/04/09550ebd96e4e2c38dc727cd49f4e373d7ea923fb440ddf45c87ac1dc566/pluckr-0.0.6.tar.gz" } ], "0.0.7": [ { "comment_text": "", "digests": { "md5": "22927418c9058779463f2a83672ebd34", "sha256": "c03fcd562ec0f2faca4f0396841ba3e41b071e1beedf4ebf1fc0ede1e80ffd59" }, "downloads": -1, "filename": "pluckr-0.0.7.tar.gz", "has_sig": false, "md5_digest": "22927418c9058779463f2a83672ebd34", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3448, "upload_time": "2014-02-10T20:28:54", "url": "https://files.pythonhosted.org/packages/06/4d/ce8c0ba5bba53a92090231ecf5d561680151945d0e9890710d8c83f289f2/pluckr-0.0.7.tar.gz" } ], "0.0.8": [ { "comment_text": "", "digests": { "md5": "63a2c0d164a783cc14c90355a05d07fe", "sha256": "c349afac8b6a69d18c2df8e26c419cc8c7c7f03c398ea9197619e7fe6b60af0f" }, "downloads": -1, "filename": "pluckr-0.0.8.tar.gz", "has_sig": false, "md5_digest": "63a2c0d164a783cc14c90355a05d07fe", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3653, "upload_time": "2014-12-16T01:08:11", "url": "https://files.pythonhosted.org/packages/1c/e0/6d5c6965d05301c60348d32f3660c3cf7d66e11b7aa6f74cddaeb9578c0b/pluckr-0.0.8.tar.gz" } ], "0.0.9": [ { "comment_text": "", "digests": { "md5": "b204ba2601d27f58ff958dba691c6f2c", "sha256": "aa7a2afff9517e4d1cf828ad8f4bbc449865166bc1f31b62c78dd3fcf8bb5a04" }, "downloads": -1, "filename": "pluckr-0.0.9.tar.gz", "has_sig": false, "md5_digest": "b204ba2601d27f58ff958dba691c6f2c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3725, "upload_time": "2015-02-27T22:10:46", "url": "https://files.pythonhosted.org/packages/fb/30/6fde938b5956bb34f5e94b4dbfcc03024464861eebbce38f8449baafd331/pluckr-0.0.9.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "b204ba2601d27f58ff958dba691c6f2c", "sha256": "aa7a2afff9517e4d1cf828ad8f4bbc449865166bc1f31b62c78dd3fcf8bb5a04" }, "downloads": -1, "filename": "pluckr-0.0.9.tar.gz", "has_sig": false, "md5_digest": "b204ba2601d27f58ff958dba691c6f2c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3725, "upload_time": "2015-02-27T22:10:46", "url": "https://files.pythonhosted.org/packages/fb/30/6fde938b5956bb34f5e94b4dbfcc03024464861eebbce38f8449baafd331/pluckr-0.0.9.tar.gz" } ] }