,可以通过以下步骤实现:
- 导入所需的Python库:import os
import json
import csv
- 定义一个函数来遍历文件夹并读取JSON文件:def read_json_files(folder_path):
json_data = []
for root, dirs, files in os.walk(folder_path):
for file in files:
if file.endswith(".json"):
file_path = os.path.join(root, file)
with open(file_path, 'r') as json_file:
data = json.load(json_file)
json_data.append(data)
return json_data
- 定义一个函数来将JSON数据导出到以制表符分隔的单独文件中:def export_to_csv(json_data, output_file):
with open(output_file, 'w', newline='') as csv_file:
writer = csv.writer(csv_file, delimiter='\t')
writer.writerow(json_data[0].keys()) # 写入表头
for data in json_data:
writer.writerow(data.values()) # 写入数据行
- 调用函数进行处理:folder_path = "文件夹路径"
output_file = "输出文件路径"
json_data = read_json_files(folder_path)
export_to_csv(json_data, output_file)
这样,多个文件夹中的JSON集合就会被导出到以制表符分隔的单独文件中。你可以根据实际情况修改文件夹路径和输出文件路径。