这是你的问题的简化版本。您可以将AwardsDict“value”字典按NSN分组,然后进行比较和匹配。在RFQDict = {
'a': {'Add_method': 'D1', 'NSN': '9905'},
'b': {'Add_method': 'D2', 'NSN': '9906'},
'c': {'Add_method': 'D3', 'NSN': '9907'},
'd': {'Add_method': 'D4', 'NSN': '9908'}
}
AwardsDict = {
'W21': {'Awarddate': '08-13-2007', 'Awardid': '1', 'NSN': '9906'},
'W22': {'Awarddate': '08-14-2007', 'Awardid': '2', 'NSN': '9905'},
'W23': {'Awarddate': '08-15-2007', 'Awardid': '3', 'NSN': '9908'},
'W24': {'Awarddate': '08-16-2007', 'Awardid': '4', 'NSN': '9907'},
}
# First create a new dictionary with "NSN" as keys and awards as matches
nsn_awards = {v['NSN']: v for v in AwardsDict.values()}
# go through all values of RFQDict and find a match by
# looking up the its NSN in the nsn_awards_dict
matches = [(rfq, nsn_awards[rfq['NSN']]) for rfq in RFQDict.values()]
print(matches)
印刷品:
^{pr2}$
请注意,这给了我们一个O(n)解决方案,但折衷的是为我们创建的dict留出空间。在
如果有可能您的nsn在AwardsDict中没有匹配,您可以在创建匹配之前执行一个简单的if nsn in nsn_awards检查。为了更好地解释,这里有一个没有列表理解的版本:matches = []
for rfq in RFQDict.values():
if rfq['NSN'] in nsn_awards: # only append if there's a match
nsn = rfq['NSN']
matches.append((rfq, nsn_awards[nsn]))