python - 在Python中将日期时间转换或更改为军事时间

Question

1. 在 Colab 或 Jupyter Python 笔记本中
2. 尝试将日期时间更改为军事日期时间
3. 原始:pickup_datetime = 02/10/2015 08:46:15 AM
4. 错误:必须是str，而不是Series(但无法转为字符串)
5. 所以，
6. 将日期时间分隔为:pickup_date 02/10/2015，pickup_time 08:46:15 AM
7. dateutil.parser.parses 必须是 str，而不是 Series(x):从 02/10/2015 到:2014/02/10
8. 无法转换或更改时间:上午 08:46:15 为 24 小时军用时间
9. 错误:必须是str，而不是Series(但无法转为字符串)
10. 救命!

代码:

t = df['pickup_24'] 
datetime.datetime.strptime(t, '%I:%M:%S %p')
# errors: strptime() argument 1 must be str, not Series

代码:

t = df['pickup_24']
datetime.datetime.strptime(t, '%I:%M:%S %p')
# error:----> 4 datetime.datetime.strptime(t, '%I:%M:%S %p')
# TypeError: strptime() argument 1 must be str, not Series

代码:

df['pickup_24'].dt.strftime('%Y-%m-%d %p')
# error:strptime() argument 1 must be str, not Series

Answer 1

我认为你需要to_datetime使用 format 参数，如有必要，请添加 Series.dt.time :

df = pd.DataFrame({'pickup_24':['08:46:15 AM','08:46:15 PM']})
df['dates'] = pd.to_datetime(df['pickup_24'], format='%I:%M:%S %p')
df['24H'] = pd.to_datetime(df['pickup_24'], format='%I:%M:%S %p').dt.strftime('%H:%M:%S')
df['times'] = pd.to_datetime(df['pickup_24'], format='%I:%M:%S %p').dt.time
print (df)
     pickup_24               dates       24H     times
0  08:46:15 AM 1900-01-01 08:46:15  08:46:15  08:46:15
1  08:46:15 PM 1900-01-01 20:46:15  20:46:15  20:46:15

或者，如果输入输出数据是日期时间，则添加 Series.dt.strftime对于自定义格式:

df = pd.DataFrame({'pickup_24':['02/10/2015 08:46:15 AM','02/10/2015 08:46:15 PM']})
df['datetimes'] = pd.to_datetime(df['pickup_24'], format='%m/%d/%Y %I:%M:%S %p')
df['strings'] = pd.to_datetime(df['pickup_24'], format='%m/%d/%Y %I:%M:%S %p').dt.strftime('%m/%d/%Y %H:%M:%S')
print (df)
                pickup_24           datetimes              strings
0  02/10/2015 08:46:15 AM 2015-02-10 08:46:15  02/10/2015 08:46:15
1  02/10/2015 08:46:15 PM 2015-02-10 20:46:15  02/10/2015 20:46:15