is that what you want?
In [30]: df[df.groupby(['store_id', 'item_id'])['items_sold'].transform('sum') > 0]Out[30]: store_id item_id items_sold date1 1 2 1 2015-12-283 2 2 0 2015-12-284 2 1 1 2015-12-295 2 2 1 2015-12-296 2 1 0 2015-12-29