如何使用帶有子節點的python迭代JSON？
uj5u.com熱心網友回復：
這是一種您可以讀取資料、清理資料（使用 false 洗掉漏洞）、對其進行排序，然后將其作為新檔案下載的方法。
import json
def base_score(item): # sorting function used in .sort()
# https://stackoverflow.com/questions/3121979/how-to-sort-a-list-tuple-of-lists-tuples-by-the-element-at-a-given-index
if 'baseMetricV3' not in item['impact']:
return (0, item['cve']['CVE_data_meta']['ID']) # no values are at a 0, therefore will sort by ID
return (item['impact']['baseMetricV3']['cvssV3']['baseScore'], item['cve']['CVE_data_meta']['ID']) # will also sort by ID if there are scores that are the same
with open('nvdcve-1.1-2022.json', 'r') as file: # read in the file and load it as a json format (similar to python dictionaries)
dict_data = json.load(file)
for CVE_Item in dict_data['CVE_Items']:
for node in CVE_Item['configurations']['nodes']:
# https://stackoverflow.com/questions/1207406/how-to-remove-items-from-a-list-while-iterating
node['cpe_match'][:] = [item for item in node['cpe_match'] if item['vulnerable']] # removing items while iterating through
if node['children']: # look at the children to see if they have any false vulnerable items and remove
for child_node in node['children']:
child_node['cpe_match'][:] = [item for item in child_node['cpe_match'] if item['vulnerable']] # removing items while iterating through
dict_data['CVE_Items'].sort(reverse=True, key=base_score) # sort the data and have it in descending order.
with open('cleaned_nvdcve-1.1-2022.json','w') as f: # write the file to the current working directory.
f.write(json.dumps(dict_data))
uj5u.com熱心網友回復：
該解決方案應該可以解決您最初的問題（使用“vulnerable:false”洗掉配置）。我使用了您在問題中提供的示例 json 資料。
import json
with open('data.json','r') as f:
data = json.load(f)
nodes = data.get('CVE_Items')[0].get('configurations').get('nodes')[0].get('cpe_match')
for index,node in enumerate(nodes):
if not node.get('vulnerable'):
nodes.pop(index)
with open('new_data.json','w') as f:
f.write(json.dumps(data))
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/525175.html
下一篇：回圈列印以x開頭的字串串列