Dataframe .where() method returns None

Asked Mar 01 '20 at 18:43

Active Mar 01 '20 at 18:43

Viewed 35 times

I am trying to filter a dataframe by the values inside one of the columns. The dataframe has a Gender column. And I am trying to filter the values by fetching only the columns that have 'Female' in the Gender column.

When I filter using lambda:

df = df.loc[lambda x: x['Gender'] == 'Female']

I get the correct results, but I am required to use the .where() method. When I use the following line instead, I get zero results:

filter = df['Gender'] == 'Female'
df = df.where(filter, inplace = True)

Why is this?

asked Mar 01 '20 at 18:43

Jimmy Nesbitt

Either do assignment without `inplace=True` or do `inplace=True` without assignment. – Quang Hoang Mar 01 '20 at 18:58
[don't use `inplace=True`](https://stackoverflow.com/a/59242208/4909087). – cs95 Mar 01 '20 at 19:28

Dataframe .where() method returns None

0 Answers0