Panda 数据透视表边距仅在行上

问题描述

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

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 数据透视表边距仅在行上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！