python sort over list by value Json sctructure

Question

I'm trying to get an output of a json file sorted by the following value "created_at" there a bit mass regarding all my tries in the code, I wasn't able to sort it.

If there is better solutions to resolve this task you more then welcome to share.

Your help and patience is much appreciated

import json
from datetime import datetime
import operator 
from collections import OrderedDict
from operator import itemgetter

null = None
true = True
false = False

text = {

    "Recipes":
    [
        {
            "id": 2090210,
            "user_id": 198555,
            "parent_id": null,
            "folder_id": 792876,
            "version_no": 17,
            "last_run_at": "2022-01-13T03:52:31.559455-08:00",
            "created_at": "2022-01-13T00:53:48.433452-08:00",
            "updated_at": "2022-01-13T03:52:27.798961-08:00",
            "job_succeeded_count": 7,
            "job_failed_count": 0,
            "lifetime_task_count": 209,
            "active": true
        },
        {
            "id": 2072031,
            "user_id": 198555,
            "parent_id": null,
            "folder_id": 283206,
            "version_no": 98,
            "last_run_at": "2022-01-04T05:14:41.485273-08:00",
            "created_at": "2022-01-14T05:12:56.677338-08:00",
            "updated_at": "2022-01-12T10:08:49.199488-08:00",
            "job_succeeded_count": 1,
            "job_failed_count": 0,
            "lifetime_task_count": 227,
            "active": false
        },
    ]
}


#info = json.dump(text, sort_keys=False)
sorted_values = sorted(text.values())
#text.sort(key=lambda s: s['created_at'])
sorted_d = {r: text[r] for r in sorted(text, key=text.get('created_at'), reverse=True)}
#print(sorted_d)
ss = sorted(text.values()) #no recips
#print(ss)
newlist = sorted(ss, key=itemgetter(1))
print(newlist)

Jai248 · Accepted Answer · 2022-01-18 11:11:46Z

2

No need to write extra lines just write this one line and it will sort you data

sorted_text = { "Recipes" :  sorted(text['Recipes'], key=itemgetter('created_at'))}
print(sorted_text)

answered Jan 18, 2022 at 11:11

Jai248

1,64910 silver badges24 bronze badges

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

2 Comments

Seedtefan Over a year ago

sure i will :) just as new user im not able to raise a number until 15 reputation and only in 5 minutes ill be able to accept i assume its done via teh green V near ur answer

Jai248 Over a year ago

yeah, the left side of my answer you will find a green button. You can click it to accept answers. thanks

Collectives™ on Stack Overflow

python sort over list by value Json sctructure

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related