Download table data to DataFrame

Download table data to a Pandas DataFrame.

Code sample


Before trying this sample, follow the Python setup instructions in the BigQuery quickstart using client libraries. For more information, see the BigQuery Python API reference documentation.

# from import bigquery
# client = bigquery.Client()
project = "bigquery-public-data"
dataset_id = "samples"

dataset_ref = bigquery.DatasetReference(project, dataset_id)
table_ref = dataset_ref.table("shakespeare")
table = client.get_table(table_ref)

df = client.list_rows(table).to_dataframe()

What's next

To search and filter code samples for other Google Cloud products, see the Google Cloud sample browser.