python 读取csv文件，并按行数据进行排序

import csv
list=[]
with open('tttpsi.csv', encoding='utf-8') as file:
    f_csv = csv.reader(file)
    for i, rows in enumerate(f_csv):
        if i >= 1:
            # new_row = []
            row = rows[1:-1]
            # print(row)
            row.sort(reverse=True) #reverse=True 降序排序  默认是升序排序
            row_1=row[0:5] #取前五个数值，如果想全部保留，则去掉[0:5]
            # print(row_1)
            list.append(row_1)
    print(list)

with open('mescpsisort.csv', 'w', encoding='utf8', newline='') as f2:
    f_csv2 = csv.writer(f2)
    f_csv2.writerows(list)