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 vote55 views1 answer
Onehotencoder example
Python
0 vote96 views1 answer
How to define an empyt dic tin python
Python
0 vote105 views1 answer
Python how to get data from dictionary
Python
1 vote92 views1 answer
Sql alchemy engine all tables
Python
0 vote98 views1 answer
Python eliminar elementos de un diccionario
Python
0 vote123 views1 answer
Graph bokeh
Python
0 vote92 views1 answer
Declare pandas dataframe with values
Python
17 votes108 views5 answers
Append element to list py
Python
0 vote119 views1 answer
Django serializer get image list
Python Django
8 votes97 views3 answers
Python gzip file
Python