是否使用Python在csv文件中添加新列？

import csv

with open('file.csv', 'r') as file:
    reader = csv.reader(file)
    rows = list(reader)
    
with open('file.csv', 'w', newline='') as file:
    writer = csv.writer(file)

header = rows[0]
header.append('new_column')
writer.writerow(header)

for row in rows[1:]:
    # 假设要添加的新列值为 'new_value'
    row.append('new_value')
    writer.writerow(row)

file.close()