As of January 1, 2020 this library no longer supports Python 2 on the latest released version. Library versions released prior to that date will continue to be available. For more information please visit Python 2 support on Google Cloud.

Installation

You can install pandas-gbq with pip or by installing from source.

Pip

To install the latest version of pandas-gbq: from the

$ pip install pandas-gbq -U

This installs pandas-gbq and all common dependencies, including pandas.

Install from Source

$ pip install git+https://github.com/googleapis/python-bigquery-pandas.git

Dependencies

This module requires following additional dependencies:

• pydata-google-auth: Helpers for authentication to Google’s API

• pyarrow: Format for getting data to/from Google BigQuery

• google-auth: authentication and authorization for Google’s API

• google-auth-oauthlib: integration with oauthlib for end-user authentication

• google-cloud-bigquery: Google Cloud client library for BigQuery

• google-cloud-bigquery-storage: Google Cloud client library for BigQuery Storage API

Note

The dependency on google-cloud-bigquery is new in version 0.3.0 of pandas-gbq. Versions less than 0.3.0 required the following dependencies:

• httplib2: HTTP client (no longer required)

• google-api-python-client: Google’s API client (no longer required, replaced by google-cloud-bigquery:)

• google-auth: authentication and authorization for Google’s API

• google-auth-oauthlib: integration with oauthlib for end-user authentication

• google-auth-httplib2: adapter to use httplib2 HTTP client with google-auth (no longer required)