How to format a string to datetime column and skip blank values?

Question

I have got a pandas serie as follows:

1    29/04/2020 22:16
2    02/05/2020 15:32
3    01/05/2020 6:37
4    02/05/2020 8:00
5    28/04/2020 8:15
6                    
7    06/05/2020 14:29
8    02/05/2020 8:12

I would like to format to date time type:

df['date_time_column'] = pd.to_datetime(df['date_time_column'], format='%d/%m/%Y %H:%M')

But the error occurs in the 6 row who is blank " "

How can I do that stuff skipping the blank rows error and kepping the row in blank?

jezrael · Accepted Answer · 2020-05-10 15:08:56Z

3

Add errors='coerce' for converting not matched datetimes to NaT:

df['date_time_column'] = pd.to_datetime(df['date_time_column'], format='%d/%m/%Y %H:%M', errors='coerce')

edited May 10, 2020 at 15:08

answered May 10, 2020 at 15:07

jezrael

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

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

Collectives™ on Stack Overflow

How to format a string to datetime column and skip blank values?

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