searching json ouput in python

Question

So I'm attempting to learn how to search the output of trakt.tv's api and return only the information for a certain show. The json ouput is as follows

[
  {
      "title": "NCIS",
      "year" : 2003,
      "url": "blah"
    },
   {   
       "title": "Jeffersons",
       "year" : 1902,
       "url": "notreally"
     }
]

:edited code for correct formatting.

I'm trying to find only the information for the title NCIS. and I've run into a problem getting the information. Possibly because everything i've seen deals with json.dump or json.loads and i'm trying to do this with data = json.load(urllib2.urlopen(url))

I basically only want to display show:0 if title matches NCIS. I'm just not sure how.

Then your example JSON misrepresents the actual output, as far as the documentation for search/shows is concerned. — Martijn Pieters
– Martijn Pieters, Commented Mar 1, 2013 at 19:16
then i probably mistyped it seeing as i have 15 windows open — crawln
– crawln, Commented Mar 1, 2013 at 19:18

Martijn Pieters · Accepted Answer · 2013-03-01 19:17:35Z

4

The /search/shows API method returns a list of shows (each a mapping) that match your search.

You can simply loop over these and match the specific title:

data = json.load(urllib2.urlopen(url))

for show in data:
    if show['title'] == 'NCIS':
        # matching show

or you could use a generator expression to get one matching show:

try:
    ncis_show = next(show for show in data if show['title'] == 'NCIS')
except StopIteration:
    ncis_show = None  # not found

answered Mar 1, 2013 at 19:17

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

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

1 Comment

woozyking Over a year ago

Using next() is very elegant imo

Collectives™ on Stack Overflow

searching json ouput in python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related