Python nested JSON for loops

snowman81 · 03-14-2022, 05:54 AM

I have a JSON file that is structured like so

Code:

x.data[0].leaders[0].type

Where I need to loop through "data" and "leaders" to find every instance of "type". I have the following but it's telling me string indices must be integers. I thought I fixed that by putting the "[0]" by the arrays but it's still giving me the message. I feel like this is either a really simple fix or I completely screwed up.

Code:

x = json.loads(JSON)
for a in x["data"][0]:
        for b in a["leaders"][0]:
            print (b["type"])

boughtonp · 03-14-2022, 08:47 AM

Don't describe errors and data - provide the exact error message and a concise example that produces that error.

A common debugging technique in these sorts of situation is to make print progressively more general until you find where your assumptions fail - so doing "print(b)" and examine the output carefully. Also, often only some parts of the data are different - you can use try/except to determine that.

pan64 · 03-14-2022, 08:54 AM

yes, you can insert a lot of debugging messages, like:

Code:

x = json.loads(JSON)
print(x)
print(x["data"])
print(x["data"][0])
for a in x["data"][0]:
    print(a)
    print(a["leaders"])
    print(a["leaders"][0])
    for b in a["leaders"][0]:
        print(b)
        print (b["type"])

and you will see which part is wrong and what should be modified.
"string indices must be integers" means you use strings as indices instead of integers.

As it was mentioned you can use try/except to catch errors (if you wish). And please post the exact error message, the real code and real json example (you can remove/replace sensitive info obviously)

dugan · 03-14-2022, 11:10 AM

Post enough of the JSON to make your first code block work.