multiple loop for in python

Question

I need help I create this dataframe:

enter image description here

And i need to create a new column with this function:

def pgto(x, num):
    if x == "(i)":
        return num
    elif x == "(ii)":
        return 750000.00
    elif x == "(iii)":
        return num * 0.7
    else:
        return 3000000.00

then i aplicate a multiple loop for:

for x in df_final["Tipo"]:
    for num in df_final["Valor_float"]:
        df_final["Pgto"] = pgto(x, num)

But the result was it:

enter image description here

What i should do?

try printing the contents of the "Tipo" column and take note what type they are. Bc I think it applies an automatic cask which doesnt mean x and (i) equal. Also you might wanna do things via indexes rather them this for each style. — Josip Juros
– Josip Juros, Commented Feb 23, 2022 at 12:55

Sebastien D · Accepted Answer · 2022-02-23 12:57:44Z

1

You are not correctly looping over rows, I'd suggest the following:

for idx, row in df_final.iterrows(): #Proper way to loop over rows
    # with the idx value (~row number), you can store the output value of your function
    df_final.loc[idx, "Pgto"] = pgto(row['Tipo'], row['Valor_float'])

answered Feb 23, 2022 at 12:57

Sebastien D

4,5024 gold badges23 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Lucas Leite Over a year ago

Many tks! You are the guy!!

Collectives™ on Stack Overflow

multiple loop for in python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related