R rearrange my table in a particular way -
i started learning r. have table rearrange in particular way difficult me explain without example. here's table got:
| user | event | line | | use1 | enter | 1 | use1 | enter | 2 | use1 | login | 3 | use1 | enter | 4 | use1 | enter | 5 | use1 | enter | 6 | use1 | login | 7 | use2 | login | 8 .... so want every time event equal login , match recent enter before it. resulting table should this:
| user | event | line | | use1 | enter | 2 | use1 | login | 3 | use1 | enter | 6 | use1 | login | 7 | use1 | enter | 6 | use1 | login | 8 ... any appreciated! thanks
separating 2 events different arrays find last previous enter event each login
i1 <- which(df1$event == "login") i2 <- which(df1$event == "enter") i3 <- unlist(lapply(i1, function(x) c(max(i2[i2 < x]), x))) df1[i3, ] user event line 2 use1 enter 2 3 use1 login 3 6 use1 enter 6 7 use1 login 7 6.1 use1 enter 6 8 use2 login 8
Comments
Post a Comment