CODEWITHSUNDEEP
pandasplot
SeagullWardy
SeagullWardy

Reputation: 187

Pandas conditions on count()

Hi hoping this is not a silly question.

I have a dataframe from which I am plotting a chart based on how many times something appears with the following code.

df.groupby('name').name.count().plot.bar()
plt.xlabel('Name')
plt.ylabel('Number')
plt.title('Number of times name appears')

Is there a way to get it to only plot those names that appear a certain amount of times? I am guessing I need some kind of function but not really sure where to start.

Upvotes: 0

Views: 658

Answers (1)

BENY
BENY

Reputation: 323226

By using value_counts

df.name.value_counts().plot(kind='bar')

Edit :

df.group1.value_counts().compress(lambda s: s>=8).plot(kind='bar')

Upvotes: 1

Related Questions