Select the value of particular row when groupby in python

Question

I want to groupby multiple column based on a particular column in python. When doing so, for a particular column I want the value to last but one row'th value. If I wanted the same for all column, I would've have used nth method. but I want it for a particular column and I couldn't find the solution online. How can I do this?

Aggregated_Halt = df.groupby('Group_Halt').agg({'Date_Time': [**last but one row**], 'Latitude': ['last'],'Longitude': ['last'], 'Time_diff':'sum', 'LocationAddress': 'last'})

Here I want datetime column to have last but one row value.

Would be better if you could share a sample of input dataframe with expected output. — Mayank Porwal
– Mayank Porwal, Commented Nov 20, 2020 at 7:12

Serial Lazer · Accepted Answer · 2020-11-20 06:47:23Z

1

Try this:

Aggregated_Halt = df.groupby('Group_Halt').agg({'Date_Time': lambda x: x[-2], 'Latitude': ['last'],'Longitude': ['last'], 'Time_diff':'sum', 'LocationAddress': 'last'})

answered Nov 20, 2020 at 6:47

Serial Lazer

1,6691 gold badge9 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Select the value of particular row when groupby in python

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