Pandas locate minimum of DataFrame matrix: index, col

Question

I'd like to get the index and column name of the minimum value in a pandas DataFrame across all rows and all columns.

I've tried .idxmin but this seems to only work when applied on a column. Ideally the function is a one-liner that doesn't require loops. It seems like a very common problem, but I haven't found a solution yet.

My DataFrame:

      col0, col1, col2
index0 1     2     3 
index1 2     3     4
index2 5     6     7

I'd like to get the index and column for the minimum value across matrix: 1.

so:

some_func(df) = (index0,col0)

You can get the min value of the whole dataframe with df.min().min() may be someone else can tell us how to get the index & column for that value. — moys
– moys, Commented Sep 6, 2019 at 17:26

Andy L. · Accepted Answer · 2019-09-06 17:28:51Z

12

Try this:

df.stack().idxmin()

Out[108]: ('index0', 'col0')

answered Sep 6, 2019 at 17:28

Andy L.

25.3k4 gold badges20 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

piRSquared · Accepted Answer · 2019-09-06 17:34:35Z

2

Numpy and `divmod`

i, j = divmod(np.argmin(np.ravel(df)), df.shape[1])

(df.index[i], df.columns[j])

('index0', 'col0')

answered Sep 6, 2019 at 17:34

piRSquared

296k68 gold badges509 silver badges654 bronze badges

2 Comments

Andy L. Over a year ago

I always like your numpy solution :) +1

piRSquared Over a year ago

Your's is super slick though (-:

Collectives™ on Stack Overflow

Pandas locate minimum of DataFrame matrix: index, col

2 Answers 2

Comments

Numpy and `divmod`

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Numpy and divmod

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related

Numpy and `divmod`