pandas 连接数据库

读取MySql数据

 import MySQLdb
 import pandas as pd
 conn = MySQLdb.connect(host = host,port = port,user = username,passwd = password,db = db_name)
 data = pd.read_sql('select * from table_name',con=conn)
 conn.close() 

读取SqlServer数据

 import pymssql
 conn = pymssql.connect(host=host, port=port ,user=username, password=password, database=database)

 sql= "select  * from  CUST_CSI_BND_INDX"#查询条件
 data = pd.read_sql(sql,con=conn)
 conn.close()

e.g
import pandas as pd
import pymssql
conn=pymssql.connect(host="172.18.3.7",user="gaokexin",password="gaokexin",database="DATAPOOL")
sql= "select  * from  CUST_CSI_BND_INDX"
data=pd.read_sql_query(sql,con=conn)
conn.close() 

 

https://blog.csdn.net/weixin_42213622/article/details/86523400   

各种连接数据库详解