How to query JSON data in python #noobie

Question

Say I have JSON data like so:

{
    "friends": {
        "Charlie": {
            "gender": "female",
            "age": "28"
        },
        "Josh": {
            "gender": "male",
            "age": "22"
        },
        "Annie": {
            "gender": "female",
            "age": "24"
        }
    }
}

What's the best/most pythonic way to "query" all my friend's age?

I understand that I can drill into a specific dataset by calling:

var_holding_json['friends']['Josh']['age']

But I can't grasp how I can go from this to

"get all my friends' age".
"get all my friends' names whose age is > 22"

Thanks for any pointer!

Dekel · Accepted Answer · 2020-04-11 00:03:13Z

3

Assuming you pur the data in data you can use

[data['friends'][x]['age'] for x in data['friends']]

If you want to get only the names of your friends whose age > 22 you can do the following:

[x for x in data['friends'] if data['friends'][x]['age'] > 22]

answered Apr 11, 2020 at 0:03

Dekel

62.9k12 gold badges109 silver badges130 bronze badges

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

2 Comments

Dekel Over a year ago

This is the pythonic way :)

EmPe Ah Over a year ago

Yes, Sensei Miyagi - it is... :D

Sri · Accepted Answer · 2020-04-11 00:02:24Z

2

Here is one solution assuming the json above is stored in a variable named data.

for friend in data["friends"]:
    print(data["friends"][friend]["age"])

for friend in data["friends"]:
    age = int(data["friends"][friend]["age"])
    if (age > 22):
        print(friend)

edited Apr 11, 2020 at 0:02

answered Apr 11, 2020 at 0:00

Sri

2,3382 gold badges20 silver badges27 bronze badges

3 Comments

EmPe Ah Over a year ago

(I've edited a second query into my question while you were already posting your answer. Thanks for your speedy response and pls excuse my "audible".)

EmPe Ah Over a year ago

Thank you so much, @Sri. Your incredibly quick and helpful response is most appreciated - especially since somone was equally quick to downvote my question. :( #sucksbeinganoob

Sri Over a year ago

No worries. Keep trying. Someone else posted a much cleaner solution using list comprehension you might want to check out.

Collectives™ on Stack Overflow

How to query JSON data in python #noobie

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related