擅长:python、mysql、java
<p>删除额外的列、groupby、sum和reset\u index应该可以得到输出</p>
<pre><code>>>> df=pd.DataFrame(data=[[729910, 13, 162],[729910, 14, 283],[730855,13,1],[731449, 13,2]], columns=['article','day', 'views'])
>>> df
article day views
0 729910 13 162
1 729910 14 283
2 730855 13 1
3 731449 13 2
>>> df[['article','views']].groupby('article').sum().reset_index()
article views
0 729910 445
1 730855 1
2 731449 2
</code></pre>