Adding pandas columns with date and time variables

Question

I have this column in a pandas dataframe:

 dataset['Start Pump Time']:
 0        10:50
 1        14:25
 2        03:00
 3        21:15
 4        02:05
 Name: Start Pump Time, Length: 94052, dtype: object`

and this one

dataset['Start Pump Date']
0       2018-12-12
1       2018-12-16
2       2019-01-14
3       2019-05-06
4       2019-06-28
Name: Start Pump Date, Length: 94052, dtype: datetime64[ns]

I want merge those two columns and create a column that has both the date and the time and delete the previous two colums. I have tried with pandas.to_datetime but my inexperience hasn't helped in finding the correct solution till now. Thanks

did you try options described [here](https://stackoverflow.com/questions/17978092/combine-date-and-time-columns-using-python-pandas)? — FObersteiner, Sep 23 '20 at 13:34

score 0 · Answer 1 · answered Sep 23 '20 at 13:36

0

pd.to_datetime(df['Start Pump Date'] + ' ' + df['Start Pump Time'])

check here Combine Date and Time columns using python pandas

answered Sep 23 '20 at 13:36

RKG

87
4

this won't work I guess since `df['Start Pump Date']` is not of type string but datetime – FObersteiner Sep 23 '20 at 14:34
I have seen the aforementioned thread, and what I get with your command is : `unsupported operand type(s) for +: 'DatetimeArray' and 'str'` Thanks for your help though! – Andreas Kampianakis Sep 23 '20 at 14:49

Quang Hoang · Answer 2 · 2020-09-23T14:48:03.717

0

Convert the other column to timedelta and add:

pd.to_timedelta(dataset['Start Pump Time'] + ":00") +  dataset['Start Pump Date']

edited Sep 23 '20 at 14:48

answered Sep 23 '20 at 13:38

Quang Hoang

146,074
10
56
74

Thanks for the help but what I get is this: `ValueError: expected hh:mm:ss format` – Andreas Kampianakis Sep 23 '20 at 14:47

Adding pandas columns with date and time variables

2 Answers2