如何在python中进行计算？

Question

我的数据帧由“确认”、“死亡”和“恢复”列组成。我需要添加新的列“死亡率%”和“恢复率%”

计算公式如下：

Death Rate % =  Death / Confirmed × 100

及

Recovery Rate % = Recovered / Confirmed × 100

我对此没有任何想法。非常感谢你的帮助

Answer 1

df['Death Rate'] = (df['Death'] / df['Confirmed']) * 100
df['Recovery Rate'] =  (df['Recovered'] / df['Confirmed']) * 100

Answer 2

假设您有一个名为df的数据帧

df = pd.DataFrame({'Confirmed': [100, 200, 300],
                     'Death': [10, 40, 90], 
                     'Recovered': [45, 60, 50]})

# this code will add the columns 'Death Rate' and 'Recovery Rate'

df['Death Rate'] = df['Death'] / df['Confirmed'] * 100
df['Recovery Rate'] = df['Recovered'] / df['Confirmed'] * 100