Test values inside JSON using Python

Question

I have this JSON in a file:

{"groupcolor":[
    {"user":"group01", "color":"blue"},
    {"user":"group02", "color":"yellow"},
    {"user":"group03", "color":"green"}
]}

and I want to use Python(3) to verify if the content of "user" matches with "color". I've tried:

import json 

with open('groupcolor.json') as f:
    for line in f:
        if f.user == group01 and f.color = blue:
            print("ok!")
        else:
            print ("not ok")

but it obviously isn't the right syntax. most of the information that I found is focused on parsing or adding information, but I haven't found anything about checking the relation between two elements. is a way to do it in Python?

you might want to parse content first: import json; json.loads(f) ... — Ozgur Vatansever
– Ozgur Vatansever, Commented May 7, 2016 at 1:23

Matt Messersmith · Accepted Answer · 2016-05-07 01:37:34Z

1

You definitely have the right idea: just the wrong syntax, as you point out.

As a comment suggests, you need to use json.load() (but not json.loads(), as json.loads() is for a string, not a file). This will rope in the json file as a dictionary.

import json 

with open('groupcolor.json') as f:
    json_dict = json.load(f)
    users = json_dict["groupcolor"]
    for item in users:
        if item["user"] == "group01" and item["color"] == "blue":
            print("ok!")
        else:
            print ("not ok")

answered May 7, 2016 at 1:37

Matt Messersmith

13.9k8 gold badges54 silver badges57 bronze badges

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

Comments

dmmfll · Accepted Answer · 2016-05-07 01:58:05Z

0

Here is one solution:

import json 

with open('groupcolor.json') as f:
    group_color = json.load(f)  # parse json into dict

group_color = group_color["groupcolor"]  # get array out of dict

# create a dictionary where user is group01 and color is blue
search_criteria = dict(zip(("user", "color"), ("group01", "blue")))
for user_data in group_color:
    message = "ok!" if user_data == search_criteria else "not ok"
    print(message)

answered May 7, 2016 at 1:58

dmmfll

2,8642 gold badges38 silver badges43 bronze badges

Collectives™ on Stack Overflow

Test values inside JSON using Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related