parsing a large json file and retrieving values in python

Question

I have one large json file of the format -

{
    "x": "",
    "y": {
        "a": {
            "-3": {
                "id": -2,
                "rut": "abc",

            },
            "-1": {
                "id": -1,
                 "rut": "cdf",

             } 
        }
     }
}

Now I want to retrieve the values of id for all situations. For this I have the following code -

import json
from pprint import pprint

with open('file.json') as data_file:
data = json.load(data_file)
data['y']['a'].value()['id']

Since I'm not too familiar with using json in python, I couldn't figure out what I was doing wrong. I used .value() because the values -3 and -1 could be any number and are not known before hand. The rest of the values are constant.

@Jezor I'm getting an error at .value() as it doesn't seem to be recognized. Not sure how to read values when you don't know a specific attribute name beforehand — Zzrot
– Zzrot, Commented Sep 11, 2016 at 20:11

Andrii Rusanov · Accepted Answer · 2016-09-11 20:10:57Z

2

import json from pprint import pprint

with open('file.json') as data_file:
    data = json.load(data_file)
    pprint([item['id'] for item in data['y']['a'].values()])

Is it what you are looking for?

answered Sep 11, 2016 at 20:10

Andrii Rusanov

4,6262 gold badges41 silver badges55 bronze badges

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

1 Comment

Zzrot Over a year ago

Yes, exactly what I wanted. Thanks!

jadsq · Accepted Answer · 2016-09-11 20:11:40Z

1

It is a bit unclear what your problem/error is, but my gess is that you want to simply iterate over all the available values to get your 'id' fields. It would look something like that:

for x in data['y']['a']:
    try:
        print(x['id'])
    except IndexError: #In case 'id' isn't present in that subtree
        pass

answered Sep 11, 2016 at 20:11

jadsq

3,5523 gold badges23 silver badges32 bronze badges

Comments

DarkDiamonD · Accepted Answer · 2016-09-11 20:26:38Z

0

Did you mean to use values() ?

However, to get the all 'id's:

sub_data = data['y']['a']
for i in sub_data:
    print(sub_data['id'])

answered Sep 11, 2016 at 20:26

DarkDiamonD

6926 silver badges10 bronze badges

Collectives™ on Stack Overflow

parsing a large json file and retrieving values in python

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related