Convert dict to sorted dict in python

Question

I want to convert a dict to a sorted dict in python

data = pandas.read_csv('D:\myfile.csv') for colname, dtype in data.dtypes.to_dict().iteritems(): if dtype == 'object': print colname count = data[colname].value_counts() d = dict((str(k), int(v)) for k, v in count.iteritems()) f = dict(sorted(d.iteritems(), key=lambda item: item[1], reverse = True)[:5]) print f m ={} m["count"]= int(sum(count)) m["Top 5"]= f print mk = json.dumps(m) print kf = {'Gears of war 3': 6, 'Batman': 5, 'gears of war 3': 4, 'Rocksmith': 5, 'Madden': 3} 

My desired result:

 f = {'Gears of war 3': 6, 'Batman': 5, 'Rocksmith': 5, 'gears of war 3': 4, 'Madden': 3} k = {'count':24, 'top 5':{'Gears of war 3': 6, 'Batman': 5, 'Rocksmith': 5, 'gears of war 3': 4, 'Madden': 3}} 

(in descending order of values ​​and the result should be dict)

Answer 1

You cannot sort the dict because the dictionary does not order.

Use collections.OrderedDict instead:

 >>> from collections import OrderedDict >>> d = {'Gears of war 3': 6, 'Batman': 5, 'gears of war 3': 4, 'Rocksmith': 5, 'Madden': 3} >>> od = OrderedDict(sorted(d.items(), key=lambda x:x[1], reverse=True)) >>> od OrderedDict([('Gears of war 3', 6), ('Batman', 5), ('gears of war 3', 4), ('Rocksmith', 5), ('Madden', 3)]) >>> od.keys() ['Gears of war 3', 'Batman', 'gears of war 3', 'Rocksmith', 'Madden'] >>> od.values() [6, 5, 4, 5, 3] >>> od['Batman'] 5 

---

The "order" that you see in the JSON object does not make sense because the JSON object is unordered [ RFC4267 ].

If you need meaningful order in your JSON, you need to use a list (which is sorted as you wish). Something like this is what you want:

 { "count": 24, "top 5": [ {"Gears of war 3": 6}, {"Batman": 5}, {"Rocksmith": 5}, {"gears of war 3": 4}, {"Madden": 3} ] } 

Given the same dict d , you can create a sorted list (which you want):

 >>> l = sorted(d.items(), key=lambda x:x[1], reverse=True) >>> l [('Gears of war 3', 6), ('Batman', 5), ('Rocksmith', 5), ('gears of war 3', 4), ('Madden', 3)] 

Now you just pass l to m['top5'] and unload it:

 m["Top 5"]= l k = json.dumps(m)