擅长:python、mysql、java
<p>我想你可以用:</p>
<pre><code>#if need select only few columns - df.columns[1:3]
df = df.pivot_table(columns=['Order'], values=df.columns[1:3], aggfunc='count')
print (df)
Order completed iProgress
apple 4 2
orange 4 2
</code></pre>
<hr/>
^{pr2}$
<p><a href="https://stackoverflow.com/questions/33346591/what-is-the-difference-between-size-and-count-in-pandas">What is the difference between size and count in pandas?</a></p>
<pre><code>df = df.pivot_table(columns=['Order'], aggfunc=len)
print (df)
Order completed iProgress
apple 4 2
banana 4 2
orange 4 2
pear 4 2
pineapple 4 2
</code></pre>
<hr/>
<pre><code>#solution with groupby and transpose
df = df.groupby('Order').count().T
print (df)
Order completed iProgress
apple 4 2
orange 4 2
banana 4 2
pear 4 2
pineapple 4 2
</code></pre>