```
# 查询 000001 2015 - 2017 年的整张合并利润表,且满足 net_profit(净利润) < 0 的条件
q = query(finance.STK_INCOME_STATEMENT).filter(
finance.STK_INCOME_STATEMENT.code=='000783.XSHE', #选定股票 000783.XSHE
finance.STK_INCOME_STATEMENT.end_date > '2005-01-01', #指定查询时间段大于2005年1月1日
finance.STK_INCOME_STATEMENT.end_date < '2018-01-01', #指定查询时间段小于2018年1月1日
finance.STK_INCOME_STATEMENT.net_profit < 0, #指定查询到的数据中net_profit为负
finance.STK_INCOME_STATEMENT.report_type == 0, #指定报告期类型为本期
).order_by(finance.STK_INCOME_STATEMENT.end_date.desc() ).limit(5) #根据end_date降序排序,并返回前5条数据
finance.run_query(q)
```
Traceback (most recent call last):
File "d:/测试/JQdata测试/获取数据.py", line 40, in < module>
finance.run_query(q)
File "D:\VNPY\lib\site-packages\jqdatasdk\utils.py", line 241, in _wrapper
return func(*args, **kwargs)
File "D:\VNPY\lib\site-packages\jqdatasdk\table.py", line 54, in run_query
df = JQDataClient.instance().db_query(db=self.db_name, sql=sql)
File "D:\VNPY\lib\site-packages\jqdatasdk\client.py", line 240, in < lambda>
return lambda **kwargs: self(method, **kwargs)
File "D:\VNPY\lib\site-packages\jqdatasdk\client.py", line 235, in __call__
raise err
File "D:\VNPY\lib\site-packages\jqdatasdk\client.py", line 214, in __call__
result = pc.load(file, encoding=pickle_encoding)
File "D:\VNPY\lib\site-packages\pandas\compat\pickle_compat.py", line 249, in load
return up.load()
File "D:\VNPY\lib\pickle.py", line 1085, in load
dispatch[key[0]](self)
File "D:\VNPY\lib\site-packages\pandas\compat\pickle_compat.py", line 45, in load_reduce
elif args and issubclass(args[0], BaseOffset):
TypeError: issubclass() arg 1 must be a class
=========================================
请问这个问题怎么解决？？头疼死了。
2021-02-09
雪球
