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