How to loop through json file

Question

I dont know how to iterate these json file using forloop i tried this it printing all content but i need to print only the id and class.

for (k, v) in bin3.items():  
if k == 'ID':
    print(v)

The above code doesnt print anything.

this is my json file content { "content": { "ID": "stringIdentity:@5", "class": 1, "annotations": [ { "ID": 1, "class": 2, "body": "" }]}}

dir_with_bin_folder=[]
for root, directories, files in os.walk(directory): 
    for filename in files:
        if filename=='@3.bin':
            with open(root+'/'+filename) as json_file:
                bin3 = json.load(json_file)
                df = pd.read_json(root+'/'+filename)
                print(filename)
                print(bin3)
                annotations=bin3['annotations']
                bin3_content=(bin3['content'])
                bin3_IID=(bin3['ID')
                bin3_class=(bin3['class'])
                for i in annotations:
                bin3_ID=(i['ID'])
                bin3_class=(i['class'])
                bin3_body=(i['body'])
                print(bin3_ID)

And i tried this above one also but im getting keyvalue error

json can be loaded as python dict. Then the contents can be accessed trivially. What content are you trying to extract? — MjZac
– MjZac, Commented Feb 28, 2020 at 6:32
I don't see anything that you can loop over in this JSON... You need an iterable to loop over (like a list), not a JSON/dictionary. — Prateek Dewan
– Prateek Dewan, Commented Feb 28, 2020 at 6:32

Lambo · Accepted Answer · 2020-02-28 07:19:29Z

2

The json file is only iterable from the annotations key contained in context. If you want to print the ID and class from annotations you will need to loop over the annotations list and get the the value where the keys equals 'ID' and 'class'.

with open(root+'/'+filename) as json_file:
    bin3 = json.load(json_file)

for annotation in bin3['content']['annotations']:
    id_value = annotation.get('ID',None)
    class_value = annotation.get('class',None)
    print(id_value, class_value, sep=' ')

answered Feb 28, 2020 at 7:19

Lambo

1,18413 silver badges19 bronze badges

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

5 Comments

priyanka madhesh Over a year ago

I have a doubt if im having a one more list ['transformations'] inside that 'annotations' how can i get details from that? this annotations and transformations are keys inside the content. so how can i give this foreg : bin3 ['content']['annotations']['transformations'] or nested for loop?

Lambo Over a year ago

You can then just loop through that tag also within the current annotation loop. For tranformation in annotation['tranformations']:

priyanka madhesh Over a year ago

im getting keyerror : transformations i just tried like that for annotation in bin3 ['content']['annotations']: print(annotation) for transformation in annotation['transformations']: print(transformation)

Lambo Over a year ago

Ok so lets assume your json looks like this now: bin3 = {"content": { "ID": "stringIdentity:@5", "class": 1, "annotations": [ { "ID": 1, "class": 2, "body": "", "transformations":[ { "ID": 1, "class": 2, "body": "" } ] }]}}

Lambo Over a year ago

Then this should work: for annotation in bin3['content']['annotations']: id_value = annotation.get('ID',None) class_value = annotation.get('class',None) for transformation in annotation.get('transformations',None): trans_id_value = transformation.get('ID', None) trans_class_value = transformation.get('class', None)

Collectives™ on Stack Overflow

How to loop through json file

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related