R Rename Group Column

Asked Feb 25 '20 at 17:55

Active Feb 25 '20 at 17:55

Viewed 29 times

data=data.frame("student" = c(12,12,12,75,75,75,31,31,31,31,46,46),
"newID"=c(1,1,1,2,2,2,3,3,3,3,4,4))

I have 'data' with 'student' and want to generate 'newID' that keeps the integrity of the 'student' column but starts with 1,2,3, and so on and so forth.

asked Feb 25 '20 at 17:55

bvowe

3,004
3
16
33

use `lag` function to detect where you have a difference then `cumsum` to get you newID – godot Feb 25 '20 at 17:59
1

`as.numeric(as.factor(data$student))` should do it – R. Schifini Feb 25 '20 at 18:01

R Rename Group Column

0 Answers0