Add a column to a dataframe based on the contents of a string in another colum

Question

My data-frame looks like this

Year   Event 
2015   Men's 100m 
2016   Men's Archery
2016   Women's Archery
2017   Men's Weightlifting
1998   Women's 100m
2002   Women's Sailing

I would like to add a new column to this data-frame that identifies if it is a male of female event. The desired output would look like this:

Year   Event               Gender
2015   Men's 100m          M
2016   Men's Archery       M
2016   Women's Archery     F
2017   Men's Weightlifting M
1998   Women's 100m        F
2002   Women's Sailing     F

Is this even possible? Any help would be appreciated

Does [this](https://stackoverflow.com/questions/19226488/change-one-value-based-on-another-value-in-pandas) answer your question? — Björn, Apr 11 '20 at 18:57
What is the issue, exactly? Please see [ask], [help/on-topic]. — AMC, Apr 11 '20 at 19:06

score 1 · Accepted Answer · answered Apr 11 '20 at 19:06

1

You can use the pd.Series.str functions -

df['Gender'] = df.Event.str.contains('Men').apply(lambda x: 'M' if x else 'F')

answered Apr 11 '20 at 19:06

Mortz

4,654
1
19
35

score 0 · Answer 2 · answered Apr 11 '20 at 19:10

0

One easy was would be:

df['Gender'] = ['M' if 'Men' in row['Event'] else 'F' for _,row in df.iterrows()]

answered Apr 11 '20 at 19:10

Adel

1
1

Add a column to a dataframe based on the contents of a string in another colum

2 Answers2