Sqlite3 - 熊猫模块'time'没有属性'clock'

Question

我想把我的数据库变成熊猫df 的sqlite3

我使用的是这段代码：

con = sqlite3.connect('pathdb.db')
df = pd.read_sql('select * from db', con)

追踪我得到的：

Traceback (most recent call last):
df = pd.read_sql('select * from db', con)
File "PATHpandasiosql.py", line 403, in read_sql
pandas_sql = pandasSQL_builder(con)
File "PATHpandasiosql.py", line 578, in pandasSQL_builder
if _is_sqlalchemy_connectable(con):
File "PATHpandasiosql.py", line 43, in _is_sqlalchemy_connectable
import sqlalchemy
File "PATHPython38-32libsite-packagessqlalchemy__init__.py", line 12, in <module>
from sqlalchemy.sql import (
File "PATHPython38-32libsite-packagessqlalchemysql__init__.py", line 7, in <module>
from sqlalchemy.sql.expression import (
File "PATHPython38-32libsite-packagessqlalchemysqlexpression.py", line 32, in <module>
from sqlalchemy import util, exc
File "PATHPython38-32libsite-packagessqlalchemyutil__init__.py", line 7, in <module>
from .compat import callable, cmp, reduce, defaultdict, py25_dict, 
File "PATHPython38-32libsite-packagessqlalchemyutilcompat.py", line 202, in <module>
time_func = time.clock
AttributeError: module 'time' has no attribute 'clock'

这个代码有问题吗？这个错误的原因是什么？

Answer 1

SQLALchemy 0.7.10真的很旧。像6.5岁。它使用了time.clock。。。

：1:弃用警告：time.clock在Python 3.3中已被弃用，并将从Python 3.8中删除：使用time.perf_counter或time.prrocess_time代替