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 vote308 views2 answers
Python error: command 'x86_64-linux-gnu-gcc' failed with exit status 1
Python
4 votes298 views4 answers
Count unique elements in list python
Python
0 vote294 views1 answer
Pandas insert a list into cell
Python
0 vote308 views1 answer
Checking if a string is in alphabetical order in python
Python
0 vote315 views1 answer
Logartim normalization python pandas
Python
1 vote279 views1 answer
Codeforces - 570b python
Python
2 votes305 views2 answers
Get title attribute beautiful soup
Python
87 votes292 views6 answers
Write dataframe to csv python
Python
3 votes335 views2 answers
List of dict values
Python
0 vote335 views1 answer
Python randomly chose user agent
Python