In [ ]:

    

import MySQLdb as mdb
import pandas as pd
import plotly
con = mdb.connect('127.0.0.1', 'root', 'paytm@197', 'stocks');
with con:
    cur = con.cursor()
    cur.execute("select * from stock_data where symbol = 'pnb'")
    rows = cur.fetchall()
    df = pd.DataFrame( [[ij for ij in i] for i in rows] )
    #print(df.head(20))
    print df[4].plot()


    

In [24]:

    

import plotly
plotly.__version__


    

    
Out[24]:





'3.5.0'