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

2 votes109 views10 answers
Javascript
Python
1 vote129 views1 answer
Pygame examples
Python
0 vote164 views1 answer
How to find most repeated word in a string in python
Python
0 vote118 views1 answer
Overlapping xtick labels pyplot
Python
0 vote151 views1 answer
Manytomany django add bulk create
Python Django
0 vote117 views2 answers
How to sum a column in Python csv
Python
0 vote140 views1 answer
Django related_name abstract class
Python Django
0 vote127 views1 answer
Csrf token fetch django
Python Django
1 vote125 views1 answer
Select rows which entries equals one of the values pandas
Python
0 vote118 views1 answer
Python set match two list
Python