我有两个变量,都是"字符"类型。如何在几分钟内获得它们之间的差异:
DisChargeDateTime Visit_DateTime
2012-01-12 15:40:48 2012-01-12 12:58:51
2012-01-12 14:27:31 2012-01-12 13:14:17
我试过了:
D$diff<-as.Date(as.character(D$DisChargeDateTime), format="%Y/%m/%d %HH:%MM:%SS") - as.Date(as.character(D$Visit_DateTime), format="%Y/%m/%d %HH:%MM:%SS")
但得到了差异NA days
这应该使用difftime
在基本 R 中工作:
D <- data.frame(DischargeDateTime = c('2012-01-12 15:40:48', ' 2012-01-12 14:27:31'),
Visit_DateTime = c('2012-01-12 12:58:51', '2012-01-12 13:14:17'))
difftime(as.POSIXct(D$DischargeDateTime), as.POSIXct(D$Visit_DateTime), units = 'mins')
#Time differences in mins
#[1] 161.95000 73.23333