AttributeError Traceback (most recent call last)
Cell In[52], line 1
----> 1 df = pd.read_sql(query,engine)

File C:\veighna_studio\lib\site-packages\pandas\io\sql.py:591, in read_sql(sql, con, index_col, coerce_float, params, parse_dates, columns, chunksize)
582 return pandas_sql.read_table(
583 sql,
584 index_col=index_col,
(...)
588 chunksize=chunksize,
589 )
590 else:
--> 591 return pandas_sql.read_query(
592 sql,
593 index_col=index_col,
594 params=params,
595 coerce_float=coerce_float,
596 parse_dates=parse_dates,
597 chunksize=chunksize,
598 )

File C:\veighna_studio\lib\site-packages\pandas\io\sql.py:1561, in SQLDatabase.read_query(self, sql, index_col, coerce_float, parse_dates, params, chunksize, dtype)
1513 """
1514 Read SQL query into a DataFrame.
1515
(...)
1557
1558 """
1559 args = _convert_params(sql, params)
-> 1561 result = self.execute(*args)
1562 columns = result.keys()
1564 if chunksize is not None:

File C:\veighna_studio\lib\site-packages\pandas\io\sql.py:1406, in SQLDatabase.execute(self, args, **kwargs)
1404 def execute(self, args, kwargs):
1405 """Simple passthrough to SQLAlchemy connectable"""
-> 1406 return self.connectable.execution_options().execute(*args, kwargs)

AttributeError: 'OptionEngine' object has no attribute 'execute'

报错信息是一条read_sql语句导致的，截图中的是to_sql，两者不是一回事，再检查下吧

你好，后面有两句忘了贴了

构造查询语句

query = "SELECT * FROM dbbardata"
df = pd.read_sql(query,engine)
然后就显示上面的结果

df = pd.read_sql(sql, engine)

这里你传入的engine是OptionEngine对象，而不是SQLAlchemy的数据引擎对象，检查下吧