Guest User

Untitled

a guest
Oct 22nd, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.24 KB | None | 0 0
  1. > dat <- data.frame("ID" = c(6,6,6,7,7,10,11,11),
  2. "Admit_Dt" = c('2013-08-12', '2013-12-12', '2016-01-03','2011-04-01', '2011-09-20','2012-02-19','2014-06-24','2014-08-12'),
  3. "Urgent" = c(0,1,1,1,0,0,1,1))
  4. > dat
  5.  
  6. | ID | Admit_Dt | Urgent|
  7. | 6 | 2013-08-12 | 1|
  8. | 6 | 2013-12-12 | 0|
  9. | 6 | 2016-01-03 | 1|
  10. | 7 | 2011-04-01 | 1|
  11. | 7 | 2011-09-20 | 0|
  12. | 10 | 2012-02-19 | 0|
  13. | 11 | 2014-06-24 | 1|
  14. | 11 | 2014-08-12 | 1|
  15.  
  16. > dat$Urgent_1yrSum <- unlist(sapply(1:length(unique(dat$ID)), function(i) {
  17. grouped <- subset(dat, ID == unique(dat$ID)[i])
  18. output <- do.call(rbind, lapply(1:nrow(grouped), function(y){
  19. urgent_sum_1year <- sum(grouped[grouped$Admit_Dt < grouped$Admit_Dt[y] & grouped$Admit_Dt > (grouped$Admit_Dt[y] - dyears(1)), "Urgent"])
  20. }))
  21. return(output)
  22. }
  23. ))
  24.  
  25. > dat
  26. | ID | Admit_Dt | Urgent| Urgent_1yrSum|
  27. | 6 | 2013-08-12 | 1| 0|
  28. | 6 | 2013-12-12 | 0| 1|
  29. | 6 | 2016-01-03 | 1| 0|
  30. | 7 | 2011-04-01 | 1| 0|
  31. | 7 | 2011-09-20 | 0| 1|
  32. | 10 | 2012-02-19 | 0| 0|
  33. | 11 | 2014-06-24 | 1| 0|
  34. | 11 | 2014-08-12 | 1| 1|
Add Comment
Please, Sign In to add comment