在Python 3.7中将嵌套JSON转换为CSV

import json
import csv

# 从文件中读取JSON
with open('data.json', 'r') as file:
    json_data = json.load(file)

# 或者直接使用JSON字符串
json_data = '''
{
  "name": "John",
  "age": 30,
  "address": {
    "street": "123 Street",
    "city": "New York"
  },
  "hobbies": ["reading", "coding", "gaming"]
}
'''

def flatten_json(json_data, prefix=''):
    flattened_data = {}
    for key, value in json_data.items():
        new_key = prefix + '_' + key if prefix else key
        if isinstance(value, dict):
            flattened_data.update(flatten_json(value, new_key))
        elif isinstance(value, list):
            for i, item in enumerate(value):
                flattened_data.update(flatten_json(item, new_key + '_' + str(i)))
        else:
            flattened_data[new_key] = value
    return flattened_data

flattened_json = flatten_json(json_data)

# 获取所有键名作为CSV的表头
fieldnames = flattened_json.keys()

# 创建CSV文件并写入表头
with open('data.csv', 'w', newline='') as file:
    writer = csv.DictWriter(file, fieldnames=fieldnames)
    writer.writeheader()

    # 写入数据行
    writer.writerow(flattened_json)