按天计数
df_test_need['入场时间'] = pd.to_datetime(df_test_need['入场时间'])
df_test_need = df_test_need.set_index(df_test_need["入场时间"])
df_cal = df_test_need.groupby([pd.Grouper(key='入场时间', freq = "D")]).size().reset_index(name = 'count')
print(df_cal.loc[df_cal["count"] == max(df_cal["count"])]) # 显示每日数量最多的行
time_with_max_num = df_cal.loc[df_cal[“count”] == max(df_cal[“count”])][“入场时间”] # 记录数目最多的行
Pandas按日期对状态进行汇总统计
想得到这样的结果
[
{date:2017-04-03, status0:10, status1:12, status10:12}
…
]
lst = []
for name, group in df.groupby('date'):
d = dict(date=name)
for n, g in group.groupby('status'):
d['status{}'.format(n)] = len(g)
lst.append(d)
print lst