擅长:python、mysql、java
<p>你可以使用<code>set_index</code>和<code>unstack</code></p>
<pre><code>In [2]: df.set_index(['id','module'])['count'].unstack().add_suffix('_count').reset_index()
Out[2]:
module id general_count payroll_count tax_count
0 2 53.0 5.0 NaN
1 5 NaN NaN 35.0
</code></pre>