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

11 votes225 views6 answers
Start python server
Python
0 vote206 views1 answer
How to loadh5 file in python
Python
1 vote199 views3 answers
Accessing data on django sessionstore
Python
0 vote266 views1 answer
Exception Type: AssertionError Exception Value: Expected a `Response`, `HttpResponse` or `HttpStreamingResponse` to be returned from the view, but received a `<class 'django.db.models.query.QuerySet'>`
Python Django
4 votes212 views5 answers
Env
Python
0 vote188 views2 answers
How to take list of integer as input in python
Python
204 votes412 views6 answers
How to read a file in python
Python
15 votes207 views1 answer
Importing file from another folder python
Python
0 vote201 views1 answer
"'S3' object has no attribute 'Bucket'", python boto3 aws
Python
6 votes195 views1 answer
Python in godot
Python