I have a dataframe (df) with columns like this:

And a formula like this:

y = ((maximum – minimum)**2) + ((x – 10)**2), where

maximum = the maximum value in the column

minimum = the minimum value in the column

x = input value from the column (each cell one by one)

y = output value (the result for each cell)

The question is:
How can I put every new value from column into X, receive Y and make it for each column?
The result should be like:

Thanks for the help!!!

>Solution :

You can use:

df.sub(10).pow(2).add(df.max().sub(df.min()).pow(2))

Or:

(df-10)**2 + (df.max()-df.min())**2

Output:

       Column 1      Column 2     Column 3
0  50070.408244  14739.860900  1207.125339
1  50672.301126   8395.616617  1513.961515
2  88794.741791   8443.334267  1283.838779