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

Answer 1

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)

Answer 2

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)

Answer 3

Try pandas

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