pandas - 如何在 Pandas 中重复 DatetimeIndex

Question

如何创建重复日期范围？例如，我希望以下内容重复三次

rng = pd.date_range('1/1/2011', periods=3, freq='W')

预期输出:
2011-01-02
2011-01-09
2011-01-16
2011-01-02
2011-01-09
2011-01-16
2011-01-02
2011-01-09
2011-01-16

我试过:

rng = pd.concat([rng] * 3, axis=1) #which does not work with dates
rng = np.repeat(rng,3) #这将每个日期重复三次而不是列表三次？

Answer 1

我们可以使用np.tile并用 DatetimeIndex 包裹如果需要，保留类型:

rng = pd.DatetimeIndex(
    np.tile(pd.date_range('1/1/2011', periods=3, freq='W'), 3)
)

rng:

DatetimeIndex(['2011-01-02', '2011-01-09', '2011-01-16', '2011-01-02',
               '2011-01-09', '2011-01-16', '2011-01-02', '2011-01-09',
               '2011-01-16'],
              dtype='datetime64[ns]', freq=None)