如何使用json数据格式化csv文件？

import csv
import json

# 示例json数据
json_data = '''
[
    {
        "name": "John",
        "age": 30,
        "city": "New York"
    },
    {
        "name": "Alice",
        "age": 25,
        "city": "San Francisco"
    },
    {
        "name": "Bob",
        "age": 35,
        "city": "Seattle"
    }
]
'''

# 解析json数据为Python对象
data = json.loads(json_data)

# 创建csv文件并打开进行写入操作
with open('output.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)

    # 写入标题行
    writer.writerow(data[0].keys())

    # 写入数据行
    for item in data:
        writer.writerow(item.values())

print("CSV文件已生成。")