pandas-gbq
==========
|preview| |pypi| |versions|
**pandas-gbq** is a package providing an interface to the Google BigQuery API from pandas.
- `Library Documentation`_
- `Product Documentation`_
.. |preview| image:: https://img.shields.io/badge/support-preview-orange.svg
:target: https://github.com/googleapis/google-cloud-python/blob/main/README.rst#beta-support
.. |pypi| image:: https://img.shields.io/pypi/v/pandas-gbq.svg
:target: https://pypi.org/project/pandas-gbq/
.. |versions| image:: https://img.shields.io/pypi/pyversions/pandas-gbq.svg
:target: https://pypi.org/project/pandas-gbq/
.. _Library Documentation: https://googleapis.dev/python/pandas-gbq/latest/
.. _Product Documentation: https://cloud.google.com/bigquery/docs/reference/v2/
Installation
------------
Install latest release version via pip
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.. code-block:: shell
$ pip install pandas-gbq
Install latest development version
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.. code-block:: shell
$ pip install git+https://github.com/googleapis/python-bigquery-pandas.git
Usage
-----
Perform a query
~~~~~~~~~~~~~~~
.. code:: python
import pandas_gbq
result_dataframe = pandas_gbq.read_gbq("SELECT column FROM dataset.table WHERE value = 'something'")
Upload a dataframe
~~~~~~~~~~~~~~~~~~
.. code:: python
import pandas_gbq
pandas_gbq.to_gbq(dataframe, "dataset.table")
More samples
~~~~~~~~~~~~
See the `pandas-gbq documentation <https://googleapis.dev/python/pandas-gbq/latest/>`_ for more details.
Raw data
{
"_id": null,
"home_page": "https://github.com/googleapis/python-bigquery-pandas",
"name": "pandas-gbq",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.8",
"maintainer_email": null,
"keywords": null,
"author": "pandas-gbq authors",
"author_email": "googleapis-packages@google.com",
"download_url": "https://files.pythonhosted.org/packages/bb/56/02f90fd919007a3bc07a1407dc159383412b165cd4f98f85f318e063fcb1/pandas_gbq-0.27.0.tar.gz",
"platform": "Posix; MacOS X; Windows",
"description": "pandas-gbq\n==========\n\n|preview| |pypi| |versions|\n\n**pandas-gbq** is a package providing an interface to the Google BigQuery API from pandas.\n\n- `Library Documentation`_\n- `Product Documentation`_\n\n.. |preview| image:: https://img.shields.io/badge/support-preview-orange.svg\n :target: https://github.com/googleapis/google-cloud-python/blob/main/README.rst#beta-support\n.. |pypi| image:: https://img.shields.io/pypi/v/pandas-gbq.svg\n :target: https://pypi.org/project/pandas-gbq/\n.. |versions| image:: https://img.shields.io/pypi/pyversions/pandas-gbq.svg\n :target: https://pypi.org/project/pandas-gbq/\n.. _Library Documentation: https://googleapis.dev/python/pandas-gbq/latest/\n.. _Product Documentation: https://cloud.google.com/bigquery/docs/reference/v2/\n\nInstallation\n------------\n\nInstall latest release version via pip\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\n.. code-block:: shell\n\n $ pip install pandas-gbq\n\nInstall latest development version\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\n.. code-block:: shell\n\n $ pip install git+https://github.com/googleapis/python-bigquery-pandas.git\n\n\nUsage\n-----\n\nPerform a query\n~~~~~~~~~~~~~~~\n\n.. code:: python\n\n import pandas_gbq\n\n result_dataframe = pandas_gbq.read_gbq(\"SELECT column FROM dataset.table WHERE value = 'something'\")\n\nUpload a dataframe\n~~~~~~~~~~~~~~~~~~\n\n.. code:: python\n\n import pandas_gbq\n\n pandas_gbq.to_gbq(dataframe, \"dataset.table\")\n\nMore samples\n~~~~~~~~~~~~\n\nSee the `pandas-gbq documentation <https://googleapis.dev/python/pandas-gbq/latest/>`_ for more details.\n",
"bugtrack_url": null,
"license": "BSD-3-Clause",
"summary": "Google BigQuery connector for pandas",
"version": "0.27.0",
"project_urls": {
"Homepage": "https://github.com/googleapis/python-bigquery-pandas"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "f3c20108d7c3c60ac20c5c0ecf60248f2b6c7e3ea038420dc44de322812472db",
"md5": "004789a9ecf1641c5f79d0b269b96945",
"sha256": "cb1fbedbefc4a92c4f96aa3ba2b5d56fddf25e651b39cd5ae11fa2158db79bc1"
},
"downloads": -1,
"filename": "pandas_gbq-0.27.0-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "004789a9ecf1641c5f79d0b269b96945",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": ">=3.8",
"size": 37630,
"upload_time": "2025-02-06T18:55:04",
"upload_time_iso_8601": "2025-02-06T18:55:04.898823Z",
"url": "https://files.pythonhosted.org/packages/f3/c2/0108d7c3c60ac20c5c0ecf60248f2b6c7e3ea038420dc44de322812472db/pandas_gbq-0.27.0-py2.py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "bb5602f90fd919007a3bc07a1407dc159383412b165cd4f98f85f318e063fcb1",
"md5": "fade7cb3a55a28e5ad2a725ff9e93d49",
"sha256": "6c19b1d84bc43ba8c54e30b9fc7c120755b5b3cf6c0c0f46fdef09bc244f3222"
},
"downloads": -1,
"filename": "pandas_gbq-0.27.0.tar.gz",
"has_sig": false,
"md5_digest": "fade7cb3a55a28e5ad2a725ff9e93d49",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.8",
"size": 63563,
"upload_time": "2025-02-06T18:55:07",
"upload_time_iso_8601": "2025-02-06T18:55:07.102483Z",
"url": "https://files.pythonhosted.org/packages/bb/56/02f90fd919007a3bc07a1407dc159383412b165cd4f98f85f318e063fcb1/pandas_gbq-0.27.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-02-06 18:55:07",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "googleapis",
"github_project": "python-bigquery-pandas",
"travis_ci": false,
"coveralls": true,
"github_actions": true,
"requirements": [
{
"name": "pandas",
"specs": []
},
{
"name": "google-auth",
"specs": []
},
{
"name": "google-auth-oauthlib",
"specs": []
},
{
"name": "google-cloud-bigquery",
"specs": []
},
{
"name": "tqdm",
"specs": []
}
],
"lcname": "pandas-gbq"
}
JSON
