5 year moving average in python code example
Example 1: rolling average df
df['pandas_SMA_3'] = df.iloc[:,1].rolling(window=3).mean()
Example 2: moving averages python
df['data'].rolling(3).mean()
df['data'].shift(periods=1).rolling(3).mean()
Example 3: 12 month movinf average in python for dataframe
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import matplotlib.dates as mdates
%matplotlib inline
import seaborn as sns
sns.set(style='darkgrid', context='talk', palette='Dark2')
my_year_month_fmt = mdates.DateFormatter('%m/%y')
data = pd.read_pickle('./data.pkl')
data.head(10)