以下是一个示例Python程序,可以遍历指定目录下的所有JSON文件,计算每个JSON文件中的键(key)和值(value)的数量,并将结果输出到Excel文件中。请确保您已安装openpyxl
库,用于操作Excel文件。
import os
import json
from openpyxl import Workbook
def count_keys_values(json_data):
keys_count = 0
values_count = 0
if isinstance(json_data, dict):
keys_count = len(json_data.keys())
for value in json_data.values():
if isinstance(value, (dict, list)):
recursive_counts = count_keys_values(value)
keys_count += recursive_counts[0]
values_count += recursive_counts[1]
else:
values_count += 1
elif isinstance(json_data, list):
for item in json_data:
recursive_counts = count_keys_values(item)
keys_count += recursive_counts[0]
values_count += recursive_counts[1]
return keys_count, values_count
def process_json_files(directory):
wb = Workbook()
ws = wb.active
ws.append(["File Name", "Keys Count", "Values Count"])
for root, dirs, files in os.walk(directory):
for file in files:
if file.endswith(".json"):
file_path = os.path.join(root, file)
with open(file_path, "r") as json_file:
try:
json_data = json.load(json_file)
counts = count_keys_values(json_data)
ws.append([file, counts[0], counts[1]])
except json.JSONDecodeError:
print(f"Failed to parse JSON file: {file_path}")
output_file = "json_counts.xlsx"
wb.save(output_file)
print(f"Results saved to {output_file}")
# 指定要遍历的目录
directory_to_process = "your_directory_path"
# 执行遍历和计数,并将结果保存到Excel文件
process_json_files(directory_to_process)
将上述代码中的"your_directory_path"替换为要遍历的目录的路径。运行该程序后,它将遍历指定目录下的所有JSON文件,计算每个JSON文件中的键和值的数量,并将结果保存到名为"json_counts.xlsx"的Excel文件中。每个行包含文件名、键的数量和值的数量。
请确保您已安装所需的库,并将程序中的路径替换为适当的目录路径,然后运行程序即可。