Return to Question

added 2 characters in body

Source Link

edited Aug 18, 2021 at 11:06

I am working with DataFrame which contains multiple datetime formats in one column. For example:

2020-11-09 00:00:48
2020-11-09 00:00:48
2020-11-09 00:00:48
2020-11-09 00:00:48
2020-11-09 00:00:48
2020-08-25
2020-08-25
2017-08-25
2018-08-25
2020-08-25
25.08.2020
25.08.2020  
25.08.2017
25.08.2018  
25.08.2020

I want to convert it into "dd.mm.yyyy" format. pd.to_datetime(columnName, format = "dd.mm.yyyy") pd.to_datetime(columnName, format = "dd.mm.yyyy") does not help.

I am working with DataFrame which contains multiple datetime formats in one column. For example:

2020-11-09 00:00:48
2020-11-09 00:00:48
2020-11-09 00:00:48
2020-11-09 00:00:48
2020-11-09 00:00:48
2020-08-25
2020-08-25
2017-08-25
2018-08-25
2020-08-25
25.08.2020
25.08.2020  
25.08.2017
25.08.2018  
25.08.2020

I want to convert it into "dd.mm.yyyy" format. pd.to_datetime(columnName, format = "dd.mm.yyyy") does not help.

I am working with DataFrame which contains multiple datetime formats in one column. For example:

2020-11-09 00:00:48
2020-11-09 00:00:48
2020-11-09 00:00:48
2020-11-09 00:00:48
2020-11-09 00:00:48
2020-08-25
2020-08-25
2017-08-25
2018-08-25
2020-08-25
25.08.2020
25.08.2020  
25.08.2017
25.08.2018  
25.08.2020

I want to convert it into "dd.mm.yyyy" format. pd.to_datetime(columnName, format = "dd.mm.yyyy") does not help.

Source Link

asked Aug 18, 2021 at 10:56

Zhamshidbek Abdulkhamidov

How to convert mixed datetime formats into single one in pandas?

I am working with DataFrame which contains multiple datetime formats in one column. For example:

2020-11-09 00:00:48
2020-11-09 00:00:48
2020-11-09 00:00:48
2020-11-09 00:00:48
2020-11-09 00:00:48
2020-08-25
2020-08-25
2017-08-25
2018-08-25
2020-08-25
25.08.2020
25.08.2020  
25.08.2017
25.08.2018  
25.08.2020

I want to convert it into "dd.mm.yyyy" format. pd.to_datetime(columnName, format = "dd.mm.yyyy") does not help.

pandas