使用Python在csv文件中的特定列上写入

name,age,city
Alice,30,New York
Bob,25,Los Angeles

import csv

# 读取原始 CSV 文件
with open('data.csv', mode='r', newline='') as infile:
    reader = csv.DictReader(infile)
    data = [row for row in reader]

# 修改 age 列
for row in data:
    row['age'] = int(row['age']) + 1

# 将修改后的数据写入新的 CSV 文件
with open('updated_data.csv', mode='w', newline='') as outfile:
    fieldnames = ['name', 'age', 'city']
    writer = csv.DictWriter(outfile, fieldnames=fieldnames)
    writer.writeheader()
    writer.writerows(data)

with open('data.csv', mode='r', encoding='utf-8-sig', newline='') as infile:
    reader = csv.DictReader(infile)
    data = [row for row in reader]

with open('updated_data.csv', mode='w', encoding='utf-8-sig', newline='') as outfile:
    fieldnames = ['name', 'age', 'city']
    writer = csv.DictWriter(outfile, fieldnames=fieldnames)
    writer.writeheader()
    writer.writerows(data)