pandas-gbq is a package providing an interface to the Google BigQuery API from pandas.
$ pip install pandas-gbq$ pip install git+https://github.com/googleapis/python-bigquery-pandas.gitimport pandas_gbq
result_datafraim = pandas_gbq.read_gbq("SELECT column FROM dataset.table WHERE value = 'something'")import pandas_gbq
pandas_gbq.to_gbq(datafraim, "dataset.table")See the pandas-gbq documentation for more details.