How do I change the values 1 and 2 to female and male in a data frame?

Question

I already have my df. The column I am trying to change is gender. Instead of having 1 and 2 there, I want it to say female or male with 1 being female and 2 being male.

Gender
1
2
2
1

Here is a great post that explains [`map`](https://stackoverflow.com/a/56300992/4985099) in detail — sushanth, Oct 14 '21 at 04:03
@sushanth: Isn't that supposed to be `df['Gender'].map(....)` ? `.map()` is only defined on a series, not a dataframe. — sj95126, Oct 14 '21 at 04:36

score 0 · Answer 1 · answered Oct 14 '21 at 04:06

0

You can do this

df.columns = ['a', 'b']

or

df_new = df.rename(columns={'1': 'Female', '2': 'Male'})

if the column name is not a string

then

df_new = df.rename(columns={1: 'Female', ': 'Male'})

answered Oct 14 '21 at 04:06

Royal

218
2
17

How do I change the values 1 and 2 to female and male in a data frame?

1 Answers1