In [3]:

    

import numpy as np
import matplotlib.pyplot as plt
import MySQLdb
from sklearn import hmm


    

In [4]:

    

db = MySQLdb.connect(host="localhost", user="root", db = "home_kitchen")


    

In [5]:

    

cursor = db.cursor()


    

In [6]:

    

tablename = 'all_hk'


    

In [7]:

    

PID = 'B000GTR2F6'
PID = ' ' + PID


    

In [8]:

    

sql = "Select RTime, RScore From " +tablename + " Where PID = " + '"' + PID +'";'


    

In [9]:

    

cursor.execute(sql)


    

    
Out[9]:





1432L

In [10]:

    

data = cursor.fetchall()


    

In [11]:

    

data = sorted(data)


    

In [ ]: