时间索引问题

2024-06-24 13:35:04 发布

您现在位置:Python中文网/ 问答频道 /正文

我有以下代码

import datetime
#import numpy as np
import jacks_toolbox.getHistoricalData as dt


# ------------------------------------------------------------------------------
# Config
# ------------------------------------------------------------------------------
rolling_time = 15
num_days = 20

Start = "2016-09-27 00:00:00"
End = "2016-10-14 23:00:00"

settleTimeStr = "2016-10-14 14:00:00"

# ------------------------------------------------------------------------------
# Start execution
# ------------------------------------------------------------------------------
# Get a window of data from MySQL and plot it
startTime  = datetime.datetime.strptime(Start, "%Y-%m-%d %H:%M:%S")
endTime    = datetime.datetime.strptime(End, "%Y-%m-%d %H:%M:%S")
settleTime = datetime.datetime.strptime(settleTimeStr, "%Y-%m-%d %H:%M:%S")

print "Start time: " + startTime.strftime("%Y-%m-%d %H:%M:%S")
print "End time: " + endTime.strftime("%Y-%m-%d %H:%M:%S")
print "Settle time: " + settleTime.strftime("%Y-%m-%d %H:%M:%S")

data = dt.getHistoricalDataByTime(startTime, endTime, 5)
settles = dt.getHistoricalDataByTime(startTime, settleTime, 5)

print settles[::1425]

我正在尝试索引它,以便它从我的开始时间开始每24小时打印一次时间,但目前它正在打印以下内容:

Start time: 2016-09-27 00:00:00
End time: 2016-10-14 23:00:00
Settle time: 2016-10-14 14:00:00
Inst                     7_year        UBZ6
2016-09-27 00:00:00   99.735491  183.839583
2016-09-28 00:00:00   99.906250  185.593750
2016-09-29 00:00:00   99.714375  184.936422
2016-09-30 00:00:00  100.012908  186.308594
2016-10-03 00:00:00   99.596467  184.013021
2016-10-04 00:00:00   99.450893  183.697917
2016-10-05 00:01:00   99.109375  181.457386
2016-10-06 00:01:00   98.953804  180.645833
2016-10-07 00:01:00   98.761837  180.049107
2016-10-10 00:01:00         NaN  179.682292
2016-10-11 00:31:00   98.584375  178.619318
2016-10-12 00:31:00   98.501563  178.125000
2016-10-13 00:31:00   98.799342  179.251042
2016-10-14 00:31:00   98.687500  178.328125

出于某种原因,这是增加一分钟,然后30分钟的时间,我试图索引它,我不知道为什么这是。最初我用1440开始,因为它是24*60,但注意到它在第一组时间里被关闭了15分钟,所以我接着切换到1425,这就是我得到的。如有任何帮助/建议,将不胜感激


Tags: importdatetimetimeas时间dtstartend