I'm trying to get this json request into df, my code is like this
gateio = requests.get("https://data.gateapi.io/api2/1/tickers")
e = gateio.json()
gateio = json_normalize(e)
print(gateio)
我得到的数据不正确。
stos_eth.highestBid stos_eth.percentChange stos_eth.baseVolume stos_eth.quoteVolume stos_eth.high24hr stos_eth.low24hr rune_eth.result rune_eth.last rune_eth.lowestAsk rune_eth.highestBid rune_eth.percentChange rune_eth.baseVolume rune_eth.quoteVolume rune_eth.high24hr rune_eth.low24hr \
0 0.0001413 -4.91 7.21566512024175 48985.4371475 0.00015302 0.00013892 true 0.0012396 0.0012427 0.0012348 -3.92 8.105154274293 6404.678774 0.0012942 0.0012377
matic_usdt.result matic_usdt.last matic_usdt.lowestAsk matic_usdt.highestBid matic_usdt.percentChange matic_usdt.baseVolume matic_usdt.quoteVolume matic_usdt.high24hr matic_usdt.low24hr arcx_usdt.result arcx_usdt.last arcx_usdt.lowestAsk arcx_usdt.highestBid arcx_usdt.percentChange \
0 true 0.83047 0.83065 0.8304 6.83 4369783.0514518 5383470.6302219 0.84403 0.77834 true 0.081401 0.083318 0.079447 19.33
arcx_usdt.baseVolume arcx_usdt.quoteVolume arcx_usdt.high24hr arcx_usdt.low24hr dsd_eth.result dsd_eth.last dsd_eth.lowestAsk dsd_eth.highestBid dsd_eth.percentChange dsd_eth.baseVolume dsd_eth.quoteVolume dsd_eth.high24hr dsd_eth.low24hr sis_usdt.result sis_usdt.last sis_usdt.lowestAsk \
0 16283.714384037 207846.51634963 0.085766 0.065975 true 0.000000753 0.000012967 0.000000593 0 0 0 0 0 true 0.1937 0.1936
my expected result is:
symbol lowestAsk highestBid
0 srk_eth 0.000000236 0.000000226
1 isp_eth 0.008294 0.0082
2 mft_eth 0.000000512 0.0000005078