如何在python中对CSV文件进行排序，使其只返回某些值？

import csv

with open('file.csv', 'r') as file:
    reader = csv.reader(file)
    data = list(reader)

sorted_data = sorted(data, key=lambda x: x[column_index])

filtered_data = [row for row in sorted_data if row[column_index] == 'value']

with open('sorted_filtered_file.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerows(filtered_data)