Answers for "how to find max value from two coloums in pandas"

minimum and max value in all columns pandas

#for multiple columns 
min_vals = df[["A","B","C"]].min() #can add how much ever columns
max_vals = df[["D","E","F"]].max() #can add how much ever columns

#for single column
min_val = df["Column"].min() 
max_val = df["Column"].max() 

#to refer to all columns
min_val = df[:].min() 
max_val = df[:].max()

pandas find column with max value for each row

# credit to Stack Overflow in the source link

df.head()
Communications and Search   Business    General Lifestyle
0   0.745763    0.050847    0.118644    0.084746
0   0.333333    0.000000    0.583333    0.083333
0   0.617021    0.042553    0.297872    0.042553
0   0.435897    0.000000    0.410256    0.153846
0   0.358974    0.076923    0.410256    0.153846

df.idxmax(axis=1)
0    Communications
1          Business
2    Communications
3    Communications
4          Business
dtype: object