pandas 熊猫没有过滤条件

pandas not condition with filtering

提问by Night Walker

How I can implement not condition on the filtering

我如何在过滤中实现非条件

grouped = store_ids_with_visits.groupby(level=[0, 1, 2])
grouped.filter(lambda x: (len(x) == 1 and x['template_fk'] == exterior_template))

I want to get all entries that not answering on the condition

我想获得所有不满足条件的条目

I tried doing:

我试着做：

grouped.filter(lambda x: ~(len(x) == 1 and x['template_fk'] == exterior_template))

But got following error:

但得到以下错误：

filter function returned a int, but expected a scalar bool

回答by Nickil Maveli

IIUC, you can use isinto check for bool conditions and take only the NOT(~)values of the grouped dataframe:

IIUC，您可以isin用来检查布尔条件并仅NOT(~)获取分组数据帧的值：

 df[~df.isin(grouped.filter(lambda x: (len(x) == 1 and x['template_fk'] == exterior_template)))]