import _mysql
try:
db=_mysql.connect(host="localhost",user="all", passwd="all")
except:
print "Error en la conexion"
import pyodbc
import pandas.io.sql as pd
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=MSI\SQL2014;DATABASE=Central;UID=sa;PWD=1')
sql="Select top 100 IdActivo,Open1,High,Low from DATA"
df = pd.read_sql(sql,conn)
df.head(1000)
conn.close()