这是我的数据
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]
