Pandas-按相同维度分组

IIUC,您可以通过执行单个 groupby :

out = (df.set_index('Tax').filter(like='G').eq(1)
         .groupby(level='Tax').sum()
       )

或

cols = ['G1', 'G2', 'G3', 'G4']

out = df.groupby('Tax')[cols].agg(lambda x: x.eq(1).sum())

如果您的值仅为0/1:

cols = ['G1', 'G2', 'G3', 'G4']

out = df.groupby('Tax')[cols].sum()

实例

# input
   G1  G2  G3  G4 Tax
0   0   1   0   0   A
1   1   1   0   1   A
2   1   1   0   0   A
3   0   1   0   1   B

# output
     G1  G2  G3  G4
Tax                
A     2   3   0   1
B     0   1   0   1