EXCEL数据插不进MYSQL数据库

MYSQL已安装好，用navicat可以连接上。

import pandas as pd
import pymysql
from sqlalchemy import create_engine
engine = create_engine("mysql+pymsql://root:123456@127.0.0.1:3306/titanic?charset=utf8")
data = pd.read_excel("titanic3.xls")
data.to_sql("my_titanic", con=engine, index=False, if_exists='replace')

出错：
"C:\Program Files\Python38\python.exe" C:/Users/Administrator/PycharmProjects/pandastitan/insql.py
Traceback (most recent call last):
File "C:/Users/Administrator/PycharmProjects/pandastitan/insql.py", line 4, in
engine = create_engine("mysql+pymsql://root:123456@127.0.0.1:3306/titanic?charset=utf8")
File "", line 2, in create_engine
File "C:\Program Files\Python38\lib\site-packages\sqlalchemy\util\deprecations.py", line 298, in warned
return fn(*args, **kwargs)
File "C:\Program Files\Python38\lib\site-packages\sqlalchemy\engine\create.py", line 522, in create_engine
entrypoint = u._get_entrypoint()
File "C:\Program Files\Python38\lib\site-packages\sqlalchemy\engine\url.py", line 636, in _get_entrypoint
cls = registry.load(name)
File "C:\Program Files\Python38\lib\site-packages\sqlalchemy\util\langhelpers.py", line 343, in load
raise exc.NoSuchModuleError(
sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:mysql.pymsql

Process finished with exit code 1

pymysql和sqlalchemy这两个个库重新安装一下试试。

数据库驱动名写错了，代码中这句创建一个连接引擎engine = create_engine("mysql+pymsql://root:123456@127.0.0.1:3306/titanic?charset=utf8")中“pymsql”写错了，漏写了个y,应该写成 pymysql。