我有一个多索引数据帧,看起来像这样
Pool Lab_ID Units ... CV% CV SEM
Analysis_panel analyte ...
OXID F2A12I A M ng/mL ... 6.111037 0.061110 0.098823
F2A12I B M ng/mL ... 3.620595 0.036206 0.050259
F2A23D A N ng/mL ... 6.631863 0.066319 0.020186
F2A23D B N ng/mL ... 6.150949 0.061509 0.021566
F2A8IP B M ng/mL ... 2.227108 0.022271 0.002000
... ... ... ... ... ... ...
VOCs HPMA B N pmol/mL ... 4.444958 0.044450 27.313001
HPMA2 A N pmol/mL ... 14.437254 0.144373 16.838646
HPMA2 B M pmol/mL ... 15.010317 0.150103 21.588423
SPMA A M pmol/mL ... 12.959157 0.129592 0.041438
SPMA B N pmol/mL ... 11.961421 0.119614 0.054991
[276 rows x 11 columns]
我想把Lab\uid列作为另一个列索引排序-我希望我的最终df的结构如下
M N
Pool Units ... SEM Pool Units ... SEM
Analysis_panel analyte
OXID F2A12I
F2A12I
F2A23D
F2A23D
F2A8IP
... ... ... ... ... ... ...
VOCs HPMA
HPMA2
HPMA2
SPMA
SPMA
有没有简单的方法
这是可行的,尽管不能产生准确的预期产出:
输出:
相关问题 更多 >
编程相关推荐