在python中从多个JSON文件中提取信息到单个CSV文件

import json
import csv
import os

def extract_info_from_json(json_file):
    with open(json_file, 'r') as file:
        data = json.load(file)
        # 提取所需的信息
        info = data['key']
        return info

def extract_info_from_directory(directory):
    info_list = []
    for filename in os.listdir(directory):
        if filename.endswith('.json'):
            json_file = os.path.join(directory, filename)
            info = extract_info_from_json(json_file)
            info_list.append(info)
    return info_list

def write_info_to_csv(info_list, csv_file):
    with open(csv_file, 'w', newline='') as file:
        writer = csv.writer(file)
        # 写入CSV文件的标题行
        writer.writerow(['Column 1', 'Column 2', 'Column 3'])
        # 写入提取的信息
        for info in info_list:
            writer.writerow([info['value1'], info['value2'], info['value3']])

directory = 'path/to/json/files'
csv_file = 'path/to/output.csv'

info_list = extract_info_from_directory(directory)
write_info_to_csv(info_list, csv_file)