我正在尝试将Binance API的响应转换为pandas DataFrame,以下是查询:
order_book = binance_client.get_order_book(symbol="ADAUSDT", limit="5")
我把它显示在屏幕上
order_book
答案如下
{'lastUpdateId': 2306936131,
'bids': [['1.20999000', '12851.90000000'],
['1.20996000', '490.10000000'],
['1.20994000', '333.80000000'],
['1.20992000', '33.10000000'],
['1.20987000', '140.40000000'],
['1.20986000', '247.20000000'],
['1.20980000', '1549.80000000'],
['1.20969000', '691.20000000'],
['1.20968000', '5738.70000000'],
['1.20966000', '1667.80000000']],
'asks': [['1.21000000', '51609.00000000'],
['1.21002000', '152.60000000'],
['1.21004000', '116.80000000'],
['1.21008000', '24.80000000'],
['1.21010000', '1151.10000000'],
['1.21011000', '5815.60000000'],
['1.21016000', '9.00000000'],
['1.21020000', '80.50000000'],
['1.21026000', '7871.90000000'],
['1.21030000', '300.00000000']]}
当我将其转换为数据帧时,如下所示
order_book_df = df(order_book)
我把它显示在屏幕上
order_book_df
显示以下内容
lastUpdateId bids asks
0 2308027293 [1.29581000, 2109.00000000] [1.29628000, 944.20000000]
1 2308027293 [1.29559000, 485.20000000] [1.29635000, 87.90000000]
2 2308027293 [1.29558000, 16000.00000000][1.29636000, 532.80000000]
3 2308027293 [1.29557000, 3492.50000000] [1.29658000, 14820.00000000]
4 2308027293 [1.29539000, 2307.60000000] [1.29664000, 532.50000000]
我需要的是如下所示的
lastUpdateId price-bids qty-bids price-asks qty-asks
0 2308027293 1.29581000 210900000000 1.29628000 944.20000000
1 2308027293 1.29559000 485.20000000 1.29635000 87.90000000
2 2308027293 1.29558000 1600000000000 1.29636000 532.80000000
3 2308027293 1.29557000 3492.50000000 1.29658000 1482000000000
4 2308027293 1.29539000 2307.6000000 1.29664000 532.50000000
在我学习的过程中,任何帮助都是非常受欢迎的。 谢谢
目前没有回答
相关问题 更多 >
编程相关推荐