How do I drop every row that doesn't contain one of 2 values?

Question

I am struggling to drop rows that do not contain certain data. For example, I want my dataset to only predict between 'Male' and 'Female' so I need to drop everything with the 'Gender' column that is not equal to those two choices. How would I go about doing this?

I've tried:

df.drop(df['GENDER'] != 'Male' & 'Female')

I honestly have tried more code that I can type out so any help would be great. All of the pandas documentation I have read only shows how to remove certain values but not how to remove everything but certain values.

Thanks in advance!

score 0 · Accepted Answer · answered Sep 08 '22 at 05:06

0

Here you go

df = df[df.GENDER.isin(['Male',"Female"])]

answered Sep 08 '22 at 05:06

sayan dasgupta

1,084
6
15

score 0 · Answer 2 · answered Sep 08 '22 at 05:11

0

df = df[~df['GENDER'].isin(['Male',"Female"])]

answered Sep 08 '22 at 05:11

ZAVERI SIR

317
4
14

How do I drop every row that doesn't contain one of 2 values?

2 Answers2