One of my datasets, I have to do a monthly analysis. On my december 2023 csv file, there is a datetime column. However,one date (December 8), is not on datetime format. Instead, for some reason, random integers and decimals just fill it. Take this for Example:
| Datetime |
|---|
| 07/12/2023 11:34 pm |
| 07/12/2023 11:59 pm |
| 35345345.543453 |
So I found a way to remove it.
I did the
df['Datetime'] = pd.to_datetime(df['Datetime'], datefirst=True, errors=coerce)
‘
This will give me NaT Values. Now I just wantto convert ALL NaT Values to a datetime,(08/12/2023 12:00 am). It doesn’t even have December 8. It can be December 9 at 1pm or December 15 at 4pm but it just needs to be a december date, with the dayfirst, because I am doing a monthly analysis.