Dec-17-2021, 04:47 PM
This is a good solution...
import pandas as pd import numpy as np # Import data data = pd.read_excel('moving_average.xlsx', index_col=0, header=0) results = [] for i in range(100): tmp = data.rolling(i+1, center=False, axis=0).mean() results.append(tmp) df=pd.concat(results, axis=1) df.to_excel("output.xlsx")