擅长:python、mysql、java
<p>使用重塑和展平列标题多索引</p>
<pre><code>df_out = df.set_index(['SIGN','TYPE']).unstack('TYPE')
df_out.columns = [f'{i}_{j}' for i, j in df_out.columns]
print(df_out)
</code></pre>
<p>输出:</p>
<pre><code> TIME_10 TIME_20 \
SIGN
AAA2222 2017-01-01 01:57:00.000 NaN
ABC5245 2017-01-01 01:52:25.000 2017-01-01 01:53:22.000
DEF1111 2017-01-01 01:55:15.000 2017-01-01 01:57:00.000
ADDITIONAL_10 ADDITIONAL_20
SIGN
AAA2222 2017-01-01 01:39:04.000 NaN
ABC5245 2017-01-01 01:39:04.000 2017-01-01 02:39:04.000
DEF1111 2017-01-01 01:39:04.000 2017-01-01 03:39:04.000
</code></pre>