How do I sort JSON from least to greatest in Python?

Question

Lets say I have a JSON file like below:

{
    "data": [
        {
            "id": 2,
            "name": "fork"
        },
        {
            "id": 1,
            "name": "knife"
        },
        {
            "id": 3,
            "name": "spoon"
        }
    ]
}

I am unsure how I sort the data inside data[] so it would be something like below (the id and name sorted by least to greatest). I tried a sorted() function but I am completely unsure how this would work.

{
    "data": [
        {
            "id": 1,
            "name": "knife"
        },
        {
            "id": 2,
            "name": "fork"
        },
        {
            "id": 3,
            "name": "spoon"
        }
    ]
}

Show what you tried. Also your JSON is invalid. Post a [mcve]. — Mark Tolonen, Aug 08 '22 at 01:51

score 1 · Answer 1 · answered Aug 08 '22 at 01:47

You can use key parameter:

dct = { "data": [ { "id": 2, "name": "fork" }, { "id": 1, "name": "knife" }, { "id": 3, "name": "spoon" } ] }

output = {'data': sorted(dct['data'], key=lambda d: d['id'])}

print(output) # {'data': [{'id': 1, 'name': 'knife'}, {'id': 2, 'name': 'fork'}, {'id': 3, 'name': 'spoon'}]}

score 1 · Answer 2 · answered Aug 08 '22 at 01:48

1

You need to sort by id

sorted(data, key=lambda x: x['id'])

answered Aug 08 '22 at 01:48

Benoît P

3,179
13
31

I got this error running it with my JSON: ```TypeError: string indices must be integers```. Any idea why? – Stature Official Aug 08 '22 at 01:52
@StatureOfficial No, but update your question with your code and valid JSON so your problem can be reproduced – Mark Tolonen Aug 08 '22 at 01:56

How do I sort JSON from least to greatest in Python?

2 Answers2