Answers for "how to get the max value in dataframe with it is index"

display Max rows in a pandas dataframe

pandas.set_option('display.max_rows', None)

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