I'm trying to get the average news results of five categories over the last year. In Google trends (https://trends.google.com/trends/explore?geo=US&gprop=news&q=Apples,Bananas,Oranges,Pears,Grapes) I get an average on the left with a bar graph giving Apples: 13, Bananas: 11, Oranges: 4, Pears: 4, Grapes: 9. But when I run this:
pytrend.build_payload(
kw_list=["apples", "bananas", "oranges", "pears", "grapes"], gprop='news', timeframe='today 12-m', geo='US')
df = pytrend.interest_over_time()
interest_over_time_df = pytrend.interest_over_time()
print(interest_over_time_df.head())
This is my output:
apples bananas oranges pears grapes isPartial
date
2020-07-19 0 0 0 0 0 False
2020-07-26 26 0 0 0 0 False
2020-08-02 25 0 0 0 0 False
2020-08-09 0 26 0 0 0 False
2020-08-16 26 26 0 0 0 False
How can I get just the average for each of these across the past year, and store those values?
The average that showing in side window is a straight average of values for each keyword, I don't think Pytrends library will provide that average for now, but you can calculate it by adding this line to your code
print(interest_over_time_df.mean())
Output:
apples 17.076923
bananas 12.942308
oranges 3.519231
pears 1.423077
grapes 8.961538
dtype: float64
Hope this will solve your issue