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 vote276 views1 answer
Python - join two columns and transform it as index
Python
12 votes247 views4 answers
Age calculator in python
Python
0 vote261 views1 answer
Python how to add a string to a list in the middle
Python
1 vote293 views2 answers
Remove first element from list
Python
14 votes256 views1 answer
Python function to print random number
Python
24 votes309 views3 answers
Python get first character of string
Python
0 vote287 views1 answer
Couple legend from twin axes python
Python
2 votes264 views1 answer
How to print palindrome in 100 between 250 in python
Python
3 votes263 views3 answers
Flask migrate
Python
7 votes228 views3 answers
How to update list in python
Python