python - 如何合并 2 个 JSON 文件？

Question

有两个不同的 JSON 文件。

[{"volume": "44", 
"affiliations": {}, 
"cite_count": 39, 
"issue": "12", 
"page_range": "1257-1271", 
"doi": "10.1016/0584-8547(89)80124-7", 
"title_en": "test"}
]

[{"sourceType": "Conference Proceeding", 
"page_range": "1257-1271",
"language": null, 
"volume": null, 
"titleEn": "test2", 
"spinCiteCount": null}
]

如您所见，它们具有相同的信息，但形式不同。有些信息不在其他文件中。我需要将它们全部转换成一个 postgreSQL 表(或 JSON 文件并解析它)。

那么，如何用Python将不同格式的JSON文件合并到一个文件或一张postgres表中呢？

Answer 1

您可以将两者合并到一个字典/json 中:

import json

dic1 = json.load('json_file_1')
dic2 = json.load('json_file_2')
dic1.update(dic2)

print dic1

输出:

{
  "volume": "44", 
  "affiliations": {}, 
  "cite_count": 39, 
  "issue": "12", 
  "page_range": "1257-1271", 
  "doi": "10.1016/0584-8547(89)80124-7", 
  "title_en": "test2"
  "sourceType": "Conference Proceeding", 
  "language": None, 
  "volume": None, 
  "spinCiteCount": None
}

Note: the common keys will be overwritten by the values of the second file. So the order you read the files matters, based on what you need, change the order.