python - 币安账户价值

Question

我正在尝试计算我在 binance 上的资产总价值，但我无法将正确的价格放入 Pandas。

输出

我究竟做错了什么？

''' from binance.client import Client from BinanceKeys import api_key, api_secret import pandas as pd from Settings import Basecoin import datetime as dt

client = Client(api_key, api_secret)

Account = client.get_account()
Account = pd.DataFrame.from_dict(Account['balances'])
Account['free'] = (Account['free'].astype(float))
Account['locked'] = Account['locked'].astype(float)
Account = Account.loc[Account.free > 0.0000001]
Account.asset = Account.asset + Basecoin 
Account.set_index(Account['asset']) 

for i in Account.asset:
    if i != Basecoin+Basecoin:
        Coinprice = client.get_symbol_ticker(symbol = i)        
        Coinprice = pd.json_normalize(Coinprice)
        Coinprice = Coinprice.price.astype(float).values[0]
        
# This line does not work :-)
        Account.loc[Account.asset == i, Account.price] = Coinprice

    else:
        Account.loc[Account.asset == i, Account.price] = 1

Account['value'] = (Account.free + Account.locked) * Account.price
print(Account,'\n')

'''

标签： pythonpandas