How to select rows from a series based on values or condition, dynamically?

Question

I have a series produced dynamically, say - df['col1'].value_counts(). I can save this as a series s and then select rows from the series, for e.g., -

s = df['col1'].value_counts()
s_selected = s[s==20]

However I would like to achieve the same dynamically, something like - df['col1'].value_counts().some_function(filtering_condition)

Dataframe has an API like this - df.query()

How to do the same for Series.

Also this isn't a dupe of the linked question. They are just similar XY questions asked by newbies who don't know any better. — shadowtalker, Oct 01 '21 at 15:46

score 1 · Accepted Answer · answered Oct 01 '21 at 15:42

1

Use Series.where chained with dropna

s.where(lambda x: x == 20).dropna()

answered Oct 01 '21 at 15:42

Vishnudev Krishnadas

10,679
2
23
55

Thanks. I am sorry could not come up with this use of `dropna()` in conjunction with `where()`. That helped. – Anirban Chakraborty Oct 02 '21 at 06:13
1

This is an open environment to learn. Don't be sorry :) @AnirbanChakraborty – Vishnudev Krishnadas Oct 02 '21 at 10:07

How to select rows from a series based on values or condition, dynamically?

1 Answers1