Guest User

Untitled

a guest
Feb 25th, 2018
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. ngay_hl <- seq(as.Date("2014-05-13"), by="day", length.out = 30)
  2. ngay_kt <- ngay_hl + 300
  3. dt_bh <- sample(5000000:7000000,30)
  4. d <- data.frame(ngay_hl, ngay_kt, dt_bh)
  5.  
  6. sum.dt_bh.period <- function(x,y) {
  7. a <- as.Date("x","%d/%m/%Y")
  8. b <- as.Date("y","%d/%m/%Y")
  9. D_temp <- mutate(d,
  10. var_M =
  11. ifelse(ngay_hl %in% a:b & ngay_kt %in% a:b, (ngay_kt-ngay_hl)*dt_bh/as.numeric(ngay_kt-ngay_hl),
  12. ifelse(ngay_hl %in% a:b & ngay_kt >b, (b-ngay_hl)*dt_bh/as.numeric(ngay_kt-ngay_hl),
  13. ifelse(ngay_hl < a & ngay_kt %in% a:b, (ngay_kt-a)*dt_bh/as.numeric(ngay_kt-ngay_hl),
  14. ifelse(ngay_hl < a & ngay_kt > b,(b-a)*dt_bh/as.numeric(ngay_kt-ngay_hl),0)))))
  15. colSums(D_temp[,"var_M"],na.rm = TRUE)
  16. }
Add Comment
Please, Sign In to add comment