Python Pandas add column for row-wise max value of selected columns [duplicate]
>>> frame['HighScore'] = frame[['test1','test2','test3']].max(axis=1)>>> frame name test1 test2 test3 HighScore0 bill 85 35 51 851 joe 75 45 61 752 steve 85 83 45 85
>>> frame['HighScore'] = frame[['test1','test2','test3']].apply(max, axis=1)>>> frame name test1 test2 test3 HighScore0 bill 85 35 51 851 joe 75 45 61 752 steve 85 83 45 85
if a max
or min
value between multiple columns in a df
is to be determined then use:
df['Z']=df[['A','B','C']].apply(np.max,axis=1)