我有一个数据框架,如下所示:
Date Time Entry Exist
2013-01-07 05:00:00 29.0 12.0
2013-01-07 10:00:00 98.0 83.0
2013-01-07 15:00:00 404.0 131.0
2013-01-07 20:00:00 2340.0 229.0
2013-01-08 05:00:00 3443.0 629.0
2013-01-08 10:00:00 6713.0 1629.0
2013-01-08 15:00:00 9547.0 2965.0
2013-01-08 20:00:00 10440.0 4589.0
我想将其转换并归一化,以便显示一段时间内的每小时消耗量。
DateTime Entry Exist
2013-01-07 00:00:00 2.0 1.0
2013-01-07 01:00:00 9.0 4.0
2013-01-07 02:00:00 16.0 6.0
2013-01-07 03:00:00 23.0 9.0
2013-01-07 04:00:00 26.0 10.0
2013-01-07 05:00:00 29.0 12.0
2013-01-07 06:00:00 37.0 19.0
2013-01-07 07:00:00 56.0 32.0
2013-01-07 08:00:00 62.0 57.0
2013-01-07 09:00:00 77.0 63.0
2013-01-07 10:00:00 98.0 83.0
2013-01-07 11:00:00 104.0 95.0
.......
我想先将日期和时