需要词典、csv文件和列表方面的帮助

Question

好的，所以我需要一个代码，将采取一个csv文件，并读取其中的值（到目前为止，我已经得到了这部分下来）

我遇到的问题是，创建一个包含这些值的列表，并按重复次数较少到重复次数最多的顺序排序。也不能有重复的值

以下是我所拥有的：

import csv
B = []
K = []
def readandprocess(name):
with open(name, newline='') as csvf:
    freader = csv.reader(csvf,delimiter=',',quotechar='"')
    datasg = {}
    artists = []



    for row in freader:
        artist = row[2]
        B.append(artist)


    for artist in B:
            c = B.count(artist)
            K.append(artist + str(c))


    list(set(K))
    print(K)

    #for row in freader:
        #artist = row[2]
        ###song = row[1]
        #if artist == 'Rolling Stones':
        #    print('Rolling Stones title: ',row[1])
        #if artist not in datasg:
        #   datasg[artist] = [song]
       #else:
            #datasg[artist].append(song)
    #for artist in datasg:
        #print(artist, datasg[artist])
    print( '--------------------------------------')
    info = datasg.items()
   # tosort = [(len(t[1]),t[0]) for t in info]
   # info = sorted(tosort)
   # print(info[-30:])
   # print(info)

print(len(datasg))   # currently 0, populate at will #Number of keys in dictionary
return datasg


if __name__ == '__main__':
    datasg = readandprocess('data/top1000.csv')

Answer 1

尝试使用Counter。一旦列表中有了所需的所有项目，就可以使用计数器，然后调用^{}来获取n最常用的元素