How to parse data in JSON format? How to parse data in JSON format? python python

How to parse data in JSON format?


python json parsing

Very simple:

import jsondata = json.loads('{"one" : "1", "two" : "2", "three" : "3"}')print data['two']

python json parsing

Sometimes your json is not a string. For example if you are getting a json from a url like this:

j = urllib2.urlopen('http://site.com/data.json')

you will need to use json.load, not json.loads:

j_obj = json.load(j)

(it is easy to forget: the 's' is for 'string')

python json parsing

For URL or file, use json.load(). For string with .json content, use json.loads().

#! /usr/bin/pythonimport json# from pprint import pprintjson_file = 'my_cube.json'cube = '1'with open(json_file) as json_data:    data = json.load(json_data)# pprint(data)print "Dimension: ", data['cubes'][cube]['dim']print "Measures:  ", data['cubes'][cube]['meas']

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last