how to parse json nested dict in python?

Question

I'm trying to work with json file stored locally. That is formatted as below:

{  
   "all":{  
      "variables":{  
         "items":{  
            "item1":{  
               "one":{  
                  "size":"1"
               },
               "two":{  
                  "size":"2"
               }
            }
         }
      }
   }
}

I'm trying to get the value of the size key using the following code.

with open('path/to/file.json','r') as file:
  data = json.load(file)
itemParse(data["all"]["variables"]["items"]["item1"])

def itemParse(data):
   for i in data:
   # also tried for i in data.iterkeys():
       # data has type dict while i has type unicode
       print i.get('size')
       # also tried print i['size']

got different errors and nothing seems to work. any suggestions?

also, tried using json.loads got error expect string or buffer

Use data[i]['size'] on your print line.

Patrick Laban
– Patrick Laban

2016-05-16 19:26:58 +00:00
Commented May 16, 2016 at 19:26 — Patrick Laban
– Patrick Laban, Commented May 16, 2016 at 19:26

Mauro Baraldi · Accepted Answer · 2016-05-16 19:26:00Z

2

When you iterate over data you are getting the key only. There is 2 ways to solve it.

def itemParse(data):
   for i, j in data.iteritems():
       print j.get('size')

or

def itemParse(data):
   for i in data:
       print data[i].get('size')

answered May 16, 2016 at 19:26

Mauro Baraldi

6,6042 gold badges35 silver badges48 bronze badges

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

2 Comments

tkyass Over a year ago

Thanks Mauro! but I'm wondering why I can't get the same result if I print i.get('size')? without using data again as in your second example?

Mauro Baraldi Over a year ago

As I said in answer, when you iterate over a dict, it retrieves the key. So you are tring to use get method in a string.

AndrewSmiley · Accepted Answer · 2016-05-16 19:26:45Z

0

First, use json.loads().

data = json.loads(open('path/to/file.json','r').read())

Second, your for loop should be changed to this

for k,v in data.iteritems():
    print data[k]['size']

Regarding the error expect string or buffer, do you have permissions to read the json file?

answered May 16, 2016 at 19:26

AndrewSmiley

1,96322 silver badges34 bronze badges

Collectives™ on Stack Overflow

how to parse json nested dict in python?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related