Assign rank for each group by each date in pandas data frame - not getting expected rank value

Question

need help. i have a sample data which contains sessionid and datetime visited. one session may be visited multiple pages in the same day. i need to assign ranking for each date group by the session.

sample

the code which i am using is

   df['date_rank'] = df.groupby(['CookieID'])['PageViewDate'].rank().astype(int)

but it is not giving expected rank

the output is

Is `CookieID` an existing column ? – tlentali Oct 11 '22 at 12:05 — tlentali, Oct 11 '22 at 12:05

tlentali · Accepted Answer · 2022-10-11T12:13:14.300

1

We can try to use the cumcount() method instead of rank() :

df['date_rank'] = df.groupby(['CookieID'])['PageViewDate'].cumcount() + 1

edited Oct 11 '22 at 12:13

answered Oct 11 '22 at 12:04

tlentali

3,407
2
14
21

Assign rank for each group by each date in pandas data frame - not getting expected rank value

1 Answers1