我刚开始接触Pandas,遇到了一些困难。 我想通过小时聚合事件(获取计数),并在事件中具有开始时间和结束时间。
例如:
一个示例:
event, start, end
soccer, 2020-01-20 00:34:00, 2020-01-20 02:34:00,
football, 2020-01-20 00:34:00, 2020-01-20 01:34:00
etc
期望输出:
00:00:00 - 2 (both began in 0th hour and went to 1st hour)
01:00:00 - 2 (both were live in 1st hour)
02:00:00 - 1 (only soccer occurred in 02 hour)
您如何解决这个问题?我尝试过重新索引、重新抽样、时间差和时间索引等方法,但都没有成功。