Advertisement
Guest User

Untitled

a guest
Aug 20th, 2017
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. library(data.table)
  2. dt <- data.table(sys_id = 1:9,
  3. A = c(11, 12, 12, 13, 14, 15, 15, 18, 18),
  4. B = c(2, 1, 2, 1, 2, 1, 2, 1, 2),
  5. Age = c(13, NA, 13, NA, 11, NA, 12, NA, 12))
  6.  
  7. sys_id A B Age
  8. 1: 1 11 2 13
  9. 2: 2 12 1 NA
  10. 3: 3 12 2 13
  11. 4: 4 13 1 NA
  12. 5: 5 14 2 11
  13. 6: 6 15 1 NA
  14. 7: 7 15 2 12
  15. 8: 8 18 1 NA
  16. 9: 9 18 2 12
  17.  
  18. dt[, Age := unique(Age[!is.na(Age)]), by = A]
  19. dt
  20.  
  21. sys_id A B Age
  22. 1: 1 11 2 13
  23. 2: 2 12 1 13
  24. 3: 3 12 2 13
  25. 4: 4 13 1 NA
  26. 5: 5 14 2 11
  27. 6: 6 15 1 12
  28. 7: 7 15 2 12
  29. 8: 8 18 1 12
  30. 9: 9 18 2 12
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement