#use this to get the index of the max value of a column
max_index = column.idxmax()
max_value_column = df["column_name"].max()
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().
>>> df.idxmax(axis=1)
0 Communications
1 Business
2 Communications
3 Communications
4 Business
dtype: object
# applying idxmax() function.
df.idxmax(axis = 0)
df.idxmin()