Printing each instance of a single line item from a JSON using python

Question

Does anyone know how to print and multiple instances of the same line from a JSON output?

The code I wish to decipher looks something similar to:

[
{
    "project": {
        "id": 6514847,
        "name": "Trial_1",
        "code": "123",
        "created_at": "2014-10-08T04:22:14Z",
        "updated_at": "2017-04-11T00:32:43Z",
        "starts_on": "2014-10-08"
    }
},

{
    "project": {
        "id": 6514864,
        "name": "Trial_2",
        "code": "456",
        "created_at": "2014-10-08T04:26:39Z",
        "updated_at": "2017-04-11T00:32:46Z",
        "starts_on": "2014-10-08"
    }
},
{
    "project": {
        "id": 12502453,
        "name": "Trial_3",
        "code": "789",
        "created_at": "2016-12-08T05:14:38Z",
        "updated_at": "2017-04-11T00:32:38Z",
        "starts_on": "2016-12-08"
    }
}
]

This code was a request.get()

I know I can print a single instance of this using

req = requests.get(url, headers=headers)
read_req = req.json()
trial = read_req['project']['code']
print(trial)  #123

The final product I wish to see is linking each Project Name to its relevant Project Code.

The code read_req['project']['code'] won't actually work for the JSON you provided. Did you mean read_req[0]['project']['code']? — SethMMorton
– SethMMorton, Commented Jul 21, 2017 at 4:17
Hey SethMMorton, I can get an individual project off the API. So the example provided would be working off the first project instance, providing the answer 123. Sorry for the confusion — Lachlan
– Lachlan, Commented Jul 21, 2017 at 4:22

SethMMorton · Accepted Answer · 2017-07-21 04:21:12Z

1

You have a list of dicts of dicts. To iterate over each "project" dict you just use a for loop.

for entry in read_req:
    trial = entry['project']['code']
    print(trial)

In this case, each time through the loop entry will be a dictionary containing the "project" key.

answered Jul 21, 2017 at 4:21

SethMMorton

49.4k13 gold badges72 silver badges90 bronze badges

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

1 Comment

Lachlan Over a year ago

Hey SethMMorton, That worked perfectly! Thanks for your help mate!

Rahul · Accepted Answer · 2017-07-21 04:24:57Z

0

You need for loop.

read_req = req.json()

for project in read_req:
    print(project['project']['code'])

edited Jul 21, 2017 at 4:24

answered Jul 21, 2017 at 4:14

Rahul

11.6k5 gold badges63 silver badges100 bronze badges

5 Comments

SethMMorton Over a year ago

If you look closely at the data structure the OP gave, you will notice that it is a list of dicts of dicts, so this won't quite work as written.

Lachlan Over a year ago

Hey Rahul, Thanks for getting back to us so quick. I tried that previously however it comes back with an error TypeError: list indices must be integers or slices, not str.

SethMMorton Over a year ago

No, it actually doesn't. Try to copy-paste the JSON on your computer and use that. You get an IndexError.

SethMMorton Over a year ago

Have you tried this in your local Python environment? This most recent update gives KeyError: 'project'.

Rahul Over a year ago

I was mistaken as this is json array.

Susan M · Accepted Answer · 2017-07-21 04:31:25Z

0

This should work for you:
assuming jsontxt is having input data

for i in range(0,len(jsontxt)):
    print jsontxt[i]['project']['name'], jsontxt[i]['project']['code']

answered Jul 21, 2017 at 4:31

Susan M

531 silver badge6 bronze badges

Collectives™ on Stack Overflow

Printing each instance of a single line item from a JSON using python

3 Answers 3

1 Comment

5 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

5 Comments

Comments

Related