<p>对熊猫来说,这是相当直截了当的。在</p>
<p><strong>代码:</strong></p>
<pre><code># read csv data into a dataframe
df = pd.read_csv(data, skipinitialspace=True)
# roll up by NA Sales
platform_roll_up = df.groupby('Platform')['NA_Sales'].sum()
# find row with max sales
idx_max = platform_roll_up.idxmax()
# show platform and sales for max
print(idx_max, platform_roll_up[idx_max])
</code></pre>
<p><strong>结果:</strong></p>
^{pr2}$
<p><strong>测试数据:</strong></p>
<pre><code>data = StringIO(u"""
Rank,Name,Platform,Year,Genre,Publisher,NA_Sales,EU_Sales,JP_Sales,Other_Sales,Global_Sales
1,Wii Sports,Wii,2006,Sports,Nintendo,41.49,29.02,3.77,8.46,82.74
2,Super Mario Bros.,NES,1985,Platform,Nintendo,29.08,3.58,6.81,0.77,40.24
3,Mario Kart Wii,Wii,2008,Racing,Nintendo,15.85,12.88,3.79,3.31,35.82
4,Wii Sports Resort,Wii,2009,Sports,Nintendo,15.75,11.01,3.28,2.96,33
5,Pokemon Red/Pokemon Blue,GB,1996,Role-Playing,Nintendo,11.27,8.89,10.22,1,31.37
6,Tetris,GB,1989,Puzzle,Nintendo,23.2,2.26,4.22,0.58,30.26
7,New Super Mario Bros.,DS,2006,Platform,Nintendo,11.38,9.23,6.5,2.9,30.01
8,Wii Play,Wii,2006,Misc,Nintendo,14.03,9.2,2.93,2.85,29.02
9,New Super Mario Bros. Wii,Wii,2009,Platform,Nintendo,14.59,7.06,4.7,2.26,28.62
10,Duck Hunt,NES,1984,Shooter,Nintendo,26.93,0.63,0.28,0.47,28.31
11,Nintendogs,DS,2005,Simulation,Nintendo,9.07,11,1.93,2.75,24.76
""")
</code></pre>