擅长:python、mysql、java
<p>我将使用<a href="https://docs.python.org/3/library/collections.html#collections.Counter" rel="nofollow noreferrer">^{<cd1>}</a>计算答案,并<a href="https://docs.python.org/3/library/itertools.html#itertools.groupby" rel="nofollow noreferrer">^{<cd2>}</a>按国家对条目进行分组:</p>
<pre class="lang-py prettyprint-override"><code>from collections import Counter
from operator import itemgetter
from itertools import groupby
dictionary1 = {...} # input data
group_func = itemgetter('Country')
result = []
for (country, *_), items in groupby(sorted(dictionary1.values(), key=group_func), group_func):
answers = Counter(answer.lower() for i in items for answer in i['Answer'])
result.append(f'{country} {sum(answers.values())} {answers.get("yes", 0)} {answers.get("no", 0)}')
</code></pre>