find the values of other columns in dataframe associated with max or min value of another column code example
Example 1: find min and max from dataframe column
max_value = column.max()
Example 2: Range all columns of df such that the minimum value in each column is 0 and max is 1. in pandas
import pandas as pd
df = pd.DataFrame(np.random.randint(1,100, 80).reshape(8, -1))
out = df.apply(lambda x:((x.max()-x)/(x.max()-x.min())).round(2))