how to find another col value associated with the max dataframe code example

Example 1: pandas get index of max value in column

#use this to get the index of the max value of a column
max_index = column.idxmax()

Example 2: find min and max from dataframe column

max_value = column.max()