从…开始
mydate col_name0 2000-12-29 00:10:00 action11 2000-12-29 00:20:00 action22 2000-12-29 00:30:00 action23 2000-12-29 00:40:00 action14 2000-12-29 00:50:00 action15 2000-12-31 00:10:00 action16 2000-12-31 00:20:00 action27 2000-12-31 00:30:00 action2
你可以做
df['mydate'] = pd.to_datetime(df['mydate'])df = df.set_index('mydate')df['day'] = df.index.datecounts = df.groupby(['day', 'col_name']).agg(len)但是也许有一个更直接的方法。无论如何以上应该工作。
如果要将计数用作数据框，则将其转换回
counts = pd.Dataframe(counts, columns=['count'])
