Pandas DataFrame Retrieve Value from Column

Question

Supposely I have dataframe as below:

The max value of dataframe column B is 4, and I could get the index from df["B"].argmax() which is 1.

The problem is now, how could I get the exact max value of the dataframe column B?

Thanks!

Jeff · Accepted Answer · 2013-09-22 15:30:12Z

4

In [6]: df
Out[6]: 
     A  B  C
Idx         
0    1  2  3
1    3  4  5
2    2  3  8

In [7]: df.max()
Out[7]: 
A    3
B    4
C    8
dtype: int64

In [10]: df['B'].max()
Out[10]: 4

In [8]: df.idxmax()
Out[8]: 
A    1
B    1
C    2
dtype: int64

answered Sep 22, 2013 at 15:30

Jeff

130k21 gold badges223 silver badges189 bronze badges

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

2 Comments

Santiago Munez Over a year ago

Yeap. Now, I have the index from df.idxmax(). How to use this index, to get the value of column A? I have tried something like df["A"](df.idxmax()), but it's not working? Thanks!

Jeff Over a year ago

df['A'].max() or df['A'](df.idxmax()['A']) is much more verbose

Collectives™ on Stack Overflow

Pandas DataFrame Retrieve Value from Column

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related