How to join date and time column of type object to datetime column pandas

Asked Nov 15 '22 at 05:44

Active Nov 15 '22 at 05:44

Viewed 13 times

I have date and time column as follows

I need to combine the 2 columns to make it look like 01-10-2022 00:00:00 , when I do df.info(), I get the dtype as object. Can anyone please tell me how to convert and combine the 2 columns as datetime.

asked Nov 15 '22 at 05:44

Akshata

1

`pd.to_datetime(df['CAPTURE_DATE'] + ' ' + df['CAPTURE_TIME'])` – BeRT2me Nov 15 '22 at 05:46
Before writing a question, try to search SO first. It’s most likely someone else already had similar issue. – Prayson W. Daniel Nov 15 '22 at 05:49

How to join date and time column of type object to datetime column pandas

0 Answers0