{ "info": { "author": "William Dry", "author_email": "wpbdry@gmail.com", "bugtrack_url": null, "classifiers": [ "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 3" ], "description": "# dftogsheet\nA Python module for writing pandas DataFrame objects directly to Google Spreadsheets \\\ndftogsheet is maintained on\n[GitHub](https://github.com/wpbdry/dftogsheet_pkg)\nand\n[PyPI](https://pypi.org/project/dftogsheet/).\n\n## Install dftogsheet\n```shell\n$ pip install dftogsheet\n```\n\n## Setup\n1. Enable the\n[Google Sheets API](https://developers.google.com/sheets/api/quickstart/python).\n2. Enter a name for your project. This is the name that will be displayed when your\napp asks for permission to edit your spreadsheets in Google Drive later.\n2. Download `credentials.json` into `project-root-folder/.dftogsheet/credentials/` folder.\n\n## Simple usage\n```python\nimport pandas as pd\nimport dftogsheet\n\ndata_frame = pd.DataFrame()\ndftogsheet.write_to_sheet(data_frame, spreadsheet_id, sheet_name)\n```\n\n### Parameters\nThere are three mandatory parameters for the above function:\n- `data_frame` is any pandas DataFrame object.\n- `spreadsheet_id` is the part of the Google Spreadsheet URL\nthat is between `/d/` and `/edit`.\n- `sheet_name` is the name of the sheet within the Google spreadsheet.\nE.g. `Sheet1`.\n\n## Advanced usage\nWith only the above function, this library pretty much only does one thing.\nBut there is actually a lot more flexibility provided to you if you know what's going on.\nPlease look into the two functions in `dftogsheets/__init__.py` to understand what is going on\nunder the hood when you run the above code and to understand how you can use the `Sheet` class\nand its methods more powerfully. If you have any suggestions, you are always more than welcome\nto [contribute](#how-can-i-contribute) ;)\n\n### Changing scopes, valueInputOption, and location of credentials file\nWhat is the valueInputOption?\nRead [this page](https://developers.google.com/sheets/api/reference/rest/v4/ValueInputOption) \\\n\\\nThese settings are actually controlled by the `Config` class. A new instance of the `Config` class\nwith default values is created for you in `dftogsheet.write_section_to_sheet` so you don't have to\nthink about it for the sample code above. However, it is possible to fully customize\nthese configurations by creating your own `config` object for your project.\nPlease look into `dftogheets/config.py` to understand how you can do that.\n\n## What's new in version 0.0.7\n- Add `Sheet.overwrite()` method.\n- Include this method by default.\n\n## How can I contribute?\nThanks for asking! \\\nI appreciate everyone who contributes, no matter how you choose to do it. \\\nAnd if you feel like conforming to my workflow (which I try to stick to), that's great ;)\n\n### My workflow\n- Use [Gitflow Workflow](https://www.atlassian.com/git/tutorials/comparing-workflows/gitflow-workflow).\n- Include GitHub issue number in `feature` and `hotfix` branch names.\n- If an issue doesn't exist on GitHub, create one.\n- Include branch name in every commit message, even on `develop`.\n- Only small \"one commit\" fixes done directly on `develop`.\n- Commit style: imperitive sentences in all lower case except proper nouns.\n- Merge into `develop` using pull requests and keeping the entire commmit history.\n- Merge into `production` squshing commits and keeping only version number in commit message.\n- At some point I would like to automatically publish every release to pushed to `production` on PyPy.\n- If you add new dependencies, don't use `pip freeze > requirements.txt`. Add new dependencies manually.\nPackages we install can install their own dependencies.\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/wpbdry/gsheets_pkg", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "dftogsheet", "package_url": "https://pypi.org/project/dftogsheet/", "platform": "", "project_url": "https://pypi.org/project/dftogsheet/", "project_urls": { "Homepage": "https://github.com/wpbdry/gsheets_pkg" }, "release_url": "https://pypi.org/project/dftogsheet/0.0.7/", "requires_dist": [ "google-auth-oauthlib (==0.3.0)", "google-api-python-client (==1.7.9)", "pandas (==0.24.2)" ], "requires_python": "", "summary": "A Python module for writing pandas DataFrame objects directly to Google Spreadsheets", "version": "0.0.7" }, "last_serial": 5387050, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "45319c267ada129a1d05043b9823e3ed", "sha256": "31436302a15a10b480b9d1fa252bb7276d8d57dca341aa6c0fa26be7bd8681e1" }, "downloads": -1, "filename": "dftogsheet-0.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "45319c267ada129a1d05043b9823e3ed", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 2375, "upload_time": "2019-06-07T20:15:55", "url": "https://files.pythonhosted.org/packages/0c/26/c880a9888d4816e4eecb28ae42ce723f27e4e74a0d76bee08da9dafbe9c3/dftogsheet-0.0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "4eb16c9c88f4aeceb9db7c371377af9d", "sha256": "e40619a60368d040ccb922a6c77ec7e1b18ddd31239016069200ab87ccfd02c6" }, "downloads": -1, "filename": "dftogsheet-0.0.1.tar.gz", "has_sig": false, "md5_digest": "4eb16c9c88f4aeceb9db7c371377af9d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1475, "upload_time": "2019-06-07T20:15:57", "url": "https://files.pythonhosted.org/packages/89/52/fe977da33d19c5cae0a1c0acabf6c69dd449691c6a931ee9623ca8b0842e/dftogsheet-0.0.1.tar.gz" } ], "0.0.2": [ { "comment_text": "", "digests": { "md5": "2178ac682e5c1a88469e3b50cb86f43d", "sha256": "3487c09b49d78d7e12e56ee18cd9538616f69470139d095fdbd92045f481e779" }, "downloads": -1, "filename": "dftogsheet-0.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "2178ac682e5c1a88469e3b50cb86f43d", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 2376, "upload_time": "2019-06-07T20:21:16", "url": "https://files.pythonhosted.org/packages/16/a2/f82b837f8c00f6f236f92a56c77b9250fc944dbf05473e1f750d4562acbb/dftogsheet-0.0.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "6ae201114779436b2973ae74e8bff5b8", "sha256": "eb629278dcbdf2e06268e7b5ebcd36aa2b80ae5960f1225b2e9ac88e8a0799a3" }, "downloads": -1, "filename": "dftogsheet-0.0.2.tar.gz", "has_sig": false, "md5_digest": "6ae201114779436b2973ae74e8bff5b8", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1451, "upload_time": "2019-06-07T20:21:17", "url": "https://files.pythonhosted.org/packages/01/ed/3e1b6ce694f5f02d02e2e72aeda44f0c17edfaf705977e801e2bf7d335f6/dftogsheet-0.0.2.tar.gz" } ], "0.0.3": [ { "comment_text": "", "digests": { "md5": "1967310cb565cfa8ef7ca47f277eefb7", "sha256": "8a84fc2f39447383a842691043fbcd1058d8e033298887ba4bcbd9ededd8446b" }, "downloads": -1, "filename": "dftogsheet-0.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "1967310cb565cfa8ef7ca47f277eefb7", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 5632, "upload_time": "2019-06-07T20:35:26", "url": "https://files.pythonhosted.org/packages/ce/41/8671b7113f2c91f0f398796dede0b2f7832b4d1bc8d9c76de99ea0f7428c/dftogsheet-0.0.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "0ebebb91e2adc7379bdf7045901c17f5", "sha256": "d6798efbe3d8064d362265fc1e88a137c67ac9e5f84cda3dc00098bd3a4d3299" }, "downloads": -1, "filename": "dftogsheet-0.0.3.tar.gz", "has_sig": false, "md5_digest": "0ebebb91e2adc7379bdf7045901c17f5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3850, "upload_time": "2019-06-07T20:35:28", "url": "https://files.pythonhosted.org/packages/c3/93/ff80a871f0c495fae0ee370d4f7a6bb13991a5f269875d61bb51049f7207/dftogsheet-0.0.3.tar.gz" } ], "0.0.4": [ { "comment_text": "", "digests": { "md5": "b7218a02949bfa404a05fc98bd136619", "sha256": "97558c7e1c50c814197970c39e7a0f461682e3720cb980a35226ab02cd91d3d7" }, "downloads": -1, "filename": "dftogsheet-0.0.4-py3-none-any.whl", "has_sig": false, "md5_digest": "b7218a02949bfa404a05fc98bd136619", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 5626, "upload_time": "2019-06-07T20:42:46", "url": "https://files.pythonhosted.org/packages/ba/e1/d5a8ccafe6835bb4d03af634c7032b5761bd38a73ff901849f1cdb3af1b1/dftogsheet-0.0.4-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "8d8066cd41b3637925980afa49208edd", "sha256": "8e9659ccdea8d38985aed4d1a53f7fea474c39d8038fe98291b50bd54d0c8f89" }, "downloads": -1, "filename": "dftogsheet-0.0.4.tar.gz", "has_sig": false, "md5_digest": "8d8066cd41b3637925980afa49208edd", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3842, "upload_time": "2019-06-07T20:42:47", "url": "https://files.pythonhosted.org/packages/04/96/13d32e6a4181d90536754f47562c358b5ab5ff39777e59e1e82fffc5c7d4/dftogsheet-0.0.4.tar.gz" } ], "0.0.5": [ { "comment_text": "", "digests": { "md5": "96b0cfca85cd2138ba1ea6fb4b7a6326", "sha256": "03f059341648cbe81dad378994dd15af475df7ac72a04fd3238f4488fc92100e" }, "downloads": -1, "filename": "dftogsheet-0.0.5-py3-none-any.whl", "has_sig": false, "md5_digest": "96b0cfca85cd2138ba1ea6fb4b7a6326", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 5679, "upload_time": "2019-06-07T20:58:45", "url": "https://files.pythonhosted.org/packages/4a/44/c313ef6626af2e10bd01e038e997a4eecdbc30db23ac8ac0bf2e5b1becb3/dftogsheet-0.0.5-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "dda174d5fcddf320e04f3560988f18bf", "sha256": "e5f8cd4625e682cba462622c5ddab869a0e92e23a247b8c90ae44b96be6e14e5" }, "downloads": -1, "filename": "dftogsheet-0.0.5.tar.gz", "has_sig": false, "md5_digest": "dda174d5fcddf320e04f3560988f18bf", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3909, "upload_time": "2019-06-07T20:58:47", "url": "https://files.pythonhosted.org/packages/62/6a/6a8a74c88fed7035b1c8e5cb67158e243fd879231106fd3e207edb395d26/dftogsheet-0.0.5.tar.gz" } ], "0.0.6": [ { "comment_text": "", "digests": { "md5": "a0072b525fc311e7e90e2a5e4aa0ac51", "sha256": "67abdb0de9e243af72da6f0707921371ad164c76575a182776273c8e05cc65de" }, "downloads": -1, "filename": "dftogsheet-0.0.6-py3-none-any.whl", "has_sig": false, "md5_digest": "a0072b525fc311e7e90e2a5e4aa0ac51", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7537, "upload_time": "2019-06-11T09:04:54", "url": "https://files.pythonhosted.org/packages/99/ff/bc4d89db3fbb65bb237b1e915ddbab8cc2ddfdd7ce7d21fc3b89838387d2/dftogsheet-0.0.6-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "faab34116f83bc24491e9d149e7881cf", "sha256": "8a115dc265e5af5467d6113d893b05aafc9936251fc0c3a008693d8dd0981563" }, "downloads": -1, "filename": "dftogsheet-0.0.6.tar.gz", "has_sig": false, "md5_digest": "faab34116f83bc24491e9d149e7881cf", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5747, "upload_time": "2019-06-11T09:04:56", "url": "https://files.pythonhosted.org/packages/d9/d5/c856fa8e0b2b298e2802787bb645f17f34a83e24d456b75d179f515a5282/dftogsheet-0.0.6.tar.gz" } ], "0.0.7": [ { "comment_text": "", "digests": { "md5": "aa762815903401b6d7710ae203928ba5", "sha256": "c24ce3fee9610b49a00fb8f1d35f0310231446551ae14c42176993544a05060d" }, "downloads": -1, "filename": "dftogsheet-0.0.7-py3-none-any.whl", "has_sig": false, "md5_digest": "aa762815903401b6d7710ae203928ba5", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7346, "upload_time": "2019-06-11T15:10:47", "url": "https://files.pythonhosted.org/packages/a4/f7/3a0b48a52bb53ba4bc6888741e48e420c0e78db3c36f54df315bb1c98286/dftogsheet-0.0.7-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "277e197affec9318d723b7a5229818e5", "sha256": "b60a4235c9e0433d7f31aef66cd863c640ba79b9499e6b054fcdf9e6e6213414" }, "downloads": -1, "filename": "dftogsheet-0.0.7.tar.gz", "has_sig": false, "md5_digest": "277e197affec9318d723b7a5229818e5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5554, "upload_time": "2019-06-11T15:10:48", "url": "https://files.pythonhosted.org/packages/67/ba/037d62ae995006ecfb2a7685bff06e7d0c5b8374a9af9f91840f95abfc2c/dftogsheet-0.0.7.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "aa762815903401b6d7710ae203928ba5", "sha256": "c24ce3fee9610b49a00fb8f1d35f0310231446551ae14c42176993544a05060d" }, "downloads": -1, "filename": "dftogsheet-0.0.7-py3-none-any.whl", "has_sig": false, "md5_digest": "aa762815903401b6d7710ae203928ba5", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7346, "upload_time": "2019-06-11T15:10:47", "url": "https://files.pythonhosted.org/packages/a4/f7/3a0b48a52bb53ba4bc6888741e48e420c0e78db3c36f54df315bb1c98286/dftogsheet-0.0.7-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "277e197affec9318d723b7a5229818e5", "sha256": "b60a4235c9e0433d7f31aef66cd863c640ba79b9499e6b054fcdf9e6e6213414" }, "downloads": -1, "filename": "dftogsheet-0.0.7.tar.gz", "has_sig": false, "md5_digest": "277e197affec9318d723b7a5229818e5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5554, "upload_time": "2019-06-11T15:10:48", "url": "https://files.pythonhosted.org/packages/67/ba/037d62ae995006ecfb2a7685bff06e7d0c5b8374a9af9f91840f95abfc2c/dftogsheet-0.0.7.tar.gz" } ] }