擅长:python、mysql、java
<p>使用:</p>
<pre><code>df.set_index(['ID','Segment'])['Var']\
.unstack()\
.add_prefix('Segment')\
.rename_axis([None], axis=1)\
.reset_index()
</code></pre>
<p>输出:</p>
^{pr2}$
<p>选项2:</p>
<pre><code>pd.crosstab(df.ID,df.Segment,df.Var,aggfunc='first')
</code></pre>