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

Question

我正在尝试使用 pandas 读取 sqlite3 数据库。不幸的是，在我的代码中是 SyntaxError 但我找不到它。

代码与许多教程中的代码相同，所以我不知道问题出在哪里

import pandas as pd

import sqlite3

con = 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&nbsp;install&nbsp;SQLAlchemy&nbsp;--upgrade