python更新csv文件中的单个值

import csv

# 打开csv文件
with open('file.csv', 'r') as file:
    # 读取csv数据
    csv_data = list(csv.reader(file))

    # 更新值
    row_index = 2  # 要更新的行索引
    column_index = 1  # 要更新的列索引
    new_value = 'New Value'  # 新的值
    csv_data[row_index][column_index] = new_value

# 写回csv文件
with open('file.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerows(csv_data)