I have nested dict something like that
my_dict= {'name1': {'code1': {'brand1': 2}},'name2': {'code2.1': {'brand2.1': 2,'brand2.2': 8,'brand2.3': 5, 'brand2.4': 4},'code2.2': {'brand2.1': 2, 'brand1': 1, 'brand2.5': 25}},'name3': {'code1': {'brand2.1': 2},'code3': {'brand4': 1,'brand3.1':2}}}
I need sort on the level “code” with depending on summing values “brands”. For example,
target_dict= {'name1': {'code1': {'brand1': 2}}, 'name2': {'code2.2': {'brand2.1':2,'brand1': 1,'brand2.5': 25},'code2.1': {'brand2.1': 2,'brand2.2': 8,'brand2.3': 5,'brand2.4': 4}}, 'name3': {'code3': {'brand4': 1, 'brand3.1':2},'code1': {'brand2.1': 2}}}
*# ‘code2.2’ first because 2+1+25=28 > 2+8+5+4=19 # ‘code3’ first because 1+2=3 > 2
I can sum values “brands” by “code” with
sum_values = [[[i, sum(v[i].values())] for i in v.keys()] for x,y in v.items() for k,v in my_dict.items()]
and try combine with sort function as
target_dict = sorted(my_dict.items(), key=lambda i: [[[i, sum(v[i].values())] for i in v.keys()] for x,y in v.items() for k,v in my_dict.items()], reverse=True).
Thanks for your attention and help!
Advertisement
Answer
Try (assuming sufficient version of Python to preserve creation order of dict):
my_dict = { "name1": {"code1": {"brand1": 2}}, "name2": { "code2.1": {"brand2.1": 2, "brand2.2": 8, "brand2.3": 5, "brand2.4": 4}, "code2.2": {"brand2.1": 2, "brand1": 1, "brand2.5": 25}, }, "name3": {"code1": {"brand2.1": 2}, "code3": {"brand4": 1, "brand3.1": 2}}, } out = { k: dict(sorted(v.items(), key=lambda d: sum(d[1].values()), reverse=True)) for k, v in my_dict.items() } print(out)
Prints:
{ "name1": {"code1": {"brand1": 2}}, "name2": { "code2.2": {"brand2.1": 2, "brand1": 1, "brand2.5": 25}, "code2.1": {"brand2.1": 2, "brand2.2": 8, "brand2.3": 5, "brand2.4": 4}, }, "name3": {"code3": {"brand4": 1, "brand3.1": 2}, "code1": {"brand2.1": 2}}, }