How to create a datetime column in pandas based on two columns date and time?

Question

Lets say I have following DataFrame:

import pandas as pd
df = pd.DataFrame({"Date":["2022-01-01", "2022-01-02", "2022-01-03"], "Time":[0,1,10]})

I want another column which is a datetime using the Date and the Time Columns.

Expected result

         Date  Time            DateTime
0  2022-01-01     0 2022-01-01 00:00:00
1  2022-01-02     1 2022-01-02 01:00:00
2  2022-01-03    10 2022-01-03 10:00:00

Trial

I tried this failed solution:

df["DateTime"] = str(df["Date"]) + " " + str(df["Time"]) + ":00"

Which outputs:

>>> df
         Date  Time                                           DateTime
0  2022-01-01     0  0    2022-01-01\n1    2022-01-02\n2    2022-01...
1  2022-01-02     1  0    2022-01-01\n1    2022-01-02\n2    2022-01...
2  2022-01-03    10  0    2022-01-01\n1    2022-01-02\n2    2022-01...

BENY · Accepted Answer · 2022-02-23 16:45:32Z

2

You can just do Date and Time add with to_datetime and to_timedelta

df['new'] = pd.to_datetime(df['Date']) + pd.to_timedelta(df['Time'],unit='hour')
df
Out[388]: 
         Date  Time                 new
0  2022-01-01     0 2022-01-01 00:00:00
1  2022-01-02     1 2022-01-02 01:00:00
2  2022-01-03    10 2022-01-03 10:00:00

answered Feb 23, 2022 at 16:45

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Comment

rish Over a year ago

How to do this if I have date as 'DD.MM.YYY' and time as 'HH:MM:SS', both are just objects?

Cedric Zoppolo · Accepted Answer · 2022-02-23 16:49:53Z

0

One solution would be the following:

df["DateTime"] = df["Date"].astype(str) + " " + df["Time"].astype(str) + ":00"

Then convert to datetime:

df["DateTime"] = pd.to_datetime(df["DateTime"])

Hence the output is as expected:

>>> df
         Date  Time            DateTime
0  2022-01-01     0 2022-01-01 00:00:00
1  2022-01-02     1 2022-01-02 01:00:00
2  2022-01-03    10 2022-01-03 10:00:00

edited Feb 23, 2022 at 16:49

answered Feb 23, 2022 at 16:43

Cedric Zoppolo

4,7937 gold badges34 silver badges63 bronze badges

Comments

Henry Ecker · Accepted Answer · 2022-02-28 00:56:53Z

0

df['date'] = [d.date() for d in df['datetime']]
df['time'] = [d.time() for d in df['datetime']]
df['date']= pd.to_datetime(df['date'])

edited Feb 28, 2022 at 0:56

Henry Ecker♦

35.8k19 gold badges48 silver badges67 bronze badges

answered Feb 24, 2022 at 1:40

Hansen Marcelino Azali

2091 silver badge7 bronze badges

Collectives™ on Stack Overflow

How to create a datetime column in pandas based on two columns date and time?

Expected result

Trial

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Expected result

Trial

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related