How to fill age with average age according to sex in Titanic data set?

Question

In the Titanic data set passengers, sex and age are given, but there are some empty values for age. I would like to enter the average by sex.

    Sex
    female    27.915709
    male      30.726645

Where the sex is equal to male I would like to ent the average male age and the same for sex equal to female

I'm somewhat new haven't tried too much

titanic.Sex = 'male' and titanic.Age.fillna(mean_homme)

The Nan for male age will equal the average male age

Thanks but it didn't work. here is a sample of some new code I'm trying titanic.fillna(titanic.groupby('Sex').Age.mean()) — Tammara Brown, Aug 04 '19 at 02:42
Nor did this work titanic.Age.fillna(titanic.groupby('Sex')['Age'].mean()) — Tammara Brown, Aug 04 '19 at 02:50

score 1 · Answer 1 · answered Aug 01 '19 at 03:45

1

Try something like this,

df['male']=df['male'].fillna(df['male'].mean())

answered Aug 01 '19 at 03:45

Arun Augustine

1 Answers1