pandas数据框架str到datetime，格式为5:30PM

Question

我想用pd.to_datetime将数据框列从str转换为日期时间格式。

import pandas as pd
data = {'Event Number' : [1, 2, 3] ,
'Time': ['1PM', '2PM', '5:30PM'] }
df = pd.DataFrame (data)
pd.to_datetime(df['Time', format = '%I%p']

然而，我得到一个错误消息:时间数据'5:30PM'不匹配格式'%I%p' (match)

Answer 1

你可以让Pandas猜:

pd.to_datetime('2021-01-01 ' + df['Time'])

输出:

0   2021-01-01 13:00:00
1   2021-01-01 14:00:00
2   2021-01-01 17:30:00
Name: Time, dtype: datetime64[ns]