python 时间表_python – 从DatetimeIndex到时间列表

最新推荐文章于 2022-11-03 13:59:48 发布

DataKing

最新推荐文章于 2022-11-03 13:59:48 发布

阅读量925

点赞数 1

文章标签： python 时间表

本文链接：https://blog.csdn.net/weixin_35319666/article/details/113966185

版权

本文介绍了如何使用pandas的DatetimeIndex生成一天中每5分钟的时间列表，并将其转换为每5分钟包含所有秒数的列表。通过pd.date_range()函数创建时间间隔，并使用tolist()和strftime()进行格式化，最终得到所需格式的时间列表。

摘要由CSDN通过智能技术生成

我的目标是有一个时间列表(以秒为单位),已经在一整天的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 00:00:21',

'2016-07-08 00:00:22', '2016-07-08 00:00:23',

'2016-07-08 00:00:24', '2016-07-08 00:00:25',

'2016-07-08 00:00:26', '2016-07-08 00:00:27',

'2016-07-08 00:00:28', '2016-07-08 00:00:29',

'2016-07-08 00:00:30', '2016-07-08 00:00:31',

'2016-07-08 00:00:32', '2016-07-08 00:00:33',

'2016-07-08 00:00:34', '2016-07-08 00:00:35',

'2016-07-08 00:00:36', '2016-07-08 00:00:37',

'2016-07-08 00:00:38', '2016-07-08 00:00:39',

'2016-07-08 00:00:40', '2016-07-08 00:00:41',

'2016-07-08 00:00:42', '2016-07-08 00:00:43',

'2016-07-08 00:00:44', '2016-07-08 00:00:45',

'2016-07-08 00:00:46', '2016-07-08 00:00:47',

'2016-07-08 00:00:48', '2016-07-08 00:00:49',

'2016-07-08 00:00:50', '2016-07-08 00:00:51',

'2016-07-08 00:00:52', '2016-07-08 00:00:53',

'2016-07-08 00:00:54', '2016-07-08 00:00:55',

'2016-07-08 00:00:56', '2016-07-08 00:00:57',

'2016-07-08 00:00:58', '2016-07-08 00:00:59'],

dtype='datetime64[ns]', freq='S')

DatetimeIndex(['2016-07-08 00:05:00', '2016-07-08 00:05:01',

'2016-07-08 00:05:02', '2016-07-08 00:05:03',

'2016-07-08 00:05:04', '2016-07-08 00:05:05',

'2016-07-08 00:05:06', '2016-07-08 00:05:07',

'2016-07-08 00:05:08', '2016-07-08 00:05:09',

'2016-07-08 00:05:10', '2016-07-08 00:05:11',

'2016-07-08 00:05:12', '2016-07-08 00:05:13',

'2016-07-08 00:05:14', '2016-07-08 00:05:15',

'2016-07-08 00:05:16', '2016-07-08 00:05:17',

'2016-07-08 00:05:18', '2016-07-08 00:05:19',

'2016-07-08 00:05:20', '2016-07-08 00:05:21',

'2016-07-08 00:05:22', '2016-07-08 00:05:23',

'2016-07-08 00:05:24', '2016-07-08 00:05:25',

'2016-07-08 00:05:26', '2016-07-08 00:05:27',

'2016-07-08 00:05:28', '2016-07-08 00:05:29',

'2016-07-08 00:05:30', '2016-07-08 00:05:31',

'2016-07-08 00:05:32', '2016-07-08 00:05:33',

'2016-07-08 00:05:34', '2016-07-08 00:05:35',

'2016-07-08 00:05:36', '2016-07-08 00:05:37',

'2016-07-08 00:05:38', '2016-07-08 00:05:39',

'2016-07-08 00:05:40', '2016-07-08 00:05:41',

'2016-07-08 00:05:42', '2016-07-08 00:05:43',

'2016-07-08 00:05:44', '2016-07-08 00:05:45',

'2016-07-08 00:05:46', '2016-07-08 00:05:47',

'2016-07-08 00:05:48', '2016-07-08 00:05:49',

'2016-07-08 00:05:50', '2016-07-08 00:05:51',

'2016-07-08 00:05:52', '2016-07-08 00:05:53',

'2016-07-08 00:05:54', '2016-07-08 00:05:55',

'2016-07-08 00:05:56', '2016-07-08 00:05:57',

'2016-07-08 00:05:58', '2016-07-08 00:05:59'],

dtype='datetime64[ns]', freq='S')

etc

这对我来说很完美！

我现在想要列表,而不是pandas.tseries.index.DatetimeIndex ..

.tolist()方法给出：

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)).tolist()

结果：

[Timestamp('2016-07-08 00:00:00', offset='S'), Timestamp('2016-07-08 00:00:01', offset='S'), Timestamp('2016-07-08 00:00:02', offset='S'), Timestamp('2016-07-08 00:00:03', offset='S'), Timestamp('2016-07-08 00:00:04', offset='S'), Timestamp('2016-07-08 00:00:05', offset='S'), Timestamp('2016-07-08 00:00:06', offset='S'), etc]

我想要这样的东西：

[['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 00:00:21',

'2016-07-08 00:00:22', '2016-07-08 00:00:23',

'2016-07-08 00:00:24', '2016-07-08 00:00:25',

'2016-07-08 00:00:26', '2016-07-08 00:00:27',

'2016-07-08 00:00:28', '2016-07-08 00:00:29',

'2016-07-08 00:00:30', '2016-07-08 00:00:31',

'2016-07-08 00:00:32', '2016-07-08 00:00:33',

'2016-07-08 00:00:34', '2016-07-08 00:00:35',

'2016-07-08 00:00:36', '2016-07-08 00:00:37',

'2016-07-08 00:00:38', '2016-07-08 00:00:39',

'2016-07-08 00:00:40', '2016-07-08 00:00:41',

'2016-07-08 00:00:42', '2016-07-08 00:00:43',

'2016-07-08 00:00:44', '2016-07-08 00:00:45',

'2016-07-08 00:00:46', '2016-07-08 00:00:47',

'2016-07-08 00:00:48', '2016-07-08 00:00:49',

'2016-07-08 00:00:50', '2016-07-08 00:00:51',

'2016-07-08 00:00:52', '2016-07-08 00:00:53',

'2016-07-08 00:00:54', '2016-07-08 00:00:55',

'2016-07-08 00:00:56', '2016-07-08 00:00:57',

'2016-07-08 00:00:58', '2016-07-08 00:00:59'],

['2016-07-08 00:05:00', '2016-07-08 00:05:01',

'2016-07-08 00:05:02', '2016-07-08 00:05:03',

'2016-07-08 00:05:04', '2016-07-08 00:05:05',

'2016-07-08 00:05:06', '2016-07-08 00:05:07',

'2016-07-08 00:05:08', '2016-07-08 00:05:09',

'2016-07-08 00:05:10', '2016-07-08 00:05:11',

'2016-07-08 00:05:12', '2016-07-08 00:05:13',

'2016-07-08 00:05:14', '2016-07-08 00:05:15',

'2016-07-08 00:05:16', '2016-07-08 00:05:17',

'2016-07-08 00:05:18', '2016-07-08 00:05:19',

'2016-07-08 00:05:20', '2016-07-08 00:05:21',

'2016-07-08 00:05:22', '2016-07-08 00:05:23',

'2016-07-08 00:05:24', '2016-07-08 00:05:25',

'2016-07-08 00:05:26', '2016-07-08 00:05:27',

'2016-07-08 00:05:28', '2016-07-08 00:05:29',

'2016-07-08 00:05:30', '2016-07-08 00:05:31',

'2016-07-08 00:05:32', '2016-07-08 00:05:33',

'2016-07-08 00:05:34', '2016-07-08 00:05:35',

'2016-07-08 00:05:36', '2016-07-08 00:05:37',

'2016-07-08 00:05:38', '2016-07-08 00:05:39',

'2016-07-08 00:05:40', '2016-07-08 00:05:41',

'2016-07-08 00:05:42', '2016-07-08 00:05:43',

'2016-07-08 00:05:44', '2016-07-08 00:05:45',

'2016-07-08 00:05:46', '2016-07-08 00:05:47',

'2016-07-08 00:05:48', '2016-07-08 00:05:49',

'2016-07-08 00:05:50', '2016-07-08 00:05:51',

'2016-07-08 00:05:52', '2016-07-08 00:05:53',

'2016-07-08 00:05:54', '2016-07-08 00:05:55',

'2016-07-08 00:05:56', '2016-07-08 00:05:57',

'2016-07-08 00:05:58', '2016-07-08 00:05:59'], etc]

有任何想法吗？

DataKing

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫