Extract values in Pandas value counts

Question

Say we have used pandas dataframe column  value counts   which outputs    apple   5   sausage 2  banana  2  cheese  1   How do you extract the values in the order same as shown above from max to min    e g   apple sausage banana cheese

User · Answer

If anyone missed it out in the comments  try this   dataframe column  value counts   to frame

User · Answer

usr bin env python  import pandas as pd    Make example dataframe df   pd DataFrame   1   Germany                        2   France                        3   Indonesia                        4   France                        5   France                        6   Germany                        7   UK                                            columns   groupid    country                      index   a    b    c    d    e    f    g       What you re looking for values   df  country   value counts   keys   tolist   counts   df  country   value counts   tolist     Now  print df  country   value counts    gives   France       3 Germany      2 UK           1 Indonesia    1   and print values  gives     France    Germany    UK    Indonesia     and print counts  gives    3  2  1  1

User · Answer

The best way to extract the values is to just do the following json loads dataframe column  value counts   to json     This returns a dictionary which you can use like any other dict  Using values or keys     quot apple quot   5   quot sausage quot   2   quot banana quot   2   quot cheese quot   1

User · Answer

Try this   dataframe column  value counts   index tolist     apple    sausage    banana    cheese

User · Answer

Code train  quot label Name quot   value counts   to frame    where   label Name Mean column name result  my case   - 0    29720  1     2242  Name  label  dtype  int64

User · Answer

First you have to sort the dataframe by the count column max to min if it s not sorted that way already  In your post  it is in the right order already but I will sort it anyways   dataframe sort index by  count   ascending  False       col     count 0   apple   5 1   sausage 2 2   banana  2 3   cheese  1    Then you can output the col column to a list   dataframe  col   tolist     apple    sausage    banana    cheese

[python] Extract values in Pandas value_counts()

Examples related to python

Examples related to pandas

Examples related to dataframe

Examples related to series