python pandas 数据透视表_python – Pandas数据透视表：列顺序和小计

小计和

MultiIndex.from_arrays的解决方案.最后

concat和所有数据帧,

sort_index并添加所有总和：

#replace km/h and convert to int

df.windspeed = df.windspeed.str.replace('km/h','').astype(int)

print (df)

FID admin0 admin1 admin2 windspeed population

0 0 cntry1 state1 city1 60 700

1 1 cntry1 state1 city1 90 210

2 2 cntry1 state1 city2 60 100

3 3 cntry1 state2 city3 60 70

4 4 cntry1 state2 city4 60 180

5 5 cntry1 state2 city4 90 370

6 6 cntry2 state3 city5 60 890

7 7 cntry2 state3 city6 60 120

8 8 cntry2 state3 city6 90 420

9 9 cntry2 state3 city6 120 360

10 10 cntry2 state4 city7 60 740

#pivoting

table = pd.pivot_table(df,

index=["admin0","admin1","admin2"],

columns=["windspeed"],

values=["population