擅长:python、mysql、java
<pre><code>In [115]: (df.pivot_table(index=['A','B','C'], columns='Property', values='Value',
...: aggfunc='first', fill_value='-')
...: .reset_index()
...: .rename_axis(None,1))
...:
Out[115]:
A B C prop1 prop2 prop9
0 Bob b100 X1 a b -
1 Bob b100 X2 c - -
2 Bob b100 Y1 a - -
3 Bob b100 Z - - b
4 Bob b200 X1 c d -
</code></pre>
<p>或使用<code>unstack</code>:</p>
<pre><code>In [124]: (df.set_index(['A','B','C','Property'])
...: ['Value'].unstack('Property', fill_value='-')
...: .reset_index()
...: .rename_axis(None,1))
...:
Out[124]:
A B C prop1 prop2 prop9
0 Bob b100 X1 a b -
1 Bob b100 X2 c - -
2 Bob b100 Y1 a - -
3 Bob b100 Z - - b
4 Bob b200 X1 c d -
</code></pre>