货币转换传递语句列表

Question

我试图写一个列表，将熊猫数据框中的货币转换为所有美元。我正在使用forex_python.converter获取汇率

数据如下所示：

^{tb1}$

我想写一个循环，应用某一天的汇率将每一行转换成美元，但是如果行是美元，那么Amount_usd应该正好等于Amount

到目前为止，我已经尝试：

for currency in currencies:
    if currency == 'usd':
        data['Amount_USD'] == data['Amount']
    else:
        date_obj=datetime.datetime(2020,8,1)
        currency2 = print('"{0}"'.format(currency))
        rate = c.get_rate(currency2,'USD', date_obj)
        data['Amount_USD'] = np.where(data['Currency']== currency2, data['Amount']*rate , np.nan)

但目前该准则将汇率应用于美元价值

Answer 1

我建议改写：

for currency in currencies:
    if currency != 'usd':
        date_obj=datetime.datetime(2020,8,1)
        currency2 = print('"{0}"'.format(currency))
        rate = c.get_rate(currency2,'USD', date_obj)
    else:
        rate = 1
    data.loc[data.currency == currency, 'Amount_USD'] = data['Amount'] * rate