Answers for "is there a way to get the max value in a dataframe with it is index"

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

find max value index in value count pandas

df = {'a': 3, 'b':4, 'c':5}
df.max() #max() gives you the maximum value in the series.
#Output
5

df.idxmax() #idx() gives you the index of the maximum values.
#Output
c

#NB: The same applies to min() and idxmin().