How to filter multiple JSON data with Python?

Question

I'm having some hard time filtering multiple json datas, I need to know the type of each data and if the type corresponds to a fruit then print the element's fields key, see python example comments for a better explanation.

Here's what the JSON looks like :

#json.items()

{
  'type': 'apple', 
  'fields': {
    'protein': '18g', 
    'glucide': '3%', 
   }
},  
{
  'type': 'banana', 
  'fields': {
    'protein': '22g', 
    'glucide': '8%', 
  }
},

Here's what I tried to do :

for key, value in json.items(): #access json dict.
    if key == 'type':           #access 'type' key
        if value == 'apple':        #check the fruit
            if key == 'fields':        #ERROR !!! Now I need to access the 'fields' key datas of this same fruit. !!!
                print('What a good fruit, be careful on quantity!')
                print('more :' + value['protein'] + ', ' + value['glucid'])

        if value == 'banana':    #if not apple check for bananas
            print('One banana each two days keeps you healthy !')
            print('more:' + value['protein'] + ', ' + value['glucid'])

Is there a way I can achieve this ?

If what you posted is your entire json, then you have a list of dicts, not just a dict. You need 2 loops. — cs95
– cs95, Commented Jul 23, 2017 at 21:13
@cᴏʟᴅsᴘᴇᴇᴅ What I posted doesn't look anything like my json because it has too much datas, this one is simplified so it's more understandable, but the number of 'fruit' vary — Horai Nuri
– Horai Nuri, Commented Jul 23, 2017 at 21:14
@KlausD. Yeah I saw that, that was the reason why I was asking the question — Horai Nuri
– Horai Nuri, Commented Jul 23, 2017 at 21:40

cs95 · Accepted Answer · 2017-07-23 21:18:07Z

1

What you have seems to be a list of dicts.

You then check if keys type and fields exist in the dictionary before checking their value, like this:

for d in data: # d is a dict
    if 'type' in d and 'fields' in d:
        if d['type'] == 'apple':
            ... # some print statements

        elif d['type'] == 'banana':
            ... # some more print statements

answered Jul 23, 2017 at 21:18

cs95

406k106 gold badges744 silver badges797 bronze badges

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

3 Comments

Horai Nuri Over a year ago

This works ! For usage purpose is it possible to not specify each key in the if statement and loop for all the existing keys ?

cs95 Over a year ago

@Lindow If you want to print unique statements for each item, I don't believe it is possible.

cs95 Over a year ago

@Lindow If you have a common print statement and nothing else, you can drop the ifs and just print something like print("{}s have {} of protein and {} glucide".format(d['type'], d['fields']['protein'], d['fields']['glucide']))

Nenya Edjah · Accepted Answer · 2017-07-23 21:29:23Z

0

Based on your representation of the JSON, it appears that is actually a list, not a dictionary. So in order to iterate through it, you could try something like this:

for item in json:
    fields = item['fields']
    if item['type'] == 'banana':
        print('Bananas have {} of protein and {} glucide'.format(fields['protein'], fields['glucide']))
    elif item['type'] == 'apple':
        print('Apples have {} of protein and {} glucide'.format(fields['protein'], fields['glucide']))

answered Jul 23, 2017 at 21:29

Nenya Edjah

111 silver badge2 bronze badges

Collectives™ on Stack Overflow

How to filter multiple JSON data with Python?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related