Parse JSON with Python

Question

I'd like to parse

{"ticker":{"high":31.9099,"low":22.5,"vol":108468,"buy":29.61,"sell":30,"last":29.61}}

and end up with:

last = 29.61

but I don't know where to start parsing python :(

I really don't understand why these question keep getting asked... typing "parse json python" into google leads straight into the Python json package. From there it should be straightforward. — I82Much
– I82Much, Commented Jun 9, 2011 at 1:21
@Mike Pennington: Sure, there's plenty of room for non-googlers. They can use Bing instead. Or they can just fire up their Python library manual contents page and type Ctrl-Fjson — John Machin
– John Machin, Commented Jun 9, 2011 at 2:01
@Mike thanks for the link to the discussion. I understand being welcoming etc., but I don't think people's first thought when they hit any snag should be to post a new StackOverflow question. Instead people should invest at least a modicum of effort into finding the answer on their own. That's my opinion at all. — I82Much
– I82Much, Commented Jun 9, 2011 at 15:03
I was less informed back in 2011 - I understand the utility of these types of questions now. — I82Much
– I82Much, Commented Jan 18, 2013 at 1:31

Ignacio Vazquez-Abrams · Accepted Answer · 2011-06-09 01:19:59Z

13

>>> text = '''{"ticker":{"high":31.9099,"low":22.5,"vol":108468,"buy":29.61,"sell":30,"last":29.61}}'''
>>> json.loads(text)
{u'ticker': {u'sell': 30, u'buy': 29.609999999999999, u'last': 29.609999999999999, u'vol': 108468, u'high': 31.9099, u'low': 22.5}}
>>> json.loads(text)[u'ticker'][u'last']
29.609999999999999

Or use simplejson with older versions of Python.

answered Jun 9, 2011 at 1:19

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

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

2 Comments

Kshitiz Sharma Over a year ago

Why is it u'ticker' instead of ticker?

Ignacio Vazquez-Abrams Over a year ago

@KshitizSharma: Because 'ticker' is bytes, not text.

Helen Neely · Accepted Answer · 2013-05-15 11:42:07Z

2

I'm not sure, but I thought I should post this here in case someone else finds it useful. There is a nice post here on Parsing JSON in Python - it is small be shows how you could use it in different scenarios.

Good luck!

answered May 15, 2013 at 11:42

Helen Neely

4,7408 gold badges45 silver badges65 bronze badges

Collectives™ on Stack Overflow

Parse JSON with Python

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related