Get multiple keys from json in Python

Question

I have the following json structure in a file:

[
{ "Date": "timevalue", "Org": "b4256282", "Referer": "somevalue" },
{ "Date": "timevalue", "Org": "b4257482", "Referer": "somevalue" },
{ "Date": "timevalue", "Org": "b4253345", "Referer": "somevalue" },
....
]

I want to extract all the Org's.

My code is:

import json

jdata = json.loads(str_of_above_json)
for orgs in jdata['Org']:
     print(orgs)

However this code does not work ... I get the following error messag

TypeError: list indices must be integers, not str

Can anyone let me know what I am doing wrong?

Remember, your data once loaded in as a Python structure is going to be a list of dictionaries. Keyword here is a list. So, Your for loop is just going to iterate over a list, and then each orgs will be the dictionary, which then you can access the 'Org' key. — idjaw
– idjaw, Commented Jul 26, 2017 at 18:38

cs95 · Accepted Answer · 2019-04-17 09:30:54Z

3

You need to iterate over each dictionary in the list and then index dict in turn with dict indexing. For each dictionary in the list,

get the i^th dictionary
get the value associated with Org in the i^th dictionary
print said value from (2)

In code, this is

for dict_ in jdata:
    org = dict_['Org']
    print(org)

However, we have the power of list comprehension at our disposal, so the code above can more succinctly be represented by,

jdata = json.loads(str_of_above_json)
orgs = [x['Org'] for x in jdata]      
print(orgs)

Why isn't your current code working?
You do jdata['Org'], but [...] is a dict indexing operation, and this will throw errors because jdata is a list.

edited Apr 17, 2019 at 9:30

answered Jul 26, 2017 at 18:37

cs95

406k106 gold badges744 silver badges797 bronze badges

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

Comments

idjaw · Accepted Answer · 2017-07-26 18:45:41Z

2

Remember, your data once loaded in as a Python structure is going to be a list of dictionaries. To keep it simple, it's just:

[{...}, {...}, {...}]

Keyword here is a list. So, your for loop will/should iterate over a list, giving you each dictionary at every iteration.

At this point you can then access the 'Org' key.

So when you do:

for orgs in jdata:
    print(orgs) # each dictionary

At that point, you can now access the Org key in the dictionary:

for orgs in jdata:
    print(orgs) # each dictionary
    print(orgs['Org']) # The value of 'Org' in each dictionary

edited Jul 26, 2017 at 18:45

answered Jul 26, 2017 at 18:41

idjaw

26.8k10 gold badges68 silver badges84 bronze badges

Comments

Jomin · Accepted Answer · 2017-07-26 18:36:32Z

0

import json

jdata = json.loads(str_of_above_json)
for orgs in jdata:
    print(orgs["Org"])

You need to iterate over the list [] then print the "org" part of each data.

answered Jul 26, 2017 at 18:36

Jomin

1232 silver badges8 bronze badges

Comments

randomir · Accepted Answer · 2017-07-26 19:10:08Z

0

All the other answers are correct and will solve your current problem.

But if you manipulate a lot with structures like this, you might find the package plucky helpful (full disclosure: I'm the author of that package).

For example (assuming your jdata is loaded):

>>> import plucky
>>> plucky.plucks(data, '.Org')
['b4256282', 'b4257482', 'b4253345']

or:

>>> plucky.pluckable(data).Org
['b4256282', 'b4257482', 'b4253345']

answered Jul 26, 2017 at 19:10

randomir

18.8k1 gold badge46 silver badges60 bronze badges

Collectives™ on Stack Overflow

Get multiple keys from json in Python

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related