将 sqlite3 数据库读入 pandas DataFrame 时如何修复 SyntaxError

Question

我正在尝试使用 pandas 读取 sqlite3 数据库。不幸的是，在我的代码中是 SyntaxError 但我找不到它。代码与许多教程中的代码相同，所以我不知道问题出在哪里import pandas as pdimport sqlite3con = sqlite3.connect("activity_log.db")query = "SELECT * from log"df = pd.read_sql_query(query, con)print(df)con.close()结果：" Traceback (most recent call last):  File "C:/Users/g50-45/Desktop/ML/1z10_webapp/data_analyser.py", line 7, in <module>    df = pd.read_sql_query(query, con)  File "C:\Users\g50-45\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\io\sql.py", line 325, in read_sql_query    pandas_sql = pandasSQL_builder(con)  File "C:\Users\g50-45\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\io\sql.py", line 575, in pandasSQL_builder    if _is_sqlalchemy_connectable(con):  File "C:\Users\g50-45\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\io\sql.py", line 44, in _is_sqlalchemy_connectable    import sqlalchemy  File "C:\Users\g50-45\AppData\Local\Programs\Python\Python37-32\lib\site-packages\sqlalchemy\__init__.py", line 12, in <module>    from sqlalchemy.sql import (  File "C:\Users\g50-45\AppData\Local\Programs\Python\Python37-32\lib\site-packages\sqlalchemy\sql\__init__.py", line 7, in <module>    from sqlalchemy.sql.expression import (  File "C:\Users\g50-45\AppData\Local\Programs\Python\Python37-32\lib\site-packages\sqlalchemy\sql\expression.py", line 2452    ^SyntaxError: invalid syntax "

Answer 1

sqlalchemy\sql\expression.py.py", line 2452在重要的重构之前，sqlalchemy 包看起来已经有 6 年历史了（ ）。

您应该删除此软件包并使用更新的版本重新安装它，或者尝试使用以下方法进行更新：

pip install SQLAlchemy --upgrade