Trying to get data from JSON file in Python

Question

I have a JSON file that looks like the following (not the whole file)

"route-information" : [
{
    "attributes" : {"xmlns" : "http://xml.juniper.net"}, 
    "route-table" : [
    {
        "comment" : "keepalive", 
        "table-name" : [
        {
            "data" : "inet"
        }
        ], 
        "destination-count" : [
        {
            "data" : "24324"
        }
        ], 
        "total-route-count" : [
        {
            "data" : "47432"
        }
        ], 
        "active-route-count" : [
        {
            "data" : "43252"
        }
        ], 
        "holddown-route-count" : [
        {
            "data" : "0"
        }
        ], 
        "hidden-route-count" : [
        {
            "data" : "1"
        }
        ],

I am trying to access the 'comment' part by using python. So far I have this:

import json

# read file
with open('route-table.json') as file:
    data = json.load(file)

print(data["route-information"]["route-table"]["comment"])

Whenever I run this part I get the following error and I can't seem to fix it.

Traceback (most recent call last):
File "json_test.py", line 7, in <module>
print(data["route-information"]["route-table"]["comment"])
TypeError: list indices must be integers or slices, not str

Does this answer your question? Reading JSON from a file?

Innat
– Innat

2020-10-27 14:39:17 +00:00
Commented Oct 27, 2020 at 14:39 — Innat
– Innat, Commented Oct 27, 2020 at 14:39

Djaouad · Accepted Answer · 2020-10-27 10:46:00Z

2

data["route-information"] is a list, so you can do data["route-information"][0] to access the dict inside, same with data["route-information"][0]["route-table"]:

print(data["route-information"][0]["route-table"][0]["comment"])

If you intend to use data later and are okay with changing it's structure, you can replace the lists with their first elements (assuming they only have one element) so that you won't have to use the [0] notation every time you need to access the dicts:

data["route-information"] = data["route-information"][0]
data["route-information"]["route-table"] = data["route-information"]["route-table"][0]

print(data["route-information"]["route-table"]["comment"])

edited Oct 27, 2020 at 10:46

answered Oct 27, 2020 at 10:30

Djaouad

22.8k4 gold badges37 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Innat · Accepted Answer · 2020-10-27 10:39:16Z

0

MrGeek is correct. Just to add more info

[] are for JSON arrays, which are called list in Python
{} are for JSON objects, which are called dict in Python

To get the value we do as follows:

data["route-information"][0]["route-table"][0]["comment"]
data["attributes"]["xmlns"]

answered Oct 27, 2020 at 10:39

Innat

17.3k6 gold badges60 silver badges115 bronze badges

Collectives™ on Stack Overflow

Trying to get data from JSON file in Python

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related