In [1]:
import numpy as np, pandas as pd, pandas_datareader.data as data
import matplotlib
from datetime import datetime as dt
%matplotlib inline
In [2]:
start = dt(2016,5,31)
start
Out[2]:
In [3]:
stocks = ['FB', 'AMZN', 'GOOG', 'NFLX', 'GLD']
In [4]:
stocks_data = data.DataReader(stocks, 'google', start)['Close']
stocks_data.describe()
Out[4]:
In [6]:
stocks_data.head()
Out[6]:
In [7]:
stocks_ln =pd.DataFrame()
for col in stocks_data:
if col not in stocks_ln:
stocks_ln[col] = np.log(stocks_data[col]).diff()
stocks_ln.head()
Out[7]:
In [8]:
corr_stocks = stocks_ln.corr()
In [9]:
corr_stocks
Out[9]:
In [ ]:
In [11]:
corr_stocks['AMZN'].sort_values(ascending=False)
Out[11]:
In [12]:
from pandas.tools.plotting import scatter_matrix
scatter_matrix(stocks_ln, figsize=(16,12), alpha=0.3)
Out[12]:
In [ ]:
Advertisement