Python -如何格式化csv文件中的抓取数据？

import csv

# 假设这是你抓取的数据
data = [
    {"name": "Alice", "age": 30, "city": "New York"},
    {"name": "Bob", "age": 25, "city": "Los Angeles"},
    {"name": "Charlie", "age": 35, "city": "Chicago"}
]

# 定义CSV文件的列名
fieldnames = ["name", "age", "city"]

# 写入CSV文件
with open('output.csv', 'w', newline='', encoding='utf-8') as csvfile:
    writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
    
    # 写入列名
    writer.writeheader()
    
    # 写入数据
    for row in data:
        writer.writerow(row)

with open('output.csv', 'w', newline='', encoding='utf-8') as csvfile:
    writer = csv.writer(csvfile, quoting=csv.QUOTE_ALL)
    writer.writerow(["name", "age", "city"])
    writer.writerow(["Alice", "30", "New York"])

with open('output.csv', 'w', newline='', encoding='utf-8') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerow(["姓名", "年龄", "城市"])
    writer.writerow(["Alice", "30", "New York"])