Python调用MySQL数据库绘制箱线图

需要安装的包pip install sqlalchemypip install pandas读取数据表Python代码import pandas as pdfrom sqlalchemy import create_enginename=‘root‘#mysql用户名pw=‘admin‘#mysql密码host=‘127.0.0.1‘#mysql连接地址port=‘3306‘database=‘pyecharts‘#数据库# 用sqlalchemy构建数据库链接engineconnect_info = ‘mysql+pymysql://{}:{}@{}:{}/{}?charset=utf8‘.format(name,pw,host,port,database)database_info = create_engine(connect_info)#查询的SQL语句sql=""df=pd.read_sql(sql,database_info)#返回结果df为"DataFrame"