I have data, which look like [["header","row"],["5","16"], ...] In case they are saved in file, they can be easily read by
with open(input_data, 'r') as f:
data = json.load(f)
It should be possible to read them into data straightforwardly but somehow the input string can't be converted to json data = json.loads(x) returns ValueError: No JSON object could be decoded
What am I missing?
The error ValueError tells you that the JSON is not valid. Correct the JSON in the file or the string and it will load properly.
Your code will correctly load in JSON data from a file if input_data is a file name.
json.load() vs json.loads()
Both of these functions will process json.
json.load() takes a file like object.
json.loads() takes a string or unicode object.
JSON file:
[["header","row"],["5","16"]]
This code will correctly read the above JSON from a file:
input_data = 'json_file_name.json'
with open(input_data, 'r') as f:
data = json.load(f)
print(data)
This will process the JSON stored in a string:
json_string = '[["header","row"],["5","16"]]'
print(json.loads(json_string))
json.loads() with the trailing s and not json.load(). If you feel that your string content is well formatted, please update your question to include the exact python code with the string containing the JSON. Possibly there is a formatting issue.json.loads() for the string and get error. The string imho isn't very well formatted json but being in a file, json.load() is able to handle it
f.read()vs. justf–json.load(f.read()). You're currently trying to load the File Object itself rather than the string of JSON from the file on disk.json.load(x)is correct ifxis an file object.json.loads(x)should be used ifxis a string. --- Your code example showsloadbut your error showsloads; which one is it?