背景
pandas：1.5.2
sqlalchemy：2.0.4
import pandas as pd
from sqlalchemy
import create_engine # SQLAlchemy v. 2.0!
sql_engine = create_engine('postgresql://user:pass@host:5432/database')
df = pd.read_sql(f''' SELECT * FROM table LIMIT 100''',
sql_engine)
報(bào)錯(cuò)
Traceback (most recent call last):
File "/app/test.py", line 31, in <module>
df = pd.read_sql(f'''
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 590, in read_sql
return pandas_sql.read_query(
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1560, in read_query
result = self.execute(*args)
File "/usr/local/lib/python3.10/site-packages/pandas/io/sql.py", line 1405, in execute
return self.connectable.execution_options().execute(*args, **kwargs)
AttributeError: 'OptionEngine' object has no attribute 'execute'
解決
https://github.com/pandas-dev/pandas/issues/40686文章來源：http://www.zghlxwxcb.cn/news/detail-559778.html
在這篇文章中看到，sqlalchemy的1.4和2.0兩種不同的語法，pandas暫時(shí)還不支持2.0，所以將sqlalchemy回退到1.4.45即可。文章來源地址http://www.zghlxwxcb.cn/news/detail-559778.html
到了這里，關(guān)于AttributeError: ‘OptionEngine‘ object has no attribute ‘execute‘的文章就介紹完了。如果您還想了解更多內(nèi)容，請?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
