使用writerow合并python中不同列的多个csv文件

import csv

# 定义要合并的CSV文件列表
csv_files = ['file1.csv', 'file2.csv', 'file3.csv']

# 定义要合并的列索引
column_indexes = [0, 2, 4]  # 假设要合并第1、3、5列

# 创建一个新的CSV文件用于存储合并结果
merged_file = open('merged.csv', 'w', newline='')
writer = csv.writer(merged_file)

# 遍历每个CSV文件
for file in csv_files:
    with open(file, 'r') as csv_file:
        reader = csv.reader(csv_file)
        for row in reader:
            # 根据列索引提取需要合并的列数据
            merged_row = [row[i] for i in column_indexes]
            writer.writerow(merged_row)

# 关闭文件
merged_file.close()