Google_trends.py

import pandas as pd                        
from pytrends.request import TrendReq

pytrend = TrendReq()

#for multiple keywords in English
list_of_keywords=['champagne','cognac','wine','whisky','vodka']

#for multiple countries
list_of_regions=['AT', 'BE', 'BG', 'DE', 'DK', 'EE', 'GB', 'GR', 'HU', 'HR']

#Create tuples of (keyword, country). 
zip_list = [(i, j) for i in list_of_keywords for j in list_of_regions]

data=pd.DataFrame()

for i,j in zip_list:
    pytrend.build_payload(kw_list=[i],
                           timeframe='2018-01-01 2020-04-29',
                            geo=j)
                           
    df = pytrend.interest_over_time()
    df['region']=j
    df['keyword']=i
    df.reset_index(inplace=True)
    df.columns=['date','value','isPartial','region','keyword']
    data=pd.concat([data,df],ignore_index=True)