pandas dataframe get the value with most occurence per row (Python2)

Question

I have the dataframe

df =A B B A B
    B B B B A
    A A A B B
    A A B A A

And I want to get a vector with the element the appeared the most, per row. So here I will get [B,B,A,A]

What is the best way to do it? In Python2

BENY · Accepted Answer · 2019-03-10 22:07:40Z

1

Let us using mode

df.T.mode()
   0  1  2  3
0  B  B  A  A

answered Mar 10, 2019 at 22:07

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Comments

Igor OA · Accepted Answer · 2019-03-10 21:58:48Z

0

You can get your vector v with most appearing values with

v = [_[1].value_counts().idxmax() for _ in df.iterrows()].

Be careful when you have multiple elements that occur the most.

answered Mar 10, 2019 at 21:58

Igor OA

3973 silver badges15 bronze badges