比较两个json文件中的差异并找出差异

Question

我试图比较两个json文件之间的差异，并输出文件a中存在但文件b中不存在的r_id值列表

我正在尝试比较的Json文件

文件a=

   {“r_id”:”123”,"RefNumber”:”2341234131","amount":"22.99”},
   {“r_id”:”345”,"RefNumber”:”2341234131","amount":"22.99”},
   {“r_id”:”678”,"RefNumber”:”2341234131","amount":"22.99”}

文件b=

     {“name” : “James”, "id" : “123”, “class” : “1A”},
     {“name” : “Sam”,"id" : “345”, “class” : “1A”},
     {“name” : “Jen”,"id" : “005”, “class” : “1A”}

比较应基于两个文件中的id。在差异文件中需要以下输出

{“r_id”:”678”,"RefNumber”:”2341234131","amount":"22.99”}

Answer 1

如果ID不符合顺序并且JSON没有相同的项，这将起作用

import json

with open("json_a.json","r") as first, open("json_b.json","r") as second :
  b =  json.load(first,object_pairs_hook=lambda x: x[0])
  c =  json.load(second,object_pairs_hook=lambda x: x[1])

b = [ _[1] for _ in b]
c = [ _[1] for _ in c]

with open("json_a.json","r") as first:
  for each_line in json.load(first):
    for uniq_id in list(set(b).difference(c)):
      if each_line['r_id']== uniq_id :
        print(each_line)

另一种方法：

import json

with open("json_a.json","r") as first, open("json_b.json","r") as second :
  b =  json.load(first)
  c =  json.load(second)

b_ids=[x['r_id'] for x in b]

c_ids=[x['id'] for x in c]

for each_item in b:
  for uniq_id in list(set(b_ids).difference(c_ids)):
    if each_item['r_id'] == uniq_id:
      print(each_item)

写入文件：

# Serializing json
json_object = json.dumps(each_item)

# Writing to sample.json 
with open("sample.json", "w") as outfile: 
    outfile.write(json_object)

有关文件写入选项的更多详细信息，请参见here