将嵌套的json转换为csv，其中每一行都包含最内层的值和所有父值

import json
import csv

def flatten_json(json_data, parent_key='', flattened_data=None):
    if flattened_data is None:
        flattened_data = {}

    if isinstance(json_data, dict):
        for key, value in json_data.items():
            new_key = parent_key + '_' + key if parent_key else key
            if isinstance(value, (dict, list)):
                flatten_json(value, new_key, flattened_data)
            else:
                flattened_data[new_key] = value

    elif isinstance(json_data, list):
        for index, item in enumerate(json_data):
            new_key = parent_key + '_' + str(index) if parent_key else str(index)
            if isinstance(item, (dict, list)):
                flatten_json(item, new_key, flattened_data)
            else:
                flattened_data[new_key] = item

    return flattened_data

def convert_json_to_csv(json_data):
    flattened_data = flatten_json(json_data)
    csv_data = [flattened_data.keys()] + [flattened_data.values()]

    with open('output.csv', 'w', newline='') as csvfile:
        writer = csv.writer(csvfile)
        writer.writerows(csv_data)

# 示例JSON数据
json_data = {
    "name": "John",
    "age": 30,
    "address": {
        "street": "123 Street",
        "city": "New York",
        "country": "USA"
    },
    "hobbies": ["reading", "coding", "gaming"]
}

convert_json_to_csv(json_data)

name,age,address_street,address_city,address_country,hobbies_0,hobbies_1,hobbies_2
John,30,123 Street,New York,USA,reading,coding,gaming