Colab includes the
google.colab.data_table package that can be used to display large pandas dataframes as an interactive data table.
It can be enabled with:
If you would prefer to return to the classic Pandas dataframe display, you can disable this by running:
google.cloud.bigquery library also includes a magic command which runs a query and either displays the result or saves it to a variable as a
Full dataset has 114420316 rows
pandas-gbq library is a community led project by the pandas community. It covers basic functionality, such as writing a DataFrame to BigQuery and running a query, but as a third-party library it may not handle all BigQuery features or use cases.