对csv文件进行排序，并仅复制标题中包含关键字的行

import csv

def sort_and_filter_csv(csv_file, keyword):
    data = []
    with open(csv_file, 'r') as file:
        reader = csv.reader(file)
        headers = next(reader)  # 获取标题行
        keyword_rows = [row for row in reader if keyword in row[0]]  # 筛选包含关键字的行
        sorted_rows = sorted(keyword_rows, key=lambda x: x[0])  # 根据标题排序
        data.append(headers)  # 添加标题行
        data.extend(sorted_rows)  # 添加排序后的行

    with open('sorted_filtered.csv', 'w', newline='') as file:
        writer = csv.writer(file)
        writer.writerows(data)  # 写入排序后的数据

# 示例用法
sort_and_filter_csv('input.csv', '关键字')