我有一个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] 删除。
我来说两句