python学习记录(1)--python3连接SQl Server，并读取表中数据

1、python3连接SQl Server，并读取表中数据。

import pyodbc
import pandas as pd
# 如需账号、密码登录，则需加入相应参数UID、PWD
cnxn = pyodbc.connect(DRIVER='{SQL Server}',SERVER='.',DATABASE='student_info26')   
sc26 = pd.read_sql("select * from sc26",cnxn)
for i in range(sc26.shape[0]):
    for j in range(sc26.shape[1]):
        try:
            sc26.iloc[i,j] = sc26.iloc[i,j].strip()     # 去掉首尾多余空格
        except:
            pass
        continue
print(sc26)

结果：