更新csv文件中特定列中的行(Python)

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]  # 获取CSV文件的标题行
column_index = header.index('column_name')  # 替换'column_name'为目标列的名称

for row in rows[1:]:  # 从第二行开始遍历每一行
    row[column_index] = 'new_value'  # 替换'new_value'为要更新的值

    writer.writerow(row)  # 将更新后的行写入新的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]
    column_index = header.index('column_name')

    for row in rows[1:]:
        row[column_index] = 'new_value'

        writer.writerow(row)