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

Popular posts from this blog

inversion of control - Autofac named registration constructor injection -

verilog - Systemverilog dynamic casting issues -

ios - Change Storyboard View using Seague -