本文主要是介绍pandas and sqlalchemy compatibility，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
Error:
TypeError: init() got multiple values for argument ‘schema’
Error in:
pandas2.0.3 and sqlalchemy1.4.46
Original answer:
As you stated, a workaround is to downgrade to SQLAlchemy<2.0,
pip install --upgrade sqlalchemy==1.4.47
There is already a fix in pandas (https://github.com/pandas-dev/pandas/pull/48576). Either install pandas from git or wait for a new release.
Edit: @DrD pointed out that the commit is already merged and will be part of pandas 2.x, also the comments point to the probability of pandas < 2.0 never supporting SQLAlchemy 2.x.
Share
Edit
Follow
edited Apr 26, 2023 at 16:39
answered Feb 10, 2023 at 22:41
cabo’s user avatar
cabo
13711 silver badge1010 bronze badges
2
as of today (Mar 28) the issue is merged on master, but no release was done, it looks like it will be part of pandas 2.* which is hopefully released, soon. –
DrD
CommentedMar 28, 2023 at 15:06
方法三：安装sqlalchemy-databricks 以代替SQLAlchemy，前提把SQLAlchemy卸载干净，以防到时冲突报错。
21 Aug 2024
这篇关于pandas and sqlalchemy compatibility的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
