{ "info": { "author": "Open Knowledge Foundation", "author_email": "info@okfn.org", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Intended Audience :: Developers", "Intended Audience :: Science/Research", "License :: OSI Approved :: GNU Lesser General Public License v3 or later (LGPLv3+)", "Operating System :: OS Independent", "Programming Language :: Python :: 2", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Topic :: Scientific/Engineering :: Information Analysis", "Topic :: Software Development :: Libraries :: Python Modules" ], "description": "jsontableschema-pandas\n======================\n\n| |Travis|\n| |Coveralls|\n| |PyPi|\n| |SemVer|\n| |Gitter|\n\nGenerate and load Pandas data frames based on JSON Table Schema\ndescriptors.\n\n Version ``v0.2`` contains breaking changes:\n\n- removed ``Storage(prefix=)`` argument (was a stub)\n- renamed ``Storage(tables=)`` to ``Storage(dataframes=)``\n- renamed ``Storage.tables`` to ``Storage.buckets``\n- changed ``Storage.read`` to read into memory\n- added ``Storage.iter`` to yield row by row\n\nGetting Started\n---------------\n\nInstallation\n~~~~~~~~~~~~\n\n::\n\n $ pip install datapackage\n $ pip install jsontableschema-pandas\n\nExample\n~~~~~~~\n\nYou can easily load resources from a data package as Pandas data frames\nby simply using ``datapackage.push_datapackage`` function:\n\n.. code:: python\n\n >>> import datapackage\n\n >>> data_url = 'http://data.okfn.org/data/core/country-list/datapackage.json'\n >>> storage = datapackage.push_datapackage(data_url, 'pandas')\n\n >>> storage.buckets\n ['data___data']\n\n >>> type(storage['data___data'])\n \n\n >>> storage['data___data'].head()\n Name Code\n 0 Afghanistan AF\n 1 \u00c5land Islands AX\n 2 Albania AL\n 3 Algeria DZ\n 4 American Samoa AS\n\nAlso it is possible to pull your existing data frame into a data\npackage:\n\n.. code:: python\n\n >>> datapackage.pull_datapackage('/tmp/datapackage.json', 'country_list', 'pandas', tables={\n ... 'data': storage['data___data'],\n ... })\n Storage\n\nStorage\n~~~~~~~\n\nPackage implements `Tabular\nStorage `__\ninterface.\n\nWe can get storage this way:\n\n.. code:: python\n\n >>> from jsontableschema_pandas import Storage\n\n >>> storage = Storage()\n\nStorage works as a container for Pandas data frames. You can define new\ndata frame inside storage using ``storage.create`` method:\n\n.. code:: python\n\n >>> storage.create('data', {\n ... 'primaryKey': 'id',\n ... 'fields': [\n ... {'name': 'id', 'type': 'integer'},\n ... {'name': 'comment', 'type': 'string'},\n ... ]\n ... })\n\n >>> storage.buckets\n ['data']\n\n >>> storage['data'].shape\n (0, 0)\n\nUse ``storage.write`` to populate data frame with data:\n\n.. code:: python\n\n >>> storage.write('data', [(1, 'a'), (2, 'b')])\n\n >>> storage['data']\n id comment\n 1 a\n 2 b\n\nAlso you can use\n`tabulator `__ to\npopulate data frame from external data file:\n\n.. code:: python\n\n >>> import tabulator\n\n >>> with tabulator.Stream('data/comments.csv', headers=1) as stream:\n ... storage.write('data', stream)\n\n >>> storage['data']\n id comment\n 1 a\n 2 b\n 1 good\n\nAs you see, subsequent writes simply appends new data on top of existing\nones.\n\nAPI Reference\n-------------\n\nSnapshot\n~~~~~~~~\n\nhttps://github.com/frictionlessdata/jsontableschema-py#snapshot\n\nDetailed\n~~~~~~~~\n\n- `Docstrings `__\n- `Changelog `__\n\nContributing\n------------\n\nPlease read the contribution guideline:\n\n`How to Contribute `__\n\nThanks!\n\n.. |Travis| image:: https://img.shields.io/travis/frictionlessdata/jsontableschema-pandas-py/master.svg\n :target: https://travis-ci.org/frictionlessdata/jsontableschema-pandas-py\n.. |Coveralls| image:: http://img.shields.io/coveralls/frictionlessdata/jsontableschema-pandas-py.svg?branch=master\n :target: https://coveralls.io/r/frictionlessdata/jsontableschema-pandas-py?branch=master\n.. |PyPi| image:: https://img.shields.io/pypi/v/jsontableschema-pandas.svg\n :target: https://pypi.python.org/pypi/jsontableschema-pandas\n.. |SemVer| image:: https://img.shields.io/badge/versions-SemVer-brightgreen.svg\n :target: http://semver.org/\n.. |Gitter| image:: https://img.shields.io/gitter/room/frictionlessdata/chat.svg\n :target: https://gitter.im/frictionlessdata/chat\n\n", "description_content_type": null, "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/frictionlessdata/jsontableschema-pandas-py", "keywords": "frictionless data,datapackage,pandas", "license": "LGPLv3+", "maintainer": "", "maintainer_email": "", "name": "jsontableschema-pandas", "package_url": "https://pypi.org/project/jsontableschema-pandas/", "platform": "", "project_url": "https://pypi.org/project/jsontableschema-pandas/", "project_urls": { "Homepage": "https://github.com/frictionlessdata/jsontableschema-pandas-py" }, "release_url": "https://pypi.org/project/jsontableschema-pandas/0.5.0/", "requires_dist": [ "jsontableschema (>=0.7,<2.0)", "pandas (>=0.18,<2.0)", "six (>=1.9,<2.0)", "tabulator (>=0.7,<2.0)", "pylama; extra == 'develop'", "tox; extra == 'develop'" ], "requires_python": "", "summary": "Generate Pandas data frames, load and extract data, based on JSON Table Schema descriptors.", "version": "0.5.0" }, "last_serial": 3149779, "releases": { "0.0.0": [], "0.1.3": [ { "comment_text": "", "digests": { "md5": "7dc2939af52fca1993e4edd2aa729e3b", "sha256": "7a8287f9114002e88a58a2ba783cfc1744c880f82f576dbb8b67f934214fb6c8" }, "downloads": -1, "filename": "jsontableschema_pandas-0.1.3-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "7dc2939af52fca1993e4edd2aa729e3b", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 8914, "upload_time": "2016-05-24T18:25:26", "url": "https://files.pythonhosted.org/packages/20/be/760e69cad4189cf0ed92a0394e765a742ac6ef1d219ca61778935b012a69/jsontableschema_pandas-0.1.3-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "9380a95d454502a97619952f1f038ff2", "sha256": "cf6f29ea214723c852a24ba3a981e74729ac5bdbc479dd21d36dbb099cdd5416" }, "downloads": -1, "filename": "jsontableschema-pandas-0.1.3.tar.gz", "has_sig": false, "md5_digest": "9380a95d454502a97619952f1f038ff2", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6500, "upload_time": "2016-05-24T18:25:41", "url": "https://files.pythonhosted.org/packages/71/61/9785d419475539770d2da4a0597f6b6bc902e7bcb2a93e463123cdf51a20/jsontableschema-pandas-0.1.3.tar.gz" } ], "0.1.4": [ { "comment_text": "", "digests": { "md5": "b6124686e378a70ca7646d8d673dd619", "sha256": "e789f4a12e257e9cd868e8a9da6009ca18f56e580f5f50a9bd62422774b97e01" }, "downloads": -1, "filename": "jsontableschema_pandas-0.1.4-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "b6124686e378a70ca7646d8d673dd619", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 8889, "upload_time": "2016-08-19T11:05:06", "url": "https://files.pythonhosted.org/packages/aa/3e/c68aa039a9dce5b2a6dbc36f236c6b9d14445199a2d2a0e5acb7773a1fb0/jsontableschema_pandas-0.1.4-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "982f1d7d1035f09f5dc766df97230042", "sha256": "6c5ecf2d3e3fc8afbd9521f17352bd587d362919a51130533425c4c2dc323501" }, "downloads": -1, "filename": "jsontableschema-pandas-0.1.4.tar.gz", "has_sig": false, "md5_digest": "982f1d7d1035f09f5dc766df97230042", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7938, "upload_time": "2016-08-19T11:05:08", "url": "https://files.pythonhosted.org/packages/9f/48/846bd04d4dbf3ccbfad8f225167a83a4a988350a55362ee204ec34dee86a/jsontableschema-pandas-0.1.4.tar.gz" } ], "0.2.0": [ { "comment_text": "", "digests": { "md5": "4ce730da985d3b678cd6e4299383f061", "sha256": "3a9930a5195454f0d26eb279a5242a93722f56903524c84dfe4e9f9dca3d2e7e" }, "downloads": -1, "filename": "jsontableschema_pandas-0.2.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "4ce730da985d3b678cd6e4299383f061", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 9303, "upload_time": "2016-10-26T15:08:00", "url": "https://files.pythonhosted.org/packages/83/f6/5e4da0411eb0f826d391cb0800942a1734b34015062b8bfdfb0d1fe6b033/jsontableschema_pandas-0.2.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "2dc1bd1d5da45b90f2ee911f3bb95508", "sha256": "4d9686eae279cc220acf4f03dc5173c0c7725f7712bc07e862ff913157548b30" }, "downloads": -1, "filename": "jsontableschema-pandas-0.2.0.tar.gz", "has_sig": false, "md5_digest": "2dc1bd1d5da45b90f2ee911f3bb95508", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8670, "upload_time": "2016-10-26T15:08:03", "url": "https://files.pythonhosted.org/packages/16/0f/e10be1351aa435bb34bcc0da484091aba19e0b72e02c42c043dcd8faf175/jsontableschema-pandas-0.2.0.tar.gz" } ], "0.3.0": [ { "comment_text": "", "digests": { "md5": "558d9f017c44957f6681bf762161ff37", "sha256": "3ca31bb20145d711088f29159edfdf12a63a9a934d6d9a2eef67d83defafc52b" }, "downloads": -1, "filename": "jsontableschema_pandas-0.3.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "558d9f017c44957f6681bf762161ff37", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 8866, "upload_time": "2017-03-28T09:28:03", "url": "https://files.pythonhosted.org/packages/07/22/fc6dd79fc72cebd664ff8b2e485b240735cd9b1f44b8ce32c8dcf930597f/jsontableschema_pandas-0.3.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "1505555c588115fcf72361d47cb7a809", "sha256": "fde129fa45d3472788cafae2eaf6a9bf9055195bc7d2dbf413c5d5146bad120c" }, "downloads": -1, "filename": "jsontableschema-pandas-0.3.0.tar.gz", "has_sig": false, "md5_digest": "1505555c588115fcf72361d47cb7a809", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6379, "upload_time": "2017-03-28T09:28:05", "url": "https://files.pythonhosted.org/packages/9d/47/daeb3214fd106072efffd2079c60300cc866fd0aa5be2e4ec1df91de76a4/jsontableschema-pandas-0.3.0.tar.gz" } ], "0.4.0": [ { "comment_text": "", "digests": { "md5": "0395313a5770f335e84980874348dd70", "sha256": "0e770d4e547dfbecc6904d881abc680ded9f85d8a544f436183ee5eca85355c1" }, "downloads": -1, "filename": "jsontableschema_pandas-0.4.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "0395313a5770f335e84980874348dd70", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 8851, "upload_time": "2017-06-06T09:36:20", "url": "https://files.pythonhosted.org/packages/bc/6d/cf3f408bb997ad612a93b96224bd1bb2e0671f4fda80d311e87ccd1c3f73/jsontableschema_pandas-0.4.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "8aec6dfe10a0fa32de4d89698546afb0", "sha256": "20ffb56748f7d6347af6c0248dbc9eee888d10b7f740a58de761bb14a49432bb" }, "downloads": -1, "filename": "jsontableschema-pandas-0.4.0.tar.gz", "has_sig": false, "md5_digest": "8aec6dfe10a0fa32de4d89698546afb0", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6351, "upload_time": "2017-06-06T09:36:22", "url": "https://files.pythonhosted.org/packages/54/c9/3e9bda18a2ed847b2c03e52d81e76c9a2964702c6f7fbb36a97f5b042b9e/jsontableschema-pandas-0.4.0.tar.gz" } ], "0.4.1": [ { "comment_text": "", "digests": { "md5": "021c8e9511f9bc9d2c584f6fe18bfc04", "sha256": "6248f9c4aec173d1f4b4a1e7e8f17454fada148132a7720e73b69b2c58498a33" }, "downloads": -1, "filename": "jsontableschema_pandas-0.4.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "021c8e9511f9bc9d2c584f6fe18bfc04", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 9035, "upload_time": "2017-06-09T08:14:00", "url": "https://files.pythonhosted.org/packages/a0/46/fb5d44e6b3bf99ab26d282803d094e2c8310ec025ee6fa2f4f82866584b4/jsontableschema_pandas-0.4.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "cc489c1d8c5409f8239acf5ee0128033", "sha256": "1b55f69c4b29bc8d2353ae4fa65b1148b366eb93614018ed9f53f8ca3dfc4836" }, "downloads": -1, "filename": "jsontableschema-pandas-0.4.1.tar.gz", "has_sig": false, "md5_digest": "cc489c1d8c5409f8239acf5ee0128033", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9430, "upload_time": "2017-06-09T08:14:02", "url": "https://files.pythonhosted.org/packages/14/4c/24e18feaf158291f56e331b12a478e91745271bb02fafe010c1255c4482e/jsontableschema-pandas-0.4.1.tar.gz" } ], "0.5.0": [ { "comment_text": "", "digests": { "md5": "66a29c27f4a7134b11c63b03a4925fca", "sha256": "32895c32d83d644ca017b5d376911a9ff018b00f550fdd70d967e34da4c29a25" }, "downloads": -1, "filename": "jsontableschema_pandas-0.5.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "66a29c27f4a7134b11c63b03a4925fca", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 9135, "upload_time": "2017-09-05T08:53:06", "url": "https://files.pythonhosted.org/packages/92/04/808b627c8d314bee0e45a296e8810328d5f7bc1449a77c63f6e79812ed59/jsontableschema_pandas-0.5.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "0f820382e791c942ace2866298d8e41f", "sha256": "cf5833ebe4ddcab29f3c652304aff6a4316fa9b92d52d9ee047b9cffbb18cebf" }, "downloads": -1, "filename": "jsontableschema-pandas-0.5.0.tar.gz", "has_sig": false, "md5_digest": "0f820382e791c942ace2866298d8e41f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9583, "upload_time": "2017-09-05T08:53:07", "url": "https://files.pythonhosted.org/packages/fa/e7/f73e2c77418819cb704e0d5ec08d7507df37a29eb5e06f5b403a39d669c5/jsontableschema-pandas-0.5.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "66a29c27f4a7134b11c63b03a4925fca", "sha256": "32895c32d83d644ca017b5d376911a9ff018b00f550fdd70d967e34da4c29a25" }, "downloads": -1, "filename": "jsontableschema_pandas-0.5.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "66a29c27f4a7134b11c63b03a4925fca", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 9135, "upload_time": "2017-09-05T08:53:06", "url": "https://files.pythonhosted.org/packages/92/04/808b627c8d314bee0e45a296e8810328d5f7bc1449a77c63f6e79812ed59/jsontableschema_pandas-0.5.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "0f820382e791c942ace2866298d8e41f", "sha256": "cf5833ebe4ddcab29f3c652304aff6a4316fa9b92d52d9ee047b9cffbb18cebf" }, "downloads": -1, "filename": "jsontableschema-pandas-0.5.0.tar.gz", "has_sig": false, "md5_digest": "0f820382e791c942ace2866298d8e41f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9583, "upload_time": "2017-09-05T08:53:07", "url": "https://files.pythonhosted.org/packages/fa/e7/f73e2c77418819cb704e0d5ec08d7507df37a29eb5e06f5b403a39d669c5/jsontableschema-pandas-0.5.0.tar.gz" } ] }