Access array in json file in python

Question

Here is a question from an absolute beginner python developer. Here is the challenge I have :)

not being able to access the "status" in this json file:

[{
        "id": 0,
        "sellerId": "HHH",
        "lat": 90.293846,
        "lon": 15.837098,
        "evses": [{
                "id": 0,
                "status": 1,
                "connectors": [{
                        "type": "Hyyyyp",
                        "maxKw": 22
                    }
                ]
            }, {
                "id": 2001,
                "status": 2,
                "connectors": [{
                        "type": "Hyyyyp",
                        "maxKw": 22
                    }
                ]
            }, {
                "id": 2002,
                "status": 1,
                "connectors": [{
                        "type": "Hyyyyp",
                        "maxKw": 22
                    }
                ]
            }, {
                "id": 2003,
                "status": 1,
                "connectors": [{
                        "type": "Hyyyp",
                        "maxKw": 22
                    }
                ]
            }
        ] 

       }, {
            "id": 10001,
            "sellerId": 7705,
            "lat": 12.59962,
            "lon": 40.8767,
            "evses": [{
                    "id": 10001,
                    "status": 1,
                    "connectors": [{
                            "type": "Tyyyyp",
                            "maxKw": 22
                        }
                    ]
                }, {
                    "id": 10002,
                    "status": 2,
                    "connectors": [{
                            "type": "Tyyyyp",
                            "maxKw": 22
                        }
                    ]
                }, {
                    "id": 10003,
                    "status": 2,
                    "connectors": [{
                            "type": "Tyyyyp",
                            "maxKw": 22
                        }
                    ]
                }, {
                    "id": 10004,
                    "status": 2,
                    "connectors": [{
                            "type": "Tyyyyp",
                            "maxKw": 22
                        }
                    ]
                }
            ]
        }, {

for the "id:10001" there are 3 cases which "status: 2". So.. how do I print 3 for id:10001?

I guess I need to have an array for storying the ids itself and another array for storying the number of "status:2" for each id.

Here is my code: firs I do print id:

with open('sample.json') as f:
    data = json.load(f)
    print(id['id'])

Then I think I need to access array evses: So here is what I do:

print(data['evses'][0]['id']['status'])

But I get error on this line.

data['evses'][0] is a dictionary, data['evses'][0]['id'] is 10001, it has no 'status' key — matszwecja
– matszwecja, Commented Mar 2, 2022 at 10:03
Your example won't work because status is not a key of id. dataID = data['evses'][0]['id'] dataStatus = data['evses'][0]['status'] — SimonT
– SimonT, Commented Mar 2, 2022 at 10:04
so how do I access the status? is not it through evses array? — user2758510
– user2758510, Commented Mar 2, 2022 at 10:09
Please show more of the data so we can show you how to get at those values — jackal
– jackal, Commented Mar 2, 2022 at 10:14
id 10001 has a status of 1. ids 10002, 10003 and 10004 have statuses of 2. So why would you want 3 for id 10001? Maybe you just want to know how many ids have a particular status value? — jackal
– jackal, Commented Mar 2, 2022 at 10:27

jackal · Accepted Answer · 2022-04-27 13:46:29Z

1

Following clarification from OP, this would be my proposed solution:

import json
from collections import Counter

def get_status_2_for_id(filename):
    count = Counter()
    with open(filename) as jdata:
        for e in json.load(jdata):
            if (id_ := e.get('id')) is not None:
                for f in e.get('evses', []):
                    if f.get('status') == 2:
                        count[id_] += 1
    return count.items()

for id_, count in get_status_2_for_id('sample.json'):
    print(f'id={id_} count={count}')

Output:

id=0 count=1
id=10001 count=3

edited Apr 27, 2022 at 13:46

answered Mar 2, 2022 at 10:58

jackal

29.1k3 gold badges9 silver badges27 bronze badges

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

4 Comments

user2758510 Over a year ago

It does not print out the output for me!

jackal Over a year ago

@user2758510 I created sample.json from the data you've shown and it works perfectly

user2758510 Over a year ago

are you sure that you got "output" using this code? It does not work for me!

jackal Over a year ago

If you're not getting any output then that's because your data doesn't match that shown in your question

Kris · Accepted Answer · 2022-03-02 10:13:30Z

1

Let's say you take a single JSON record of your data which is below

record = {
    "id": 10001,
    "sellerId": 7705,
    "lat": 12.59962,
    "lon": 40.8767,
    "evses": [{
        "id": 10001,
        "status": 1,
        "connectors": [{
            "type": "Tyyyyp",
            "maxKw": 22
        }
        ]
    }, {
        "id": 10002,
        "status": 2,
        "connectors": [{
            "type": "Tyyyyp",
            "maxKw": 22
        }
        ]
    }, {
        "id": 10003,
        "status": 2,
        "connectors": [{
            "type": "Tyyyyp",
            "maxKw": 22
        }
        ]
    }, {
        "id": 10004,
        "status": 2,
        "connectors": [{
            "type": "Tyyyyp",
            "maxKw": 22
        }
        ]
    }
    ]
}

From this data record above, if you want to count the number of occurences of a particular status you can do something like below

status_2_count = [stp["status"] for stp in record["evses"]].count(2)

We just generate a list of all statuses in the record["evses"] and count the occurence of a particualr status.

You can make this a function, and repeat it for other records in the file.

answered Mar 2, 2022 at 10:13

Kris

8,8984 gold badges45 silver badges71 bronze badges

1 Comment

user2758510 Over a year ago

Tried it but did not work. I got this error: status_2_count = [stp["status"] for stp in id["evses"]].count(2) TypeError: 'builtin_function_or_method' object is not subscriptable

PW1990 · Accepted Answer · 2022-03-02 11:52:28Z

1

You can try this if its stored as a variable:

for status in json_data["evses"]:
    print('status = ', status['status'])

And this if it's stored in a file:

import json

status_pts = 1

with open('file.json') as json_file:
    data = json.loads(json_file.read())
    ls = data[0]['evses']
    for s in ls:
        if s['status'] == status_pts:
            print('id:', s['id'], "number of status =", status_pts)

Also, your json data wasn't closed off, the very last line has:

}, {

It needed:

}]

edited Mar 2, 2022 at 11:52

answered Mar 2, 2022 at 10:12

PW1990

4892 silver badges11 bronze badges

7 Comments

user2758510 Over a year ago

I get "TypeError" error in the for loop line

PW1990 Over a year ago

Is the data assigned to a variable? I put your json data into a variable called json_data.

user2758510 Over a year ago

The json file starts exactly with what I have in my question which is [{ is there anything missing you think?

user2758510 Over a year ago

Then how do I iterate through the ids and print out the number of status that are equal to 2 for each id? for example I would like to print out something like this: id = 0 , 1(number of status = 2) and id:10001 , 3(number of status = 2)

PW1990 Over a year ago

I'm not real sure what you're after there. I have tried understanding your new question and have edited my original. If my answer helped your original question, please mark it as the answer.

|

Collectives™ on Stack Overflow

Access array in json file in python

3 Answers 3

4 Comments

1 Comment

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

1 Comment

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related