python - Python Pandas 中的日期时间字符串到 Unix 时间

Question

df['DATE'][0] -> '2019-10-01'
df['TIME'][0] -> '00:53:00'

鉴于数据框有时间，日期是两个列作为字符串，如何将其转换为 Unix 时间并分配给 df['unixTime]

df['unixTime]= # (time.mktime( df['DATE']+ df['TIME'] ) # Some code like this

标签： pythonpandas

Answer 1

import time
import datetime

df= pd.read_csv("train\\data.csv")
T = pd.to_timedelta(df.TIME, unit='H')
D = pd.to_datetime(df.DATE, format="%Y-%m-%d")
df['unixTime'] = T + D
df['unixTime']=df['unixTime'].map(
    lambda x: int(time.mktime(datetime.datetime.strptime( str(x),"%Y-%m-%d %H:%M:%S").timetuple())) )
df.describe()