from IPython.core.display import HTML
HTML("<iframe src=http://pandas.pydata.org width=600 height=350></iframe>")

import pandas as pd
import pandas.io.data
import datetime

aapl = pd.io.data.get_data_yahoo('AAPL', 
                                 start=datetime.datetime(2006, 10, 1), 
                                 end=datetime.datetime(2015, 1, 4))
aapl.head()

aapl.to_csv('aapl_ohlc.csv')
%ls

df = pd.read_csv('aapl_ohlc.csv', index_col='Date', parse_dates=True)
df.tail()

df.index

df['diff'] = df.Open - df.Close
df.head()

def show_col(dataframe, name):
    ts = dataframe[name][-10:]
    print ts

from IPython.html.widgets import interact, fixed

interact(show_col, dataframe=fixed(df), name=list(df.columns.values))

close_px = df['Adj Close']
mavg = pd.rolling_mean(close_px, 40)

%pylab inline
close_px.plot(label='AAPL')
mavg.plot(label='mavg')
plt.legend(loc=4)