需安装的包
pymysql
pandas
sqlalchemy
import pymysql
import pandas as pd
from sqlalchemy import create_engine
def GetQueryByDF(self,sql):
list_conn = self.GetDBConnectStr()
connect_info = 'mysql+pymysql://{}:{}@{}:{}/{}?charset=utf8'\
.format("user", "passwd", "hostname", "port","dbname")
engine = create_engine(connect_info)
result = pd.read_sql(sql, engine)
return result
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。