擅长:python、mysql、java
<p>要将<code>MultiIndex</code>转换为<code>Index</code>,请将列表理解与<a href="http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.pivot_table.html" rel="nofollow noreferrer">^{<cd3>}</a>一起使用以避免错误:</p>
<blockquote>
<p>Index contains duplicate entries, cannot reshape </p>
</blockquote>
<hr/>
<pre><code>df2_SEX_AGE=df1.pivot_table(index='codprg',
columns=['SEX','ETA'],
values='counts',
aggfunc='sum')
df2_SEX_AGE.columns = [f'{a}{b}' for a, b in df2_SEX_AGE.columns]
</code></pre>