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.9",
"maintainer_email": null,
"keywords": null,
"author": "pandas-gbq authors",
"author_email": "googleapis-packages@google.com",
"download_url": "https://files.pythonhosted.org/packages/ca/f1/d38e7c03a8055fea816dfc9b697c97b4fecfd6b881072a34945e11972e35/pandas_gbq-0.30.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.30.0",
"project_urls": {
"Homepage": "https://github.com/googleapis/python-bigquery-pandas"
},
"split_keywords": [],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "241038e5d6442ea389a070be7466bff55a8160146d446b33efc59980dbe05906",
"md5": "88ed94c2c5a66ae17891249183203f36",
"sha256": "d9b4454b17aee3c23ef1dfcfd91df6e2b77f1e69e1e4b28467701cd75850664a"
},
"downloads": -1,
"filename": "pandas_gbq-0.30.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "88ed94c2c5a66ae17891249183203f36",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.9",
"size": 41561,
"upload_time": "2025-11-03T18:38:03",
"upload_time_iso_8601": "2025-11-03T18:38:03.811479Z",
"url": "https://files.pythonhosted.org/packages/24/10/38e5d6442ea389a070be7466bff55a8160146d446b33efc59980dbe05906/pandas_gbq-0.30.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "caf1d38e7c03a8055fea816dfc9b697c97b4fecfd6b881072a34945e11972e35",
"md5": "e959c5a75fc20eaf70ac6f3d50863759",
"sha256": "8fe811786e4ad2e0d4608e897534207d9fbe768ab3168f766a99f0cb4cd5ed20"
},
"downloads": -1,
"filename": "pandas_gbq-0.30.0.tar.gz",
"has_sig": false,
"md5_digest": "e959c5a75fc20eaf70ac6f3d50863759",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.9",
"size": 66582,
"upload_time": "2025-11-03T18:38:05",
"upload_time_iso_8601": "2025-11-03T18:38:05.145086Z",
"url": "https://files.pythonhosted.org/packages/ca/f1/d38e7c03a8055fea816dfc9b697c97b4fecfd6b881072a34945e11972e35/pandas_gbq-0.30.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-11-03 18:38:05",
"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
