Google BigQuery connector for pandas


Keywords
bigquery, data, pandas
License
BSD-3-Clause
Install
pip install pandas-gbq==0.22.0

Documentation

pandas-gbq

preview pypi versions

pandas-gbq is a package providing an interface to the Google BigQuery API from pandas.

Installation

Install latest release version via conda

$ conda install pandas-gbq --channel conda-forge

Install latest release version via pip

$ pip install pandas-gbq

Install latest development version

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

Usage

Perform a query

import pandas_gbq

result_dataframe = pandas_gbq.read_gbq("SELECT column FROM dataset.table WHERE value = 'something'")

Upload a dataframe

import pandas_gbq

pandas_gbq.to_gbq(dataframe, "dataset.table")

More samples

See the pandas-gbq documentation for more details.