python - Find max value and the corresponding column/index name in entire dataframe -


i want select maximum value in dataframe, , find out index , column name of value. there way it?

say, in example below, want first find max value (31), , return index , column name of value (20, r20d)

a = pd.dataframe({'r05d':[1,2,3],'r10d':[7,4,3],'r20d':[31,2,4]},index=[20,25,30]) 

thanks!

turn dataframe multipleindex series , ask index of max element argmax or idxmax function:

coord = a.stack().argmax() coord (20, 'r20d') 

to value, use coordinates against loc:

df.loc[coord] 31 

Comments

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -