在营业时间之外屏蔽时间序列 [英] Mask timeseries outside business hours

问题描述

你好，我有一个小时时间序列，如果时间序列索引不在工作时间，我想掩盖.

Hello I have an hourly timeseries that I would like to mask if the timeseries index is outside business hours.

我可以实现我想要的工作日数据，而不是每小时数据

I can achieve what I want for business day data but not hourly data

import datetime
import pandas as pd
import numpy as np
from pandas.tseries.offsets import *

st = datetime.datetime(2013, 1, 1)
ed = datetime.datetime(2013, 2, 1)
myrange = pd.date_range(st, ed, freq='H')
ts = pd.Series(np.random.randn(len(myrange)), index=myrange)
ts.asfreq(BDay()).asfreq(Day())

我尝试生成BDay日期范围，然后将频率更改为每小时，但这不起作用.

I have tried generating a BDay date range and then changing the freq to hourly but this doesn't work.

newrange = pd.date_range(datetime.datetime(2013, 1, 1), datetime.datetime(2013, 1, 1), freq='B') 
#but adding this doesn't work .asfreq(Hour())
ts[ts.index.isin(newrange)].asfreq(Hour()) #Of course this only gives one value on the day

谢谢

推荐答案

要将时间限制为工作日，可以使用:

To restrict your times to Business days you could use:

ts = ts.ix[ts.index.map(BDay())]

和 indexer_between_time 来限制营业时间:

and indexer_between_time to restrict between business hours:

ts = ts.ix[ts.index.indexer_between_time(time(7), time(18))]

要限制在工作时间内的工作日(以任何一种顺序应用).

To restrict to Business days within business hours (apply these in either order).

这篇关于在营业时间之外屏蔽时间序列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！