I am trying to filter a pandas DataFrame without using mask by using .filter()
but it doesn't seem to work. Here is my example:
df1
numbers Name
0 0 Tom
1 3 Harry
2 2 John
3 1 Mary
I want to filter all rows where numbers <2 so like this:
df1
numbers Name
0 0 Tom
3 1 Mary
I have tried to do this using .filter
with this solution:
df1.filter(df1.numbers < 2)
I get True/False for the parameter but filter filters everything out.
Can someone explain or provide a different solution please. Thanks