/Python/12 month movinf average in python for dataframe

12 month movinf average in python for dataframe

Rolling average df

df['pandas_SMA_3'] = df.iloc[:,1].rolling(window=3).mean()

Source: datacamp.com

12 month movinf average in python for dataframe

start_date = '2015-01-01'
end_date = '2016-12-31'

fig, ax = plt.subplots(figsize=(16,9))

ax.plot(data.loc[start_date:end_date, :].index, data.loc[start_date:end_date, 'MSFT'], label='Price')
ax.plot(long_rolling.loc[start_date:end_date, :].index, long_rolling.loc[start_date:end_date, 'MSFT'], label = '100-days SMA')
ax.plot(short_rolling.loc[start_date:end_date, :].index, short_rolling.loc[start_date:end_date, 'MSFT'], label = '20-days SMA')

ax.legend(loc='best')
ax.set_ylabel('Price in $')
ax.xaxis.set_major_formatter(my_year_month_fmt)

Source: learndatasci.com

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)

Source: learndatasci.com

12 month movinf average in python for dataframe

# Calculating the long-window simple moving average
long_rolling = data.rolling(window=100).mean()
long_rolling.tail()

Source: learndatasci.com

12 month movinf average in python for dataframe

# Calculating the short-window simple moving average
short_rolling = data.rolling(window=20).mean()
short_rolling.head(20)

Source: learndatasci.com

Similar codes

0 vote129 views1 answer
No matching distribution found for numpy.core._multiarray_umath
Python
0 vote270 views1 answer
Python devops modules
Python
0 vote139 views1 answer
Sqlalchemy_database_uri
Python
0 vote128 views1 answer
Python get host.docker.internal ip site:stackoverflow.com
Python
-1 vote125 views1 answer
Http python lib
Python
0 vote121 views1 answer
How to select li element in selenium python
Python
24 votes138 views3 answers
Get last n characters of string python
Python
1 vote123 views1 answer
Python order 2d array by secode element
Python
3 votes129 views1 answer
How to export a string as txt file in python
Python
1 vote120 views1 answer
Selenium close current driver but don't quit
Python