Skip to content
Advertisement

Unable to import json file in spyder python with JSONDecodeError: Extra data

I’m new to python, I used the below code in spyder platform to parse the json file but it reflects an error.

import json

with open('D:/Py_Scrach/used_car_prices1.json') as f:
    data = json.load(f)
    print(data)

Error:

runfile('C:/Users/sathishkumar.m/.spyder-py3/temp.py', wdir='C:/Users/sathishkumar.m/.spyder-py3')
Traceback (most recent call last):

  File "C:Userssathishkumar.m.spyder-py3temp.py", line 10, in <module>
    data = json.load(f)

  File "C:ProgramDataAnaconda3libjson__init__.py", line 293, in load
    return loads(fp.read(),

  File "C:ProgramDataAnaconda3libjson__init__.py", line 346, in loads
    return _default_decoder.decode(s)

  File "C:ProgramDataAnaconda3libjsondecoder.py", line 340, in decode
    raise JSONDecodeError("Extra data", s, end)

JSONDecodeError: Extra data

Advertisement

Answer

df1 = pd.read_json(“D:/Py_Scrach/used_car_prices1.json”,lines=True)

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement