Parsing json - dictionary with in dictionary

[krish216]

Hello I want to extract the value of all pr1 from location1 & 2 from below json - Any ideas would be appreciated

import json jsonget = { "data":[ { "location1":[ { "pr1":"hn1", "pr2":"2019-08-07" } ] }, { "location2":[ { "pr1":"hn2", "pr2":"2019-08-07" } ] } ] } if __name__ == '__main__': jsonout = json.dumps(jsonget) jsonout1 = json.loads(jsonout) for val in jsonout1['data']: print val['location1']

Error:
==ERROR: [{u'pr1'Traceback (most recent call last): print val['location1'] KeyError: 'location1' : u'hn1', u'pr2': u'2019-08-07'}] [Finished in 0.1s with exit code 1]

[ichabod801]

The second item in 'data' has the key 'location2', but not the key 'location1'.

[krish216]

Can you help with a snippet to extract pr1 for each location ..

Here is how output should like

location1 hn1
location2 hn2.

Thank you.

[ichabod801]

I would loop through the sub-dictionaries (for sub_dict in val.values()), and if the key you are looking for is in there, you can extract it.

[cvsae]

Can you help with a snippet to extract pr1 for each location ..

Here is how output should like

location1 hn1
location2 hn2.

Thank you.

import json jsonget = { "data":[ { "location1":[ { "pr1":"hn1", "pr2":"2019-08-07" } ] }, { "location2":[ { "pr1":"hn2", "pr2":"2019-08-07" } ] } ] } if __name__ == '__main__': jsonout = json.dumps(jsonget) jsonout1 = json.loads(jsonout) for val in jsonout1['data']: key = val.keys()[0] print key, val[key][0]["pr1"]

[krish216]

Thanks @cvsae for the quick help.

[cvsae]

Thanks @cvsae for the quick help.

you're welcome