Coinmarketcap Data Nested Dictionary

Hi I am still in the beginner stages of learning python. I am trying to extract data from Coinmarketcap.com using their api system. I am able to get an output with one large dictio

Solution 1:

In Python, you can access the value of the dictionary by simply doing

value = dict[key]

In your case, you have a nested JSON. You can access the values by chaining the keys.

Your JSON looks like

{
"status": {
    "timestamp": "2019-07-17T20:54:40.829Z",
    "error_code": 0,
    "error_message": null,
    "elapsed": 7,
    "credit_count": 1
},
"data": {
    "ADA": {
        "id": 2010,
        "name": "Cardano",
        "symbol": "ADA",
        "slug": "cardano",
        "num_market_pairs": 90,
        "date_added": "2017-10-01T00:00:00.000Z",
        "tags": ["mineable"],
        "max_supply": 45000000000,
        "circulating_supply": 25927070538,
        "total_supply": 31112483745,
        "platform": null,
        "cmc_rank": 12,
        "last_updated": "2019-07-17T20:54:04.000Z",
        "quote": {
            "USD": {
                "price": 0.056165857414,
                "volume_24h": 102375843.427606,
                "percent_change_1h": -0.816068,
                "percent_change_24h": 5.42849,
                "percent_change_7d": -21.8139,
                "market_cap": 1456216147.0000284,
                "last_updated": "2019-07-17T20:54:04.000Z"
            }
        }
    }
}
}

You can access the price as

price = data['data']['ADA']['quote']['USD']['price']

Hope it helps

Solution 2:

Despite similarity it isn't a dictionary as the built-in of Python. Is a JSON. You can parse by the 'key' values. Example:

import json

a = '{"status": {"timestamp": "2019-07-17T20:54:40.829Z", "error_code": 0, "error_message": null, "elapsed": 7}}'
b = json.loads(a)
print(b["status"]["elapsed"])

See that once you're already using requests you don't have to import json module. Ex:

requests.get(url).json()[0]["your_target"]) 

Analyse the response you get, maybe the index '0' does not apply.