How to extract elements from JSON File with python?

Question

I have the JSON file below and i am trying to extract the value dob_year from each item if the name element is jim.

This is my try:

import json

with open('j.json') as json_file:
    data = json.load(json_file)
    if data['name'] == 'jim'
        print(data['dob_year'])

Error:

File "extractjson.py", line 6 if data['name'] == 'jim' ^ SyntaxError: invalid syntax

this is my file.

[
      {
        "name": "jim",
        "age": "10",
        "sex": "male",
        "dob_year": "2007",
        "ssn": "123-23-1234"
      },
      {
        "name": "jill",
        "age": "6",
        "sex": "female",
        "dob_year": "2011",
        "ssn": "123-23-1235"
      }
    ]

Your data is a list of dictionaries. You need to loop through (d['dob_year'] for d in data if d['name'] == 'jim') — Prayson W. Daniel
– Prayson W. Daniel, Commented Feb 16, 2020 at 15:05

Yann · Accepted Answer · 2020-02-16 15:19:13Z

2

You need to iterate over the list in the JSON file

data = json.load(json_file)
for item in data:
    if item['name'] == 'jim':
        print(item['dob_year'])

edited Feb 16, 2020 at 15:19

answered Feb 16, 2020 at 15:04

Yann

2,5722 gold badges21 silver badges38 bronze badges

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

1 Comment

Catalina Over a year ago

i am getting the error: File "extractjson.py", line 6 if data['name'] == 'jim' ^ SyntaxError: invalid syntax

gp42 · Accepted Answer · 2020-02-16 15:20:51Z

0

I suggest to use list comprehension:

import json

with open('j.json') as json_file:
    data = json.load(json_file)

print([item["dob_year"] for item in a if item["name"] == "jim"])

answered Feb 16, 2020 at 15:20

gp42

5453 silver badges7 bronze badges

Comments

Aamir Syed · Accepted Answer · 2020-02-16 15:28:06Z

0

json.load()

returns a list of entries, the way you have saved it. You have to iterate through all list items, then search for your field in the list item. Also, if it is a repetitive task, make a function out of it. You can pass different files, fields to be extracted, etc. this way, and it can make your job easier.

Example:

def extract_info(search_field, extract_field, name, filename):

import json

with open(filename) as json_file:
    data = json.load(json_file)
    for item in data:
        if item[search_field] == name:
            print(item[extract_field])

extract_info('name','dob_year','jim','j.json')

answered Feb 16, 2020 at 15:28

Aamir Syed

951 silver badge11 bronze badges

Comments

Raphael · Accepted Answer · 2020-02-16 16:17:19Z

0

data is a list of dictionaries! you cannot directly access the key value pairs. Try encapsulating it in a loop to check every dict in the list:

import json

with open('j.json') as json_file:
    data = json.load(json_file)
    for set in data:
        if set['name'] == 'jim':
            print(set['dob_year'])

edited Feb 16, 2020 at 16:17

answered Feb 16, 2020 at 15:04

Raphael

1,2151 gold badge10 silver badges26 bronze badges

2 Comments

Catalina Over a year ago

I am getting this error : File "extractjson.py", line 6 if set['name'] == 'jim' ^ SyntaxError: invalid syntax

Raphael Over a year ago

ah yes i forgot the colon at the end, that line should be if set['name'] == 'jim':

Collectives™ on Stack Overflow

How to extract elements from JSON File with python?

4 Answers 4

1 Comment

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related