Binance API client.get_order_book(Python中的symbol='ADAUSDT'

2024-06-06 10:40:10 发布

您现在位置:Python中文网/ 问答频道 /正文

我正在尝试将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

在我学习的过程中,任何帮助都是非常受欢迎的。 谢谢


Tags: clientapidataframepandasdf屏幕binanceorder