将嵌套字典写入CSV

import csv

data = [
    {
        'name': 'Alice',
        'age': 25,
        'address': {
            'city': 'New York',
            'state': 'NY'
        }
    },
    {
        'name': 'Bob',
        'age': 30,
        'address': {
            'city': 'San Francisco',
            'state': 'CA'
        }
    }
]

# 定义CSV文件的字段名
fieldnames = ['name', 'age', 'city', 'state']

# 打开CSV文件并写入数据
with open('data.csv', 'w', newline='') as csvfile:
    writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
    
    # 写入表头
    writer.writeheader()
    
    # 写入数据
    for item in data:
        row = {
            'name': item['name'],
            'age': item['age'],
            'city': item['address']['city'],
            'state': item['address']['state']
        }
        writer.writerow(row)