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
– ifly6, Commented Jul 12, 2021 at 18:14

hilo · Accepted Answer · 2021-07-12 18:28:01Z

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, 2021 at 18:28

answered Jul 12, 2021 at 18:24

hilo

11611 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Henry Ecker · Accepted Answer · 2021-07-12 18:26:49Z

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, 2021 at 18:26

Henry Ecker♦

35.8k19 gold badges48 silver badges67 bronze badges

answered Jul 12, 2021 at 18:23

Ajay dalavi

591 bronze badge

Comments

Behrooz Ostadaghaee · Accepted Answer · 2021-07-12 19:06:23Z

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, 2021 at 19:06

answered Jul 12, 2021 at 19:00

Behrooz Ostadaghaee

914 bronze badges

Collectives™ on Stack Overflow

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

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related