33. Pandas的时间序列数据-Timestamp
在pandas里可以使用pandas.tslib.Timestamp类来实现时间序列,本章就Timestamp进行展开,了解该类的基本使用。
from pandas.tslib import Timestamp
cur0 = Timestamp("2018-12-26 17:30:36")
print cur0
cur0 = Timestamp("17:30:36")
print cur0
程序执行结果:
2018-12-26 17:30:36
2018-12-16 17:30:36
使用pandas的timedelta模块实现时间的间隔。
from pandas.tslib import Timestamp
cur0 = Timestamp("2018-12-26 17:30:36")
print cur0
cur0 = Timestamp("17:30:36")
print cur0
import pandas as pd
from datetime import datetime
cur1 = cur0 + pd.Timedelta(days = 1)
print cur1
cur2 = datetime(2018,12,16,17,30, 36) + pd.Timedelta(days = 1)
print cur2
程序执行结果:
2018-12-26 17:30:36 # cur0
2018-12-16 17:30:36 # cur0
2018-12-17 17:30:36 # cur1
2018-12-17 17:30:36 # cur2
利用pandas的timedelta构造时间序列数据:
import numpy as np
import pandas as pd
b = datetime(2018,12,16, 17,30,55)
vi = np.random.randn(60)
ind = []
for x in range(60):
bi = b + pd.Timedelta(minutes = x)
ind.append(bi)
ts = pd.Series(vi, index = ind)
print ts[:5]
程序的执行结果:
2018-12-16 17:30:55 -0.816316
2018-12-16 17:31:55 -0.914680
2018-12-16 17:32:55 -0.304760
2018-12-16 17:33:55 -1.339267
2018-12-16 17:34:55 1.578459
dtype: float64