Checking if Date is Between two Dates in R

by

You may use foverlaps from data.table. Convert both the data.frames to data.table with start/end columns. Set the key column as the column names of each dataset. Use foverlaps to get the numeric index which can be converted to binary match based on the NA values in it.

library(data.table)#v1.9.5+
dt1 <- data.table(ID=df1$ID, start=df1$actual.date, end=df1$actual.date)
setkeyv(dt1, colnames(dt1))
dt2 <- as.data.table(df2)
setnames(dt2, 2:3, c('start', 'end'))
setkeyv(dt2, colnames(dt2))
indx <- foverlaps(dt1, dt2, type="within", which=TRUE, mult="first")
dt1[, match:= +(!is.na(indx))][,end:=NULL]
setnames(dt1, 1:2, colnames(df1))
dt1
#   ID actual.date match
#1:  1  1997-10-01     0
#2:  1  1998-02-01     1
#3:  1  2002-05-01     1
#4:  2  1999-07-01     0
#5:  3  2005-09-01     1
#6:  4  2003-02-03     1
#7:  4  2006-05-01     0

More Related Contents:

  1. How to prevent ifelse() from turning Date objects into numeric objects
  2. How to convert Excel date format to proper date in R
  3. How to flatten / merge overlapping time periods
  4. Split date-time column into Date and time variables
  5. efficiently generate a random sample of times and dates between two dates
  6. Change day of the month in a Date to first day (01)
  7. Convert decimal day to HH:MM
  8. Round a POSIX date (POSIXct) with base R functionality
  9. Convert date-time string to class Date
  10. Replace values in a dataframe based on lookup table
  11. Specify custom Date format for colClasses argument in read.table/read.csv
  12. Converting year and month (“yyyy-mm” format) to a date?
  13. Subset a dataframe between 2 dates
  14. Find which season a particular date belongs to
  15. as.Date with dates in format m/d/y in R
  16. Change timezone in a POSIXct object
  17. How to parse milliseconds?
  18. as.Date returning NA while converting from ‘ddmmmyyyy’
  19. R: How to handle times without dates?
  20. Extract Month and Year From Date in R
  21. How to Parse Year + Week Number in R?
  22. How to determine if date is a weekend or not (not using lubridate)
  23. Converting date in Year.decimal form in R
  24. How to subtract years?
  25. Find all date ranges for overlapping start and end dates in R
  26. Convert integer as “20160119” to different columns of “day” “year” “month”
  27. as.Date(as.POSIXct()) gives the wrong date?
  28. R datetime series missing values
  29. Create a Vector of All Days Between Two Dates
  30. How to calculate time difference with previous row of a data.frame by group

Leave a Comment