Creating day count using pandas

Question

I have following dataframe,

I have to create a column like below,

How to do that using pandas/python?

ArchAngelPwn · Accepted Answer · 2022-06-29 17:07:48Z

2

This will give you the results you expect IIUC

df['day'] = df.groupby('ID')['d_of_stay'].cumcount()
df['day'] = 'Day ' + df['day'].astype(str)

answered Jun 29, 2022 at 17:06

ArchAngelPwn

3,0461 gold badge6 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Oh no I misread thought he started at 1 i'll update thank you

It should be without +1, so it starts from 0