在Python中联合多个嵌套JSON

Question

我有多个json文件，其中包含需要合并的关系数据，每个文件都有一个带有commonkey的记录，这是所有文件中的公共键，在下面的示例中，a0，a1是公共键。值是多个键的嵌套字典，如Key1、key2等，如下所示，我需要合并多个json文件并获得如dboutput.json所示的输出，文件名在合并操作中充当索引。这样的问题是一个相关的问题，它合并了丢失的信息，但在我的情况下，我不希望任何更新替换现有的键或跳过更新，如果击中现有的键，将创建另一个由文件名索引的嵌套字典，如下所示：

示例：

"a0": {
        "commonkey": [
            "a1", 
            "parentkeyvalue1"
        ], 
        "key1": "kvalue1", 
        "key2": "kvalue2"
        "keyp": "kvalue2abc"

    }, 
"a1": { 
...
}

"a0": {
        "commonkey": [
            "a1", 
            "parentkeyvalue1"
        ], 
        "key1": "kvalue1xyz", 
        "key2": "kvalue2",
        "key3": "kvalue2"



    }, 

"a1": { 
...
}

"a0": {
        "commonkey": [
            "a1", 
            "parentkeyvalue1"
        ], 
        "key1": {"db1":"kvalue1","db2":"kvalue1xyz"} ,
        "key2": {"db1":"kvalue2","db2":"kvalue2"} ,
        "key3": {"db2":"kvalue2"}
        "keyp": {"db1":"kvalue2abc"}



    }, 
"a1": { 
...
}

"commonkey": [
            "a1", 
            "parentkeyvalue1"
        ],

Answer 1

一个简单的解决方案是遍历每个JSON对象，并在每个“Commonkey”中添加字典对。这里有一个示例，您在列表中加载每个JSON文件，然后迭代合并它们。

#!/usr/bin/python
import json

# Hardcoded list of JSON files
dbs = [ "db1.json", "db2.json" ]
output = dict() # stores all the merged output

for db in dbs:
    # Name the JSON obj and load it 
    db_name = db.split(".json")[0]
    obj = json.load(open(db))

    # Iterate through the common keys, adding them only if they're new
    for common_key, data in obj.items():
        if common_key not in output:
            output[common_key] = dict(commonkey=data["commonkey"])

        # Within each common key, add key, val pairs 
        # subindexed by the database name
        for key, val in data.items():
            if key != "commonkey":
                if key in output[common_key]:
                    output[common_key][key][db_name] = val
                else:
                    output[common_key][key] = {db_name: val}


# Output resulting json to file
open("dboutput.json", "w").write( 
    json.dumps( output, sort_keys=True, indent=4, separators=(',', ': ') )
)