python-生成时间序列并获取时、分、秒_pandas将时间从毫秒转化为分钟

利用pandas生成时间序列

import datetime
import pandas as pd
yyyyMMddHHmmss_begin = '20191201_000000'
yyyyMMddHHmmss_end = '20191211_000000'
yyyyMMddHHmmss_begin = datetime.datetime.strptime(yyyyMMddHHmmss_begin, '%Y%m%d_%H%M%S').strftime('%Y-%m-%d')
yyyyMMddHHmmss_end = (datetime.datetime.strptime(yyyyMMddHHmmss_end, '%Y%m%d_%H%M%S')+datetime.timedelta(days=1)).strftime('%Y-%m-%d')
# 每second_interval秒生成一次时间
Second_interval = 300
time_predict_iter = pd.date_range(start = yyyyMMddHHmmss_begin, end = yyyyMMddHHmmss_end, freq = str(Second_interval)+'s')
1
2
3
4
5
6
7
8
9

结果 time_predict_iter

time_predict_iter[0]的type是Timestamp

时间戳转为字符串

str1 = time_predict_iter[1].strftime("%Y-%m-%d %H:%M:%S") 
1

转为datetime格式

dt = datetime.datetime.strptime(str1, "%Y-%m-%d %H:%M:%S") 
1

获取dt的hour、minute、second

dt.hour
dt.minute
dt.second
1
2
3

获取每个间隔的h、m、s

str_time = time_predict_iter.strftime("%Y-%m-%d %H:%M:%S")
date_time = []
for i in range(len(str_time)):
    date_time.append(datetime.datetime.strptime(str_time[i], "%Y-%m-%d %H:%M:%S"))
HH = []
mm = []
ss = []
for i in range(len(date_time)):
    HH.append(date_time[i].hour)
    mm.append(date_time[i].minute)
    ss.append(date_time[i].second)
1
2
3
4
5
6
7
8
9
10
11