date difference along with group

Asked Nov 17 '22 at 09:09

Active Nov 17 '22 at 09:09

Viewed 16 times

I have a dataframe which consist of order_date,order_time for multiple restaurant. I want to create a new column which would calculate the queue based on order date and time.

I have tried using diff() on order time along with group by on order_date and restaurant_id but it didnt worked.

Expected output : a new column 'time_diff' which would contain difference between consecutive orders for same restaurant and on same date.

asked Nov 17 '22 at 09:09

Shivam Singhal

So for the first two order times in your example, you want a new column with the result of `47:19.1 - 46:67.9` ? – Nick Nov 17 '22 at 09:35
@Nick , Yes if the order belong to same restaurant and is of same date. – Shivam Singhal Nov 17 '22 at 09:37
Does [this](https://stackoverflow.com/a/62330004/2570277) answer solve the problem? – Nick Nov 17 '22 at 09:55
@nick, No since I have to sort data based on restaurant id, order date and order date. Then i need to calculate the time difference. – Shivam Singhal Nov 17 '22 at 10:51

date difference along with group

0 Answers0