Remove values from columns if a column contains specific string in Python

Question

I would like to remove values in the value1 and value2 column if the status column contains the string 'new'

Data

id  date        location    status  value1  value2  
CC  1/1/2022    ny          new     12      1   
CC  4/1/2022    ny          new     1       1   
CC  7/1/2022    ny          new     1       1   
CC  10/1/2022   ny          new     1       2   
CC  1/1/2023    ny          ok      1       2

Desired

id  date        location    status  value1  value2  
CC  1/1/2022    ny          new         
CC  4/1/2022    ny          new         
CC  7/1/2022    ny          new         
CC  10/1/2022   ny          new         
CC  1/1/2023    ny          ok      1       2

I do not want a NaN value, but I wish to have a blanks. Any suggestion is appreciated

Doing

df.loc[(df.status == 'new')  'value1', 'value2']= np.nan

BENY · Accepted Answer · 2022-07-28 01:59:37Z

4

Try with :

df.loc[(df.status == 'new'), ['value1', 'value2']] = ''

edited Jul 28, 2022 at 1:59

answered Jul 28, 2022 at 1:45

BENY

324k22 gold badges176 silver badges250 bronze badges

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

4 Comments

Michael S. Over a year ago

"I do not want with a NaN value but wish to have blanks"

Scott Boston Over a year ago

Use '' instead of np.nan. Two single quotes no space. to assign a blank string.

Lynn Over a year ago

Hi @BENY I tried adding more columns besides 2 and this doesn't work. Isn't the logic the same as you add more columns?

BENY Over a year ago

@Lynn df.loc[(df.status == 'new'), ['value1', 'value2'，'value3']] = ''

Collectives™ on Stack Overflow

Remove values from columns if a column contains specific string in Python

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related