Advertisement
Guest User

Untitled

a guest
Jul 21st, 2019
175
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. test = tibble(time = c(as_datetime('2019-01-01 00:00:00'),
  2. as_datetime('2019-01-01 01:00:00'),
  3. as_datetime('2019-01-01 00:00:00'),
  4. as_datetime('2019-01-01 01:00:00')),
  5. tz = c('EST','EST','Asia/Hong_Kong','Asia/Hong_Kong'))
  6.  
  7. test %>% group_by(tz) %>% mutate(localtime = with_tz(time, tz[1]))
  8.  
  9. time tz localtime
  10. <dttm> <chr> <dttm>
  11. 1 2019-01-01 00:00:00 EST 2019-01-01 00:00:00
  12. 2 2019-01-01 01:00:00 EST 2019-01-01 01:00:00
  13. 3 2019-01-01 00:00:00 Asia/Hong_Kong 2019-01-01 00:00:00
  14. 4 2019-01-01 01:00:00 Asia/Hong_Kong 2019-01-01 01:00:00
  15.  
  16. test %>% group_by(tz) %>% mutate(localtime = with_tz(time, !!tz[1]))
  17.  
  18. time tz localtime
  19. <dttm> <chr> <dttm>
  20. 1 2019-01-01 00:00:00 EST 2018-12-31 19:00:00
  21. 2 2019-01-01 01:00:00 EST 2018-12-31 20:00:00
  22. 3 2019-01-01 00:00:00 Asia/Hong_Kong 2018-12-31 19:00:00
  23. 4 2019-01-01 01:00:00 Asia/Hong_Kong 2018-12-31 20:00:00
  24.  
  25. test %>% rowwise %>% mutate(localtime = with_tz(time, tz))
  26.  
  27. time tz localtime
  28. <dttm> <chr> <dttm>
  29. 1 2019-01-01 00:00:00 EST 2019-01-01 08:00:00
  30. 2 2019-01-01 01:00:00 EST 2019-01-01 09:00:00
  31. 3 2019-01-01 00:00:00 Asia/Hong_Kong 2019-01-01 08:00:00
  32. 4 2019-01-01 01:00:00 Asia/Hong_Kong 2019-01-01 09:00:00
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement