如何循环遍历多个 .json 文件

20 浏览
0 Comments

如何循环遍历多个 .json 文件

这个问题已经在这里有答案了：

如何迭代遍历给定目录中的文件？

我有许多在同一目录中具有相同结构的 .json 文件。 我想创建一个独特的 csv 文件，其中包含每个 json 文件的一些键的值。

循环遍历单个文件时，一切都运行良好。 下面是脚本的快照：

import json, os
import csv
input_file = open ('JSON/test.json')
json_array = json.load(input_file)
object_list = []
for obj in json_array:
    for item in obj['objects']:
        object_details = {"_system_object_id":None,"preview_url":None,"original_download_url":None,"original_url":None}
        object_details['_system_object_id'] = item['_system_object_id']
        try:
            object_details['preview_url'] = item['do']['do_digitalobject'][0]['versions']['preview']['url']
        except:
            print("not found")
        try:
            object_details['original_download_url'] = item['do']['do_digitalobject'][0]['versions']['original']['download_url']
        except:
            print("not found")
        try:
            object_details['original_url'] = item['do']['do_digitalobject'][0]['versions']['original']['url']
        except:
            print("not found")
        #object_details['type'] = item['type']
        object_list.append(object_details)
    print(object_list)

如何处理文件夹中的所有 .json 文件？

谢谢

admin 更改状态以发布 2023年5月21日
0

1 答案

0 Comments

使用 listdir，可以在指定的目录中找到所有的 .json 文件，然后对它们进行迭代并应用你的逻辑：

from os import listdir
from os.path import isfile, join
import json
dir_path = "full/path/to/dir"
object_list = []
# get all json full paths of the json files in dir_path
all_json_files = [join(dir_path, f) for f in listdir(dir_path) if isfile(join(dir_path, f)) and f.endswith(".json")]
# iterate over the paths and apply your logic
for file_path in all_json_files:
    with open(file_path) as input_file:
        json_array = json.load(input_file)
        for obj in json_array:
            # your business logic
            object_list.append(object_details)
print(object_list)

0