Create a new column in excel with a condition

Question

I want to create a new column called Book in which I take data from a column called Exposure. If the value from the exposure column is 0, I want it to return 100, else I want to retain the same value. This is what I've already tried:

df['Book'] = np.where(df['Exposure']==0,100,)

how do I get it to return the same value if it's not zero?

score 0 · Accepted Answer · answered Jul 08 '19 at 14:33

0

Try this :

df['Book'] = df['Exposure'].replace(0, 100)

answered Jul 08 '19 at 14:33

Jerome

16
3

I need to use np.where unfortunately – Andreas Jul 08 '19 at 14:36
Sorry, like that maybe ? df['Book'] = np.where(df['Exposure']==0,100, df['Exposure']) – Jerome Jul 08 '19 at 15:03

Create a new column in excel with a condition

1 Answers1