将JSON (在嵌套键值中)解析为CSV

import json
import csv

def parse_json_to_csv(json_data):
    # 解析JSON数据
    data = json.loads(json_data)
    
    # 提取字段值
    headers = []
    rows = []
    
    def extract_data(obj, path=''):
        if isinstance(obj, dict):
            for key, value in obj.items():
                new_path = f"{path}.{key}" if path else key
                extract_data(value, new_path)
        elif isinstance(obj, list):
            for item in obj:
                extract_data(item, path)
        else:
            headers.append(path)
            rows.append(obj)
    
    extract_data(data)
    
    # 构建CSV文件
    with open('output.csv', 'w', newline='') as csvfile:
        writer = csv.writer(csvfile)
        
        # 写入表头
        writer.writerow(headers)
        
        # 写入数据行
        writer.writerow(rows)

# 示例JSON数据
json_data = '''
{
    "name": "John",
    "age": 30,
    "address": {
        "street": "123 Main St",
        "city": "New York"
    },
    "hobbies": ["reading", "music", "sports"]
}
'''

# 调用函数进行解析
parse_json_to_csv(json_data)