Name | gs-update-utils JSON |
Version |
1.0.4
JSON |
| download |
home_page | |
Summary | Utilities for working with Google Sheets: establishing a connection, reading data from a sheet, and uploading a DataFrame to Google Sheets with retry support. |
upload_time | 2023-10-19 12:39:40 |
maintainer | |
docs_url | None |
author | xgzx |
requires_python | >=3.7 |
license | |
keywords |
example
python
|
VCS |
|
bugtrack_url |
|
requirements |
No requirements were recorded.
|
Travis-CI |
No Travis.
|
coveralls test coverage |
No coveralls.
|
<div class="markdown prose w-full break-words dark:prose-invert dark">
<p><strong>English:</strong></p>
<h1>Google Sheets Utils Module</h1>
<p>The module provides convenient utilities for working with Google Sheets. Features include establishing a connection to the Google Sheets API, reading data from a sheet, and uploading a DataFrame to Google Sheets with retry support.</p><h2>Installation</h2><pre><div class="bg-black rounded-md mb-4"><div class="flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md"><span>bash</span><button class="flex ml-auto gizmo:ml-0 gap-2 items-center"><svg stroke="currentColor" fill="none" stroke-width="2" viewBox="0 0 24 24" stroke-linecap="round" stroke-linejoin="round" class="icon-sm" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path d="M16 4h2a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2h2"></path><rect x="8" y="2" width="8" height="4" rx="1" ry="1"></rect></svg>Copy code</button></div><div class="p-4 overflow-y-auto"><code class="!whitespace-pre hljs language-bash">pip install gs-update-utils
</code></div></div></pre><h2>Usage</h2><h3>Establishing a Connection</h3><pre><div class="bg-black rounded-md mb-4"><div class="flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md"><span>python</span><button class="flex ml-auto gizmo:ml-0 gap-2 items-center"><svg stroke="currentColor" fill="none" stroke-width="2" viewBox="0 0 24 24" stroke-linecap="round" stroke-linejoin="round" class="icon-sm" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path d="M16 4h2a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2h2"></path><rect x="8" y="2" width="8" height="4" rx="1" ry="1"></rect></svg>Copy code</button></div><div class="p-4 overflow-y-auto"><code class="!whitespace-pre hljs language-python"><span class="hljs-keyword">from</span> gs-update-utils <span class="hljs-keyword">import</span> setup_google_sheets
credentials_folder = <span class="hljs-string">"path/to/credentials"</span>
credentials_file = <span class="hljs-string">"credentials.json"</span>
google_credentials = setup_google_sheets(credentials_folder, credentials_file)
</code></div></div></pre>
<h3>Reading Data from a Sheet</h3><pre><div class="bg-black rounded-md mb-4"><div class="flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md"><span>python</span><button class="flex ml-auto gizmo:ml-0 gap-2 items-center"><svg stroke="currentColor" fill="none" stroke-width="2" viewBox="0 0 24 24" stroke-linecap="round" stroke-linejoin="round" class="icon-sm" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path d="M16 4h2a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2h2"></path><rect x="8" y="2" width="8" height="4" rx="1" ry="1"></rect></svg>Copy code</button></div><div class="p-4 overflow-y-auto"><code class="!whitespace-pre hljs language-python"><span class="hljs-keyword">from</span> gs-update-utils <span class="hljs-keyword">import</span> read_gs_table
worksheet_id = <span class="hljs-string">"your_worksheet_id"</span>
worksheet_name = <span class="hljs-string">"your_worksheet_name"</span>
dataframe = read_gs_table(worksheet_id, worksheet_name, google_credentials)
</code></div></div></pre><h3>Uploading DataFrame to Google Sheets</h3><pre><div class="bg-black rounded-md mb-4"><div class="flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md"><span>python</span><button class="flex ml-auto gizmo:ml-0 gap-2 items-center"><svg stroke="currentColor" fill="none" stroke-width="2" viewBox="0 0 24 24" stroke-linecap="round" stroke-linejoin="round" class="icon-sm" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path d="M16 4h2a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2h2"></path><rect x="8" y="2" width="8" height="4" rx="1" ry="1"></rect></svg>Copy code</button></div><div class="p-4 overflow-y-auto"><code class="!whitespace-pre hljs language-python"><span class="hljs-keyword">from</span> gs-update-utils <span class="hljs-keyword">import</span> upload_table_to_google_sheet
worksheet_id = <span class="hljs-string">"your_worksheet_id"</span>
worksheet_name = <span class="hljs-string">"your_worksheet_name"</span>
upload_table_to_google_sheet(dataframe, worksheet_id, worksheet_name, google_credentials)
</code></div></div></pre></div>
<p><strong>Русский:</strong></p>
<h1>Модуль Google Sheets Utils</h1>
<p>Модуль предоставляет удобные утилиты для работы с Google Sheets. Возможности включают установку соединения с API Google Sheets, чтение данных из листа и загрузку DataFrame в Google Sheets с поддержкой повторных попыток.</p><h2>Установка</h2><pre><div class="bg-black rounded-md mb-4"><div class="flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md"><span>bash</span><button class="flex ml-auto gizmo:ml-0 gap-2 items-center"><svg stroke="currentColor" fill="none" stroke-width="2" viewBox="0 0 24 24" stroke-linecap="round" stroke-linejoin="round" class="icon-sm" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path d="M16 4h2a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2h2"></path><rect x="8" y="2" width="8" height="4" rx="1" ry="1"></rect></svg>Copy code</button></div><div class="p-4 overflow-y-auto"><code class="!whitespace-pre hljs language-bash">pip install gs-update-utils
</code></div></pre><h2>Использование</h2><h3>Установка соединения</h3><pre><div class="bg-black rounded-md mb-4"><div class="flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md"><span>python</span><button class="flex ml-auto gizmo:ml-0 gap-2 items-center"><svg stroke="currentColor" fill="none" stroke-width="2" viewBox="0 0 24 24" stroke-linecap="round" stroke-linejoin="round" class="icon-sm" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path d="M16 4h2a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2h2"></path><rect x="8" y="2" width="8" height="4" rx="1" ry="1"></rect></svg>Copy code</button></div><div class="p-4 overflow-y-auto"><code class="!whitespace-pre hljs language-python"><span class="hljs-keyword">from</span> gs-update-utils <span class="hljs-keyword">import</span> setup_google_sheets
credentials_folder = <span class="hljs-string">"path/to/credentials"</span>
credentials_file = <span class="hljs-string">"credentials.json"</span>
google_credentials = setup_google_sheets(credentials_folder, credentials_file)
</code></div></div></pre><h3>Чтение данных из листа</h3><pre><div class="bg-black rounded-md mb-4"><div class="flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md"><span>python</span><button class="flex ml-auto gizmo:ml-0 gap-2 items-center"><svg stroke="currentColor" fill="none" stroke-width="2" viewBox="0 0 24 24" stroke-linecap="round" stroke-linejoin="round" class="icon-sm" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path d="M16 4h2a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2h2"></path><rect x="8" y="2" width="8" height="4" rx="1" ry="1"></rect></svg>Copy code</button></div><div class="p-4 overflow-y-auto"><code class="!whitespace-pre hljs language-python"><span class="hljs-keyword">from</span> gs-update-utils <span class="hljs-keyword">import</span> read_gs_table
worksheet_id = <span class="hljs-string">"your_worksheet_id"</span>
worksheet_name = <span class="hljs-string">"your_worksheet_name"</span>
dataframe = read_gs_table(worksheet_id, worksheet_name, google_credentials)
</code></div></div></pre><h3>Загрузка DataFrame в Google Sheets</h3><pre><div class="bg-black rounded-md mb-4"><div class="flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md"><span>python</span><button class="flex ml-auto gizmo:ml-0 gap-2 items-center"><svg stroke="currentColor" fill="none" stroke-width="2" viewBox="0 0 24 24" stroke-linecap="round" stroke-linejoin="round" class="icon-sm" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path d="M16 4h2a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2h2"></path><rect x="8" y="2" width="8" height="4" rx="1" ry="1"></rect></svg>Copy code</button></div><div class="p-4 overflow-y-auto"><code class="!whitespace-pre hljs language-python"><span class="hljs-keyword">from</span> gs-update-utils <span class="hljs-keyword">import</span> upload_table_to_google_sheet
worksheet_id = <span class="hljs-string">"your_worksheet_id"</span>
worksheet_name = <span class="hljs-string">"your_worksheet_name"</span>
upload_table_to_google_sheet(dataframe, worksheet_id, worksheet_name, google_credentials)
</code></div></div></pre>
Raw data
{
"_id": null,
"home_page": "",
"name": "gs-update-utils",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.7",
"maintainer_email": "",
"keywords": "example python",
"author": "xgzx",
"author_email": "vadijimory@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/e6/d7/7e5ff2553d94d22719902de65436b185244a869100ad456ceeb520b62450/gs_update_utils-1.0.4.tar.gz",
"platform": null,
"description": "<div class=\"markdown prose w-full break-words dark:prose-invert dark\">\r\n\r\n<p><strong>English:</strong></p>\r\n\r\n<h1>Google Sheets Utils Module</h1>\r\n<p>The module provides convenient utilities for working with Google Sheets. Features include establishing a connection to the Google Sheets API, reading data from a sheet, and uploading a DataFrame to Google Sheets with retry support.</p><h2>Installation</h2><pre><div class=\"bg-black rounded-md mb-4\"><div class=\"flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md\"><span>bash</span><button class=\"flex ml-auto gizmo:ml-0 gap-2 items-center\"><svg stroke=\"currentColor\" fill=\"none\" stroke-width=\"2\" viewBox=\"0 0 24 24\" stroke-linecap=\"round\" stroke-linejoin=\"round\" class=\"icon-sm\" height=\"1em\" width=\"1em\" xmlns=\"http://www.w3.org/2000/svg\"><path d=\"M16 4h2a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2h2\"></path><rect x=\"8\" y=\"2\" width=\"8\" height=\"4\" rx=\"1\" ry=\"1\"></rect></svg>Copy code</button></div><div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-bash\">pip install gs-update-utils\r\n</code></div></div></pre><h2>Usage</h2><h3>Establishing a Connection</h3><pre><div class=\"bg-black rounded-md mb-4\"><div class=\"flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md\"><span>python</span><button class=\"flex ml-auto gizmo:ml-0 gap-2 items-center\"><svg stroke=\"currentColor\" fill=\"none\" stroke-width=\"2\" viewBox=\"0 0 24 24\" stroke-linecap=\"round\" stroke-linejoin=\"round\" class=\"icon-sm\" height=\"1em\" width=\"1em\" xmlns=\"http://www.w3.org/2000/svg\"><path d=\"M16 4h2a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2h2\"></path><rect x=\"8\" y=\"2\" width=\"8\" height=\"4\" rx=\"1\" ry=\"1\"></rect></svg>Copy code</button></div><div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-python\"><span class=\"hljs-keyword\">from</span> gs-update-utils <span class=\"hljs-keyword\">import</span> setup_google_sheets\r\n\r\ncredentials_folder = <span class=\"hljs-string\">\"path/to/credentials\"</span>\r\ncredentials_file = <span class=\"hljs-string\">\"credentials.json\"</span>\r\ngoogle_credentials = setup_google_sheets(credentials_folder, credentials_file)\r\n</code></div></div></pre>\r\n\r\n<h3>Reading Data from a Sheet</h3><pre><div class=\"bg-black rounded-md mb-4\"><div class=\"flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md\"><span>python</span><button class=\"flex ml-auto gizmo:ml-0 gap-2 items-center\"><svg stroke=\"currentColor\" fill=\"none\" stroke-width=\"2\" viewBox=\"0 0 24 24\" stroke-linecap=\"round\" stroke-linejoin=\"round\" class=\"icon-sm\" height=\"1em\" width=\"1em\" xmlns=\"http://www.w3.org/2000/svg\"><path d=\"M16 4h2a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2h2\"></path><rect x=\"8\" y=\"2\" width=\"8\" height=\"4\" rx=\"1\" ry=\"1\"></rect></svg>Copy code</button></div><div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-python\"><span class=\"hljs-keyword\">from</span> gs-update-utils <span class=\"hljs-keyword\">import</span> read_gs_table\r\n\r\nworksheet_id = <span class=\"hljs-string\">\"your_worksheet_id\"</span>\r\nworksheet_name = <span class=\"hljs-string\">\"your_worksheet_name\"</span>\r\ndataframe = read_gs_table(worksheet_id, worksheet_name, google_credentials)\r\n</code></div></div></pre><h3>Uploading DataFrame to Google Sheets</h3><pre><div class=\"bg-black rounded-md mb-4\"><div class=\"flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md\"><span>python</span><button class=\"flex ml-auto gizmo:ml-0 gap-2 items-center\"><svg stroke=\"currentColor\" fill=\"none\" stroke-width=\"2\" viewBox=\"0 0 24 24\" stroke-linecap=\"round\" stroke-linejoin=\"round\" class=\"icon-sm\" height=\"1em\" width=\"1em\" xmlns=\"http://www.w3.org/2000/svg\"><path d=\"M16 4h2a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2h2\"></path><rect x=\"8\" y=\"2\" width=\"8\" height=\"4\" rx=\"1\" ry=\"1\"></rect></svg>Copy code</button></div><div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-python\"><span class=\"hljs-keyword\">from</span> gs-update-utils <span class=\"hljs-keyword\">import</span> upload_table_to_google_sheet\r\n\r\nworksheet_id = <span class=\"hljs-string\">\"your_worksheet_id\"</span>\r\nworksheet_name = <span class=\"hljs-string\">\"your_worksheet_name\"</span>\r\nupload_table_to_google_sheet(dataframe, worksheet_id, worksheet_name, google_credentials)\r\n</code></div></div></pre></div>\r\n\r\n<p><strong>\u0420\u0443\u0441\u0441\u043a\u0438\u0439:</strong></p>\r\n\r\n<h1>\u041c\u043e\u0434\u0443\u043b\u044c Google Sheets Utils</h1>\r\n\r\n<p>\u041c\u043e\u0434\u0443\u043b\u044c \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u0443\u0434\u043e\u0431\u043d\u044b\u0435 \u0443\u0442\u0438\u043b\u0438\u0442\u044b \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 Google Sheets. \u0412\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438 \u0432\u043a\u043b\u044e\u0447\u0430\u044e\u0442 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0443 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u044f \u0441 API Google Sheets, \u0447\u0442\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 \u043b\u0438\u0441\u0442\u0430 \u0438 \u0437\u0430\u0433\u0440\u0443\u0437\u043a\u0443 DataFrame \u0432 Google Sheets \u0441 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u043e\u0439 \u043f\u043e\u0432\u0442\u043e\u0440\u043d\u044b\u0445 \u043f\u043e\u043f\u044b\u0442\u043e\u043a.</p><h2>\u0423\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430</h2><pre><div class=\"bg-black rounded-md mb-4\"><div class=\"flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md\"><span>bash</span><button class=\"flex ml-auto gizmo:ml-0 gap-2 items-center\"><svg stroke=\"currentColor\" fill=\"none\" stroke-width=\"2\" viewBox=\"0 0 24 24\" stroke-linecap=\"round\" stroke-linejoin=\"round\" class=\"icon-sm\" height=\"1em\" width=\"1em\" xmlns=\"http://www.w3.org/2000/svg\"><path d=\"M16 4h2a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2h2\"></path><rect x=\"8\" y=\"2\" width=\"8\" height=\"4\" rx=\"1\" ry=\"1\"></rect></svg>Copy code</button></div><div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-bash\">pip install gs-update-utils\r\n</code></div></pre><h2>\u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435</h2><h3>\u0423\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u044f</h3><pre><div class=\"bg-black rounded-md mb-4\"><div class=\"flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md\"><span>python</span><button class=\"flex ml-auto gizmo:ml-0 gap-2 items-center\"><svg stroke=\"currentColor\" fill=\"none\" stroke-width=\"2\" viewBox=\"0 0 24 24\" stroke-linecap=\"round\" stroke-linejoin=\"round\" class=\"icon-sm\" height=\"1em\" width=\"1em\" xmlns=\"http://www.w3.org/2000/svg\"><path d=\"M16 4h2a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2h2\"></path><rect x=\"8\" y=\"2\" width=\"8\" height=\"4\" rx=\"1\" ry=\"1\"></rect></svg>Copy code</button></div><div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-python\"><span class=\"hljs-keyword\">from</span> gs-update-utils <span class=\"hljs-keyword\">import</span> setup_google_sheets\r\n\r\ncredentials_folder = <span class=\"hljs-string\">\"path/to/credentials\"</span>\r\ncredentials_file = <span class=\"hljs-string\">\"credentials.json\"</span>\r\ngoogle_credentials = setup_google_sheets(credentials_folder, credentials_file)\r\n</code></div></div></pre><h3>\u0427\u0442\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 \u043b\u0438\u0441\u0442\u0430</h3><pre><div class=\"bg-black rounded-md mb-4\"><div class=\"flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md\"><span>python</span><button class=\"flex ml-auto gizmo:ml-0 gap-2 items-center\"><svg stroke=\"currentColor\" fill=\"none\" stroke-width=\"2\" viewBox=\"0 0 24 24\" stroke-linecap=\"round\" stroke-linejoin=\"round\" class=\"icon-sm\" height=\"1em\" width=\"1em\" xmlns=\"http://www.w3.org/2000/svg\"><path d=\"M16 4h2a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2h2\"></path><rect x=\"8\" y=\"2\" width=\"8\" height=\"4\" rx=\"1\" ry=\"1\"></rect></svg>Copy code</button></div><div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-python\"><span class=\"hljs-keyword\">from</span> gs-update-utils <span class=\"hljs-keyword\">import</span> read_gs_table\r\n\r\nworksheet_id = <span class=\"hljs-string\">\"your_worksheet_id\"</span>\r\nworksheet_name = <span class=\"hljs-string\">\"your_worksheet_name\"</span>\r\ndataframe = read_gs_table(worksheet_id, worksheet_name, google_credentials)\r\n</code></div></div></pre><h3>\u0417\u0430\u0433\u0440\u0443\u0437\u043a\u0430 DataFrame \u0432 Google Sheets</h3><pre><div class=\"bg-black rounded-md mb-4\"><div class=\"flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md\"><span>python</span><button class=\"flex ml-auto gizmo:ml-0 gap-2 items-center\"><svg stroke=\"currentColor\" fill=\"none\" stroke-width=\"2\" viewBox=\"0 0 24 24\" stroke-linecap=\"round\" stroke-linejoin=\"round\" class=\"icon-sm\" height=\"1em\" width=\"1em\" xmlns=\"http://www.w3.org/2000/svg\"><path d=\"M16 4h2a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2V6a2 2 0 0 1 2-2h2\"></path><rect x=\"8\" y=\"2\" width=\"8\" height=\"4\" rx=\"1\" ry=\"1\"></rect></svg>Copy code</button></div><div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-python\"><span class=\"hljs-keyword\">from</span> gs-update-utils <span class=\"hljs-keyword\">import</span> upload_table_to_google_sheet\r\n\r\nworksheet_id = <span class=\"hljs-string\">\"your_worksheet_id\"</span>\r\nworksheet_name = <span class=\"hljs-string\">\"your_worksheet_name\"</span>\r\nupload_table_to_google_sheet(dataframe, worksheet_id, worksheet_name, google_credentials)\r\n</code></div></div></pre>\r\n\r\n",
"bugtrack_url": null,
"license": "",
"summary": "Utilities for working with Google Sheets: establishing a connection, reading data from a sheet, and uploading a DataFrame to Google Sheets with retry support.",
"version": "1.0.4",
"project_urls": null,
"split_keywords": [
"example",
"python"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "e4fd8b4f6a7ef48083d7c40c9bb3f5a8d5cbf4f1af340578b08651c3dd2a74d3",
"md5": "c784300fd5fc54d75d95f607ab186392",
"sha256": "853f74574ccca9b2aecbee247c38f95c28ec22dbf3bd5c9931fb8b0cb933220c"
},
"downloads": -1,
"filename": "gs_update_utils-1.0.4-py3-none-any.whl",
"has_sig": false,
"md5_digest": "c784300fd5fc54d75d95f607ab186392",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.7",
"size": 5452,
"upload_time": "2023-10-19T12:39:39",
"upload_time_iso_8601": "2023-10-19T12:39:39.885916Z",
"url": "https://files.pythonhosted.org/packages/e4/fd/8b4f6a7ef48083d7c40c9bb3f5a8d5cbf4f1af340578b08651c3dd2a74d3/gs_update_utils-1.0.4-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "e6d77e5ff2553d94d22719902de65436b185244a869100ad456ceeb520b62450",
"md5": "43167431175c8369fa98e396aceffc98",
"sha256": "eba710c330d8a8c0048c408439f5bfa3191230cac0856b422272f89e56c5a13d"
},
"downloads": -1,
"filename": "gs_update_utils-1.0.4.tar.gz",
"has_sig": false,
"md5_digest": "43167431175c8369fa98e396aceffc98",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.7",
"size": 5302,
"upload_time": "2023-10-19T12:39:40",
"upload_time_iso_8601": "2023-10-19T12:39:40.941159Z",
"url": "https://files.pythonhosted.org/packages/e6/d7/7e5ff2553d94d22719902de65436b185244a869100ad456ceeb520b62450/gs_update_utils-1.0.4.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-10-19 12:39:40",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "gs-update-utils"
}