pandas中配置SQL Server引擎

196 阅读1分钟
import pandas as pd
from sqlalchemy import create_engine

USER = ""
PASSWORD = ""
HOST = ""
DATABASE = ""
def sql_engine():
    engine_str = "mssql+pyodbc://" + USER + ":" + PASSWORD + "@" + HOST + "/" + DATABASE + "?driver=SQL+Server"
    engine = create_engine(engine_str)
    return engine