Analyze some Data

I need a code in Python, that from a google takeout zip file (you can test it on your own, downloading it from google takeout), from the "searches" folder takes out all the json files to create first a csv file called [login to view URL] (| separator) with 2 columns: timestampUsStart|query_text Then creates a second csv file called [login to view URL](| separator) with 3 columns: timestampMsStart|query_text|Category The category must be created using Google Trends api autocomplete feature "[login to view URL]" The category can be appended directly to the json files or can be appended to the csv file or can be appended wit R using httr, whatever is simpler If there is a search with more than one timestamp there must be one record/row for each timestamp with the same query_text. If google trends api gives more than 1 category, categories It should be a Python file that can be run and delivers 2 csv files with te required columns. References for creating categories: [login to view URL] [login to view URL] [login to view URL] [login to view URL]