要根据日期偏移量选择时间序列的最后一段时间,请使用last () 方法。首先,使用句点和频率设置日期索引。Freq 用于频率 -
i = pd.date_range('2021-07-15', periods=5, freq='3D')
现在,创建一个具有上述索引的 DataFrame -
dataFrame = pd.DataFrame({'k': [1, 2, 3, 4, 5]},index=i)
获取过去 4 天的行,即 4D -
dataFrame.last('4D')
以下是完整的代码 -
import pandas as pd # date index set with 5 periods and frequency of 3 days i = pd.date_range('2021-07-15', periods=5, freq='3D') # creating DataFrame with above index dataFrame = pd.DataFrame({'k': [1, 2, 3, 4, 5]}, index=i) print"DataFrame...\n",dataFrame # fetching last few rows # fetch rows from last 4 days print"Last few rows fetched..\n",dataFrame.last('4D');输出结果
这将产生以下输出 -
DataFrame... k 2021-07-15 1 2021-07-18 2 2021-07-21 3 2021-07-24 4 2021-07-27 5 Last few rows fetched.. k 2021-07-24 4 2021-07-27 5