Index JSON searches python

Question

I have the next JSON that I get from a URL:

[{
  "id": 1,
  "version": 23,
  "external_id": "2312",
  "url": "https://example.com/432",
  "type": "typeA",
  "date": "2",
  "notes": "notes",
  "title": "title",
  "abstract": "dsadasdas",
  "details": "something",
  "accuracy": 0,
  "reliability": 0,
  "severity": 12,
  "thing": "32132",
  "other": [
    "aaaaaaaaaaaaaaaaaa",
    "bbbbbbbbbbbbbb",
    "cccccccccccccccc",
    "dddddddddddddd",
    "eeeeeeeeee"
  ],
  "nana": 8
},
{
  "id": 2,
  "version": 23,
  "external_id": "2312",
  "url": "https://example.com/432",
  "type": "typeA",
  "date": "2",
  "notes": "notes",
  "title": "title",
  "abstract": "dsadasdas",
  "details": "something",
  "accuracy": 0,
  "reliability": 0,
  "severity": 12,
  "thing": "32132",
  "other": [
    "aaaaaaaaaaaaaaaaaa",
    "bbbbbbbbbbbbbb",
    "cccccccccccccccc",
    "dddddddddddddd",
    "eeeeeeeeee"
  ],
  "nana": 8
}]

My code:

import json
import urllib2

data = json.load(urllib2.urlopen('http://someurl/path/to/json'))
print data

I want to know how to access to the part "abstract" of the object that has "id" equal to 2 for example. The part "id" is unique so I can use id to index my searchs.

Thanks!

Maybe take a look here > stackoverflow.com/questions/8712008/… — guisantogui
– guisantogui, Commented Oct 10, 2013 at 19:46

Community · Accepted Answer · 2017-05-23 12:17:45Z

3

Here's one way to do it. You can create a generator via a generator expression, call next to iterate that generator once, and get back the desired object.

item = next((item for item in data if item['id'] == 2), None)
if item:
    print item['abstract']

See also Python: get a dict from a list based on something inside the dict

EDIT : If you'd like access to all elements of the list that have a given key value (for example, id == 2) you can do one of two things. You can either create a list via comprehension (as shown in the other answer), or you can alter my solution:

my_gen = (item for item in data if item['id'] == 2)
for item in my_gen:
    print item

In the loop, item will iterate over those items in your list which satisfy the given condition (here, id == 2).

edited May 23, 2017 at 12:17

CommunityBot

11 silver badge

answered Oct 10, 2013 at 19:47

Emmett Butler

6,2352 gold badges33 silver badges48 bronze badges

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

5 Comments

Alberto Over a year ago

Thanks. Is there any way to do something like this: data["id=2"]["abstract"] ?? Thanks again

Emmett Butler Over a year ago

Python doesn't support deep key lookups as you've shown, but you can simulate them using the above.

Alberto Over a year ago

The problem is that if I want to show all the objects that have the "date" = 2 it only show me one object instead of both of them

Emmett Butler Over a year ago

Please see my updated answer addressing this concern.

martineau Over a year ago

@Alberto: To get a list of the details fields from all the objects with 'id' == 2 use [obj['details'] for obj in data if obj['id'] == 2].

Gezim · Accepted Answer · 2013-10-10 19:54:21Z

You can use list comprehention to filter:

import json

j = """[{"id":1,"version":23,"external_id":"2312","url":"https://example.com/432","type":"typeA","date":"2","notes":"notes","title":"title","abstract":"dsadasdas","details":"something","accuracy":0,"reliability":0,"severity":12,"thing":"32132","other":["aaaaaaaaaaaaaaaaaa","bbbbbbbbbbbbbb","cccccccccccccccc","dddddddddddddd","eeeeeeeeee"],"nana":8},{"id":2,"version":23,"external_id":"2312","url":"https://example.com/432","type":"typeA","date":"2","notes":"notes","title":"title","abstract":"dsadasdas","details":"something","accuracy":0,"reliability":0,"severity":12,"thing":"32132","other":["aaaaaaaaaaaaaaaaaa","bbbbbbbbbbbbbb","cccccccccccccccc","dddddddddddddd","eeeeeeeeee"],"nana":8}]"""

dicto = json.loads(j)

results = [x for x in dicto if "id" in x and x["id"]==2]

And then you can print the 'abstract' values like so:

for result in results:
    if "abstract" in result:
        print result["abstract"]

MONTYHS · Accepted Answer · 2013-10-15 14:36:44Z

0

import urllib2
import json
data = json.load(urllib2.urlopen('http://someurl/path/to/json'))
your_id = raw_input('enter the id')
for each in data:
    if each['id'] == your_id:
        print each['abstract']

In the above code data is list and each is a dict you can easily access the dict object.

answered Oct 15, 2013 at 14:36

MONTYHS

9241 gold badge7 silver badges30 bronze badges

Collectives™ on Stack Overflow

Index JSON searches python

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related