python 数据返回list无法提取

Question

def down_data():
    rsa = bs.query_all_stock(day="2021-12-17")
    data_df = []
    rsa = bs.query_history_k_data_plus("sz.300251",
                                       "date,code,open,high,low,close,volume,amount",
                                       start_date="2021-12-17", end_date="2021-12-28", frequency="d", adjustflag="3")

    while (rsa.error_code == '0') & rsa.next():
        data_df.append(rsa.get_data())
    result = pd.DataFrame(data_df, columns=rsa.fields)
    print(result)
打印错误 ：ValueError: Must pass 2-d input. shape=(1, 8, 8)
直接打印data_df格式是[1,2,3,4,5,6,[8 rows x 8 columns] ] 一样不能处理

Answer 1

直接将获取的数据写成数据框即可，不要再添加进列表。代码如下：

def down_data():
    rsa = bs.query_all_stock(day="2021-12-17")
    rsa = bs.query_history_k_data_plus("sz.300251",
                                       "date,code,open,high,low,close,volume,amount",
                                       start_date="2021-12-17", end_date="2021-12-28", frequency="d", adjustflag="3")
 
    while (rsa.error_code == '0') & rsa.next():
        result = pd.DataFrame(rsa.get_data(), columns=rsa.fields)
    print(result)

运行结果：

F:\2021\qa\ot3>t3
login success!
         date       code  ...    volume          amount
0  2021-12-17  sz.300251  ...  20899934  234973640.1100  
1  2021-12-20  sz.300251  ...  28825229  332725313.5800  
2  2021-12-21  sz.300251  ...  20808207  241288060.3600  
...
[8 rows x 8 columns]

如有帮助，请点击一下采纳按钮。