I have costs in several currencies in one column. I want to make a new column that will convert all the costs to USD.
This is what I did:
for i in range(len(df)) :
if(df[i]['Currency'] == 'Botswana Pula(P)'):
df[i]['new cost'] = df[i]['Average Cost for two'] * 0.095
...
and so on for the other currencies.
