数据框上差异变化的百分比 [英] Percentage of change of difference on a dataframe

问题描述

我有一个如下数据框，

                     SP        IS
group2      
Control             669303.62   0.00
Test - NonRedeemers 1888366.53  -1219062.91
Test - Redeemers    709095.22   -39791.60

我需要计算差异变化的百分比，我想使用的公式是(df['IS']/df.loc['Control'].iat[0])*100

I need to calculate the percentage of change of difference, The formulae I wanted to use is (df['IS']/df.loc['Control'].iat[0])*100

我应用了它，但是我需要绝对值的百分比. 任何帮助都非常感激

And I applied it but I need the percentage of absolute values. Any help is much appreciated

推荐答案

似乎您需要:

a = ((df['IS']/df.loc['Control'].iat[0])*100).abs()
print (a)
group2
Control                  0.000000
Test - NonRedeemers    182.138998
Test - Redeemers         5.945224
Name: IS, dtype: float64

---

a = df['IS'].div(df.loc['Control'].iat[0]).mul(100).abs()
print (a)
group2
Control                  0.000000
Test - NonRedeemers    182.138998
Test - Redeemers         5.945224
Name: IS, dtype: float64

这篇关于数据框上差异变化的百分比的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！