Python按不同周期遍历DatetimeIndex遇ValueError报错求助

我有一个带有DatetimeIndex的DataFrame，尝试按不同频率遍历该索引，编写的代码如下：

import pandas as pd
import numpy as np

data = [[99330,12,122],[1123,1230,1287],[123,101,812739],[1143,12301230,252],[234,342,4546],[2445,3453,3457],[7897,8657,5675],   [46,5675,453],[76,484,3735],   [363,93,4568],   [385,568,367],   [458,846,4847],   [574,45747,658468],   [57457,46534,4675]]
df1 = pd.DataFrame(data, index=['2022-01-01', '2022-01-02', '2022-01-03', '2022-01-04',
                       '2022-01-05', '2022-01-06', '2022-01-07', '2022-01-08',
                       '2022-01-09', '2022-01-10', '2022-01-11', '2022-01-12',
                       '2022-01-13', '2022-01-14'], 
          columns=['col_A', 'col_B', 'col_C'])
df1.index = pd.to_datetime(df1.index)

periodicity_dict = {'1D':'daily', '1W':'weekly'}
for key in periodicity_dict:
    for col in df1.columns:
        df1[col+'_rolling']= np.nan
        for i in pd.date_range(start=df1[col].first_valid_index(), end=df1[col].last_valid_index(), freq=key):
            print(i)

运行时触发如下错误：

ValueError: Of the four parameters: start, end, periods, and freq, exactly three must be specified

错误原因 #

当start和end的时间跨度无法被指定的freq整除时，pd.date_range无法自动确定最终的日期序列边界，必须显式补充参数消除歧义。

方案1：用resample替代手动遍历（推荐） #

Pandas的resample方法专门用于按时间频率分组处理，比手动遍历更高效且不易出错。示例代码如下：

import pandas as pd
import numpy as np

data = [[99330,12,122],[1123,1230,1287],[123,101,812739],[1143,12301230,252],[234,342,4546],[2445,3453,3457],[7897,8657,5675],   [46,5675,453],[76,484,3735],   [363,93,4568],   [385,568,367],   [458,846,4847],   [574,45747,658468],   [57457,46534,4675]]
df1 = pd.DataFrame(data, index=['2022-01-01', '2022-01-02', '2022-01-03', '2022-01-04',
                       '2022-01-05', '2022-01-06', '2022-01-07', '2022-01-08',
                       '2022-01-09', '2022-01-10', '2022-01-11', '2022-01-12',
                       '2022-01-13', '2022-01-14'], 
          columns=['col_A', 'col_B', 'col_C'])
df1.index = pd.to_datetime(df1.index)

periodicity_dict = {'1D':'daily', '1W':'weekly'}
for freq, name in periodicity_dict.items():
    resampled_group = df1.resample(freq)
    for col in df1.columns:
        # 这里可替换为你需要的滚动计算逻辑，示例为周期均值
        df1[f'{col}_rolling_{name}'] = resampled_group[col].transform('mean')

方案2：修正pd.date_range参数 #

如果必须手动遍历日期序列，可以通过计算周期数指定periods参数，确保序列生成无歧义：

# 原代码中遍历日期的部分替换为：
start = df1[col].first_valid_index()
end = df1[col].last_valid_index()
# 计算从start到end的周期数量
periods = (end - start) // pd.Timedelta(freq=key) + 1
for i in pd.date_range(start=start, periods=periods, freq=key):
    print(i)

也可以使用closed参数明确序列的闭合规则（如closed='left'），但这种方式可能遗漏部分边界日期，需根据需求调整。

内容的提问来源于stack exchange，提问作者MathMan 99