python - Pandas: Create new column by filtering an existing column

Question

I have a column gender that contains males "E" and females “K”, I am trying to add two new columns that should include only the males and another for females. My code is as follow:

df=df.reindex(columns=["name","gender","year","month","count"])

df["M"]=df[(df.gender == "E")]

question from:https://stackoverflow.com/questions/65908979/pandas-create-new-column-by-filtering-an-existing-column

Answer 1

As mentioned in my comment, using the .loc property will get you there.

This returns a boolean Series on the gender column and creates a new column matching the search criteria.

df['M'] = df.loc[df['gender'] == 'E', 'gender']