json decoding error

[deneme2]

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.

Error:
Traceback (most recent call last):
  File "c:\Users\monst\Downloads\python_stavka\parcali_results\parcali_results-FilterExcel-dateupdate.py", line 8, in <module>
    jsondata = json.load(f)
  File "C:\Users\monst\AppData\Local\Programs\Python\Python310\lib\json\__init__.py", line 293, in load
    return loads(fp.read(),
  File "C:\Users\monst\AppData\Local\Programs\Python\Python310\lib\json\__init__.py", line 346, in loads
    return _default_decoder.decode(s)
  File "C:\Users\monst\AppData\Local\Programs\Python\Python310\lib\json\decoder.py", line 337, in decode
    obj, end = self.raw_decode(s, idx=_w(s, 0).end())
  File "C:\Users\monst\AppData\Local\Programs\Python\Python310\lib\json\decoder.py", line 355, in raw_decode
    raise JSONDecodeError("Expecting value", s, err.value) from None
json.decoder.JSONDecodeError: Expecting value: line 15 column 1 (char 1472190)

How can I fix that?
Thank you.

[rob101]

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?

[deneme2]

@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)

[Axel_Erfurt]

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.")

[deneme2]

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.

Error:
Traceback (most recent call last):
  File "c:\post4_testRun\post6_code.py", line 12, in <module>
    result.append(json.load(infile))
  File "C:\Users\monst\AppData\Local\Programs\Python\Python310\lib\json\__init__.py", line 293, in load
    return loads(fp.read(),
  File "C:\Users\monst\AppData\Local\Programs\Python\Python310\lib\encodings\cp1254.py", line 23, in decode
    return codecs.charmap_decode(input,self.errors,decoding_table)[0]
UnicodeDecodeError: 'charmap' codec can't decode byte 0x90 in position 9680: character maps to <undefined>

[Axel_Erfurt]

I have Linux (LMDE5), it worked there with your 5 files. Maybe someone who uses Windows can help.

[deneme2]

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?

[Axel_Erfurt]

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.")

[deneme2]

it gave same error

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.

[Axel_Erfurt]

You can add all the files you need to the list.