从嵌套的python字典导出csv

import csv

def export_nested_dict_to_csv(data, file_path):
    # 获取所有嵌套字典的键
    keys = set().union(*data.values())
    
    with open(file_path, 'w', newline='') as csvfile:
        writer = csv.DictWriter(csvfile, fieldnames=keys)
        writer.writeheader()
        
        # 递归遍历嵌套字典并写入CSV文件
        def write_dict_to_csv(dict_data):
            for key, value in dict_data.items():
                if isinstance(value, dict):
                    write_dict_to_csv(value)
                else:
                    dict_data[key] = str(value)
            writer.writerow(dict_data)
        
        write_dict_to_csv(data)

# 示例数据
data = {
    'name': 'John',
    'age': 30,
    'address': {
        'street': '123 Main St',
        'city': 'New York',
        'state': 'NY'
    }
}

# 导出为CSV文件
export_nested_dict_to_csv(data, 'output.csv')