擅长:python、mysql、java
<p>或者,您可以只设置<code>multiindex</code>和<code>unstack</code>:</p>
<pre><code>In []:
L = ['ABC', 'GHI']
df = df.set_index(['ID', 'var_name'])['var_value'].unstack(fill_value='')[L].reset_index()
df
Out[]:
var_name ID ABC GHI
0 1 This is abc1
1 2 This is abc2 This is ghi2
2 3 This is abc3
3 4 This is abc4
In []:
[df.columns.tolist()] + df.values.tolist()
Out[]:
[['ID', 'ABC', 'GHI'],
[1, 'This is abc1', ''],
[2, 'This is abc2', 'This is ghi2'],
[3, 'This is abc3', ''],
[4, 'This is abc4', '']]
</code></pre>