{ "info": { "author": "Robin Thomas", "author_email": "rthomas900@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "Intended Audience :: Developers", "Intended Audience :: Science/Research", "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python", "Programming Language :: Python :: 3", "Topic :: Office/Business :: Financial :: Spreadsheet", "Topic :: Software Development :: Libraries :: Python Modules" ], "description": "gspread-dataframe\n-----------------\n\n.. image:: https://badge.fury.io/py/gspread-dataframe.svg\n :target: https://badge.fury.io/py/gspread-dataframe\n\n.. image:: https://travis-ci.org/robin900/gspread-dataframe.svg?branch=master\n :target: https://travis-ci.org/robin900/gspread-dataframe\n\nThis package allows easy data flow between a worksheet in a Google spreadsheet\nand a Pandas DataFrame. Any worksheet you can obtain using the ``gspread`` package\ncan be retrieved as a DataFrame with ``get_as_dataframe``; DataFrame objects can\nbe written to a worksheet using ``set_with_dataframe``:\n\n.. code:: python\n\n import pandas as pd\n from gspread_dataframe import get_as_dataframe, set_with_dataframe\n\n worksheet = some_worksheet_obtained_from_gspread_client\n\n df = pd.DataFrame.from_records([{'a': i, 'b': i * 2} for i in range(100)])\n set_with_dataframe(worksheet, df)\n\n df2 = get_as_dataframe(worksheet)\n\nThe ``get_as_dataframe`` function supports the keyword arguments\nthat are supported by your Pandas version's text parsing readers,\nsuch as ``pandas.read_csv``. Consult your Pandas documentation for a full\nlist of options; since the ``'python'`` engine in Pandas is used for parsing,\nonly options supported by that engine are acceptable:\n\n.. code:: python\n\n import pandas as pd\n from gspread_dataframe import get_as_dataframe\n\n worksheet = some_worksheet_obtained_from_gspread_client\n\n df = get_as_dataframe(worksheet, parse_dates=True, usecols=[0,2], skiprows=1, header=None)\n\nInstallation\n------------\n\nRequirements\n~~~~~~~~~~~~\n\n* Python 2.6+ or Python 3.2+\n* gspread (>=3.0.0; to use older versions of gspread, use gspread-dataframe releases of 2.1.1 or earlier)\n* Pandas >= 0.14.0\n\nFrom PyPI\n~~~~~~~~~\n\n.. code:: sh\n\n pip install gspread-dataframe\n\nFrom GitHub\n~~~~~~~~~~~\n\n.. code:: sh\n\n git clone https://github.com/robin900/gspread-dataframe.git\n cd gspread-dataframe\n python setup.py install\n\n\n", "description_content_type": "", "docs_url": "https://pythonhosted.org/gspread-dataframe/", "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/robin900/gspread-dataframe", "keywords": "spreadsheets,google-spreadsheets,pandas,dataframe", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "gspread-dataframe", "package_url": "https://pypi.org/project/gspread-dataframe/", "platform": "", "project_url": "https://pypi.org/project/gspread-dataframe/", "project_urls": { "Homepage": "https://github.com/robin900/gspread-dataframe" }, "release_url": "https://pypi.org/project/gspread-dataframe/3.0.3/", "requires_dist": [ "gspread (>=3.0.0)", "pandas (>=0.14.0)" ], "requires_python": "", "summary": "Read/write gspread worksheets using pandas DataFrames", "version": "3.0.3" }, "last_serial": 5640074, "releases": { "1.0.0": [ { "comment_text": "", "digests": { "md5": "acedb4ad4aac0e40c17f6241bdbede32", "sha256": "f6d626bdd0c2fde30a34b745f9572117ed1fc4e2e7b3e952cc59ed7da960ad8e" }, "downloads": -1, "filename": "gspread_dataframe-1.0.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "acedb4ad4aac0e40c17f6241bdbede32", "packagetype": "bdist_wheel", "python_version": "3.4", "requires_python": null, "size": 5894, "upload_time": "2017-03-11T06:22:11", "url": "https://files.pythonhosted.org/packages/57/7e/9f22a0a031e0b56360e9645af0cdc5b57c5870fc50c0c2b122f10b734df0/gspread_dataframe-1.0.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "5cebd4299f673633018b5d9ac480b150", "sha256": "0b7a15c8c90fbcda4dddaefbf2dda08fa5ff2c09ede4a712e6ed19c6f97b473b" }, "downloads": -1, "filename": "gspread-dataframe-1.0.0.tar.gz", "has_sig": false, "md5_digest": "5cebd4299f673633018b5d9ac480b150", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4709, "upload_time": "2017-03-11T06:22:08", "url": "https://files.pythonhosted.org/packages/4f/ab/cbb8d0c5cb9519393914c7c031daa04b367af4cd977d389bb06b9e55dc6c/gspread-dataframe-1.0.0.tar.gz" } ], "1.1.0": [ { "comment_text": "", "digests": { "md5": "4fdb19452d68021839924b2f8c684b93", "sha256": "219ce03657848da8c0fa18013e2eae6fc5f3bdd1b4d4ce890f1d4961b6427ce7" }, "downloads": -1, "filename": "gspread_dataframe-1.1.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "4fdb19452d68021839924b2f8c684b93", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5904, "upload_time": "2017-03-15T16:12:57", "url": "https://files.pythonhosted.org/packages/2e/d5/3c5a3ee4a919ae8ed84bb4ce4e42cbd4772ffda19e5b62ac913c0a263a70/gspread_dataframe-1.1.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "dd7f759de740b881290de0268c076a7e", "sha256": "9681f63d95c02f93dfef4d8926a944d10e190cc9ffcb28aa5abb235fba0209d7" }, "downloads": -1, "filename": "gspread-dataframe-1.1.0.tar.gz", "has_sig": false, "md5_digest": "dd7f759de740b881290de0268c076a7e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4729, "upload_time": "2017-03-15T16:12:45", "url": "https://files.pythonhosted.org/packages/81/c0/405abd03ef672b5c18f109162d833266beb95aa74e159368f0ed776097dc/gspread-dataframe-1.1.0.tar.gz" } ], "2.0.0": [ { "comment_text": "", "digests": { "md5": "bc3f10bf657d043649068eb59c9599ac", "sha256": "e4afb79c18f026c06c0ebb6eb9485a5ee7935a04758cf9dbad9d602e81c6bb1b" }, "downloads": -1, "filename": "gspread_dataframe-2.0.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "bc3f10bf657d043649068eb59c9599ac", "packagetype": "bdist_wheel", "python_version": "3.4", "requires_python": null, "size": 6489, "upload_time": "2017-03-29T13:21:39", "url": "https://files.pythonhosted.org/packages/e1/d6/33f8e806653dd977f8e8cf0f0d9996e685719fcfaca1dd34afef91bc2a7d/gspread_dataframe-2.0.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d088c58de3e721beee40ab14c29c6a04", "sha256": "4b4e25a94701b7a688a1012efd5c4fa049503fe80151ecfe9054ae1cb102357c" }, "downloads": -1, "filename": "gspread-dataframe-2.0.0.tar.gz", "has_sig": false, "md5_digest": "d088c58de3e721beee40ab14c29c6a04", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4795, "upload_time": "2017-03-29T13:21:40", "url": "https://files.pythonhosted.org/packages/d5/77/230e347947079a977aa30b45f537cc7be486571d65ca9998e049a9016afc/gspread-dataframe-2.0.0.tar.gz" } ], "2.0.1": [ { "comment_text": "", "digests": { "md5": "7288c57374622e9ef087fdff323d2c3c", "sha256": "daf0006f2560a06ace6ddc97c627a52278bdaf5292c0a3453e29ab814e5d89c0" }, "downloads": -1, "filename": "gspread_dataframe-2.0.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "7288c57374622e9ef087fdff323d2c3c", "packagetype": "bdist_wheel", "python_version": "3.4", "requires_python": null, "size": 6494, "upload_time": "2017-03-31T03:23:59", "url": "https://files.pythonhosted.org/packages/f3/9d/9dfaa835e39da386706b12bdfa39ad1e60d1f2d0bd724935d984db204642/gspread_dataframe-2.0.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "f7028808c0e000248aee339b1b48e113", "sha256": "3d391c3220aa65f0ef09b82dd83086a985bfb8ce6cf800e1189b0cdb7dbcd9b0" }, "downloads": -1, "filename": "gspread-dataframe-2.0.1.tar.gz", "has_sig": false, "md5_digest": "f7028808c0e000248aee339b1b48e113", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4832, "upload_time": "2017-03-31T03:24:00", "url": "https://files.pythonhosted.org/packages/8c/e1/a7fafc3421fa6d402b1a5ba26f966fbe211f9b65a88a66c9bd2675a10bd8/gspread-dataframe-2.0.1.tar.gz" } ], "2.1.0": [ { "comment_text": "", "digests": { "md5": "2b435b2254f226bd9f3d2d4b13c5eb69", "sha256": "ad121733ac05df0c73d4657ca08275824aea3b222ff9d33af2518ea6d245b4b4" }, "downloads": -1, "filename": "gspread_dataframe-2.1.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "2b435b2254f226bd9f3d2d4b13c5eb69", "packagetype": "bdist_wheel", "python_version": "3.4", "requires_python": null, "size": 6517, "upload_time": "2017-07-28T13:25:04", "url": "https://files.pythonhosted.org/packages/f2/ca/19386116aa52e731fc96a780b458e39a81b544bb9cbb601030ee02450083/gspread_dataframe-2.1.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "bc296b1b13ef12167426d256f480ec45", "sha256": "872a2427dca3130695df1aeb1f9508b1599c0e94d98f8c1a10c28d5fbdede900" }, "downloads": -1, "filename": "gspread-dataframe-2.1.0.tar.gz", "has_sig": false, "md5_digest": "bc296b1b13ef12167426d256f480ec45", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4855, "upload_time": "2017-07-28T13:25:05", "url": "https://files.pythonhosted.org/packages/36/4e/a2976ecc727e1284084406e377aff0876146a7ce5c80f35ccfac7e983787/gspread-dataframe-2.1.0.tar.gz" } ], "2.1.1": [ { "comment_text": "", "digests": { "md5": "a7e43268fecba90ef59a119e29fc5ebf", "sha256": "1b62f74b97e1fc11df3ede448ffdc6f5fff6790052c9f1438de1130d4f16f49e" }, "downloads": -1, "filename": "gspread_dataframe-2.1.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "a7e43268fecba90ef59a119e29fc5ebf", "packagetype": "bdist_wheel", "python_version": "3.4", "requires_python": null, "size": 6533, "upload_time": "2018-04-19T13:58:05", "url": "https://files.pythonhosted.org/packages/b9/d5/6742f64ff8ea8d8ea7a2f262d8643e56fcb4cb91e321680317cbdabfd8bf/gspread_dataframe-2.1.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "7a4c48e955291d42f5256c2d3b5dd5b7", "sha256": "03644e166bcfd4a94e9cbc96bdc50091b13b2f2e562104ed5421e9453f1fb871" }, "downloads": -1, "filename": "gspread-dataframe-2.1.1.tar.gz", "has_sig": false, "md5_digest": "7a4c48e955291d42f5256c2d3b5dd5b7", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4882, "upload_time": "2018-04-19T13:58:04", "url": "https://files.pythonhosted.org/packages/20/10/54ec460fa9d1c0cfc852843a8248aecf62c2066cddfa58e232f62b232e5b/gspread-dataframe-2.1.1.tar.gz" } ], "3.0.0": [ { "comment_text": "", "digests": { "md5": "ceb7893e85af2b9c1216c707fd013808", "sha256": "cc10a068f5812791feceb7ca3c924534edd0a0441a55a1ff581b2ca4d3c1a8b4" }, "downloads": -1, "filename": "gspread_dataframe-3.0.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "ceb7893e85af2b9c1216c707fd013808", "packagetype": "bdist_wheel", "python_version": "3.4", "requires_python": null, "size": 6099, "upload_time": "2018-04-19T16:24:30", "url": "https://files.pythonhosted.org/packages/e9/a6/664366f67ee292ec3a7f7960c8a8feaf6e5a7ee7f99a2efc849a1ea0b631/gspread_dataframe-3.0.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "6541e41c57c1a7e23450b9d907e74933", "sha256": "ee451cc401047061961fb7147ec0090ad7bbb7f8d07fd434c6f80f9cc83fdb1f" }, "downloads": -1, "filename": "gspread-dataframe-3.0.0.tar.gz", "has_sig": false, "md5_digest": "6541e41c57c1a7e23450b9d907e74933", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4496, "upload_time": "2018-04-19T16:24:29", "url": "https://files.pythonhosted.org/packages/1f/7f/eca7cc6b9823bbda20106ef839b9af17536e77002689515bb2c164f777d9/gspread-dataframe-3.0.0.tar.gz" } ], "3.0.1": [ { "comment_text": "", "digests": { "md5": "b8b7be37fe3fd9195d0961af83784b66", "sha256": "7111ea38a9436a92fc52c16ed54245fb3b7141e9bcbc31db7ff7b53e545adb32" }, "downloads": -1, "filename": "gspread_dataframe-3.0.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "b8b7be37fe3fd9195d0961af83784b66", "packagetype": "bdist_wheel", "python_version": "3.4", "requires_python": null, "size": 7421, "upload_time": "2018-04-20T15:36:17", "url": "https://files.pythonhosted.org/packages/fa/1b/6737cfb45e51ca23762432bc6af0837e4708eda33f5f8f92a72281fec0fd/gspread_dataframe-3.0.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "8fe3baa9dc0d1ec0431eec3863c286c7", "sha256": "881d317f8bbdba387a956bd7df62ab5a800039f554daa25e8a4b0c59d55cf7b4" }, "downloads": -1, "filename": "gspread-dataframe-3.0.1.tar.gz", "has_sig": false, "md5_digest": "8fe3baa9dc0d1ec0431eec3863c286c7", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4679, "upload_time": "2018-04-20T15:36:15", "url": "https://files.pythonhosted.org/packages/6e/ce/85e2f5dac0e8ec4a6ec1630458ab07b5e3c29d05cf59cfa59eb4ba9cd92b/gspread-dataframe-3.0.1.tar.gz" } ], "3.0.2": [ { "comment_text": "", "digests": { "md5": "4534e57de4ac49dc33ef4a4b8857a131", "sha256": "312902287a7abc285bcd50bfc34186c863f293efc0990a8bba87d6fd701b052f" }, "downloads": -1, "filename": "gspread_dataframe-3.0.2-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "4534e57de4ac49dc33ef4a4b8857a131", "packagetype": "bdist_wheel", "python_version": "3.4", "requires_python": null, "size": 7632, "upload_time": "2018-07-24T17:25:36", "url": "https://files.pythonhosted.org/packages/ca/2e/467a7ecf8d0295f39db4826bcdaf837ce2493036fff09026bdd0d252ecef/gspread_dataframe-3.0.2-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "c01e8b7685120d7aa3581f49b4dc355c", "sha256": "d1984489a2a8e0aa98241f84f38de4ee4d5176bf9d6a37eb63e00c0b9d14fd3a" }, "downloads": -1, "filename": "gspread-dataframe-3.0.2.tar.gz", "has_sig": false, "md5_digest": "c01e8b7685120d7aa3581f49b4dc355c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4845, "upload_time": "2018-07-24T17:25:35", "url": "https://files.pythonhosted.org/packages/85/df/d6a0b0fb0d8ec0091bb6edd17dbbe6be1f61e52bae39c4ba910a465128e6/gspread-dataframe-3.0.2.tar.gz" } ], "3.0.3": [ { "comment_text": "", "digests": { "md5": "eafb42dc08f92e6df7cacbfd9af47bfd", "sha256": "876e257cef4247c4a86ae00f9523cbedd015c6833b6c6265cb8f32f72c1e2245" }, "downloads": -1, "filename": "gspread_dataframe-3.0.3-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "eafb42dc08f92e6df7cacbfd9af47bfd", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5873, "upload_time": "2019-08-06T14:27:10", "url": "https://files.pythonhosted.org/packages/da/84/18b24575a3e30a4104f399e3d24796d8bd9f6a64fced19a6aa7ae8ee43c1/gspread_dataframe-3.0.3-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "aaa64e1e10f18b52d9fd7dcddc8414d0", "sha256": "a494271466542522cf1fd1dc0101150da1b6c9e764f2fabf535c6f280e4ca182" }, "downloads": -1, "filename": "gspread-dataframe-3.0.3.tar.gz", "has_sig": false, "md5_digest": "aaa64e1e10f18b52d9fd7dcddc8414d0", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5630, "upload_time": "2019-08-06T14:27:11", "url": "https://files.pythonhosted.org/packages/78/6d/6fb58fc0ac6585040f8d6999c92d95df486d5c4fe15d1689f9173cdda0c2/gspread-dataframe-3.0.3.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "eafb42dc08f92e6df7cacbfd9af47bfd", "sha256": "876e257cef4247c4a86ae00f9523cbedd015c6833b6c6265cb8f32f72c1e2245" }, "downloads": -1, "filename": "gspread_dataframe-3.0.3-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "eafb42dc08f92e6df7cacbfd9af47bfd", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5873, "upload_time": "2019-08-06T14:27:10", "url": "https://files.pythonhosted.org/packages/da/84/18b24575a3e30a4104f399e3d24796d8bd9f6a64fced19a6aa7ae8ee43c1/gspread_dataframe-3.0.3-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "aaa64e1e10f18b52d9fd7dcddc8414d0", "sha256": "a494271466542522cf1fd1dc0101150da1b6c9e764f2fabf535c6f280e4ca182" }, "downloads": -1, "filename": "gspread-dataframe-3.0.3.tar.gz", "has_sig": false, "md5_digest": "aaa64e1e10f18b52d9fd7dcddc8414d0", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5630, "upload_time": "2019-08-06T14:27:11", "url": "https://files.pythonhosted.org/packages/78/6d/6fb58fc0ac6585040f8d6999c92d95df486d5c4fe15d1689f9173cdda0c2/gspread-dataframe-3.0.3.tar.gz" } ] }