如何将一列添加到多个具有不同值的.csv文件

import csv
import os

# 列数据
new_column_data = ['Value1', 'Value2', 'Value3']

# 文件夹路径
folder_path = 'path/to/csv/files'

# 遍历文件夹中的每个.csv文件
for filename in os.listdir(folder_path):
    if filename.endswith('.csv'):
        file_path = os.path.join(folder_path, filename)
        
        # 打开.csv文件并读取内容
        with open(file_path, 'r') as file:
            reader = csv.reader(file)
            rows = list(reader)
        
        # 添加新的列数据
        for i in range(len(rows)):
            rows[i].append(new_column_data[i])
        
        # 将更新后的内容写回到.csv文件中
        with open(file_path, 'w', newline='') as file:
            writer = csv.writer(file)
            writer.writerows(rows)