如何获取由开始和结束日期时间数组定义的pandas数据帧范围的平均值？

import pandas as pd
import numpy as np

start_dates = pd.to_datetime(['2022-01-01', '2022-02-01', '2022-03-01'])
end_dates = pd.to_datetime(['2022-01-31', '2022-02-28', '2022-03-31'])

result_df = pd.DataFrame(columns=['Start Date', 'End Date', 'Average'])

for i in range(len(start_dates)):
    start_date = start_dates[i]
    end_date = end_dates[i]
    
    # 生成随机数据作为示例
    data = pd.DataFrame({'Date': pd.date_range(start_date, end_date),
                         'Value': np.random.randint(1, 100, size=(end_date - start_date + pd.Timedelta(days=1)).days)})
    
    # 计算平均值
    average = data['Value'].mean()
    
    # 将结果添加到数据帧中
    result_df = result_df.append({'Start Date': start_date, 'End Date': end_date, 'Average': average}, ignore_index=True)

print(result_df)