包含多个元素的groupby [英] groupby that contain more than one element

问题描述

我正在尝试在DataFrame中恢复包含多个元素的组的行(按TYPE).

I am trying to recover in a DataFrame the rows of the groups (by TYPE) that contain more than one element.

TYPE VALEUR
M1   A
M1   B
M2   A

结果应该是:

TYPE VALEUR
M1   A
M1   B

谢谢！

推荐答案

对优雅的解决方案一无所知.这是我的笨蛋:

Have no idea for an elegant solution. Here's my stupid one:

In [149]: m = df.groupby('TYPE').size() > 1

In [151]: df[df['TYPE'].map(m)]
Out[151]: 
  TYPE VALEUR
0   M1      A
1   M1      B

这篇关于包含多个元素的groupby的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！