Make a column based on specific values from other column pandas python

Question

I got this dataframe

Contact	Title
1	Dear Sir White,
2	Dear Madam Ford,
3	Dear Sir / Madam Hendricx,

I want to make another column called 'Gender' based on the column 'Title'

Contact	Title	Gender
1	Dear Sir White,	M
2	Dear Madam Ford,	F
3	Dear Sir / Madam Hendricx,	O

So Dear Sir is M(ale)

Dear Madam is F(emale)

Dear Sir / Madam is O

I hope someone can help!

You want to clearly define how you want to identify gender from these salutations. Merely writing a regex seems less than sufficient for that kind of task. — ifly6, Jul 12 '21 at 18:14

hilo · Accepted Answer · 2021-07-12T18:28:01.323

3

df.loc[df['title'].str.contains("Sir"), 'Gender'] = 'Male'
df.loc[df['title'].str.contains("Madam"), 'Gender'] = 'Female'
df.loc[df['title'].str.contains(" Sir / Madam"), 'Gender'] = '0'

also, check this

edited Jul 12 '21 at 18:28

answered Jul 12 '21 at 18:24

hilo

116
11

score 1 · Answer 2 · edited Jul 12 '21 at 18:26

1

g = []

for text in df.Title:
    if ' Sir / Madam' in text:
        g.append('O')
    elif 'Sir' in text:
        g.append('M')
    else:
        g.append('F')

df["Gender"] = g

edited Jul 12 '21 at 18:26

Henry Ecker

34,399
18
41
57

answered Jul 12 '21 at 18:23

Ajay dalavi

59
1

Behrooz Ostadaghaee · Answer 3 · 2021-07-12T19:06:23.867

0

def my_func(text):
    if 'Sir / Madam' in text:
        return 'O'
    elif 'Madam' in text:
        return 'F'
    else:
        return 'M'

df['Gender'] = df['Title'].apply(my_func)

edited Jul 12 '21 at 19:06

answered Jul 12 '21 at 19:00

Behrooz Ostadaghaee

71
4

Make a column based on specific values from other column pandas python

3 Answers3