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 conda
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.. code-block:: shell
$ conda install pandas-gbq --channel conda-forge
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": "",
"docs_url": null,
"requires_python": ">=3.7",
"maintainer_email": "",
"keywords": "",
"author": "pandas-gbq authors",
"author_email": "googleapis-packages@google.com",
"download_url": "https://files.pythonhosted.org/packages/e5/ac/45f0705c29bdd9fecb6a4ab5fc8798cbcfc02ccf38eae1dff1b6f8d02cdf/pandas-gbq-0.21.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\n\nInstall latest release version via conda\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\n.. code-block:: shell\n\n $ conda install pandas-gbq --channel conda-forge\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.21.0",
"project_urls": {
"Homepage": "https://github.com/googleapis/python-bigquery-pandas"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "c1ab786aadb136d697b8a8708394fea15db2f95e62f38662724106f5d370aef1",
"md5": "b784aac859ff5cb6264da70b1089fb5f",
"sha256": "1f82db5048e86516d7bafae68a911982c1f2590ea117ad72879cc981b050bf11"
},
"downloads": -1,
"filename": "pandas_gbq-0.21.0-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "b784aac859ff5cb6264da70b1089fb5f",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": ">=3.7",
"size": 26847,
"upload_time": "2024-02-05T16:50:23",
"upload_time_iso_8601": "2024-02-05T16:50:23.915753Z",
"url": "https://files.pythonhosted.org/packages/c1/ab/786aadb136d697b8a8708394fea15db2f95e62f38662724106f5d370aef1/pandas_gbq-0.21.0-py2.py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "e5ac45f0705c29bdd9fecb6a4ab5fc8798cbcfc02ccf38eae1dff1b6f8d02cdf",
"md5": "2215a5fd6af496aa890ce5d3ca9e094a",
"sha256": "f9c137430d34059f380af6c37781334d0be0a16021a8bdbf2836687e50ab63af"
},
"downloads": -1,
"filename": "pandas-gbq-0.21.0.tar.gz",
"has_sig": false,
"md5_digest": "2215a5fd6af496aa890ce5d3ca9e094a",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.7",
"size": 50187,
"upload_time": "2024-02-05T16:50:27",
"upload_time_iso_8601": "2024-02-05T16:50:27.133911Z",
"url": "https://files.pythonhosted.org/packages/e5/ac/45f0705c29bdd9fecb6a4ab5fc8798cbcfc02ccf38eae1dff1b6f8d02cdf/pandas-gbq-0.21.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-02-05 16:50:27",
"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"
}