您可以选择所有行并使用切片df
loc,然后使用调用
div并传递最后一行
iloc[-1]:
In [58]:df.loc[:,'C14-Cer_mean':] = df.loc[:,'C14-Cer_mean':].div(df.iloc[-1]['C14-Cer_mean':])dfOut[58]: Sample_name C14-Cer_mean C16-Cer_mean C18-Cer_mean C18:1-Cer_meanindex0 1 1 0.305224 0.542487 66.4284 73.61531 1 10 0.814694 1.24617 73.8026 58.06462 1 13 0.556437 0.517383 50.5559 51.91373 1 14 0.314057 1.14875 56.1658 61.26224 1 5 0.499128 0.460814 40.1824 41.77115 1 6 0.300203 0.784066 47.3595 52.8426 1 9 0.395581 1.08206 54.0198 58.7737Blank 1 1 1 1



