擅长:python、mysql、java
<p>groupby上的<code>count</code>将返回唯一行的所有计数,然后选择amount并重命名该列将执行此操作。在</p>
<pre><code>data.groupby(['Store','Company','product'],as_index='False').count()['Amount'].rename('count').reset_index()
Store Company product count
0 A comapny_z A003 5
1 A company_x A001 5
2 A company_y A002 5
3 B comapny_x A001 5
4 B company_y A002 5
5 B company_z A003 5
</code></pre>