如何合并三个dict、移除公共键值并按升序重排?附示例字典
三字典合并去重并按升序排序实现
明确执行规则
- 合并判定逻辑:某一个键如果出现在2个及以上的原始字典中,该键对应的整组键值对会被直接移除,不纳入最终合并结果
- 最终输出要求:所有保留下来的键值对,按照键的数值大小做升序排列
原始字典定义
import numpy as np dict1 = {99: [2.35, np.nan, 4.31], 200: [2.02, np.nan, np.nan], 314: [1.94, np.nan, np.nan], 749: [21.75, np.nan, np.nan], 964: [25.73, np.nan, np.nan], 1232: [64.42, np.nan, np.nan], 1486: [95.46, np.nan, np.nan], 1620: [120.96, np.nan, np.nan], 1851: [60.19, np.nan, np.nan], 1886: [57.64, np.nan, np.nan], 2034: [34.32, np.nan, np.nan], 2086: [35.16, np.nan, np.nan], 2368: [25.17, np.nan, np.nan]} dict2 = {101: [np.nan, 21.67, np.nan], 287: [np.nan, 20.23, np.nan], 738: [np.nan, 77.4, np.nan], 897: [np.nan, 86.6, np.nan], 1235: [np.nan, 138.77, np.nan], 1490: [np.nan, 187.46, np.nan], 1668: [np.nan, 216.83, np.nan], 1894: [np.nan, 130.03, np.nan], 2345: [np.nan, 75.26, 15.9]} dict3 = {99: [2.35, np.nan, 4.31], 205: [np.nan, np.nan, 4.08], 308: [np.nan, np.nan, 3.32], 448: [np.nan, np.nan, 5.79], 570: [np.nan, np.nan, 7.04], 748: [np.nan, np.nan, 10.85], 994: [np.nan, np.nan, 19.56], 1237: [np.nan, np.nan, 33.89], 1415: [np.nan, np.nan, 35.21], 1618: [np.nan, np.nan, 41.38], 1676: [np.nan, np.nan, 40.11], 1899: [np.nan, np.nan, 25.51], 1986: [np.nan, np.nan, 21.45], 2039: [np.nan, np.nan, 22.56], 2337: [np.nan, np.nan, 16.71], 2345: [np.nan, 75.26, 15.9]}
可直接运行的实现逻辑
- 遍历三个字典的所有键,统计每个键的独立出现次数
- 筛选出仅在单个字典中出现的键,收集对应键值对
- 对收集到的键值对按键的数值做升序排序,生成最终有序结果
from collections import OrderedDict # 统计每个键的出现频次 key_appear_count = {} for single_dict in [dict1, dict2, dict3]: for key in single_dict.keys(): key_appear_count[key] = key_appear_count.get(key, 0) + 1 # 筛选符合保留规则的键值对 valid_pairs = [] for single_dict in [dict1, dict2, dict3]: for key, value in single_dict.items(): if key_appear_count[key] == 1: valid_pairs.append((key, value)) # 按键升序排列生成最终结果 final_result = OrderedDict(sorted(valid_pairs, key=lambda item: item[0]))
结果核对说明
本次运算中需要被移除的公共键共2个:
- 键
99:同时存在于dict1、dict3 - 键
2345:同时存在于dict2、dict3
内容的提问来源于stack exchange,提问作者Muhammad Ahmad
相关产品推荐
相关产品推荐

