假设我们有以下数据帧:
Name Filter_1 Filter_2 Weight
Rat A 1 1
Cat B 2 10
Lion A 3 80
Tiger C 4 60
Dog A 1 20
我想将具有Filter_ 1的动物的重量求和为"A"&过滤器_2为'1'
df[(df['Filter_1']=='A') & (df['Filter_2']==1)]['Weight'].sum()
我认为这应该有效:
df.loc[(df['Filter_1']==A)&(df['Filter_2']==1), 'Weight'].sum(axis=0)
这也会起作用:
df[df.Filter_1 == 'A'][df.Filter_2 == 1].sum()