擅长:python、mysql、java
<p>一种方法是将all-in-One与:<a href="https://pandas.pydata.org/pandas-docs/version/0.22/generated/pandas.pivot_table.html" rel="nofollow noreferrer">pivot_table</a>与默认值<code>aggfunc</code><code>numpy.mean</code>与<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.reset_index.html" rel="nofollow noreferrer">reset_index</a>和<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.rename_axis.html" rel="nofollow noreferrer">rename_axis</a>一起使用</p>
<pre><code>pd.pivot_table(df,index='id', columns = df.tp.astype(str).str.cat(df.dt.astype(str)), values="amt").reset_index(col_level=1).rename_axis(None, axis=1)
</code></pre>
<blockquote>
<p>Output:</p>
</blockquote>
<pre><code> id CR2017 CR2018 DR2017 DR2018
0 1 94678.0 13508.0 78671.0 13797.0
1 2 111417.0 21479.0 95266.0 1864.0
</code></pre>