熊猫过滤（~isin）无法工作

Question

这是我的数据

 omzet_activity_paid_count_january_devices

No    Text    
1     dcbjkd
2     hdgfhds
3     dsdfs
33    jhsda
40    ydgyua

我希望像这样过滤数据

^{pr2}$

我就是这么做的

user_internal = ['1','2','33']
omzet_activity_paid_count_january_devices = omzet_activity_paid_count_january_devices[~omzet_activity_paid_count_january_devices.No.isin(user_internal)]

上面的代码不工作了，输出的还是我原来的数据帧，我错过了什么？在

Answer 1

我认为有一个问题你混合了类型-数字和字符串。在

omzet_activity_paid_count_january_devices.No.dtype
dtype('O')

omzet_activity_paid_count_january_devices.No.head().tolist()
[1, 2, 3, 33, 40] 

因此，将列No转换为字符串：

^{pr2}$

或将strings从列表更改为ints：

user_internal = [1,2,33]
mask = ~omzet_activity_paid_count_january_devices.No.isin(user_internal)
omzet_activity_paid_count_january_devices =  omzet_activity_paid_count_january_devices[mask]