Hi,can anyone help me? i am trying to fill a column of a dataset using a conditional loop. To do that i am trying to fill a column called “new_amount” with these conditions: if in the same row the “currency” column is “INR”, then “new_amount” should copy the value of "sales_amount ", but if it says “USD” them the value in “new_amount” should be equal to ("sales_amount ")*75. For what i can see the script is doing what i want but is sending a warning that i dont understand.
This is a short version of the dataframe (the original is too big).
sales2.xlsx (6.0 KB)
And this is the link that i should see but i am not seing what i am doing wrong:
This is the code:
k=0 for valor in sales["currency"]: if valor =="INR": sales['new_amount'][k]=sales["sales_amount"][k] elif valor =="USD": sales["new_amount"][k]=(sales["sales_amount"][k])*75 k+=1``` Thanks! :)