filter column of a dataframe by the two fields that are repeated the most

Question

I have a dataframe and values are repeated in a column called label, I want to show only the two that are repeated the most........

I attach an image as an example

I tried

# the name of colums is label

# the name of dataframe is pd_data

filter = \['a','b'\]
pd_data = pd_data\[\~pd_data.labels.isin(filter)\]

print(len(pd_data))
pd_data.groupby('label').size().sort_values(ascending=False)

enter image description here

Does this answer your question? [Pandas get the most frequent values of a column](https://stackoverflow.com/questions/48590268/pandas-get-the-most-frequent-values-of-a-column) — nathan liang, Mar 24 '22 at 00:01

score 0 · Answer 1 · answered Mar 24 '22 at 02:01

0

You can use pandas.Series.value_counts() to get the counts of unique values in Series, then slicing the Series with top 2

pd_data['label'].value_counts()[:1]

answered Mar 24 '22 at 02:01

Ynjxsjmh

28,441
6
34
52

perfect, thank you pd_data['label'].value_counts()[:2] – GABRIEL Mar 24 '22 at 20:38
But I need delete the rest of values and save the two firts with more values – GABRIEL Mar 24 '22 at 21:10

score 0 · Accepted Answer · answered Mar 24 '22 at 02:02

0

You may use value_counts

pd_data.value_counts()

or

pd_data.groupby(['label']).count()

answered Mar 24 '22 at 02:02

Esraa Abdelmaksoud

1,307
12
25

But I need delete the rest of values and save the two firts with more values – GABRIEL Mar 24 '22 at 21:11
All you have to do is slicing the part you need like this: df = pd_data.groupby(['label']).count() new_df = df[:2] – Esraa Abdelmaksoud Mar 25 '22 at 03:53

filter column of a dataframe by the two fields that are repeated the most

2 Answers2