如何使用python更新带有逗号分隔文件的值的现有csv文件

import csv

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

for row in rows:
    row[2] = 'new value'  # 更新第三列的值

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

import csv

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

for row in rows:
    row[2] = 'new value'  # 更新第三列的值

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