# python – Reading JSON from a file?

## The Question :

347 people think this question is useful

I am getting a bit of headache just because a simple looking, easy statement is throwing some errors in my face.

I have a json file called strings.json like this:

"strings": [{"-name": "city", "#text": "City"}, {"-name": "phone", "#text": "Phone"}, ...,



I want to read the json file, just that for now. I have these statements which I found out, but it’s not working:

import json
from pprint import pprint

with open('strings.json') as json_data:
json_data.close()
pprint(d)



Traceback (most recent call last):
File "/home/.../android/values/manipulate_json.py", line 5, in <module>
File "/usr/lib/python2.7/json/__init__.py", line 326, in loads
return _default_decoder.decode(s)
File "/usr/lib/python2.7/json/decoder.py", line 366, in decode
obj, end = self.raw_decode(s, idx=_w(s, 0).end())
TypeError: expected string or buffer
[Finished in 0.1s with exit code 1]



Edited

Changed from json.loads to json.load

and got this:

Traceback (most recent call last):
File "/home/.../android/values/manipulate_json.py", line 5, in <module>
File "/usr/lib/python2.7/json/__init__.py", line 278, in load
**kw)
File "/usr/lib/python2.7/json/__init__.py", line 326, in loads
return _default_decoder.decode(s)
File "/usr/lib/python2.7/json/decoder.py", line 369, in decode
raise ValueError(errmsg("Extra data", s, end, len(s)))
ValueError: Extra data: line 829 column 1 - line 829 column 2 (char 18476 - 18477)
[Finished in 0.1s with exit code 1]


• Are you sure that the file contains valid JSON?
• possible duplicate of Parsing values from a JSON file in Python
• Your file is an invalid json format. Change it to: {"strings": [{"-name": "city", "#text": "City"}, {"-name": "phone", "#text": "Phone"}, ..., {"-name": "address", "#text": "Address"}]}

586 people think this answer is useful

The json.load() method (without “s” in “load”) can read a file directly:

import json

with open('strings.json') as f:
print(d)



You were using the json.loads() method, which is used for string arguments only.

Edit: The new message is a totally different problem. In that case, there is some invalid json in that file. For that, I would recommend running the file through a json validator.

There are also solutions for fixing json like for example How do I automatically fix an invalid JSON string?.

115 people think this answer is useful

Here is a copy of code which works fine for me

import json

with open("test.json") as json_file:
print(json_data)



with the data

{
"a": [1,3,"asdf",true],
"b": {
"Hello": "world"
}
}



you may want to wrap your json.load line with a try catch because invalid JSON will cause a stacktrace error message.

41 people think this answer is useful

The problem is using with statement:

with open('strings.json') as json_data:
pprint(d)



The file is going to be implicitly closed already. There is no need to call json_data.close() again.

27 people think this answer is useful

In python 3, we can use below method.

Read from file and convert to JSON

import json
from pprint import pprint

# Considering "json_list.json" is a json file

with open('json_list.json') as fd:
pprint(json_data)



with statement automatically close the opened file descriptor.

String to JSON

import json
from pprint import pprint

json_data = json.loads('{"name" : "myName", "age":24}')
pprint(json_data)



3 people think this answer is useful

To add on this, today you are able to use pandas to import json:
https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_json.html You may want to do a careful use of the orient parameter.

2 people think this answer is useful

You can use pandas library to read the JSON file.

import pandas as pd
print(df)



0 people think this answer is useful

This works for me.

json.load() accepts file object, parses the JSON data, populates a Python dictionary with the data and returns it back to you.

Suppose JSON file is like this:

{
"emp_details":[
{
"emp_name":"John",
"emp_emailId":"john@gmail.com"
},
{
}
]
}


import json

# Opening JSON file
f = open('data.json',)

# returns JSON object as
# a dictionary

# Iterating through the json
# list
for i in data['emp_details']:
print(i)

# Closing file
f.close()

#Output:
{'emp_name':'John','emp_emailId':'john@gmail.com'}