Download query results to DataFrame

Stay organized with collections Save and categorize content based on your preferences.

Get query results as 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()

sql = """
    SELECT name, SUM(number) as count
    FROM `bigquery-public-data.usa_names.usa_1910_current`
    GROUP BY name
    ORDER BY count DESC
    LIMIT 10

df = client.query(sql).to_dataframe()

What's next

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