json decoding error - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: Python Coding (https://python-forum.io/forum-7.html) +--- Forum: General Coding Help (https://python-forum.io/forum-8.html) +--- Thread: json decoding error (/thread-39633.html) Pages:
1
2
|
json decoding error - deneme2 - Mar-19-2023 Hello my friends, Wish you al have a restful sunday. I want to use one json file in python with a following code. import json import datetime import pandas as pd list=[] with open("12.json", encoding="UTF-8") as f: jsondata = json.load(f) for matches in jsondata["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.")when I run it, it gives such error. How can I fix that?Thank you. RE: json decoding error - rob101 - Mar-19-2023 Not that I've done so much coding with JSON files, but on the face of this, the first question I have: are you sure that the JSON file is valid? Maybe you could post it up? Or is it HUGE? RE: json decoding error - deneme2 - Mar-21-2023 @rob101 thanks a lot for your quick response pal. Regarding my some healths problems in my waist, i couldn't use pc since sunday and still not recovered. Yeah you are correct my friend. I wanted to merge five singles json files manually bcuz of my insufficient programming knowledge. and merged it wrongly. Bcuz as you guessed, I run the code per single json file and it executed without any errors. I wish you could help me to merge "items" object of the single json files linked in the below. 1.json 2.json 3.json 4.json 5.json 12.json (merged 1.2.3.4.5.json) RE: json decoding error - Axel_Erfurt - Mar-21-2023 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.") RE: json decoding error - deneme2 - Mar-22-2023 Hey @Axel_Erfurt, Thanks a lot for your interest. I deleted existing 12.json in the folder and Run your code, but it gave following error.
RE: json decoding error - Axel_Erfurt - Mar-22-2023 I have Linux (LMDE5), it worked there with your 5 files. Maybe someone who uses Windows can help. RE: json decoding error - deneme2 - Mar-22-2023 i see Mr. @Axel_Erfurt files=['1.json', '2.json', '3.json', '4.json', '5.json']what about this part? how this part can be edited to merge all *.json files in same directory? RE: json decoding error - Axel_Erfurt - Mar-22-2023 That's only a list of the file names. The problem is at result.append(json.load(infile)) try open with encoding 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", encoding="utf-8") as infile: result.append(json.load(infile)) with open("12.json", "w") as outfile: json.dump(result, outfile, ensure_ascii=False) # 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.") RE: json decoding error - deneme2 - Mar-22-2023 it gave same error (Mar-22-2023, 05:36 PM)Axel_Erfurt Wrote: That's only a list of the file names.i know. I wanted to marge not only five json files, thare are tens of json files in same directory. So I wanted to edit that part too. Anyway. RE: json decoding error - Axel_Erfurt - Mar-22-2023 You can add all the files you need to the list. |