JSON print specific value in Python

Question

I am trying to print only project name from data which looks like this

[{'Project Name': 'ABC'}, {'Customer Name': None}, {'Customer Address': None}, {'Project Description': 'Industries Pvt limited'}]

with my Python Code

with open('project.json', 'r') as f:
    data = json.load(f)
    print(data)

for p in data:
    if 'Project Name' in p:
        print(p)
#Here it prints {'Project Name': 'ABC'}
# Print each property of the object
for p in data:
  print(p['Project Name'])

It prints out the Project Name as ABC but gives a Key Error like this

KeyError: 'Project Name'

Scott Hunter · Accepted Answer · 2020-08-05 14:34:31Z

2

Use an if statement to see if p has a Project Name before trying to print it.

answered Aug 5, 2020 at 14:34

Scott Hunter

50k12 gold badges64 silver badges107 bronze badges

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

3 Comments

Scott Hunter Over a year ago

That's what is in the JSON you posted; what were you expecting?

Darshan Malu Over a year ago

Scott I was expecting the output to be ABC, I did the mistake of inserting 'for' outside 'with' loop. Thanks for the help though. appreciate it :)

Scott Hunter Over a year ago

print(p['Project Name']) will not show {'Project Name': 'ABC'}.

Bruce Salcedo · Accepted Answer · 2020-08-05 15:03:37Z

1

Your JSON file:

[
    {
        "Project Name": "ABC",
        "Customer Name": "None",
        "Customer Address": "None",
        "Project Description": "Industries Pvt limited"
    },
    {
        "Project Name": "QWERTY",
        "Customer Name": "None",
        "Customer Address": "None",
        "Project Description": "Some Text"
    }
]

And here's the python file:

import json

with open('my_json_file.json') as json_file:
    my_json = json.load(json_file)
    for data in my_json:
        print(data["Project Name"])

Output would look like this:

ABC
QWERTY

answered Aug 5, 2020 at 15:03

Bruce Salcedo

2021 gold badge2 silver badges7 bronze badges

2 Comments

Darshan Malu Over a year ago

Thanks! Works well

Scott Hunter Over a year ago

That isn't the JSON posted in the question.

LIU · Accepted Answer · 2020-08-05 14:48:03Z

0

You should not use for to iterate the items because the key 'Project Name' doesn't exist at the later indies. Or you have to use if statement to judge if the key name exists.

Another suggestion is that the data you provided seems like a list of dict rather than common json. Why not use ast? Try the codes below:

import ast

txt = "[{'Project Name': 'ABC'}, {'Customer Name': None}, {'Customer Address': None}, {'Project Description': 'Industries Pvt limited'}]"
data = ast.literal_eval(txt)

print(data[0]['Project Name'])

answered Aug 5, 2020 at 14:48

LIU

511 silver badge6 bronze badges

Comments

Hunter Tran · Accepted Answer · 2021-12-25 03:20:32Z

0

Your JSON is invalid. You can check your JSON here: json lint

Use double quote marks for your JSON to make it valid.

[
{
    "Project Name": "ABC"
},
{
    "Customer Name": "None"
},
{
    "Customer Address": "None"
},
{
    "Project Description": "Industries Pvt limited"
}
]

I suggest use a JSON editor to compose your JSON: json editor

edited Dec 25, 2021 at 3:20

answered Aug 5, 2020 at 14:43

Hunter Tran

16.1k2 gold badges16 silver badges27 bronze badges

Collectives™ on Stack Overflow

JSON print specific value in Python

4 Answers 4

3 Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related