python读取csv文件排序并新建数据集(一份包含不同国家每日数据的文件)
怎样实行对文件特定列的排序,在对特定列排序后将排在前十的数据新存在一个文件中?
可以啊,比如说csv文件长这样:
import csv
with open('stock.csv','r') as f:
f = csv.reader(f)
stock=[]
for i in f:
stock.append(i)
stock.sort(key=lambda x: eval(x[-1]))
new = stock[:10]
with open('new.csv','w',newline='') as f:
w = csv.writer(f)
w.writerows(new)
结果就是这样: