将json取消嵌套到拆分为键列和值列的多个行

import json
import csv

def flatten_json(json_data):
    flattened_data = []
    
    def flatten(data, prefix=''):
        if isinstance(data, dict):
            for key, value in data.items():
                new_key = f"{prefix}.{key}" if prefix else key
                flatten(value, new_key)
        elif isinstance(data, list):
            for index, item in enumerate(data):
                new_key = f"{prefix}[{index}]" if prefix else str(index)
                flatten(item, new_key)
        else:
            flattened_data.append((prefix, data))
    
    flatten(json_data)
    return flattened_data

# 示例JSON数据
json_data = {
    "name": "John Doe",
    "age": 30,
    "address": {
        "street": "123 Main St",
        "city": "New York",
        "country": "USA"
    },
    "hobbies": ["reading", "traveling", "photography"]
}

# 将JSON数据取消嵌套并拆分为键列和值列
flattened_data = flatten_json(json_data)

# 将拆分后的数据存储到CSV文件
with open('flattened_data.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerow(['Key', 'Value'])
    writer.writerows(flattened_data)