我的目标是有一个时间列表(以秒为单位),已经在一整天的5分钟内列入时间列表.
这是我的代码,将“2016-07-08”的整天打包5分钟:
pd.date_range('2016-07-08 00:00:00', '2016-07-08 23:59:00', freq='5Min')
结果 :
DatetimeIndex(['2016-07-08 00:00:00', '2016-07-08 00:05:00',
'2016-07-08 00:10:00', '2016-07-08 00:15:00',
'2016-07-08 00:20:00', '2016-07-08 00:25:00',
'2016-07-08 00:30:00', '2016-07-08 00:35:00',
'2016-07-08 00:40:00', '2016-07-08 00:45:00',
...
'2016-07-08 23:10:00', '2016-07-08 23:15:00',
'2016-07-08 23:20:00', '2016-07-08 23:25:00',
'2016-07-08 23:30:00', '2016-07-08 23:35:00',
'2016-07-08 23:40:00', '2016-07-08 23:45:00',
'2016-07-08 23:50:00', '2016-07-08 23:55:00'],
dtype='datetime64[ns]', length=288, freq='5T')
这是每5分钟包含所有时间(按秒)的代码:
for time in pd.date_range('2016-07-08 00:00:00', '2016-07-08 23:59:00', freq='5Min').tolist():
time_by_5_min = datetime.datetime.strftime(time.to_datetime(), "%Y-%m-%d %H:%M:%S")
print pd.date_range(time_by_5_min, freq='S', periods=60)
结果 :
DatetimeIndex(['2016-07-08 00:00:00', '2016-07-08 00:00:01',
'2016-07-08 00:00:02', '2016-07-08 00:00:03',
'2016-07-08 00:00:04', '2016-07-08 00:00:05',
'2016-07-08 00:00:06', '2016-07-08 00:00:07',
'2016-07-08 00:00:08', '2016-07-08 00:00:09',
'2016-07-08 00:00:10', '2016-07-08 00:00:11',
'2016-07-08 00:00:12', '2016-07-08 00:00:13',
'2016-07-08 00:00:14', '2016-07-08 00:00:15',
'2016-07-08 00:00:16', '2016-07-08 00:00:17',
'2016-07-08 00:00:18', '2016-07-08 00:00:19',
'2016-07-08 00:00:20', '2016-07-08 0