将字典转换为python中排序的字典 [英] convert a dict to sorted dict in python

问题描述

我想将dict转换为python中排序的dict

I want to convert a dict into 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 m    
        k = json.dumps(m)
        print k    
f = {'Gears of war 3': 6, 'Batman': 5, 'gears of war 3': 4, 'Rocksmith': 5, 'Madden': 3}

我想要的输出是:

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 the descending order of values and the result should be a dict)

推荐答案

您无法对dict进行排序，因为字典没有排序.

You cannot sort a dict because dictionary has no ordering.

相反，请使用 collections.OrderedDict :

Instead, use collections.OrderedDict:

>>> 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

---

您在JSON对象中看到的顺序"没有意义，因为JSON对象是无序的[ RFC4267 ].

---

The "order" you see in an JSON object is not meaningful, as JSON object is unordered[RFC4267].

如果要在JSON中进行有意义的排序，则需要使用列表(以所需的方式排序).这样的东西就是您想要的:

If you want meaningful ordering in your JSON, you need to use a list (that's sorted the way you wanted). Something like this is what you'd want:

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

基于相同的字典d，您可以通过以下方式生成排序列表(这是您想要的):

Given the same dict d, you can generate a sorted list (which is what you want) by:

>>> 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)]

现在，您只需将l传递给m['top5']并将其转储:

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

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

这篇关于将字典转换为python中排序的字典的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！