2024-04-26 13:18:39 发布
网友
我有熊猫系列,我们称之为“批准的”字段,我想用它来过滤df:
approved_field(['Field1','Field2','Field3')] df Field 0 Field1 1 Field4 2 Field2 3 Field5 4 Field2
应用经批准的_字段过滤器后,得到的df应如下所示:
谢谢!在
您可以使用isin和布尔索引:
isin
>>> import pandas as pd >>> df = pd.DataFrame({"Field": "Field1 Field4 Field2 Field5 Field2".split()}) >>> approved_fields = "Field1", "Field2", "Field3" >>> df['Field'].isin(approved_fields) 0 True 1 False 2 True 3 False 4 True Name: Field, dtype: bool >>> df[df['Field'].isin(approved_fields)] Field 0 Field1 2 Field2 4 Field2
请注意,预期解决方案中的索引已关闭
In [16]: approved_field = ['Field1','Field2','Field3'] In [17]: df = DataFrame(dict(Field = ['Field1','Field4','Field2','Field5','Field2'])) In [18]: df Out[18]: Field 0 Field1 1 Field4 2 Field2 3 Field5 4 Field2 In [19]: df[df.Field.isin(approved_field)] Out[19]: Field 0 Field1 2 Field2 4 Field2
您可以使用
isin
和布尔索引:请注意,预期解决方案中的索引已关闭
相关问题 更多 >
编程相关推荐