from bokeh.palettes import RdYlBu11
from bokeh.plotting import show, output_file, reset_output

output_file("bokehplot.html")

mytools = ['pan', 'box_zoom', 'resize', 'wheel_zoom',
           'reset']  # Does not allow save and question options
p = figure(width=800, height=600, tools=mytools, x_axis_type='datetime')
cols = mydata.columns.values[:-1]
print cols
mypalette = RdYlBu11[0:len(cols)]
print mypalette
dates = mydata.index.values
print dates
for indx, col in enumerate(cols):
    p.line(dates, mydata[col], color=mypalette[indx], line_width=3)

show(p)
reset_output()

#mydata = quandl.get("PIKETTY/TS9_3")
#mydata1 = quandl.get("PIKETTY/TS9_5")
mydata = pd.read_csv('PIKETTY-TS9_3.csv', index_col=0)
#Transform to datetime
mydata.index = pd.to_datetime(mydata.index)

mydata1 = pd.read_csv('PIKETTY-TS9_5.csv', index_col=0)
mydata1.index = pd.to_datetime(mydata1.index)

print(mydata.head())
print(mydata1.head())