pandas, How to apply a function to all columns using another as parameter

Asked Sep 19 '22 at 13:30

Active Sep 19 '22 at 13:30

Viewed 25 times

I'm not too expert with pandas and hence there's one thing I cannot do.

I have a dataframe with several columns: he first is a int, the others are floats.

I want to apply a function to all columns using the first one as a parameter for the function. Example:

  A    B    C
  4   0.3  0.5
  7   0.2  0.6

I have a function which I want to apply to columns B and C, whose result depends on the value of A for that row.

The only way I can think of is a sort of zip between first column and the others, but it doesn't look right.

asked Sep 19 '22 at 13:30

spider

depends on the function, there might be smarter ways depending on what you really want to achieve – mozway Sep 19 '22 at 13:32
1

For example: `df.drop('A', axis=1).apply(lambda x: x*df['A'])` – Quang Hoang Sep 19 '22 at 13:36
you need to add ```axis=1``` to apply: ```df['new_col'] = df.apply(lambda x: x['A']+x['B'] if x['A'] > x['B'] else None , axis=1)``` – khaled koubaa Sep 19 '22 at 14:52

0 Answers0