I want to group by id
column and add the value from the next row to the current row only for the trip
column
How can I transform the first data frame to the second data frame shown below?
Advertisement
Answer
I am not sure if the only thing requested is to concatenate the trip ID of the next row to the current row but if it is, would you consider using shift(-1) ?
df['newtrip']=df['trip']+'-'+df['trip'].shift(-1)