Samples for a guide for migrating from pandas-gbq to google-cloud-bigquery
For detailed documentation that includes this code sample, see the following:
To authenticate to BigQuery, set up Application Default Credentials. For more information, see Set up authentication for a local development environment.
import pandas sql = """ SELECT name FROM `bigquery-public-data.usa_names.usa_1910_current` WHERE state = 'TX' LIMIT 100 """ # Run a Standard SQL query using the environment's default project df = pandas.read_gbq(sql, dialect="standard") # Run a Standard SQL query with the project set explicitly project_id = "your-project-id" df = pandas.read_gbq(sql, project_id=project_id, dialect="standard")
To search and filter code samples for other Google Cloud products, see the Google Cloud sample browser.