Changing column values in pandas dataframe

Question

I want to change the value of a Cabin column in my data frame.

Here's my dataframe:

I would like to assign the value to be 1, where the Cabin is not equal to 0. That means the value of C85, C123, E46 should be 1 and rest of the values should be same.

This is the code, but I am getting a value error.

if df_train.Cabin != 0:
   df_train.Cabin = 1
else:
   df_train.Cabin = 0

Can you post your dataframe not as an image, but as text?

user3483203
– user3483203

2018-06-27 17:47:58 +00:00
Commented Jun 27, 2018 at 17:47 — user3483203
– user3483203, Commented Jun 27, 2018 at 17:47

koPytok · Accepted Answer · 2022-03-02 20:16:17Z

3

Just use df.apply:

df_train["new_Cabin"] = df_train["Cabin"].apply(lambda x: x != 0).astype(int)

Also, you can compare column to zero:

df["new_Cabin"] = (df_train["Cabin"] != 0).astype(int)

edited Mar 2, 2022 at 20:16

answered Jun 27, 2018 at 17:39

koPytok

3,7631 gold badge16 silver badges29 bronze badges

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

3 Comments

Vic13 Over a year ago

All the values are being converted to 1. I dont want to convert 0's to 1.

koPytok Over a year ago

@Vic13 Maybe, you need to remove quotes " around 0: x != 0 instead of x != "0"

Vic13 Over a year ago

Thanks for the help

user96564 · Accepted Answer · 2018-06-27 17:58:25Z

1

try np.where

df['newCabin'] = np.where(df['cabin'] != 0, 1, df['cabin'])

print(df)
cabin newCabin
    0        0
  C85        1
    0        0
 C123        1
    0        0
    0        0

and if you dont want extra new column, then you can do this one too

df['cabin'] = np.where(df['cabin'] != 0, 1, df['cabin'])
print(df)
cabin
    0
    1
    0
    1
    0
    0

edited Jun 27, 2018 at 17:58

answered Jun 27, 2018 at 17:46

user96564

1,6175 gold badges27 silver badges47 bronze badges

3 Comments

Vic13 Over a year ago

df['cabin'] = np.where(df['cabin'] != '0', 1, df['cabin']) instead of this f['cabin'] = np.where(df['cabin'] != 0, 1, df['cabin'])

Vic13 Over a year ago

Thanks for the help

user96564 Over a year ago

I had 0 as a string in my dataframe, thatswhy I used the quote.

Pascal Stalder · Accepted Answer · 2018-06-27 20:23:39Z

0

simple oneliner that should work

df_train['cabin'][df_train['cabin'] != '0'] = 1

answered Jun 27, 2018 at 20:23

Pascal Stalder

11 bronze badge

Collectives™ on Stack Overflow

Changing column values in pandas dataframe

3 Answers 3

3 Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related