How to handle JSON with multiple data

Question

I have a simple question. I would like to use JSON file as following:

{
"data": {
    "1": {
        "id": 1, 
        "symbol": "A", 
        ...
        },
    }, 
    "1027": {
        "id": 1027, 
        "symbol": "B", 
        ...
        }, 
    },
    ...
}

It is from website, and I make a JSON file to parse such as tmp. I wanna see the result of tmp["data"]["1"]["symbol"], and there are 1000 data included. What I said is I would like to check tmp["data"]["1"]["symbol"] to tmp["data"]["1000"]["symbol"] with for statement. I cannot replace "1" part with another index number. Please help me out.

Thanks in advance.

blhsing · Accepted Answer · 2018-10-11 05:03:22Z

1

This will output all the symbol values along with the corresponding ids:

for data in tmp['data'].values():
    print(data['id'], data['symbol'])

answered Oct 11, 2018 at 5:03

blhsing

109k9 gold badges89 silver badges132 bronze badges

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

Comments

Vishal · Accepted Answer · 2018-10-11 05:36:08Z

1

For accessing all the sub-elements of data, try this -

for var in tmp['data'].values():
     print(var['symbol'])

This iterates for all the subelements of data and prints the symbol element in all the subelements.

answered Oct 11, 2018 at 5:36

Vishal

291 silver badge9 bronze badges

Collectives™ on Stack Overflow

How to handle JSON with multiple data

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related