按熊猫分组求和和除法

丹麦文

我有一个df,如下所示:

Place       Occupancy     Number
Bangalore   Occupied      80    
Bangalore   Vacant       20
Chennai     Occupied      90
Chennai     Vacant       60
Delhi       Occupied      20
Delhi       Vacant       20

我正在尝试生成以下内容:

Place         Occupancy_%     Total_Number   Number_vacant  Number_occupied
Bangalore     80              100            20             80
Chennai       60              150            60             90
Bangalore     50              40             20             20
广晃

您可以执行以下操作:

new_df = df.pivot(index='Place', columns='Occupancy', values='Number')
new_df['Total_Number'] = new_df.sum(1)
new_df['Occupancy_%'] = new_df['Occupied']/new_df['Total_Number'] * 100

输出:

Occupancy  Occupied  Vacant  Total_Number  Occupancy_%
Place                                                 
Bangalore        80      20           100         80.0
Chennai          90      60           150         60.0
Delhi            20      20            40         50.0

本文收集自互联网,转载请注明来源。

如有侵权,请联系 [email protected] 删除。

编辑于
0

我来说两句

0 条评论
登录 后参与评论

相关文章