如何将嵌套的JSON转换为CSV？

import json
import csv

def flatten_json(json_data, parent_key='', separator='.'):
    flattened_data = {}
    for key, value in json_data.items():
        new_key = f"{parent_key}{separator}{key}" if parent_key else key
        if isinstance(value, dict):
            flattened_data.update(flatten_json(value, new_key, separator))
        else:
            flattened_data[new_key] = value
    return flattened_data

# 假设嵌套的JSON数据存储在json_data变量中
json_data = {
    "name": "John",
    "age": 30,
    "address": {
        "street": "123 Main St",
        "city": "New York",
        "state": "NY"
    },
    "hobbies": ["reading", "traveling"]
}

# 将嵌套的JSON数据转换为扁平化的字典
flattened_data = flatten_json(json_data)

# 将字典数据写入CSV文件
csv_file = open('output.csv', 'w', newline='')
csv_writer = csv.writer(csv_file)
csv_writer.writerow(flattened_data.keys())
csv_writer.writerow(flattened_data.values())
csv_file.close()