Group by ID and Date

Asked Nov 28 '19 at 11:07

Active Nov 28 '19 at 11:17

Viewed 35 times

I have the following question: How can I group by a dataframe based on 2 columns. One of them is an ID (integer) and the other one is a date in the format of (datetime64[ns]). So this is an example dataset of the input I have and the output desired:

Input

ID Date
1  2019-11-20 01:04:18
1  2019-11-19 01:04:18
1  2019-11-18 01:04:18

2  2019-11-20 01:04:18
2  2019-11-19 01:04:18
2  2019-11-18 01:04:18

3  2019-11-20 01:04:18
3  2019-11-19 01:04:18
3  2019-11-18 01:04:18

Expected output 
 ID Date
    1  2019-11-18 01:04:18
    1  2019-11-19 01:04:18
    1  2019-11-20 01:04:18

    2  2019-11-18 01:04:18
    2  2019-11-19 01:04:18
    2  2019-11-20 01:04:18

    3  2019-11-18 01:04:18
    3  2019-11-19 01:04:18
    3  2019-11-20 01:04:18

asked Nov 28 '19 at 11:07

Vasilis

So you want to sort the dates? – Dani Mesejo Nov 28 '19 at 11:08
Use `df = df.sort_values(['ID','Date'])` – jezrael Nov 28 '19 at 11:17
the code that was here before worked not "df = df.sort_values(['ID','Date'])" – Vasilis Nov 28 '19 at 11:19
I noticed that it only takes days into account. How about hours in minutes? In case they also differ? – Vasilis Nov 28 '19 at 11:56

Group by ID and Date

0 Answers0