我有这个Json文件
{
"timezone": "UTC",
"serverTime": 1565246363776,
"rateLimits": […… ],
"exchangeFilters": [….. ],
"symbols": [
{
"symbol": "ETHBTC",
"status": "TRADING",
"baseAsset": "ETH",
"baseAssetPrecision": 8,
"quoteAsset": "BTC",
"quotePrecision": 8,
"quoteAssetPrecision": 8,
"baseCommissionPrecision": 8,
"quoteCommissionPrecision": 8,
"filters": [
{"filterType": "PRICE_FILTER",
"minPrice": "0.00000100",
"maxPrice": "100000.00000000",
"tickSize": "0.00000100"},
{"filterType": "PERCENT_PRICE",
"multiplierUp": "1.3000",
"multiplierDown": "0.7000",
"avgPriceMins": 5}
{"filterType": "LOT_SIZE",
"minQty": "0.00100000",
"maxQty": "100000.00000000",
"stepSize": “0.00100000"}]
}
我已将Json文件中的“符号”转换为数据帧:
with open('exchangeInfo.json', 'r') as fp:
exchangeInfo = json.load(fp)
symbolsDF = pd.DataFrame(client.get_exchange_info(['symbols'])
我想将“过滤器”列从“符号”转换为这样的列
"symbols": [
{
"symbol": "ETHBTC",
"status": "TRADING",
"baseAsset": "ETH",
"baseAssetPrecision": 8,
"quoteAsset": "BTC",
"quotePrecision": 8,
"quoteAssetPrecision": 8,
"baseCommissionPrecision": 8,
"quoteCommissionPrecision": 8,
"minPrice": "0.00000100",
"maxPrice": "100000.00000000",
"tickSize": "0.00000100",
"minQty": "0.00100000",
"maxQty": "100000.00000000",
"stepSize": "0.00100000"}]
}
因此,我的最终数据帧将包含在符号上,列将是
["symbol", "status", "baseAsset", "baseAssetPrecision", "quoteAsset","quotePrecision", "quoteAssetPrecision", "baseCommissionPrecision", "quoteCommissionPrecision", "minPrice", "maxPrice", "tickSize", "minQty", "maxQty", "stepSize"]
多谢各位
尝试:
印刷品:
相关问题 更多 >
编程相关推荐