text_plain_output_2.png application_vnd.jupyter.stderr_output_1.png
import pandas as pd
from google.cloud import bigquery
client = bigquery.Client()

dataset_ref = client.dataset('san_francisco_bikeshare', project='bigquery-public-data')
dataset = client.get_dataset(dataset_ref)

tables = list(client.list_tables(dataset))

table_ref_regions = dataset_ref.table('bikeshare_regions')
table_ref_station_info = dataset_ref.table('bikeshare_station_info')
table_ref_station_status = dataset_ref.table('bikeshare_station_status')
table_ref_trips = dataset_ref.table('bikeshare_trips')
bikeshare_regions = client.get_table(table_ref_regions)
bikeshare_station_info = client.get_table(table_ref_station_info)
bikeshare_station_status = client.get_table(table_ref_station_status)
bikeshare_trips = client.get_table(table_ref_trips)

client.list_rows(bikeshare_trips, max_results=5).to_dataframe()