Read local JSON file with Python

Question

I want to read a JSON file with Python :

Here is part of my JSON file :

{ "Jointure":[ { "IDJointure":1, "societe":"S.R.T.K", "date":"2019/01/01", "heure":"05:47:00"}, { "IDJointure":2, "societe":"S.R.T.K", "date":"2019/01/01", "heure":"05:50:00"}]}

This is the code :

import json

data  = json.loads('Data2019.json')
for i in data['Jointure']:
   print(i)

But, here is the error that was displayed

Traceback (most recent call last):
  File "C:\Users\HP\Desktop\readJSON.py", line 4, in <module>
    data  = json.loads('Data2019.json')
  File "C:\Users\HP\AppData\Local\Programs\Python\Python38\lib\json\__init__.py", line 357, in loads
    return _default_decoder.decode(s)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python38\lib\json\decoder.py", line 337, in decode
    obj, end = self.raw_decode(s, idx=_w(s, 0).end())
  File "C:\Users\HP\AppData\Local\Programs\Python\Python38\lib\json\decoder.py", line 355, in raw_decode
    raise JSONDecodeError("Expecting value", s, err.value) from None
json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)
>>>

open the file, read it in as a string, perform json.loads() on that string? As per the answers and some reading into the documentation, json.load() will allow for a file-like object and appears to be a better solution — plum 0
– plum 0, Commented Jul 9, 2020 at 15:44
here is a similar question : stackoverflow.com/questions/20199126/reading-json-from-a-file — cyboashu
– cyboashu, Commented Jul 9, 2020 at 15:45

John Gordon · Accepted Answer · 2020-07-09 15:45:01Z

35

json.loads() expects the json data to already be a string -- so it's trying to interpret the filename Data2019.json as actual json data.

Open the file, and then pass the file object to json.load():

with open('Data2019.json') as fp:
    data = json.load(fp)

answered Jul 9, 2020 at 15:45

John Gordon

33.8k9 gold badges48 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dharman · Accepted Answer · 2020-07-10 22:13:54Z

4

don't read the file directly. Open the file it's only the contents of the file that works with the json module. Try this:

import json

with open('path_to_file/person.json') as f:
  data = json.load(f)

edited Jul 10, 2020 at 22:13

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Jul 9, 2020 at 15:54

ad stefnum

986 bronze badges

Comments

Ashraf Beshtawi · Accepted Answer · 2020-07-09 15:43:30Z

-9

Try pandas

import pandas as pd
patients_df = pd.read_json('E:/datasets/patients.json')
patients_df.head()

answered Jul 9, 2020 at 15:43

Ashraf Beshtawi

205 bronze badges

1 Comment

user13776247 Over a year ago

No need to import a library for a simple bug fix.

Collectives™ on Stack Overflow

Read local JSON file with Python

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related