如何在python中执行此聚合-Howtocarryoutthisaggregationinpython

I have a more compact method.

我有一个更紧凑的方法。

I think it's more readable and easy to understand. You can refer as below:

我认为它更易读,更容易理解。你可以参考如下:

This is your var I delcare response:

这是你的var I delcare回复:

respOnse= [
    {'country': 'KR', 'values': ['Server1']},
    {'country': 'IE', 'values': ['Server1', 'Server3', 'Server2']},
    {'country': 'IE', 'values': ['Server1', 'Server3']},
    {'country': 'DE', 'values': ['Server1']},
    {'country': 'DE', 'values': ['Server2']},
]

Let's merge the values.

让我们合并这些值。

new_res = {}
for e in response:
    if e['country'] not in new_res:
        new_res[e['country']] = e['values']
    else:
        new_res[e['country']].extend(e['values'])

You can print new_res if you want to know its content. It's like as below:

如果您想了解其内容,可以打印new_res。它如下所示:

{
    'KR': ['Server1'],
    'DE': ['Server1', 'Server2'],
    'IE': ['Server1', 'Server3', 'Server2', 'Server1', 'Server3']
}

Invoking collections module collects elements:

调用集合模块收集元素:

from collections import Counter
new_list = []
for country, values in new_res.items():
    # elements are stored as dictionary keys and their counts are stored as dictionary values
    merge_values = Counter(values)

    # calculate percentage
    new_values = []
    total = sum(merge_values.values())    
    for server_name, num in merge_values.items():
        #ex: Server1-40.0
        new_values.append("{0}-{1:.1f}".format(server_name, num*100/total))

    percent = merge_values["Server1"]*1.0*100/total

    new_list.append({"country": country,
                     "percent": percent,
                     "values": new_values})

You can print new_list when finishing calculating result:

完成计算结果后可以打印new_list:

[{'country': 'KR', 'percent': 100.0, 'values': ['Server1-100.0']},
 {'country': 'DE', 'percent': 50.0,  'values': ['Server1-50.0', 'Server2-50.0']},
 {'country': 'IE', 'percent': 40.0,  'values': ['Server1-40.0', 'Server2-20.0', 'Server3-40.0']}]

So you can get answer you want.

所以你可以得到你想要的答案。

Let's say you have

让我们说你有

orig = [
    {'country': 'KR', 'values': ['Server1']},
    {'country': 'IE', 'values': ['Server1', 'Server3', 'Server2']},
    {'country': 'IE', 'values': ['Server1', 'Server3']},
    {'country': 'DE', 'values': ['Server1']},
    {'country': 'DE', 'values': ['Server2']},
]

You can create a new dictionary that has a list of what servers are in what countries and their counts

您可以创建一个新字典,其中列出了哪些服务器位于哪些国家/地区及其计数

newDict = {}
for c in orig:
    if c['country'] not in newDict:
        newDict[c['country']] = dict()
    for s in c['values']:
        if s in newDict[c['country']]:
            newDict[c['country']][s] = newDict[c['country']][s] + 1
        else:
            newDict[c['country']][s] = 1

which will be of the form:

其形式如下:

{'KR': {'Server1': 1}, 
 'DE': {'Server1': 1, 'Server2': 1}, 
 'IE': {'Server1': 2, 'Server2': 1, 'Server3': 2}}

You can then calculate the percentages as such:

然后,您可以计算百分比:

output = []
for country in newList:
    total = 0
    for server in newList[country]:
        total = total + newList[country][server]    
    output.append({"country": country, "percent": (100.0 * newList[country]['Server1'])/total})

which will produce

这将产生

[{'country': 'KR', 'percent': 100.0}, 
 {'country': 'DE', 'percent': 50.0}, 
 {'country': 'IE', 'percent': 40.0}]

I'll leave it as an exercise for the reader to optimize and add the other fields that you want

我将把它作为练习让读者优化并添加你想要的其他字段