Python如何遍历嵌套json中的所有键和值以放入csv文件

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
            flatten_json(value, new_key, flattened_data)
    elif isinstance(json_data, list):
        for i, item in enumerate(json_data):
            new_key = parent_key + '.' + str(i) if parent_key else str(i)
            flatten_json(item, new_key, flattened_data)
    else:
        flattened_data[parent_key] = json_data

    return flattened_data

def write_to_csv(data, filename):
    with open(filename, 'w', newline='') as csvfile:
        writer = csv.writer(csvfile)
        writer.writerow(data.keys())
        writer.writerow(data.values())

# 假设你已经有一个嵌套的JSON数据
nested_json = {
    "name": "John",
    "age": 30,
    "address": {
        "street": "123 Main St",
        "city": "New York",
        "state": "NY"
    },
    "hobbies": ["reading", "coding", "gaming"]
}

# 将嵌套的JSON数据扁平化
flattened_data = flatten_json(nested_json)

# 将扁平化后的数据写入CSV文件
write_to_csv(flattened_data, 'output.csv')