添加了路径也不行
之前的帖子提到过这个问题,但是具体怎么解决,能麻烦写一下么,本人新手
你好,后面有两句忘了贴了
query = "SELECT * FROM dbbardata"
df = pd.read_sql(query,engine)
然后就显示上面的结果
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'
ImportError Traceback (most recent call last)
Cell In[1], line 6
4 from vnpy.trader.constant import Exchange, Interval
5 from vnpy.trader.object import BarData
----> 6 from vnpy.trader.database import DB_TZ, database_manager
9 def download_stock_daily_data(symbol: str, exchange: Exchange):
10 """基于代码和交易所下载数据"""
ImportError: cannot import name 'database_manager' from 'vnpy.trader.database' (C:\veighna_studio\lib\site-packages\vnpy\trader\database.py)