我的数据有 df：
+-----+---------------------+--------+--------------------+--------------------+--------------+--------------+
| | date | time | home_team | away_team | home_score | away_score |
+=====+=====================+========+====================+====================+==============+==============+
| 50 | 2014-11-07 00:00:00 | 18:30 | Aalen | FSV Frankfurt | 0 | 1 |
+-----+---------------------+--------+--------------------+--------------------+--------------+--------------+
| 51 | 2014-11-07 00:00:00 | 18:30 | Kaiserslautern | Bochum | 2 | 2 |
+-----+---------------------+--------+--------------------+--------------------+--------------+--------------+
我希望日期和时间列组合为：
+-----+---------------------+--------+--------------------+--------------------+--------------+--------------+
| | datetime | time | home_team | away_team | home_score | away_score |
+=====+=====================+========+====================+====================+==============+==============+
| 50 | 2014-11-07 18:30:00 | 18:30 | Aalen | FSV Frankfurt | 0 | 1 |
+-----+---------------------+--------+--------------------+--------------------+--------------+--------------+
| 51 | 2014-11-07 18:30:00 | 18:30 | Kaiserslautern | Bochum | 2 | 2 |
+-----+---------------------+--------+--------------------+--------------------+--------------+--------------+
如何合并这两列？获取日期时间？
如果有必要转换两列，将日期时间和timedeltas使用to_datetime具有to_timedelta：
df['date'] = pd.to_datetime(df['date']) + pd.to_timedelta(df['time'] + ':00')
如果已经有日期时间只添加时间增量：
df['date'] += pd.to_timedelta(df['time'] + ':00')
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句