0

I have this df:

 BU  Others
 IT   10
 IT   11
 IT   10
 ING  11
 ING  10
 ING  11

The df have been ordered by "BU".

I would like to assign another column with a reference number depends on the number of row for each value of "BU".

Like that:

 BU  Others  Reference
 IT   10      1
 IT   11      2
 IT   10      3
 ING  11      1
 ING  10      2
 ING  11      3

I´ve tried something like that (with mutate, transform, creating the column previously...), but not working:

df<-df %>% 
 mutate(Reference=ifelse(BU== shift(BU),shift(Reference)+1,1))

0 Answers0