Extract data from JSON API using Python [duplicate]

Question

I go through this part:

How do I extract the data from that URL? I only want to print out the "networkdiff": 58954.60268219.

from urllib import urlopen

url = urlopen('http://21.luckyminers.com/index.php?page=api&action=getpoolstatus&api_key=8dba7050f9fea1e6a554bbcf4c3de5096795b253b45525c53562b72938771c41').read()

print url

This is what the API display as a result from print url command:

{
    "getpoolstatus": {
        "version": "1.0.0",
        "runtime": 16.618967056274,
        "data": {
            "pool_name": "21 Coin Pool @ Luckyminers.com",
            "hashrate": 485426748,
            "efficiency": 98.1,
            "workers": 14,
            "currentnetworkblock": 12025,
            "nextnetworkblock": 12026,
            "lastblock": 12023,
            "networkdiff": 58954.60268219,
            "esttime": 521.61956775542,
            "estshares": 241478052.58625,
            "timesincelast": 427,
            "nethashrate": 485426748
        }
    }
}

If there's an answer you like, please help the community and mark it as accepted by clicking the check mark. — scorpiodawg
– scorpiodawg, Commented Feb 12, 2014 at 6:58

scorpiodawg · Accepted Answer · 2014-02-10 07:14:51Z

21

You can use the json module to parse out a Python dictionary and get right to the value like so:

import json
result = json.loads(url)  # result is now a dict
print '"networkdiff":', result['getpoolstatus']['data']['networkdiff']

To do this multiple times (to answer your question in the comments section):

import json
import urllib

urls = {'joe': 'url1', 'jack': 'url2', 'jane': 'url3'}
for who in urls.keys():
    url = urllib.urlopen(urls[who])
    result = json.loads(url)  # result is now a dict
    print 'For %s: "networkdiff":' % who, result['getpoolstatus']['data']['networkdiff']

edited Feb 10, 2014 at 7:14

answered Feb 10, 2014 at 6:27

scorpiodawg

5,7623 gold badges45 silver badges62 bronze badges

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

2 Comments

Python2014 Over a year ago

I like your approach with the dictionary approach.

Python2014 Over a year ago

Now I have 3 URLs that I want to get the 'networkdiff' data to display. How do I create a dictionary with 3 different names. Joe, Jack, Jane and at the same time display the three 'networkdiff' next to those 3 names.

Sar009 · Accepted Answer · 2014-02-10 06:25:36Z

2

convert the response to json and then read it

from urllib import urlopen
import simplejson as json

url = urlopen('http://21.luckyminers.com/index.php?page=api&action=getpoolstatus&api_key=8dba7050f9fea1e6a554bbcf4c3de5096795b253b45525c53562b72938771c41').read()
url = json.loads(url)

print url.get('getpoolstatus').get('data').get('networkdiff')

answered Feb 10, 2014 at 6:25

Sar009

2,2865 gold badges30 silver badges50 bronze badges

6 Comments

user1907906 Over a year ago

Why use simplejson instead of json?

Python2014 Over a year ago

what do I do next after I use your code? how does it display the networkdiff number for me to see?

user1907906 Over a year ago

@Python2014 print prints it.

Sar009 Over a year ago

simplejson has backwards compatibility and is updated quite often you may use try: import simplejson as json except ImportError: import json for fallback safety.

Sar009 Over a year ago

u may install simplejson by pip install simplejson or else if on python 2.6+ can simply use json

|

Collectives™ on Stack Overflow

Extract data from JSON API using Python [duplicate]

2 Answers 2

2 Comments

6 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

6 Comments

Linked

Related