Mar-21-2023, 05:37 PM
try this
import json import datetime import pandas as pd list=[] # combine json files=['1.json', '2.json', '3.json', '4.json', '5.json'] result = [] for f in files: with open(f, "r") as infile: result.append(json.load(infile)) with open("12.json", "w") as outfile: json.dump(result, outfile) # make xlsx with open("12.json", encoding="UTF-8") as f: jsondata = json.load(f) for data in jsondata: if "items" in data: for matches in data["items"]: if "Alternative" in matches["champName"]: continue list.append([matches["champName"],datetime.datetime.fromtimestamp(matches["dateStart"]),matches["opp1"],matches["opp2"],matches["score"]]) df=pd.DataFrame(list) df.to_excel("output.xlsx") print("Saved.")