Python将文件夹目录中的多个JSON文件转换为CSV

import os
import json
import csv

def json_to_csv(json_file, csv_file):
    with open(json_file, 'r') as f:
        data = json.load(f)
    
    with open(csv_file, 'w', newline='') as f:
        writer = csv.writer(f)
        
        # 写入CSV文件的表头
        writer.writerow(data[0].keys())
        
        # 写入CSV文件的数据
        for item in data:
            writer.writerow(item.values())

def convert_folder_to_csv(folder_path):
    for file_name in os.listdir(folder_path):
        if file_name.endswith('.json'):
            json_file = os.path.join(folder_path, file_name)
            csv_file = os.path.join(folder_path, file_name.replace('.json', '.csv'))
            json_to_csv(json_file, csv_file)

folder_path = '/path/to/folder'
convert_folder_to_csv(folder_path)