https://pythondata.com/quick-tip-sqlalchemy-for-mysql-and-pandas/
https://www.youtube.com/watch?v=M-4EpNdlSuY
https://www.programcreek.com/python/example/101381/pandas.read_sql
一切看起来都很好,与代码有关
import pandas
import sqlalchemy
engine = sqlalchemy.create_engine('mysql+pymysql://root:mypass@example.com:3306/mydatabase')
df = pandas.read_sql("SELECT * FROM persons", con = engine)
收到以下错误 -
AttributeError:'Engine'对象没有属性'游标'
当我尝试传递“connection”变量而不是“engine”,如下所示 -
import pandas
import sqlalchemy
engine = sqlalchemy.create_engine('mysql+pymysql://root:mypass@example.com:3306/mydatabase')
connection = engine.connect()
df = pandas.read_sql("SELECT * FROM persons", con = connection)
它说 -
属性错误:'Connection'对象没有'cursor'属性
我做错了什么?
pandas.read_sql_query()
吗?安装了哪些版本的 pandas 和 sqlalchemy? - codeape