从JSON编写CSV，仅导入给定的密钥

import json
import csv

def json_to_csv(json_data, keys):
    # 解析JSON数据
    data = json.loads(json_data)
    
    # 提取指定密钥对应的数据
    extracted_data = []
    for item in data:
        extracted_item = {}
        for key in keys:
            extracted_item[key] = item.get(key, '')
        extracted_data.append(extracted_item)
    
    # 创建CSV文件并写入数据
    with open('output.csv', 'w', newline='') as csvfile:
        writer = csv.DictWriter(csvfile, fieldnames=keys)
        writer.writeheader()
        writer.writerows(extracted_data)

# 示例JSON数据
json_data = '''
[
    {
        "name": "Alice",
        "age": 25,
        "email": "alice@example.com",
        "address": "123 Main St"
    },
    {
        "name": "Bob",
        "age": 30,
        "email": "bob@example.com",
        "address": "456 Elm St"
    }
]
'''

# 指定要导入的密钥
keys = ['name', 'email']

# 调用函数进行转换
json_to_csv(json_data, keys)