Re: python, sorting a dict/json

Top Page
Attachments:
Message as email
+ (text/plain)
+ (text/plain)
Delete this message
Reply to this message
Author: der.hans
Date:  
To: Main PLUG discussion list
Subject: Re: python, sorting a dict/json
Am 22. Feb, 2019 schwätzte James Dugger so:

moin moin James,

Thanks!

The lamda is what I needed. It simplified what I was doing.

I also added datetime.strptime() for when I need a date. I'm leaving the
field as an int for sorting for now.

ciao,

der.hans

>> import json
>> from datetime import datetime
>>
>> with open('testp.json') as f:
>>     data = json.load(f)

>>
>> for i in data['pubs']:
>>     pub_date = datetime.strptime(i['date'], '%Y%m%d')
>>     i['date'] = pub_date

>>
>> pub_list = sorted(data['pubs'], key=lambda k: k['date'])
>>
>> print(pub_list)
>>
>> open parses the json file into a python dictionary. Currently the format
> of your json will produce a dictionary with one key 'pubs' and a value
> formatted as a python list of nested dictionaries.
>
> The for loop targets the list inside the main dictionary and first converts
> the date to a python date object.
>
> Then simply use the sorted method with a lambda expression to sort the
> order of dictionaries by the newly created date objects.
>
> Yor initial date values are integers. You will need to either store them
> in the json object as strings or convert them so that datetime.strptime()
> can parse them.
>
> I'm sure there are other ways to do this but this was the fastest given the
> json format.
>
> On Fri, Feb 22, 2019 at 12:21 PM der.hans <> wrote:
>
>> moin moin,
>>
>> I'm trying to sort some data that is currently in json being imported into
>> a dict.
>>
>> It's essentially bibliography information, but without a unique ID.
>>
>> I mostly want to sort on publication date, but also want to group by
>> publication. There could be multiple publications on the same date.
>>
>> Currently using a json format like:
>>
>> {
>>   "pubs": [
>>    {
>>     "date": 20190222
>>     "title": "a title"
>>     "url": "https://some.domain/page.html"
>>    },
>>    {
>>     "date": 20190221
>>     "title": "another title"
>>     "url": "https://some.other.domain/page.html"
>>    }
>>   ]
>> }

>>
>> Format can change if that helps.
>>
>> I want to be able to display items in order. Mostly chronological, but
>> also by other details.
>>
>> Any suggestions for how to sort them for display?
>>
>> A nice, but not required, feature would be sorting them for saving to disk
>> as well.
>>
>> ciao,
>>
>> der.hans
>> --
>> # https://www.LuftHans.com https://www.PhxLinux.org
>> # "You want weapons? We're in a library! Books! The best weapons in the
>> # world! This room's the greatest arsenal we could have - arm yourselves!"
>> # -- the Doctor: Doctor Who, Tooth and Claw, 2006
>> ---------------------------------------------------
>> PLUG-discuss mailing list -
>> To subscribe, unsubscribe, or to change your mail settings:
>> https://lists.phxlinux.org/mailman/listinfo/plug-discuss
>
>
>
>


--
# https://www.LuftHans.com https://www.PhxLinux.org
# The only way for a woman to change a man
# is if he's wearing Depends[TM] - der.hans---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change your mail settings:
https://lists.phxlinux.org/mailman/listinfo/plug-discuss