How to iterate through columns in a dataframe and update the values?

Question

I have some data in an excel file (a snippet of it is shown in the figure below:

I would like to iterate through each of the columns and update their values. I have attempted the following...however it gives me an error which is unclear: "KeyError: 32.5". Any help to get around this would be much appreciated!

def iterate (data, cost_T, int_T, cost_F, int_F):
     for i, j in zip(data.iloc[:, 0], data.iloc[:, 1]):
         data[i] = (data[i]- cost_T)/int_T
         data[j] = (data[j]- cost_F)/int_F
iterate (df, 455, 31, 501, 42)

Nori · Accepted Answer · 2021-05-28 01:07:56Z

1

You can use DataFrame.map(function)

df['TT_a'] = df['TT'].map(lambda x:(x - 455) / 31)
df['FT_a'] = df['FT'].map(lambda x:(x - 501) / 42)

answered May 28, 2021 at 1:07

Nori

3,1042 gold badges29 silver badges58 bronze badges

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

Comments

sukhbinder · Accepted Answer · 2021-05-28 01:02:43Z

0

You could simply do this with two lines of code without a loop

data["TT"] = (data["TT"]-cos_T)/ini_T
data["FT"] = (data["FT"]-cos_F)/ini_F

answered May 28, 2021 at 1:02

sukhbinder

1,12911 silver badges10 bronze badges

1 Comment

user12441225 Over a year ago

Thank you! Guess I was over-complicating it

Collectives™ on Stack Overflow

How to iterate through columns in a dataframe and update the values?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related