擅长:python、mysql、java
<pre><code>In [67]: df['decision'] = \
np.where(df.groupby(['CategoryA', 'CategoryB'])['Count'].transform('sum') > 0,
'keep', 'delete')
In [68]: df
Out[68]:
CategoryA CategoryB Count decision
0 1 A 0 delete
1 1 A -1 delete
2 2 B 1 keep
3 2 B 1 keep
4 3 C 1 delete
5 3 C -1 delete
</code></pre>