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

0 vote364 views1 answer
Increase "bar width" "px.bar"
Python
0 vote354 views1 answer
Webdriver.ChromeOptions()
Python
1 vote372 views1 answer
Dirs' base_dir / 'templates' error
Python
0 vote352 views1 answer
Frontmost flag qt
Python
19 votes353 views6 answers
Install Django in Windows
Python
3 votes347 views1 answer
Python initialize multidimensional list
Python
7 votes344 views2 answers
Check package version python
Python
1 vote341 views1 answer
What is ycor in python turle
Python
0 vote382 views1 answer
Python serial COM3
Python
0 vote370 views1 answer
Pythom sum
Python