python - 如何合并具有重复值的字典列表以创建嵌套字典？

Question

我有一个形式的字典:

[
    {
        "group_name": "CUSTOMER_RED",
        "interface": "ae4",
        "unit_name": 2520
    },
    {
        "group_name": "CUSTOMER_RED",
        "interface": "ae4",
        "unit_name": 4091
    },
    {
        "group_name": "CUSTOMER_BLUE",
        "interface": "ae4",
        "unit_name": 847
    },
    {
        "group_name": "CUSTOMER_BLUE",
        "interface": "ae4",
        "unit_name": 103
    }
}

我怎样才能将它合并成一个列表，如:

[
    {
        "group_name": "CUSTOMER_RED",
        "interface": "ae4",
        "unit_names": [2520, 4091]
    },
    {
        "group_name": "CUSTOMER_BLUE",
        "interface": "ae4",
        "unit_names": [847, 103]
    },
}

或者如果更简单:

[
    {
        "group_name": "CUSTOMER_RED",
        "interfaces": ["ae4": "unit_names": [2520, 4091]]
    },
    {
        "group_name": "CUSTOMER_BLUE",
        "interface": ["ae4": "unit_names": [847, 103]]
    },
}

我试过这个:

def merge_relevant_config(config):
    return_config = []
    for item in config:
        name = item['group_name']
        interface = item['interface']
        units = []
        for item in config:
            if item['group_name'] == name and item['interface'] == interface:
                units.append(item['unit_name'])
        return_config.append({
            'name': name,
            'interface': interface,
            'units': units
        })
    return return_config

但是这会返回重复项:

[
    {
        "name": "CUSTOMER_RED",
        "interface": "ae4",
        "units": [
            2520,
            4091
        ]
    },
    {
        "name": "CUSTOMER_RED",
        "interface": "ae4",
        "units": [
            2520,
            4091
        ]
    },
    {
        "name": "CUSTOMER_BLUE",
        "interface": "ae4",
        "units": [
            847,
            103
        ]
    },
    {
        "name": "CUSTOMER_BLUE",
        "interface": "ae4",
        "units": [
            847,
            103
        ]
    }
]

Answer 1

这是一种方法。

例如:

data = [
    {
        "group_name": "CUSTOMER_RED",
        "interface": "ae4",
        "unit_name": 2520
    },
    {
        "group_name": "CUSTOMER_RED",
        "interface": "ae4",
        "unit_name": 4091
    },
    {
        "group_name": "CUSTOMER_BLUE",
        "interface": "ae4",
        "unit_name": 847
    },
    {
        "group_name": "CUSTOMER_BLUE",
        "interface": "ae4",
        "unit_name": 103
    }
]

result = {}
for i in data:
    if i['group_name'] not in result:
        #if group by `group_name` & `interface` use --> result[(i['group_name'], i['interface'])]
        result[i['group_name']] = {'group_name': i['group_name'], 'interface': i['interface'], "unit_names": [i['unit_name']]}
    else:
        result[i['group_name']]["unit_names"].append(i['unit_name'])

print(list(result.values()))

输出:

[
    {
        'group_name': 'CUSTOMER_RED',
        'interface': 'ae4',
        'unit_names': [2520, 4091]
    },
    {
        'group_name': 'CUSTOMER_BLUE',
        'interface': 'ae4',
        'unit_names': [847, 103]
    }
]