Nested Python Dictionary Sorting

Question

I have a python dictionary with the following format.

{'range_qty': 
  {'0 to 10 qty': 5,
  'more than 5000 qty': 18,
  '500 to 1000 qty': 20,
  '200 to 500 qty': 19,
  '1000 to 5000 qty': 15,
  '10 to 50 qty': 3,
  '50 to 200 qty': 14}}

How can I sort this dictionary by the key ? I need output like

{'range_qty': 
  {'0 to 10 qty': 5,
  '10 to 50 qty': 3,
  '50 to 200 qty': 14,
  '200 to 500 qty': 19,
  '500 to 1000 qty': 20,
  '1000 to 5000 qty': 15,
  'more than 5000 qty': 18,
  }}

I'm very curious - why are you trying to sort a dictionary at all? — Mark Snyder
– Mark Snyder, Commented May 6, 2020 at 8:55
This is literally the first link you find if you search the internet for 'python sort dict' — mapf
– mapf, Commented May 6, 2020 at 8:56
Just a heads up, all these "values" are strings, and will not nessecarily be sorted according to values or sizes. If you want to sort by quantity, convert these into actual values such as 0, 10, 50 and so on, and measure the gap from the last key to the current key to determinate the quantity in between. — Torxed
– Torxed, Commented May 6, 2020 at 8:58
@mapf I'm inclined to agree with your link, the problem is that OP's values aren't corresponding to the key text. For instance, 50 to 200 qty has a value of 14 which is no where in between. OP also wants to sort it by the key, not the value, although that change in the linked answer is minuscule. — Torxed
– Torxed, Commented May 6, 2020 at 8:59

Rakesh · Accepted Answer · 2020-05-06 09:09:06Z

1

Using a custom sort.

Ex:

import sys


def cust_sort(val):
    i = val[0].split(" ", 1)[0]
    if not i.isdigit():
        return sys.maxsize
    return int(i)

data = {'range_qty': 
  {'0 to 10 qty': 5,
  'more than 5000 qty': 18,
  '500 to 1000 qty': 20,
  '200 to 500 qty': 19,
  '1000 to 5000 qty': 15,
  '10 to 50 qty': 3,
  '50 to 200 qty': 14}}

data = sorted(data['range_qty'].items(), key=cust_sort)
#or data = {'range_qty': dict(sorted(data['range_qty'].items(), key=cust_sort))}
print(data)

Output:

[('0 to 10 qty', 5),
 ('10 to 50 qty', 3),
 ('50 to 200 qty', 14),
 ('200 to 500 qty', 19),
 ('500 to 1000 qty', 20),
 ('1000 to 5000 qty', 15),
 ('more than 5000 qty', 18)]

answered May 6, 2020 at 9:09

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

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

1 Comment

M Usman Wahab Over a year ago

Thanks bro. Really appreciate your effort.

Chris Doyle · Accepted Answer · 2020-05-06 09:10:33Z

0

Depending on your python version your dict by default might not store order. However if you wanted to iterate over this dict in the order you listed you can use sort if you make your keys uniform. I.E make them all start with an int. So instead of more than 5000 qty you could change it to 5000 or more qty

data = {'range_qty':
  {'0 to 10 qty': 5,
  '5000 or more qty': 18,
  '500 to 1000 qty': 20,
  '200 to 500 qty': 19,
  '1000 to 5000 qty': 15,
  '10 to 50 qty': 3,
  '50 to 200 qty': 14}}

for qty in sorted(data['range_qty'], key=lambda text: int(text.split()[0])):
    print(f"{qty}: {data['range_qty'][qty]}")

OUTPUT

0 to 10 qty: 5
10 to 50 qty: 3
50 to 200 qty: 14
200 to 500 qty: 19
500 to 1000 qty: 20
1000 to 5000 qty: 15
5000 or more qty: 18

answered May 6, 2020 at 9:10

Chris Doyle

12.4k2 gold badges30 silver badges49 bronze badges

1 Comment

M Usman Wahab Over a year ago

Thanks bro for you effort.

Collectives™ on Stack Overflow

Nested Python Dictionary Sorting

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related