python, sorting a dict/json

[der.hans]

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 <PLUGd at lufthans.com> 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 - PLUG-discuss at lists.phxlinux.org
>> 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