pandas - Select Last Row of Column Based on Different Column Value

Question

I've got a dataframe like

    Season   Game   Event_Num        Home         Away         Margin
0   2016-17     1          1           0           0             0
1   2016-17     1          2           0           0             0
2   2016-17     1          3           0           2             2
3   2016-17     1          4           0           2             2
4   2016-17     1          5           0           2             2
..      ...   ...        ...         ...         ...           ...
95  2017-18     5         53          17          10             7
96  2017-18     5         54          17          10             7
97  2017-18     5         55          17          10             7
98  2017-18     5         56          17          10             7
99  2017-18     5         57          17          10             7

And ultimately, I'd like to take the last row of each Game played, so for instance, the last row for Game 1, Game 2, etc. so I can see what the final margin was, but I'd like to do this for every unique season.

For example, if there were 3 games played for 2 unique seasons then the df would look something like:

        Season   Game   Event_Num        Home         Away        Final Margin
    0   2016-17     1          1          90           80            10
    1   2016-17     2          2          83           88             5
    2   2016-17     3          3          67           78            11
    3   2017-18     1          4         101          102             1
    4   2017-18     2          5         112          132            20
    5   2017-18     3          6

Is there a good way to do something like this? TIA.

Mutaz-MSFT · Accepted Answer · 2021-07-25 03:40:57Z

2

Try:

df.groupby(['Season','Game']).tail(1)

output

    Season  Game  Event_Num  Home  Away  Margin
4  2016-17     1          5     0     2       2
9  2017-18     5         57    17    10       7

edited Jul 25, 2021 at 3:40

answered Jul 25, 2021 at 3:33

Mutaz-MSFT

8066 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

pandas - Select Last Row of Column Based on Different Column Value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related