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))