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

2 votes339 views1 answer
Save df to txt
Python
0 vote354 views1 answer
E tensorflow/stream_executor/cuda/cuda_dnn.cc:329] Could not create cudnn handle: CUDNN_STATUS_INTERNAL_ERROR
Python
1 vote353 views2 answers
Count the number of cells that contain a specific value in a pandas dataframe python
Python
1 vote370 views1 answer
Set the root directory when starting jupyter notebooks
Python
0 vote346 views1 answer
Python dict keys to string
Python
4 votes351 views1 answer
Replace multi spaces with single space
Python
3 votes370 views10 answers
Date parser python pandas
Python
5 votes346 views2 answers
How to click on button using python
Python
1 vote392 views1 answer
Hot reloading flask
Python Flask
2 votes297 views4 answers
Sum of array in python
Python