擅长:python、mysql、java
<p>您可以在列级别执行列表理解,并使用下划线连接,然后调用<code>reset_index</code>:</p>
<pre><code>In [39]:
grouped.columns= ['_'.join(x) for x in list(zip(grouped.columns.get_level_values(0), grouped.columns.get_level_values(1)))]
grouped = grouped.reset_index()
grouped
Out[39]:
city day cats_mean cats_std people_mean people_std
0 Berlin Friday 6.140710 0.555981 10.187634 0.359724
1 Berlin Monday 6.420175 0.986568 10.134376 0.963938
2 Oslo Friday 6.978572 0.573297 11.345484 1.454762
3 Oslo Monday 4.594814 NaN 10.842988 NaN
</code></pre>