Home / Questions / 332901
Accepted
Wiska
Asked: 2020-02-28 11:55:16 +0800 CST 2020-02-28 11:55:16 +0800 CST

Upload a JSON file

  • 772

How do I load an entire JSON file that is written in the form of dictionaries? It is also so that it remains as a graph. The constellations are the largest "group", they have the name, in this case "Donkey Constellation" and it has some stars, the main one and the others that are connected to it.

     "constellations": [
    {
      "name":"Constelación del Burro",
      "stars":[
        {
          "id": 1,
          "label": "Alpha1",
          "linkedTo": [
            {
              "starId": 2,
              "distance": 120
            },
            {
              "starId": 4,
              "distance": 87
            },
            {
              "starId": 5,
              "distance": 101
            }
          ],
          "radius": 0.4,
          "timeToEat": 3,
          "amountOfEnergy": 1,
          "coordenates": {
            "x": 25,
            "y": 34
          },
          "hypergiant": false
        }]
      ]
   ]
python

1 Answers

  1. Best Answer

    The quoted json is missing a brace before the last bracket, so to read the file and convert it we do the following

    import json  #1
with open("c:\miarchivo.json", 'r') as archivo:  #2
    constelaciones = json.loads("{%s}" % archivo.read())  #3
    1. We import json
    2. We open the file in read mode
    3. We wrap the json of the example in braces so that it is valid and we convert it into a dictionary.

    Edit: I forgot about the graph, although I'm not entirely clear what it looks like and what its output would be, we can use pydot for that job.

    import pydot

graph = pydot.Dot(graph_type='graph')

for constelacion in constelaciones["constellations"]:
    for estrella in constelacion["stars"]:
        e_estrella = pydot.Edge(constelacion["name"], estrella["label"])
        graph.add_edge(e_estrella)
        for enlace in estrella["linkedTo"]:
            e_enlace = pydot.Edge(estrella["label"], enlace["starId"])
            graph.add_edge(e_enlace)

graph.write_png('constelaciones.png')

    We go through the dictionary for each constellation, each star is added and for each star its links, we save it in a file in png format.

    This is the graph generated for the cited example donkey constellation

    • 2