Python: Loop through JSON File

Question

I'm not sure how to loop through this particular structure where the top level keys A1 and B6 are random.

I want to be able to output name, x, y and yr

{
    "A1": {
        "msgs": ["Something there"],
        "name": "Mary White",
        "x": 132,
        "y": 73,
        "yr": 1978
    },
    "B6": {
        "msgs": ["Something here"],
        "name": "Joe Bloggs",
        "x": 132,
        "y": 73,
        "yr": 2016
    },
...

Using the following to load my JSON

import json

with open('items.json') as data_file:    
    data = json.load(data_file)

@ZdaR no, you'd need to loop through .items().

Daniel Roseman
– Daniel Roseman

2017-01-03 14:22:16 +00:00
Commented Jan 3, 2017 at 14:22 — Daniel Roseman
– Daniel Roseman, Commented Jan 3, 2017 at 14:22
Where does json_ come into play? Updated question

pee2pee
– pee2pee

2017-01-03 14:24:13 +00:00
Commented Jan 3, 2017 at 14:24 — pee2pee
– pee2pee, Commented Jan 3, 2017 at 14:24

Yevhen Kuzmovych · Accepted Answer · 2017-01-03 14:25:29Z

17

Iterate through .values():

import json

with open('data.json') as data_file:    
    data = json.load(data_file)
    for v in data.values():
        print(v['x'], v['y'], v['yr'])

edited Jan 3, 2017 at 14:25

answered Jan 3, 2017 at 14:24

Yevhen Kuzmovych

12.3k8 gold badges32 silver badges54 bronze badges

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

2 Comments

pee2pee Over a year ago

That only prints out the first one

Yevhen Kuzmovych Over a year ago

@pee2pee Works fine for me. Check your json file. And try to print(data).

Collectives™ on Stack Overflow

Python: Loop through JSON File

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related