replacing NaT with 0 days

Question

I have a pandas dataframe that looks lie:

A      
3 days    
NaT       
4 days

Is there a way to replace the NaT with 0 days ?

thanks, Ed

Answer 1

Please note that the other answers are not up to date anymore. The preferred syntax is:

df['column'].fillna(pd.Timedelta(seconds=0))

The previously mentioned

df['column'].fillna(0)

will results in:

FutureWarning: Passing integers to fillna is deprecated, will raise a TypeError in a future version. To retain the old behavior, pass pd.Timedelta(seconds=n) instead. df['column'] = df['column'].fillna(0)