application_vnd.jupyter.stderr_output_1.png
from bq_helper import BigQueryHelper

import pandas as pd

bq_assistant = BigQueryHelper('patents-public-data', 'worldbank_wdi')
bq_assistant.list_tables()

bq_assistant.table_schema('wdi_2016')
import pandas as pd
pd.get_option('max_colwidth')
pd.set_option('max_colwidth', 500)

query1 = '\nSELECT  year, country_code,country_name, indicator_code, indicator_name, indicator_value\nFROM  `patents-public-data.worldbank_wdi.wdi_2016`\nwhere country_code  in ("GRC", "GBR", "FRA", "ITA", "BEL", "CHN","CYP","DEU","EMU","MKD","PRT","TUR","USA", "DNK")\n     and year>=2014 \n     and indicator_code not like ("per_%") \n     and indicator_code not like ("DC.DAC.%") \n     and indicator_code not like ("DT.%") \nORDER BY year DESC, indicator_code\n-- LIMIT  200;\n        '

bq_assistant.estimate_query_size(query1)