How to clean Pandas data frame column which contains mix of both datetime and date?

Question

I have a column in a Pandas data frame that has a date column but has datetime and date mixed in together as follows:

2020-05-20 00:00:00
2020-05-21 00:00:00
2020-05-22 
2020-05-23

Is there any way to convert everything to a date format as follows:

Does this answer your question? Working with mixed date time formats in pandas — Bertil Johannes Ipsen
– Bertil Johannes Ipsen, Commented Jun 8, 2020 at 10:37
@BertilJohannesIpsen No, the date format is the same across the entire column. Just that a few have time (00:00:00) attached to them .The answer by jezrael seems to be working. Will validate and update. — Biswankar Das
– Biswankar Das, Commented Jun 8, 2020 at 10:45
@BertilJohannesIpsen that's not a relevant dupe target, it;s about multiple datetime formats (YYYY-MM-DD vs DD.MM.YYYY). But this one is about a single date format, except that it may/may not contain the time. — smci
– smci, Commented Jun 8, 2020 at 10:45

jezrael · Accepted Answer · 2020-06-08 10:38:11Z

2

Convert values to strings and then to datetimes, last to dates:

pd.to_datetime(df['date'].astype(str)).dt.date

answered Jun 8, 2020 at 10:38

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

1 Answer 1