Guest User

Untitled

a guest
Jan 21st, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. ID ID_2 END BEG
  2. 1 55 2017-06-30 2016-01-01
  3. 1 55 2015-12-31 2015-11-12 --> Gap (required date)
  4. 1 88 2008-07-26 2003-02-24
  5. 2 19 2014-09-30 2013-05-01
  6. 2 33 2013-04-30 2011-01-01 --> Not Gap (overlapping)
  7. 2 19 2012-12-31 2011-01-01
  8. 2 33 2010-12-31 2008-05-01
  9. 2 19 2009-06-30 2009-01-01
  10. 2 19 2008-07-26 1980-10-20 --> No actual Gap(required date)
  11.  
  12. df <- df%>%
  13. group_by(ID)%>%
  14. mutate(END_lead = lead(END))
  15.  
  16. df$FLAG <- df$BEG - days(1) == df$END_lead
  17.  
  18. df <- df%>%
  19. group_by(ID)%>%
  20. filter(cumsum(cumsum(FLAG == FALSE))<=1)
  21.  
  22. ID ID_2 END BEG
  23. 1 55 2015-12-31 2015-11-12
  24. 2 19 2008-07-26 1980-10-20
Add Comment
Please, Sign In to add comment