擅长:python、mysql、java
<p>带有<code>cumcount</code>和<code>unstack</code>的简单<code>set_index</code></p>
<pre><code>df_final = df.set_index([df.groupby('key').cumcount(),'key'])['values'].unstack()
Out[423]:
key ID Interface Line-Status State
0 9000 InterfaceA Up Up
1 9001 InterfaceB Down Down
</code></pre>
<p>另一种方法是使用<code>pd.crosstab</code></p>
<pre><code>df_final = pd.crosstab(df.groupby('key')['values'].cumcount(),
df['key'],
df['values'], aggfunc='first')
Out[424]:
key ID Interface Line-Status State
row_0
0 9000 InterfaceA Up Up
1 9001 InterfaceB Down Down
</code></pre>