User Tools

Site Tools

Trace:
pandas_groupby

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
pandas_groupby [2021/07/06 23:02] – [preserve the highest odd value in each group] adminpandas_groupby [2021/07/06 23:07] – [preserve the highest odd value in each group] admin
Line 93: Line 93:
 11  MM7  S7     t      3 11  MM7  S7     t      3
 </code> </code>
-get all the rows with highest odd 'count' for each ['Sp', 'Mt'] combination. That is, we want+ 
 +We want
 <code> <code>
      Sp  Mt Value  count      Sp  Mt Value  count
Line 103: Line 104:
 11  MM7  S7     t      3 11  MM7  S7     t      3
 </code> </code>
 +That is get all the rows with highest odd 'count' for each ['Sp', 'Mt'] combination.
 +If there is a group with only even 'count' values, discard it.
 +
 Solution Solution
 <code> <code>
Line 169: Line 173:
  
 In [5]: In [5]:
-df.groupby(['Sp', 'Mt'])['count'].transform(max_odd) == df['count']+idx = df.groupby(['Sp', 'Mt'])['count'].transform(max_odd) == df['count'] 
 +idx
 Out[5]: Out[5]:
 0     False 0     False
pandas_groupby.txt · Last modified: 2024/05/07 20:47 by raju