以CSV格式打印JSON中的所有键和值

import csv
import json

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

    # 获取所有键
    keys = []
    for item in data:
        keys.extend(item.keys())
    keys = list(set(keys))  # 去重

    # 创建CSV文件并写入数据
    with open('output.csv', 'w', newline='') as csvfile:
        writer = csv.writer(csvfile)
        
        # 写入表头
        writer.writerow(keys)
        
        # 写入数据行
        for item in data:
            row = []
            for key in keys:
                if key in item:
                    row.append(item[key])
                else:
                    row.append('')
            writer.writerow(row)

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

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

# 调用函数打印JSON数据为CSV格式
print_json_as_csv(json_data)

name,age,city,occupation,hobby
John,30,New York,,
Alice,25,San Francisco,Engineer,
Bob,35,Seattle,,Gardening