擅长:python、mysql、java
<p>我认为<code>MultiIndex</code>应该有帮助:</p>
<pre><code>#set all not R columns to index
df = df.set_index(['ID'])
#create multiindex
df.columns = df.columns.str.split(expand=True)
#custom reordering
df = df.reindex(columns=['App','Pear','Oro'], level=0)
print (df)
App Pear Oro
R1 R2 R3 R1 R2 R3 R1 R2 R3
ID
1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 1
</code></pre>
<hr/>
^{pr2}$