python - 如何在Python中分割时间数据？

Question

我有一个如下所示的数据框:

d={
    'Date' :['2016-10-30','2016-10-30','2016-11-01','2016-10-30'],
    'Time':['09:58:11', '10:05:34', '10:07:57', '11:15:32'],
    'Transaction':[2,3,1,1]
}

df=pd.DataFrame(d, columns=['Date','Time','Transaction'])

我需要创建一个新变量作为 Time_Group。对于 Time_group 的数据，For (6,11] 为“上午”，for (11,17] 为“下午”，for (17,20] 为“晚上”。如何使用时间列子创建此变量？

Answer 1

将pd.cut与pd.Timedelta结合使用:

u = df.assign(Time=pd.to_timedelta(df['Time']))
bins = [6,11,17,20]
labels = ['Morning','Afternoon','Evening']
u = u.assign(Time_Group=pd.cut(u['Time'],[pd.Timedelta(hours=i) for i in bins],
                               labels=labels))

---

print(u)
         Date     Time  Transaction Time_Group
0  2016-10-30 09:58:11            2    Morning
1  2016-10-30 10:05:34            3    Morning
2  2016-11-01 10:07:57            1    Morning
3  2016-10-30 11:15:32            1  Afternoon