Tutorial by Examples

In [1]: import pandas as pd In order to run a query in BigQuery you need to have your own BigQuery project. We can request some public sample data: In [2]: data = pd.read_gbq('''SELECT title, id, num_characters ...: FROM [publicdata:samples.wikipedia] ...: ...

If you have created service account and have private key json file for it, you can use this file to authenticate with pandas In [5]: pd.read_gbq('''SELECT corpus, sum(word_count) words FROM [bigquery-public-data:samples.shakespeare] GROUP BY co...