pandas+create_engine:连接数据库,返回DataFrame类型的结果
导包
from sqlalchemy import create_engine
import pandas as pd
连接
获取连接引擎engine
engine = create_engine('mysql+pymysql://root:dong@localhost:3306/stu?charset=utf8')
sql语句
sql = 'select * from student'
sql = 'select name,sum(year(age)) as 年龄和 from student'
查询
pd.read_sql_query(sql,engine)
返回值类型:pandas.core.frame.DataFrame