擅长:python、mysql、java
<p>您可以使用<a href="http://pandas.pydata.org/" rel="nofollow">the Pandas module</a>,它非常适合这种类型的应用程序:</p>
<pre><code>import pandas as pd
df = pd.read_csv('songfestival.csv')
gb = df.groupby('Country')
res = pd.concat([i[1].sum(numeric_only=True) for i in gb], axis=1).T
res.pop('Year')
order = [i[0] for i in gb]
print(order)
print(res)
#['Israel', 'Lithuania']
# Albania Andorra Armenia Austria Azerbaijan
#0 1 9 2 0 4
#1 1 5 1 0 9
</code></pre>
<p>要查询每个列的结果,只需执行以下操作:</p>
^{pr2}$