{
    "info": {
        "author": "Eduard Trott",
        "author_email": "etrott@redhat.com",
        "bugtrack_url": null,
        "classifiers": [
            "License :: OSI Approved :: GNU General Public License v3 (GPLv3)",
            "Natural Language :: English",
            "Programming Language :: Python :: 2.7",
            "Topic :: Office/Business",
            "Topic :: Utilities"
        ],
        "description": "==================\n    df2gspread\n==================\n\nTransfer data between Google Spreadsheets and Pandas DataFrame.\n\n\nDescription\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\nPython library that provides possibility to transport table-data\nbetween Google Spreadsheets and Pandas DataFrame for further\nmanagement or processing.\nCan be useful in all cases, when you need to handle the data\nlocated in Google Drive.\n\n\nStatus\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\n.. list-table::\n   :widths: 5 6\n   :stub-columns: 1\n   :header-rows: 0\n\n   * - Latest Release\n     - .. image:: https://badge.fury.io/py/df2gspread.svg\n          :target: http://badge.fury.io/py/df2gspread\n   * - Build\n     - .. image:: https://travis-ci.org/maybelinot/df2gspread.png\n          :target: https://travis-ci.org/maybelinot/df2gspread\n   * - Docs\n     - .. image:: https://readthedocs.org/projects/df2gspread/badge/\n          :target: https://readthedocs.org/projects/df2gspread/\n   * - License\n     - .. image:: https://img.shields.io/pypi/l/df2gspread.svg\n          :target: https://pypi.python.org/pypi/df2gspread/\n\n\nInstall\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nExample install, using VirtualEnv:\n\n.. code:: bash\n\n   # install/use python virtual environment\n   virtualenv ~/virtenv_scratch --no-site-packages\n\n   # activate the virtual environment\n   source ~/virtenv_scratch/bin/activate\n\n   # upgrade pip in the new virtenv\n   pip install -U pip setuptools\n\n   # install this package in DEVELOPMENT mode\n   # python setup.py develop\n\n   # simply install\n   # python setup.py install\n\n   # or install via pip\n   pip install df2gspread\n\n\nAccess Credentials\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nTo allow a script to use Google Drive API we need to authenticate\nour self towards Google.  To do so, we need to create a project,\ndescribing the tool and generate credentials. Please use your web\nbrowser and go to `Google console <https://console.developers.google.com>`_ and :\n\n* Choose **\"Create Project\"** in popup menu on the top.\n\n* A dialog box appears, so give your project a name and click on **\"Create\"** button.\n\n* On the left-side menu click on **\"API Manager\"**.\n\n* A table of available APIs is shown. Switch **\"Drive API\"** and click on **\"Enable API\"** button. Other APIs might be switched off, for our purpose.\n\n* On the left-side menu click on **\"Credentials\"**.\n\n* In section **\"OAuth consent screen\"** select your email address and give your product a name. Then click on **\"Save\"** button.\n\n* In section **\"Credentials\"** click on **\"Add credentials\"** and switch **\"OAuth 2.0 client ID\"**.\n\n* A dialog box  **\"Create Cliend ID\"** appears. Select **\"Application type\"** item as **\"Other\"**.\n\n* Click on **\"Create\"** button.\n\n* Click on **\"Download JSON\"** icon on the right side of created **\"OAuth 2.0 client IDs\"** and store the downloaded file on your file system. Please be aware, the file contains your private credentials, so take care of the file in the same way you care of your private SSH key; i.e. move downloaded JSON file to **~/.gdrive_private**.\n\n* Then, the first time you run it your browser window will open a google authorization request page. Approve authorization and then the credentials will work as expected.\n\n\nUsage\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nRun df2gspread like:\n\n.. code:: python\n\n    from df2gspread import df2gspread as d2g\n    import pandas as pd\n    d = [pd.Series([1., 2., 3.], index=['a', 'b', 'c']),\n        pd.Series([1., 2., 3., 4.], index=['a', 'b', 'c', 'd'])]\n    df = pd.DataFrame(d)\n\n    # use full path to spreadsheet file\n    spreadsheet = '/some/folder/New Spreadsheet'\n    # or spreadsheet file id\n    # spreadsheet = '1cIOgi90...'\n\n    wks_name = 'New Sheet'\n\n    d2g.upload(df, spreadsheet, wks_name)\n    # if spreadsheet already exists, all data of provided worksheet(or first as default)\n    # will be replaced with data of given DataFrame, make sure that this is what you need!\n\nRun gspread2df like:\n\n.. code:: python\n\n    from df2gspread import gspread2df as g2d\n\n    # use full path to spreadsheet file\n    spreadsheet = '/some/folder/New Spreadsheet'\n    # or spreadsheet file id\n    # spreadsheet = '1cIOgi90...'\n    wks_name = 'New Sheet'\n\n    df = g2d.download(spreadsheet, wks_name, col_names = True, row_names = True)\n\n\nDocumentation\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nDocumentation is available `here <http://df2gspread.readthedocs.org/>`_.\n\n\nTesting\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nTesting is py.test based. Run with:\n\n.. code:: bash\n\n    py.test tests/ -v\n    \nOr with `coverage <https://pypi.python.org/pypi/coverage>`_:\n\n.. code:: bash\n\n    coverage run --source df2gspread -m py.test\n    coverage report\n\n\nDevelopment\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nInstall the supplied githooks; eg::\n\n    ln -s ~/repos/df2gspread/_githooks/commit-msg ~/repos/df2gspread/.git/hooks/commit-msg\n    ln -s ~/repos/df2gspread/_githooks/pre-commit ~/repos/df2gspread/.git/hooks/pre-commit",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "https://github.com/maybelinot/df2gspread/archive/master.zip",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/maybelinot/df2gspread",
        "keywords": "information",
        "license": "GPLv3",
        "maintainer": "Chris Ward",
        "maintainer_email": "cward@redhat.com",
        "name": "df2gspread",
        "package_url": "https://pypi.org/project/df2gspread/",
        "platform": "",
        "project_url": "https://pypi.org/project/df2gspread/",
        "project_urls": {
            "Download": "https://github.com/maybelinot/df2gspread/archive/master.zip",
            "Homepage": "https://github.com/maybelinot/df2gspread"
        },
        "release_url": "https://pypi.org/project/df2gspread/1.0.4/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Export tables to Google Spreadsheets.",
        "version": "1.0.4"
    },
    "last_serial": 4656140,
    "releases": {
        "0.0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "ae6abad6ea7db9e627a2426c67f66880",
                    "sha256": "9c212705f36c1c4b8c98c7e0dd3626787aab93dab3f20c1018f0fd2e1d9e8fcd"
                },
                "downloads": -1,
                "filename": "df2gspread-0.0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "ae6abad6ea7db9e627a2426c67f66880",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 10995,
                "upload_time": "2016-01-19T13:57:58",
                "url": "https://files.pythonhosted.org/packages/e0/82/6e60b7b2047911b72129510071df00bc2d2d064d22c9676e221cada97253/df2gspread-0.0.1.tar.gz"
            }
        ],
        "0.0.5": [],
        "0.0.5a0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "a993944ee6c8263949b50894a3c7be46",
                    "sha256": "a3d48f9f70b0742925afde1129bf670354687b3a1b100d1b86d0a55967e22eab"
                },
                "downloads": -1,
                "filename": "df2gspread-0.0.5a0.tar.gz",
                "has_sig": false,
                "md5_digest": "a993944ee6c8263949b50894a3c7be46",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 7685,
                "upload_time": "2017-10-30T10:55:02",
                "url": "https://files.pythonhosted.org/packages/ed/77/71a2e43686c67e21b77daf3d61d9b5dda2fec89bf8953e75c25c2fec21f6/df2gspread-0.0.5a0.tar.gz"
            }
        ],
        "0.0.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "12029204bb8e634747ee83a27eca571f",
                    "sha256": "9ac3a1f262c88b4f52574415b973b115570115d89726eba58a7559f21d1a8bac"
                },
                "downloads": -1,
                "filename": "df2gspread-0.0.6.tar.gz",
                "has_sig": false,
                "md5_digest": "12029204bb8e634747ee83a27eca571f",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8956,
                "upload_time": "2015-12-21T09:30:10",
                "url": "https://files.pythonhosted.org/packages/f1/d9/b5fc4cef5f1b663585832eea2a6c20417415b1c0e55a2130c724549fa157/df2gspread-0.0.6.tar.gz"
            }
        ],
        "0.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "6bfea91ee6fed30112681b82f06ae793",
                    "sha256": "ff88c5783b87aeaf581c7789963ecb97111d4432fa36eaa16a820abf91665c0c"
                },
                "downloads": -1,
                "filename": "df2gspread-0.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "6bfea91ee6fed30112681b82f06ae793",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 10999,
                "upload_time": "2016-01-19T13:58:28",
                "url": "https://files.pythonhosted.org/packages/51/2f/0a1544a238dd95d6601562a30d63577271ec8061515f57914ca8582034a6/df2gspread-0.1.0.tar.gz"
            }
        ],
        "0.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "2b36d01af228b753bc66ff670584c331",
                    "sha256": "279ddeba41167f28ea820c725ef30bc3a2a10a7345814bdb1e31227107902cf7"
                },
                "downloads": -1,
                "filename": "df2gspread-0.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "2b36d01af228b753bc66ff670584c331",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 11051,
                "upload_time": "2016-02-16T10:27:09",
                "url": "https://files.pythonhosted.org/packages/d1/b1/80bb704ae5a3e10b965a9f799bed2acaec0f8bbe638cfdb52a845b87165d/df2gspread-0.1.1.tar.gz"
            }
        ],
        "0.1.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "ece0d34fa9449c04e042796a6c5a5e9d",
                    "sha256": "516bc7a14d289dbff6de746d149ab9dd5af8de6f1dd506664430d8a1c2bf8cbe"
                },
                "downloads": -1,
                "filename": "df2gspread-0.1.2.tar.gz",
                "has_sig": false,
                "md5_digest": "ece0d34fa9449c04e042796a6c5a5e9d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 11254,
                "upload_time": "2016-03-08T11:43:42",
                "url": "https://files.pythonhosted.org/packages/e2/d2/e1c1cc2cdad16043440b06cfdd073295b184d2320d3a0f6ccabec1ac3ea7/df2gspread-0.1.2.tar.gz"
            }
        ],
        "0.2.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "80c8d83e6af30f3bce562f6d186862b9",
                    "sha256": "761e95e85cb35c13868bd1d4b8d724cbba4b1128066925c84c8e902d0379a0ee"
                },
                "downloads": -1,
                "filename": "df2gspread-0.2.0.tar.gz",
                "has_sig": false,
                "md5_digest": "80c8d83e6af30f3bce562f6d186862b9",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 11895,
                "upload_time": "2016-07-31T20:24:48",
                "url": "https://files.pythonhosted.org/packages/eb/df/59aa151dc2a769a2b6c454bfc9dbf954b587bfd2b24b29c1ab516dac2920/df2gspread-0.2.0.tar.gz"
            }
        ],
        "0.2.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "80d9fab118c804920878e59a1395f02e",
                    "sha256": "06c1b826809d2fa0937eb731fe14e72e3c03fabe24fdffe357ff03bd695eed7e"
                },
                "downloads": -1,
                "filename": "df2gspread-0.2.1.tar.gz",
                "has_sig": false,
                "md5_digest": "80d9fab118c804920878e59a1395f02e",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 11944,
                "upload_time": "2016-09-24T12:06:13",
                "url": "https://files.pythonhosted.org/packages/06/c7/17341f578a541eb1d8458cf2bcc5b9a5db81c180084ddd30143a24ef0c12/df2gspread-0.2.1.tar.gz"
            }
        ],
        "0.2.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "5f99d628f94a8c740564f10ea19a0104",
                    "sha256": "b385f14c41a51f44511220aed1c4e08f9c69904ca4b78340a93e7e1af5259352"
                },
                "downloads": -1,
                "filename": "df2gspread-0.2.2.tar.gz",
                "has_sig": false,
                "md5_digest": "5f99d628f94a8c740564f10ea19a0104",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 12016,
                "upload_time": "2017-02-22T14:38:08",
                "url": "https://files.pythonhosted.org/packages/f9/fe/559cc7e5bd00ae2f951e404f6bb3e1cc663abfe152b12d5d6d8031c3e8d6/df2gspread-0.2.2.tar.gz"
            }
        ],
        "0.2.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "bbd0009d05dab43af57a627a9895c525",
                    "sha256": "98501399986871495d115b2331110fef576658b81002c95393c7ea478cb87c84"
                },
                "downloads": -1,
                "filename": "df2gspread-0.2.3.tar.gz",
                "has_sig": false,
                "md5_digest": "bbd0009d05dab43af57a627a9895c525",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 12036,
                "upload_time": "2017-02-22T15:31:32",
                "url": "https://files.pythonhosted.org/packages/e1/fc/170e94f5943b12ba84327c810c19a5c8a9b935376be45f3412a314dbff30/df2gspread-0.2.3.tar.gz"
            }
        ],
        "0.2.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "18414c693ea670cbbb1af25da2a1960c",
                    "sha256": "43b423f93b2da561fccfd07290416beb658af151f9f672f6efce956e0d683dbb"
                },
                "downloads": -1,
                "filename": "df2gspread-0.2.4.tar.gz",
                "has_sig": false,
                "md5_digest": "18414c693ea670cbbb1af25da2a1960c",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 12057,
                "upload_time": "2017-06-23T12:04:33",
                "url": "https://files.pythonhosted.org/packages/52/08/7c26432177f0aaa30afe61a067efcabd741b8ead8a6560c915b56db60bae/df2gspread-0.2.4.tar.gz"
            }
        ],
        "0.2.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "df7b1fe24de8a13f831c13882c18e46c",
                    "sha256": "3093b7808e65d1d834153509ec7b33266b02e5e4dd65d8c91caafbb26f3203ea"
                },
                "downloads": -1,
                "filename": "df2gspread-0.2.5.tar.gz",
                "has_sig": false,
                "md5_digest": "df7b1fe24de8a13f831c13882c18e46c",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 12090,
                "upload_time": "2017-10-30T11:00:01",
                "url": "https://files.pythonhosted.org/packages/ab/ed/cd87289cd42f0371f8a9eca22bedf8b1091da21341bcd10b3426230927cd/df2gspread-0.2.5.tar.gz"
            }
        ],
        "1.0.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "569bda1b90fde33644340423a53feb76",
                    "sha256": "db833fa7bc921d8cd1fd5cd3ac07e697a7fabe474d8448d43d778077dd8ce83d"
                },
                "downloads": -1,
                "filename": "df2gspread-1.0.0.tar.gz",
                "has_sig": false,
                "md5_digest": "569bda1b90fde33644340423a53feb76",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 12163,
                "upload_time": "2018-05-02T16:59:47",
                "url": "https://files.pythonhosted.org/packages/ae/2a/3400c96d2c9a6e917e79a1652a9489710c0a82497009a9c71bb981b11518/df2gspread-1.0.0.tar.gz"
            }
        ],
        "1.0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "5c14450d81208cd0241ad5d312142318",
                    "sha256": "d5bf6c7786faeba5687ab4e7efaa454b13cf9c796099f3ca52c0f56fcfe11091"
                },
                "downloads": -1,
                "filename": "df2gspread-1.0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "5c14450d81208cd0241ad5d312142318",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 12127,
                "upload_time": "2018-05-03T08:17:20",
                "url": "https://files.pythonhosted.org/packages/ed/ba/0585a7779769acbe3561805cacb6bfb1b641eddbce9ce9bc9f94d24ba0ce/df2gspread-1.0.1.tar.gz"
            }
        ],
        "1.0.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "3b3a95197728a72d624e3950ca78b7fe",
                    "sha256": "9623fe11c0b75f24f604abe5b2d07940776df358c336458ee1da4b27f90f53df"
                },
                "downloads": -1,
                "filename": "df2gspread-1.0.2.tar.gz",
                "has_sig": false,
                "md5_digest": "3b3a95197728a72d624e3950ca78b7fe",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 11950,
                "upload_time": "2018-05-03T08:48:58",
                "url": "https://files.pythonhosted.org/packages/01/92/6c8c7a5fac27b9e9e2ce402232aefe876def67780bbaf4350728f4a46d19/df2gspread-1.0.2.tar.gz"
            }
        ],
        "1.0.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "177522c1bdb314678db0c79e2b2896dd",
                    "sha256": "361e44f1b1f21fe9ab3b65eced78f99766b8a1c0d2f27c6214f8ae068b85159c"
                },
                "downloads": -1,
                "filename": "df2gspread-1.0.3.tar.gz",
                "has_sig": false,
                "md5_digest": "177522c1bdb314678db0c79e2b2896dd",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 11919,
                "upload_time": "2018-05-09T08:53:18",
                "url": "https://files.pythonhosted.org/packages/0c/a2/eca6d2f709e0755702d00ed6c6ebdf50a9e766a01da7a92ff0edae2a184e/df2gspread-1.0.3.tar.gz"
            }
        ],
        "1.0.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "8685480cba2b6b9fa5d325f80ed328eb",
                    "sha256": "fa18a06b2d8b815ac3e437150ba6d1a88612af1d7a528e0c305577c304fafc7a"
                },
                "downloads": -1,
                "filename": "df2gspread-1.0.4.tar.gz",
                "has_sig": false,
                "md5_digest": "8685480cba2b6b9fa5d325f80ed328eb",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 11640,
                "upload_time": "2019-01-03T11:55:42",
                "url": "https://files.pythonhosted.org/packages/56/c3/fc3801749129df5632deeb7b9b9ef758a0ea6a4498c207a9eb4ac36deffb/df2gspread-1.0.4.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "8685480cba2b6b9fa5d325f80ed328eb",
                "sha256": "fa18a06b2d8b815ac3e437150ba6d1a88612af1d7a528e0c305577c304fafc7a"
            },
            "downloads": -1,
            "filename": "df2gspread-1.0.4.tar.gz",
            "has_sig": false,
            "md5_digest": "8685480cba2b6b9fa5d325f80ed328eb",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 11640,
            "upload_time": "2019-01-03T11:55:42",
            "url": "https://files.pythonhosted.org/packages/56/c3/fc3801749129df5632deeb7b9b9ef758a0ea6a4498c207a9eb4ac36deffb/df2gspread-1.0.4.tar.gz"
        }
    ]
}