Maximum in two columns dataframe python pandas

Question

I have two columns in a dataframe, one of them are strings (country's) and the other are integers related to each country. How do I ask which country has the biggest value using python pandas?

@anky_91 I'm sorry I didn't make this clear, but actually there are more columns in the dataframe. — Davi Alefe
– Davi Alefe, Commented Jun 30, 2019 at 18:26
Welcome to StackOverflow. Please take the time to read this post on how to provide a great pandas example as well as how to provide a minimal, complete, and verifiable example and revise your question accordingly. — anky
– anky, Commented Jun 30, 2019 at 18:38

piRSquared · Accepted Answer · 2019-06-30 20:27:05Z

1

Setup

df = pd.DataFrame(dict(Num=[*map(int, '352741845')], Country=[*'ABCDEFGHI']))

df

   Num Country
0    3       A
1    5       B
2    2       C
3    7       D
4    4       E
5    1       F
6    8       G
7    4       H
8    5       I

`idxmax`

df.loc[[df.Num.idxmax()]]

   Num Country
6    8       G

`nlargest`

df.nlargest(1, columns=['Num'])

   Num Country
6    8       G

`sort_values` and `tail`

df.sort_values('Num').tail(1)

   Num Country
6    8       G

answered Jun 30, 2019 at 20:27

piRSquared

296k68 gold badges509 silver badges654 bronze badges

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

Collectives™ on Stack Overflow

Maximum in two columns dataframe python pandas

1 Answer 1

Setup

`idxmax`

`nlargest`

`sort_values` and `tail`

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Setup

idxmax

nlargest

sort_values and tail

Comments

Your Answer

Sign up or log in

Post as a guest

Related

`idxmax`

`nlargest`

`sort_values` and `tail`