Question

I have 2 dataframes in a list, I mean Intraday_Mape and Day_Ahead_Mape are dataframes. These dataframes contains hourly data but I want to change them into monthly data. When I am doing this, I want to use for loop because, I ll deal with more dataframes in the future.

report_dfs = [Intraday_Mape, Day_Ahead_Mape]

for i, _ in enumerate(report_dfs):
    report_dfs[i]=report_dfs[i].index.name =  Date 
    report_dfs[i]=report_dfs[i].resample( M ).mean().reindex(annual_date_range, fill_value = 0)
    report_dfs[i]=report_dfs[i].round(2)

When I print Intraday_Mape, I have still hourly data, it is not change. How can I achieve modified dataframes out of the for loop? I mean, when I print Intraday_Mape:

print(Intraday_Mape)

I got old one. How do I permanently change these datasets outside of the for loop?

Answer 1

请说<代码>(报告_dfs[0]和(报告_dfs ***),以获取数据。您没有实际修改指定的数据范围。你正在篡改你编制的名单上的数据。页: 1

Answer 2

you may want to try the for loop below (assuming report_dfs represents a list of data frames, not a list of strings):

for r in report_dfs:
    r = r.index.name =  Date 
    r = r.resample( M ).mean().reindex(annual_date_range, fill_value = 0)
    r = r.round(2)

友情链接