Python iterate over multi value nested dictionary

Question

I have the below data structure call letters_dict:

'aa': {'Price': '147,130,104,24,19',
       'Qty': '262,53,65,80,185,210',
       'Time': '51302324915,51308461317,51316258845,51324326568'},

'bb': {'Price': '196,203,209,177,150,160,160,180,194',
       'Qty': '129,268,225,228,176,76,17,45,207,61,143,195,230,97',
       'Time': '51305086913,51314981179,51323072726,51435766657,51597990966'}}

I want to iterate over each item of the outer dictionary and then the inner values, price qty and time and then each value within price qty and time to then do data processing. What is the best way to do this?

As an aside, the values in your inner dict are *strings* of comma-seperated values. — juanpa.arrivillaga, Jun 20 '17 at 07:41

nikpod · Accepted Answer · 2017-06-20T08:11:56.140

0

First iterating over the outer values using key_level1 and val_level1, then iterating over inner values using key_level2, val_level2:

for key_level1, val_level1 in r.items():
        for key_level2, val_level2 in val_level1.items():
            for val in val_level2.split(','):
                # Example:
                # do something
                print(key_level1, key_level2, val)

edited Jun 20 '17 at 08:11

answered Jun 20 '17 at 07:51

nikpod

1,238
14
22

That still prints the whole dictionary not just Price – Jaron787 Jun 20 '17 at 07:59
This still doesn't iterate over each comma delimited value in the price list – Jaron787 Jun 20 '17 at 08:10
@Jaron787, finally understood your requirement. I guess this is what you are asking for...(edited answer) – nikpod Jun 20 '17 at 08:12
Nice this works, thanks! – Jaron787 Jun 20 '17 at 08:13

Marc Z · Answer 2 · 2017-06-21T08:54:11.307

0

for key_1 in letters_dict:
    for key_2 in letters_dict[key_1]:
        for value in letters_dict[key_1][key_2].split(','):

This is to me the simplest way (doesn't mean the best). I'm not sure why you didn't even try it ...

edited Jun 21 '17 at 08:54

answered Jun 20 '17 at 08:00

Marc Z

116
5

AttributeError: 'dict' object has no attribute 'split' – Jaron787 Jun 20 '17 at 08:02
Yup, edited the answer. – Marc Z Jun 21 '17 at 08:54

Python iterate over multi value nested dictionary

2 Answers2

Linked