pandas 对布尔类型应用过滤器 [英] pandas apply filter for boolean type

问题描述

这些是我的DataFrame的类型；

These are the types for my DataFrame;

count     int64
word     object
cat1       bool
cat2     object
cat3       bool
dtype: object

如何为"cat1"和"cat2"中的布尔值进行过滤?

How do I do a filter for boolean values from 'cat1' and 'cat2'?

类似...

data[(data['cat1'].bool() == FALSE) & (data['cat3'].bool() == FALSE)]

推荐答案

只需:

data[(data['cat1'] == FALSE) & (data['cat2'] == FALSE)]

cat2是object dtype，所以它可能是一个字符串，我想您想要:

cat2 is an object dtype so it is probably a string, I think you want:

data[(data['cat1'] == FALSE) & (data['cat3'] == FALSE)]

否则，如果确实是字符串值，则可以

otherwise if it really is string values then you can do

data[(data['cat1'] == FALSE) & (data['cat2'] == 'FALSE')]

或

data[(data['cat1'] == FALSE) & (data['cat2'].str.contains('FALSE'))]

这篇关于 pandas 对布尔类型应用过滤器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！