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

2022-01-22 00:00:00 python pandas pivot

问题描述

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

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

相关文章