python - 从日期时间中提取时间以便在 Pandas 中进行比较

Question

我有一个数据框

customer_number   purchase_time         quantity
14                2007-03-01 07:06:00   10
20                2007-03-12 13:05:00   13

我试图找到上午和下午购买的总数量。我将 purchase_time 转换为 datetime

df['purchase_time'] = pd.to_datetime(df['purchase_time'])
# Baskets bought in morning.
df[df['purchase_time'] < '12:00:00']

但是，结果是原始数据集。

Answer 1

你可以

df[df['purchase_time'].dt.time < pd.to_datetime('12:00:00').time()]
Out[152]: 
   customer_number       purchase_time  quantity
0               14 2007-03-01 07:06:00        10