{ "info": { "author": "Keith Hamilton", "author_email": "the.keith.hamilton@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Programming Language :: Python", "Programming Language :: Python :: 2.6", "Programming Language :: Python :: 2.7", "Topic :: Office/Business" ], "description": "transposer\n==========\nYou got columnar data? Turn that into row-wise data!! You got\nrow-wise data?? Turn it into columnar data!!! SAY WUT?!?\n\n(transposer transposes columns and rows in delimited text files)\n\nWhat It Does\n------------ \ntransposer is a one-trick pony, but it's a good one-trick pony.\nA simple command-line tool that can be used to effectively\ntranspose columnar data in a delimited file to row-wise data. EPIC.\n\nConsider these three rows of data:\n\n::\n\n FirstName|LastName|Age|Weight\n Sam|Simms|52|176\n Jane|Franklin|35|125\n\ntransposer would take these three rows, and transpose the data as follows:\n\n::\n\n FirstName|Sam|Jane\n LastName|Simms|Franklin\n Age|52|35\n Weight|176|125\n\nIf you wanted to transform the row-wise data back into its former columnar self,\nyou would just run transposer against the transposed data.\n\ntransposer also works well with different types of delimiters, you just need\nto declare which type you are working with (default is comma-separated).\n\nBut, Keith\n----------\nIt's so easy to transpose that kind of data by hand. Why would I want to use \na package for it?\n\nYeah, transposing three rows is easy to do by hand. Try 100,000. transposer will\ndo that work for you so you can do better things like watch reruns of The\nShawshank Redemption. You don't even have to write the data out to another file\nyou can also just hold onto it to do some wicked transforms before you dump\nit to a flatfile. Up to you.\n\nInstalling\n----------\nInstalling is easy, just use pip:\n\n::\n \n $ pip install transposer\n\nOr grab this repo and run:\n\n::\n\n $ python setup.py install\n\nUsing\n-----\ntransposer can be used both on the command line as well as in a Python project.\n\nCommand Line\n~~~~~~~~~~~~\n\n::\n\n $ transposer -i 'my_file.csv' -o 'out_file.csv'\n $ transposer -i 'my_file.txt' -d '|'\n $ transposer --in 'my_file.txt' -d '\\t'\n\nModule-based\n~~~~~~~~~~~~\nIn your project file:\n\n.. code-block:: python\n\n import transposer\n\n # this will output a file.\n transposer.transpose(i='cols.csv', o='rows.csv')\n \n # this will just keep the transposition in memory\n rows = transposer.transpose(i='cols.csv', o=None)\n\n # so will this\n rows = transposer.transpose(i='cols.csv')\n\n # the delimiter defaults to a comma. Use pipes too.\n transposer.transpose(i='cols.txt', o='rows.txt', d='|')\n\n\nLicense\n-------\ntransposer uses the MIT license, and is free for you.", "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/keithhamilton/transposer", "keywords": "text,csv,tab-delimited,delimited,excel,sheet,spreadsheet", "license": "BSD License", "maintainer": null, "maintainer_email": null, "name": "transposer", "package_url": "https://pypi.org/project/transposer/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/transposer/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://github.com/keithhamilton/transposer" }, "release_url": "https://pypi.org/project/transposer/0.0.3/", "requires_dist": null, "requires_python": null, "summary": "Transposes columns and rows in delimited text files", "version": "0.0.3" }, "last_serial": 1394787, "releases": { "0.0.3": [ { "comment_text": "built for Darwin-14.0.0", "digests": { "md5": "cf42fb07738f56219f591c2f4416b895", "sha256": "4e6e060398172febd3f927bebe1094c1bcc28ae3d66ac91821de283dac27fd30" }, "downloads": -1, "filename": "transposer-0.0.3.macosx-10.10-x86_64.tar.gz", "has_sig": false, "md5_digest": "cf42fb07738f56219f591c2f4416b895", "packagetype": "bdist_dumb", "python_version": "any", "requires_python": null, "size": 4418, "upload_time": "2015-01-24T16:08:07", "url": "https://files.pythonhosted.org/packages/2a/75/3db120950f62a42d94ef689b1b8a89947ad577dad7d93c4ca1b61e30877b/transposer-0.0.3.macosx-10.10-x86_64.tar.gz" }, { "comment_text": "", "digests": { "md5": "2d64cf381d8e177399570f4b80ca0aa8", "sha256": "9b7e0e6f486c19cc6cf3a8e07e4df3a6c248b49ef8d3d9632d566f019764b126" }, "downloads": -1, "filename": "transposer-0.0.3.tar.gz", "has_sig": false, "md5_digest": "2d64cf381d8e177399570f4b80ca0aa8", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3501, "upload_time": "2015-01-24T16:08:04", "url": "https://files.pythonhosted.org/packages/6b/63/b9da51ba20c3760105d43f72b60035e74306abe1e8f52f3a8bb9ccee5a4f/transposer-0.0.3.tar.gz" } ] }, "urls": [ { "comment_text": "built for Darwin-14.0.0", "digests": { "md5": "cf42fb07738f56219f591c2f4416b895", "sha256": "4e6e060398172febd3f927bebe1094c1bcc28ae3d66ac91821de283dac27fd30" }, "downloads": -1, "filename": "transposer-0.0.3.macosx-10.10-x86_64.tar.gz", "has_sig": false, "md5_digest": "cf42fb07738f56219f591c2f4416b895", "packagetype": "bdist_dumb", "python_version": "any", "requires_python": null, "size": 4418, "upload_time": "2015-01-24T16:08:07", "url": "https://files.pythonhosted.org/packages/2a/75/3db120950f62a42d94ef689b1b8a89947ad577dad7d93c4ca1b61e30877b/transposer-0.0.3.macosx-10.10-x86_64.tar.gz" }, { "comment_text": "", "digests": { "md5": "2d64cf381d8e177399570f4b80ca0aa8", "sha256": "9b7e0e6f486c19cc6cf3a8e07e4df3a6c248b49ef8d3d9632d566f019764b126" }, "downloads": -1, "filename": "transposer-0.0.3.tar.gz", "has_sig": false, "md5_digest": "2d64cf381d8e177399570f4b80ca0aa8", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3501, "upload_time": "2015-01-24T16:08:04", "url": "https://files.pythonhosted.org/packages/6b/63/b9da51ba20c3760105d43f72b60035e74306abe1e8f52f3a8bb9ccee5a4f/transposer-0.0.3.tar.gz" } ] }