使用python脚本按日期排序tsv

import csv
from datetime import datetime

data = []
with open('file.tsv', 'r') as file:
    reader = csv.reader(file, delimiter='\t')
    for row in reader:
        date_str = row[0]  # 假设日期在第一列
        date = datetime.strptime(date_str, '%Y-%m-%d')  # 解析日期字符串
        data.append((date, row))  # 将日期和行数据存储为元组

sorted_data = sorted(data, key=lambda x: x[0])  # 使用日期作为排序键

with open('sorted_file.tsv', 'w') as file:
    writer = csv.writer(file, delimiter='\t')
    for _, row in sorted_data:
        writer.writerow(row)