[Python] Add date string and time string of pandas Dataframe (pandas의 date와 time 문자열을 합친 날짜형식 만들기)

pandas의 date(yyyy-mm-dd) 문자열과 time(HH:MM:SS) 문자열을 합쳐서 새로운 날짜형식 만들기

 

import pandas as pd
import datetime as datetime

d = [['2019-10-14','01:11:12'],['2019-10-13','02:01:37']]
df = pd.DataFrame(d, columns=['date','time'])
print(df)
-----------------------------------------------------------
         date      time
0  2019-10-14  01:11:12
1  2019-10-13  02:01:37




df['datetime'] = pd.to_datetime(df['date']+' '+df['time'],format='%Y-%m-%d %H:%M:%S')
print(df)
print(df['datetime'])
-----------------------------------------------------------
         date      time            datetime
0  2019-10-14  01:11:12    2019-10-14 01:11:12
1  2019-10-13  02:01:37    2019-10-13 02:01:37




print(df['datetime'].dtype)
-----------------------------
datetime64[ns]