python对csv中某一列排序_Python:按列对csv排序

到目前为止，我得到的是：import csv

import operator

with open('Links.csv', 'rb') as input_file, \

open('Link Statements.csv', 'w') as output_file:

reader = csv.reader(input_file, delimiter=',', quoting=csv.QUOTE_NONE)

for row in reader:

link_name, from_unit, to_unit, rate, type = row

output_file.write(" %s," % (from_unit))

output_file.write("Establish %s link %s at %s Kbps to %s.\n" % (type, link_name, rate, to_unit))

output_file.write(" %s," % (to_unit))

output_file.write("Terminate %s link %s at %s Kbps from %s.\n" % (type, link_name, rate, from_unit))

data = csv.reader(open('Link Statements.csv'),delimiter=',')

for unit, statement in reader:

print unit

sortedlist = sorted(data, key=operator.itemgetter(0), reverse=True)

sortedlist

我正在创建一个如下所示的csv：

^{pr2}$

我试图按第一列按字母数字对CSV进行排序，但我无法使sortedlist语句正常工作。在

谢谢。在