我有看起来像这样的数据帧。| Date_Time | Execution_Time |
|---------------------|----------------|
| 2019-10-10 09:07:29 | 14.0 |
| 2019-09-21 19:47:01 | 14.3 |
| 2019-09-19 02:49:49 | 14.1 |
| 2019-09-27 23:19:16 | 21.9 |
| 2019-09-05 18:46:00 | 14.2 |执行以秒为单位。如何添加 和 ?Date_TimeExecution_TimeDate_Time 的数据类型: 、 Execution_Time:objectfloat64我试过了,它返回以下错误:df['diff'] = df['Date_Time'] + df['Execution_Time']TypeError: ufunc 'add' did not contain a loop with signature matching types dtype('<U32') dtype('<U32') dtype('<U32')
1 回答
函数式编程
TA贡献1807条经验 获得超9个赞
第一列按 to_datetime
转换为日期时间,第二列按 to_timedelta 转换为
时间详图:
df['diff'] = (pd.to_datetime(df['Date_Time']) +
pd.to_timedelta(df['Execution_Time'], unit='s'))
print (df)
Date_Time Execution_Time diff
0 2019-10-10 09:07:29 14.0 2019-10-10 09:07:43.000
1 2019-09-21 19:47:01 14.3 2019-09-21 19:47:15.300
2 2019-09-19 02:49:49 14.1 2019-09-19 02:50:03.100
3 2019-09-27 23:19:16 21.9 2019-09-27 23:19:37.900
4 2019-09-05 18:46:00 14.2 2019-09-05 18:46:14.200
添加回答
举报
0/150
提交
取消