我有一个关于一组个人的数据集,它是从每个人的不同时间开始收集的.
我需要设置自第一次输入后1年的数据子集,如下所示:myData[myDate >= "first entry" & myDate += "1 year"]
示例数据:
df_date <- data.frame( Name = c("Jim","Jim","Jim","Jim","Jim","Jim","Jim","Jim","Jim","Jim","Jim","Jim","Jim","Jim",
"Sue","Sue","Sue","Sue","Sue","Sue","Sue","Sue","Sue","Sue","Sue","Sue","Sue","Sue"),
Dates = c("2010-1-1", "2010-2-2", "2010-3-5","2010-4-17","2010-5-20",
"2010-6-29","2010-7-6","2010-8-9","2010-9-16","2010-10-28","2010-11-16","2010-12-28","2011-1-16","2011-2-28",
"2010-4-1", "2010-5-2", "2010-6-5","2010-7-17","2010-8-20",
"2010-9-29","2010-10-6","2010-11-9","2012-12-16","2011-1-28","2011-2-28","2011-3-28","2011-2-28","2011-3-28"),
Event = c(1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1) )
期望的输出将是Jim将拥有来自1/1/2010 - 12/28/2010
的数据,Sue将拥有来自4/4/2010 - 3/28/2011
的数据,依此类推.实际的数据集有20个样本,都是在不同的时间开始的.