Brave Search

stackoverflow.com › questions › 20199126 › reading-json-from-a-file

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

import json

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

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

The error you get with json.loads is a totally different problem. In that case, there is some invalid JSON content 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?.

Answer from ubomb on Stack Overflow

Python.org

discuss.python.org › core development

Vote: New function for reading JSON from path - Core Development - Discussions on Python.org

March 10, 2021 - We have discussed about new function in the json module, but we didn’t make decision about its naming. Previous discussion: Mailman 3 A shortcut to load a JSON file into a dict : json.loadf - Python-ideas - python.org Issue: Issue 43457: Include simple file loading and saving functions in ...

Stack Overflow

stackoverflow.com › questions › 20199126 › reading-json-from-a-file

python - Reading JSON from a file - Stack Overflow

Top answer

1 of 7

1084

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

import json

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

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

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

2 of 7

135

Here is a copy of code which works fine for me,

import json

with open("test.json") as json_file:
    json_data = json.load(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.

Discussions

Appending JSON to same file

Hi, I need to make that within each request from api new dict will be appended to json. Now I have that each time data overwritten, but I need to append to existing file. How to achieve this? Code:(import requestsimport jsonimport timeimport csvimport pandas start=2 - Pastebin.com) More on discuss.python.org

discuss.python.org

January 5, 2023

Python newbie... Creating multiple json files from a single json file based on *some* value...

It only contains the last item You aren't collating your data in python. You have a list of dictionaries, and overwrite (or append) the file for each dictionary in the list, based on TeamID. But what you *want* is a dict of lists-of-dictionaries (probably), with each list-of-dictionaries each having the same TeamID entries: import json from collections import defaultdict jsonFilePath="new.json" with open(jsonFilePath, encoding='utf-8') as jsonFile: jsonData=json.load(jsonFile) # Collate dictionaries with the same TeamID into new lists. collated_teamids = defaultdict(list) for team in jsonData: # for each team, add to the list of team data collated_teamids[team['TeamID']].append(team) for team_id, teams in collated_teamids.items(): filename = "teams/" + str(team_id) + ".json" print(filename) with open(filename, 'w', encoding='utf-8') as outputFile: outputFile.write(json.dumps(teams, ensure_ascii=False, indent=2)) Note that I'm using a defaultdict(list) here to make it easy to just append each new 'team' dictionary (what you called row). But a regular dict is almost as easy, if you use the Python dict.get or dict.setdefault methods (or just test for the key first and create a new list). You definitely don't want to be appending to json files; they are structured data, and can't reliably be concatenated. Assemble the data first, and then write it all at once (as above). I don't make an effort to sort each team file by player ID, but that could be done by sorting the 'teams' variable that is retrieved by iterating over the collated_teamids. More on reddit.com

r/learnpython

January 5, 2019

Looking for a PyQt5 example to put a Json file into a treeview model item

First off I'd recommend posting in r/learnpython as you might get a few more replies over there. Second, you may consider breaking the problem in two. The are numerous ways to load Jason data into Python, with loading to a dict most likely the easiest. Thus you may find it easier to focus on how to translate the JSON data structure into your tree view items as the loading of the JSON shouldn't be difficult nor does it directly relate to PyQt. More on reddit.com

r/Python

September 7, 2016

One Horse Sized JSON file or 1000 Duck Sized JSON files.

Just put it in a database like SQLite. More on reddit.com

r/Python

November 12, 2020

Videos