Filter groupby pandas

>>> 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

3 votes268 views2 answers
How many columns have null values present in them? in pandas
Python
0 vote298 views1 answer
Pydub play audio
Python
0 vote279 views1 answer
Item[0]: (i + 1) * 2 for i, item in (sort_loc)
Python
3 votes297 views5 answers
How to groupby in pandas
Python
0 vote280 views1 answer
Clean consol python
Python
-1 vote323 views1 answer
Uninstall python3.8 ubuntu
Python
0 vote259 views1 answer
Django import "" could not be resolved
Python
0 vote282 views1 answer
Create a new list from a list when a certain condition is met
Python
16 votes305 views3 answers
Python empty text file
Python
1 vote274 views1 answer
Python tts
Python