如何将动态嵌套的json转换为csv？

import json
import csv

def json_to_csv(json_data, csv_file):
    # 解析JSON数据
    data = json.loads(json_data)
    
    # 递归遍历JSON数据
    def traverse(data, prefix=''):
        if isinstance(data, dict):
            for key, value in data.items():
                new_prefix = prefix + key + '.'
                traverse(value, new_prefix)
        elif isinstance(data, list):
            for item in data:
                traverse(item, prefix)
        else:
            # 构建CSV行数据
            csv_writer.writerow([prefix[:-1], data])
    
    # 构建CSV表头
    csv_writer = csv.writer(csv_file)
    csv_writer.writerow(['Key', 'Value'])
    
    # 构建CSV行数据
    traverse(data)
    
    # 写入CSV文件
    csv_file.close()

# 示例用法
json_data = '{"name": "John", "age": 30, "address": {"city": "New York", "country": "USA"}}'
csv_file = open('output.csv', 'w', newline='')
json_to_csv(json_data, csv_file)