Create row of most frequent value in each dataframe column

Question

CONTEXT

I want to create a top row with the most frequent values of each column.

CURRENT CODE

df = df.loc[df['Gender'] == 'M']
df = df('Gender').count()

DATA SAMPLE

Gender      Eyes      Hair    Height
  M         Brown     Brown    >6ft
  M         Blue      Blonde   <6ft
  M         Brown     Blonde   <6ft

EXPECTED OUTCOME

Gender      Eyes      Hair    Height
  M         Brown     Blonde    <6ft

score 2 · Answer 1 · answered Feb 18 '20 at 02:46

2

It's exactly what the mode function in Pandas does. Assuming your data sample is df, you can obtain your expected output using the following line of code

df.mode()

answered Feb 18 '20 at 02:46

Kavish

69
6

score 1 · Accepted Answer · answered Feb 18 '20 at 02:46

1

Check with mode

df.mode()
  Gender   Eyes    Hair Height
0      M  Brown  Blonde   <6ft

answered Feb 18 '20 at 02:46

BENY

317,841
20
164
234

Create row of most frequent value in each dataframe column

2 Answers2