Python create dictionary from json values

Question

I currently do an API call to the Steam Web API which gets a json response which looks like this:

{
"response": {
    "globalstats": {
        "heist_success": {
            "total": "58932654920",
            "history": [
                {
                    "date": 1486252800,
                    "total": "696574"
                },
                {
                    "date": 1486339200,
                    "total": "357344"
                },
                {
                    "date": 1486425600,
                    "total": "356800"
                },
                {
                    "date": 1486512000,
                    "total": "311056"
                }
            ]

        }
    },
    "result": 1
}

The date is in unix time stamp and the total is an amount. What I want to do is create a dictionary from the values in date and time and not the names. I tried using the following:

dict = dict(data['response']['globalstats']['heist_success']['history'])

But that just created a dict of "date" "total".

How can I create a dict of just the values?

To clearify, I want to create a dict with the timestamp in the first column and the amount in the second one. — Samuel Leberto
– Samuel Leberto, Commented Feb 9, 2017 at 10:56

Sarath Sadasivan Pillai · Accepted Answer · 2017-02-09 11:30:36Z

9

You may get the values and make dictionary out of it ,

This is what you may do

Code

d = data['response']['globalstats']['heist_success']['history']
result_dict = dict((i["date"],i["total"]) for i in d)

You may also use dict comprehension if using python version 2.7 or above

result_dict = {i["date"]:i["total"]  for i in d}

Output

{1486252800: '696574',
 1486339200: '357344',
 1486425600: '356800',
 1486512000: '311056'}

edited Feb 9, 2017 at 11:30

answered Feb 9, 2017 at 11:00

Sarath Sadasivan Pillai

7,15135 silver badges47 bronze badges

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

3 Comments

Samuel Leberto Over a year ago

Perfect! Worked like a charm. Thanks for the help!

Samuel Leberto Over a year ago

Sorry but I can't since I got less than 15 rep myself :/

Samuel Leberto Over a year ago

Didn't see that... Done!

Mark Tolonen · Accepted Answer · 2017-02-09 11:15:33Z

2

You can use a dict comprehension:

D = {h['date']:h['total'] for h in data['response']['globalstats']['heist_success']['history']}

The for will iterate over the list of dicts in history and date and total are selected as the key and value.

answered Feb 9, 2017 at 11:15

Mark Tolonen

181k26 gold badges182 silver badges278 bronze badges

Collectives™ on Stack Overflow

Python create dictionary from json values

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related