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

12 votes250 views2 answers
Python hotkey pyautogui
Python
0 vote230 views2 answers
Random seed generator minecraft
Python
0 vote225 views1 answer
Display array of odd rows and even columns in numpy
Python
1 vote219 views1 answer
Show all numpy array
Python
0 vote223 views1 answer
Numpy fill with 0
Python
0 vote230 views1 answer
Print First 10 natural numbers using while loop
Python
13 votes218 views3 answers
Python http server command line
Python
4 votes246 views4 answers
How recursion works in python
Python
1 vote218 views1 answer
Open excel through python
Python
14 votes259 views2 answers
Django static files / templates
Python