如何在python3中读取、写入和更新CSV值

import csv

with open('file.csv', 'r') as csvfile:
    reader = csv.reader(csvfile)
    for row in reader:
        for value in row:
            print(value)

import csv

data = [
    ['Name', 'Age', 'City'],
    ['John', '25', 'New York'],
    ['Alice', '30', 'Los Angeles']
]

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

import csv

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

# 修改数据
data[1][1] = '26'  # 将第二行第二列的值更新为'26'

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