如何将JSON转换为CSV

import csv
import json

def json_to_csv(json_data):
    # 解析JSON数据
    data = json.loads(json_data)
    
    # 提取字段
    fields = list(data[0].keys())
    
    # 创建CSV文件并写入数据
    with open('output.csv', 'w', newline='') as csvfile:
        writer = csv.DictWriter(csvfile, fieldnames=fields)
        writer.writeheader()
        writer.writerows(data)
    
    print("JSON转换为CSV成功！")

# 示例JSON数据
json_data = '[{"name": "John", "age": 30, "city": "New York"}, {"name": "Alice", "age": 25, "city": "London"}]'

# 调用函数进行转换
json_to_csv(json_data)