Data Frames > pandas-gbq

pandas Google Big Query. <img height="20" src="img/pandas_big.png" alt="pandas compatible">

Package 490 stars Archived GitHub

:NOTE: This github repository is archived. The repository contents and history have moved to google-cloud-python_.

.. _google-cloud-python: https://github.com/googleapis/google-cloud-python/tree/main/packages/pandas-gbq

pandas-gbq

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.

Back to Data Science