在缺少字段名的情况下将JSON转换为CSV

import json
import csv

def json_to_csv(json_data):
    # 解析JSON数据
    data = json.loads(json_data)

    # 提取字段名
    field_names = set()
    for item in data:
        field_names.update(item.keys())

    # 创建CSV文件
    with open('output.csv', 'w', newline='') as csvfile:
        writer = csv.writer(csvfile)

        # 写入字段名
        writer.writerow(field_names)

        # 写入数据
        for item in data:
            row = [item.get(field, '') for field in field_names]
            writer.writerow(row)

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

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