Groupby where only

>>> df = pd.DataFrame({'A' : ['foo', 'bar', 'foo', 'bar',
...                           'foo', 'bar'],
...                    'B' : [1, 2, 3, 4, 5, 6],
...                    'C' : [2.0, 5., 8., 1., 2., 9.]})
>>> grouped = df.groupby('A')
>>> grouped.filter(lambda x: x['B'].mean() > 3.)
     A  B    C
1  bar  2  5.0
3  bar  4  1.0
5  bar  6  9.0

-1

Source: pandas.pydata.org

Similar codes

6 votes243 views4 answers
How to encrypt text in python
Python
0 vote243 views1 answer
Selenium chrome options suppress warnings python
Python
0 vote252 views1 answer
Python write line break
Python
3 votes240 views4 answers
Pandas count
Python
0 vote237 views1 answer
Np.loadtext
Python
6 votes248 views2 answers
If ,elif, else in python
Python
0 vote304 views1 answer
Test if instance in queryset django
Python Django
-2 votes255 views1 answer
En_core_web_sm
Python
-1 vote238 views1 answer
Receipt parsing
Python
0 vote245 views2 answers
How do I stop Selenium from closing my browser
Python