Python Pandas add column for row-wise max value of selected columns [duplicate] Python Pandas add column for row-wise max value of selected columns [duplicate] pandas pandas

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)