pandas读取sql文件出现：告警UserWarning: pandas only supports SQLAlchemy connectable

​
错误原因：导入sql的方式更新了

解决方法：

import pandas as pd
from sqlalchemy import create_engine
MYSQL_HOST = 'localhost'
MYSQL_PORT = '3306'
MYSQL_USER = 'root'
MYSQL_PASSWORD = '123456'
MYSQL_DB = 'cldk_data'
engine = create_engine('mysql+pymysql://%s:%s@%s:%s/%s?charset=utf8'
% (MYSQL_USER, MYSQL_PASSWORD, MYSQL_HOST, MYSQL_PORT, MYSQL_DB))

data=pd.read_sql('select * from pt_user',engine)
print(data)

运行结果:

D:\Python\p\Scripts\python.exe "D:\Python\python-learning\数据分析(二)\读取文件.py"
USER_UUID USER_NAME ... DEL_FLAG MODTIME
0 001fddf8608c4cd1bbac81dde4e0c701 zhaowei ... 0 2022-11-16 17:07:01
1 011d83b63034470ab6225a2ead643cf7 hanguobing ... 0 2022-11-16 17:07:01
2 01635ed157e445bba6725675bdd8ff67 renjun ... 0 2022-11-24 10:45:55
3 02d7938e06934f48b92baec5348a8609 yanwenyi ... 0 2020-07-30 16:20:25
4 0311e42abab4467a80aefd2ebd18ab19 zhangjifang ... 0 2020-07-30 16:20:25
.. ... ... ... ... ...
64 9ca276a5609111edabb4204747cf5c3e HuYujiao ... 0 2022-11-10 08:50:39
65 9ca87e7a609111edabb4204747cf5c3e TaoHan ... 0 2022-11-10 08:50:39
66 9ef1c745625d11edbffa005056c00001 wxl ... 0 2022-11-14 21:45:40
67 d6ae0dd2633c11ed9d3d00ffac55512a wec ... 0 2022-11-14 21:43:09
68 fb1b7efc853b40d0b2206d8a1c672d53 eee ... 0 2022-11-17 16:02:18

[69 rows x 10 columns]

进程已结束，退出代码为 0

​