Skip to main content
 首页 » 编程设计

python之Pandas 过滤(〜isin)不起作用

2025年01月19日9yyy_WW

这是我的数据

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

我期待像这样过滤数据

omzet_activity_paid_count_january_devices 
 
No    Text     
3     dsdfs 
40    ydgyua 

这是我做的

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)] 

上面的代码不工作,输出仍然像我原来的数据帧,我错过了什么?

请您参考如下方法:

我认为你有混合类型的问题 - 数字和字符串。

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 列转换为字符串:

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

或者将 string 从列表更改为 int:

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]