How to format Json query results
Question: 
    #!/usr/bin/env python
    import urllib2
    import json
    api_key = 'VtxgIC2UnhfUmXe_pBksov7-lguAQMZD'
    url = 'http://www.energyhive.com/mobile_proxy/getCurrentValuesSummary?token='+api_key
    response = urllib2.urlopen(url)
    content = response.read()
    for x in json.loads(content):
        if x["cid"] == "PWER":
            print (x["data"])
    for y in json.loads(content):
        if y["cid"] == "PWER_GAC":
            print(y["data"])
    for z in json.loads(content):
        if z["cid"] == "PWER_IMM":
            print(z["data"])
    for a in json.loads(content):
        if a["cid"] == "FBAK_IMM":
            print(a["data"])
    

When I run the code I get results in this format

    
    
    [{u'1439193214000': 2880}]
    [{u'1439193214000': 2979}]
    [{u'1439193212000': 3276}]
    [{u'1439193212000': 135}]
    

How do I remove all and just print only the numbers after the :


Answer: json.loads turns it into a python structure, in this case a list of
dictionaries, so just call the values function

    
    
        import urllib2
        import json
        api_key = 'VtxgIC2UnhfUmXe_pBksov7-lguAQMZD'
        url = 'http://www.energyhive.com/mobile_proxy/getCurrentValuesSummary?token='+api_key
        response = urllib2.urlopen(url)
        content = response.read()
        for x in json.loads(content):
            if x["cid"] == "PWER":
                print (x["data"][0].values()[0])
    

