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

Issue

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

Solution

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

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

Answered By - tlentali