Dataframe replace string with a word and set other rows as NULL using Python pandas

Question

I have a dataframe in python, want to replace Fri as this friday and the rest of the rows in that colume as NULL

Use this code will replace all the rows with this friday, which is not what i want

import datetime
today = datetime.date.today()
friday = today + datetime.timedelta( (4-today.weekday()) % 7 )
this_firday = friday.strftime('%Y-%m-%d')

df['date3'] = df.loc[(df['date'] == 'Fri'), 'date'] = this_firday 
df

my expected result is

Anurag Dabas · Accepted Answer · 2021-08-12 06:01:35Z

1

try via map():

df['date']=df['date'].map({'Fri':this_firday})

OR

via loc:

df.loc[(df['date'] == 'Fri'), 'date'] = this_firday
df.loc[(df['date'] != 'Fri'),'date']=float('NaN')

OR

you can also use np.where():

#import numpy as np
df['date']=np.where((df['date'] == 'Fri'),this_firday,np.nan)

edited Aug 12, 2021 at 6:01

answered Aug 12, 2021 at 5:54

Anurag Dabas

24.3k9 gold badges25 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

Dataframe replace string with a word and set other rows as NULL using Python pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related