iterating nested dictionaries using for loop in python

Question

here is my json file which has sample data in nested dictionaries like below

data = {
    'school': {
        'name': 'abc',
        'class': {
            'firstclass': {'teacher': 'b', 'students': '10'},
            'secondclass': {'teacher': 'c', 'students': '25'},
        }, 'city': 'x'},
    'college': {
        'name': 'def',
        'class': {
            'firstclass': {'teacher': 'd', 'students': '9'},
            'secondclass': {'teacher': 'e', 'students': '65'},
        }, 'city': 'y'},
    'university': {
        'name': 'ghi',
        'class': {
            'firstclass': {'teacher': 'f', 'students': '55'},
            'secondclass': {'teacher': 'g', 'students': '22'},
        }, 'city': 'z'}
}

my output should be like:

'teacher':'b','students':'10'
'teacher':'d','students':'9'
'teacher':'f','students':'55'

here is my code in for loop:

for id in data:
    for j in data[id]:
        print(j  ,"="  , data[id][j])

i am not getting above expected output. how to get exact output as above .

You are explicitly printing an `"="`, which is not even in your expected output?! — user2390182, Oct 15 '21 at 11:32
Also, pls post data structures that can be copied verbatim. That `data` of yours is **not** a valid `dict` — user2390182, Oct 15 '21 at 11:33

score 1 · Accepted Answer · answered Oct 15 '21 at 11:36

1

This might nudge you in the right direction:

for v in data.values():
    for dct in v["class"].values():
        print(", ".join(map("=".join, dct.items())))
    
teacher=b, students=10
teacher=c, students=25
teacher=d, students=9
teacher=e, students=65
teacher=f, students=55
teacher=g, students=22

answered Oct 15 '21 at 11:36

user2390182

72,016
6
67
89

if i want to get only first class or second class from every class – Krishna Prasad Oct 15 '21 at 11:50
Which first? Your desired output has 6 key-value pairs as has the output in this answer? – user2390182 Oct 15 '21 at 11:51
yes i got output exactly, but what if i want to get to only dictionary of firstclass or second class from class of school,college and university .like firstclass from school,firstclass from college and firstclass from university data values – Krishna Prasad Oct 15 '21 at 11:54
Then you would have to access those key combinations explicitly. – user2390182 Oct 15 '21 at 12:00
how to add time and date column to output.output should display like teachers,students,time,date .if possible pls share snippet – Krishna Prasad Oct 15 '21 at 16:48
@KrishnaPrasad are you trying to read Stock/Index json? and wanna add time and date for the same? I can help. – John Mar 19 '22 at 16:16
Yes stock json data, now I am getting output of @user23901 but I need to include name value to the output from school,college, university also, will u help me – Krishna Prasad Mar 20 '22 at 17:51
@John check above – Krishna Prasad Mar 20 '22 at 23:19
@KrishnaPrasad I have a solution for reading Stocks and Index JSON which fetches data from NSE. If interested, pls let me know. – John Mar 21 '22 at 05:42
@KrishnaPrasad I too had a problem reading the data. Yesterday got solved. Here's the link. https://stackoverflow.com/questions/71545470/parsing-json-conditionally-using-python I hope this will help you if you wanna read the data as I am reading. – John Mar 21 '22 at 05:44
@john the above link doesn't help me, I need to read whole data – Krishna Prasad Mar 23 '22 at 02:27
@KrishnaPrasad I am also reading the whole data, using this piece of code. Share you e-mail, if you can – John Mar 23 '22 at 15:58
@John palakoori05@gmail.com ,pls do help – Krishna Prasad Mar 24 '22 at 08:21
@John, pls share – Krishna Prasad Mar 25 '22 at 02:16

iterating nested dictionaries using for loop in python

1 Answers1