将.csv文件保存在与.py文件相同的目录中

import csv

# 写入数据到.csv文件
data = [
    ['Name', 'Age', 'Gender'],
    ['John', '25', 'Male'],
    ['Lisa', '30', 'Female'],
    ['Tom', '35', 'Male']
]

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

print(f'Data has been written to {filename}.')

# 从.csv文件中读取数据
with open(filename, 'r') as file:
    reader = csv.reader(file)
    for row in reader:
        print(row)