为特定列设置数据格式python csv

import csv

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

data = [
    ['Alice', 25, 95.5],
    ['Bob', 30, 88.2],
    ['Charlie', 27, 91.8]
]

with open('data.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    for row in data:
        row[2] = float(row[2])  # 将成绩列的数据格式设置为浮点数
        writer.writerow(row)