Handling nested JSON in Python

Question

I'm attempting to retrieve data from within a nested JSON data using Python.

Abbreviated example of the JSON data:

{

    "daily" : {
        "1524182400000" : 438,
        "1524268800000" : 438,
        "1524355200000" : 437,
        "1524441600000" : 437,
        "1524528000000" : 432
    }
}

As you see, each of the above keys is a unix timestamp and the overall object is constantly updated with new key/value pairs.

While I am easily able to retrieve the data if I know the timestamp I don't know how I get the value of the latest timestamp.

I would usually complete this in PHP with the below code and selecting the array position:

foreach ($data["daily"] as $timedate => $value) {
    array_push($ValueArray, $value);
    array_push($ValueDate, $timedate);
}

How do I get this in Python?

Any help would be appreciated!

so you want to grab the last key in the nested dictionary?

eagle
– eagle

2018-04-24 18:47:12 +00:00
Commented Apr 24, 2018 at 18:47 — eagle
– eagle, Commented Apr 24, 2018 at 18:47

wbadart · Accepted Answer · 2018-04-24 18:49:14Z

4

The entry you're looking for is prices['daily'][max(prices['daily'], key=int)].

max(prices['daily'], key=int) iterates over the keys and find the largest (aka, most recent) one. Setting key=int ensures the function does a numerical, rather than lexical comparison.

answered Apr 24, 2018 at 18:49

wbadart

3,0211 gold badge18 silver badges29 bronze badges

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

Comments

Adriano Martins · Accepted Answer · 2018-04-24 18:47:57Z

0

just use the equivalent of foreach in python:

for timedate, value in tmp['daily'].items():
    # Do something with timedate or value...

It works exactly like the foreach on php.

answered Apr 24, 2018 at 18:47

Adriano Martins

1,8091 gold badge20 silver badges23 bronze badges

Comments

Lemayzeur · Accepted Answer · 2018-04-24 19:22:13Z

0

For what you are loking for, this will work:

json_data['daily'][sorted(json_data['daily'].keys())[-1]]

answered Apr 24, 2018 at 19:22

Lemayzeur

8,5153 gold badges27 silver badges55 bronze badges

Collectives™ on Stack Overflow

Handling nested JSON in Python

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related