python将pandas数据写入sqlserver数据库示例
import pandas as pd
import pyodbc
import sqlalchemy
engin=sqlalchemy.create_engine(“mssql+pyodbc://sa:123@testdb”)
data=pd.read_excel(r"E:\anzhuo\qcm_batch_search.xlsx")
data.to_sql(“单位名称”,engin,index=False,if_exists=‘append’)