Hi, I have this simple df:
data.source <-
data.frame(stringsAsFactors=FALSE,
VIN = c("aaa", "aaa", "bbb", "bbb", "ccc", "ccc", "ccc", "ccc",
"ddd", "eee", "fff", "fff", "ggg", "ggg",
"ggg", "ggg", "hhh", "hhh", "hhh", "hhh", "hhh",
"iii", "jjj"),
EventDate = c("2019-09-05 16:41:28", "2019-12-10 10:40:44",
"2019-11-07 17:31:45",
"2019-12-10 10:40:13", "2019-08-05 16:41:28",
"2019-12-10 10:40:44", "2019-11-07 17:31:45",
"2019-12-10 10:40:13", "2019-11-07 17:31:45",
"2019-12-10 10:40:13", "2019-11-07 17:31:45",
"2019-12-11 16:01:33", "2019-10-11 16:01:32",
"2020-01-11 16:01:33", "2020-01-07 12:36:08",
"2020-01-01 12:36:08", "2020-01-07 12:36:08",
"2019-12-13 10:17:29", "2019-12-13 10:17:29",
"2019-12-13 10:17:29", "2019-11-28 17:37:13",
"2019-11-28 17:37:13", "2019-11-28 17:37:13")
)
data.source
How can I create a new column showing a gap to previous date for duplicated VINs? Can I also create a variable with the previous date?