Panda 数据透视表边距仅在行上 [英] Panda pivot table margins only on row

问题描述

有人知道如何在熊猫数据透视表上只在行上做边距吗?当前设置将计算行和列边距谢谢！

Anyone knows how to do margins on panda pivot table only on row? current setting will calculate both row and column margin Thanks !

推荐答案

您可以通过使用 DataFrame.iloc:

You can remove them by indexing with DataFrame.iloc:

df = pd.DataFrame({
    'A': ['a','b','a','a'],
    'B': ['a','d','d','b']
})

df = pd.crosstab(df['A'], df['B'], margins=True)
print (df)
B    a  b  d  All
A                
a    1  1  1    3
b    0  0  1    1
All  1  1  2    4

df1 = df.iloc[:, :-1]
print (df1)
B    a  b  d
A           
a    1  1  1
b    0  0  1
All  1  1  2

df2 = df.iloc[:-1]
print (df2)
B  a  b  d  All
A              
a  1  1  1    3
b  0  0  1    1

这篇关于Panda 数据透视表边距仅在行上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！