Replace Negative values with Null in pandas column

Question

My duration column in dataframe contains negative timedelta values as shown below:

NaT
00:27:03.466021
-1 days +23:57:26.139011
00:10:06.227683

How to replace negative dates to Null or NaT in dataframe column?

Does this answer your question? [How to replace negative numbers in Pandas Data Frame by zero](https://stackoverflow.com/questions/27759084/how-to-replace-negative-numbers-in-pandas-data-frame-by-zero) — Rahul Bharadwaj, Jan 12 '20 at 04:15

score 0 · Answer 1 · answered Jan 12 '20 at 05:15

0

Use below command

mask=df['duration'] < pd.Timedelta(0)
df['duration'].mask(mask)

answered Jan 12 '20 at 05:15

Md Ziaul Haque

1 Answers1