Pandas get the most frequent values of a column

Question

i have this dataframe   0 name data 1 alex asd 2 helen sdd 3 alex dss 4 helen sdsd 5 john sdadd   so i am trying to get the most frequent value or values in this case its values  so what i do is   dataframe  name   value counts   idxmax     but it returns only the value  Alex even if it Helen appears two times as well

User · Answer

You could try argmax like this     dataframe  name   value counts   argmax   Out 13    alex       The value counts will return a count object of pandas core series Series and argmax could be used to achieve the key of max values

User · Answer

You can use this to get a perfect count  it calculates the mode a particular column  df  name   value counts

User · Answer

n is used to get the number of top frequent used items n   2  a dataframe  name   value counts    n  index tolist    dataframe  quot name quot   value counts   a

User · Answer

df  name   value counts    5  sort values ascending False    The value counts will return a count object of pandas core series Series and sort values ascending False  will get you the highest values first

User · Answer

my best solution to get the first is   df  my column   value counts   sort values ascending False  argmax

User · Answer

By using mode   df name mode   Out 712    0     alex 1    helen dtype  object

User · Answer

To get the n most frequent values  just subset  value counts   and grab the index     get top 10 most frequent names n   10 dataframe  name   value counts    n  index tolist

User · Answer

to get top 5   dataframe  name   value counts   0 5

User · Answer

Here s one way   df  name   value counts   df  name   value counts      df  name   value counts   max      which prints   helen    2 alex     2 Name  name  dtype  int64

User · Answer

You could use  apply and pd value counts to get a count the occurrence of all the names in the name column   dataframe  name   apply pd value counts

User · Answer

Simply use this       dataframe  name   value counts   nlargest n    The functions for frequencies largest and smallest are    nlargest   for mostfrequent  n  values nsmallest   for least frequent  n  values

User · Answer

To get the top five most common names   dataframe  name   value counts   head

User · Answer

Use  df  name   mode    or df  name   value counts   idxmax

User · Answer

Not Obvious  But Fast    f  u   pd factorize df name values  counts   np bincount f  u counts    counts max     array   alex    helen    dtype object

[python] Pandas get the most frequent values of a column

Examples related to python

Examples related to pandas

Examples related to dataframe