我有两组数据:
第一组数据:
patient<-c("A","A","B","B","C","C","C","C")
arrival<-c("11:00","11:00","13:00","13:00","14:00","14:00","14:00","14:00")
lastRow<-c("","Yes","","Yes","","","","Yes")
data1<-data.frame(patient,arrival,lastRow)
另一组数据:
patient<-c("A","A","A","A","B","B","B","C","C","C")
availableSlot<-c("11:15","11:35","11:45","11:55","12:55","13:55","14:00","14:00","14:10","17:00")
data2<-data.frame(patient, availableSlot)
我希望为第一个数据集添加一列,以便为每个患者的最后一行显示最接近到达时间的可用时段:
结果如下:
patient arrival lastRow availableSlot
A 11:00
A 11:00 Yes 11:15
B 13:00
B 13:00 Yes 12:55
C 14:00
C 14:00
C 14:00
C 14:00 Yes 14:00
希望有人能告诉我如何在R中实现这个。
data2
按照arrival
排序,那么这段代码是将data1
和data2[!duplicated(data2$patient),]
按照patient
进行合并。 - Sotos