Я использовал библиотеку lubridate
, чтобы найти разницу между временем начала и временем окончания. Вот мой код:
library(lubridate)
a <- read.csv("C:/Users/Desktop/Dump.csv")
b <- a$StartTime
c <- a$EndTime
hm(c)- hm(b)
Это мой результат для кода:
[1] "1H -18M 0S" "1H 5M 0S" "1H 16M 0S" "1H 16M 0S" "1H 5M 0S" "1H 16M 0S" "1H 18M 0S"
[8] "44M 0S" "1H 0M 0S" "1H 23M 0S" "2H -41M 0S" "1H -18M 0S" "1H -18M 0S" "1H -16M 0S"
[15] "1H 0M 0S" "41M 0S" "1H 0M 0S" "24M 0S" "1H -20M 0S" "1H 0M 0S" "1H -19M 0S"
[22] "1H 16M 0S" "1H 25M 0S" "1H 10M 0S" "1H 16M 0S" "44M 0S" "1H 18M 0S" "1H 23M 0S"
[29] "1H -19M 0S" "1H 6M 0S" "1H 16M 0S" "1H -19M 0S" "1H -17M 0S" "1H -20M 0S" "1H 0M 0S"
[36] "2H -40M 0S" "2H -40M 0S" "1H -20M 0S" "1H -20M 0S" "1H 5M 0S" "1H 17M 0S" "1H 11M 0S"
[43] "1H -23M 0S" "1H -30M 0S" "1H -29M 0S" "1H -19M 0S" "45M 0S" "1H -19M 0S" "1H 1M 0S"
[50] "1H -6M 0S" "30M 0S" "1H 28M 0S" "1H -21M 0S" "30M 0S" "1H 1M 0S" "1H -10M 0S"
[57] "1H 0M 0S" "1H -28M 0S" "42M 0S" "51M 0S" "52M 0S" "1H 17M 0S" "2H -43M 0S"
[64] "1H -19M 0S" "1H 1M 0S" "1H -26M 0S" "50M 0S" "1H -19M 0S" "1H 0M 0S" "1H -23M 0S"
[71] "1H 2M 0S" "40M 0S" "30M 0S" "1H -15M 0S" "1H -6M 0S" "30M 0S" "1H -33M 0S"
[78] "1H -20M 0S" "1H 4M 0S" "41M 0S" "1H 13M 0S" "1H 0M 0S" "1H 0M 0S" "1H -30M 0S"
[85] "29M 0S" "1H 10M 0S" "1H 5M 0S" "1H 0M 0S" "1H -27M 0S" "51M 0S" "1H -5M 0S"
[92] "31M 0S" "1H -30M 0S" "33M 0S" "1H 0M 0S" "36M 0S" "2H -43M 0S" "1H -30M 0S"
[99] "34M 0S" "50M 0S" "1H -31M 0S" "41M 0S" "50M 0S" "1H -15M 0S" "1H -15M 0S"
Это мой результат, но он имеет отрицательное значение в минутах, что означает, что правильный ответ - «час - минуты». Кто-нибудь знает, где мой код неправильный, или я забыл что-нибудь закодировать.
Формат данных факторный.
dput(head(a,n=20))
? Могут быть другие способы получить то, что вам нужно (сlubridate
или без него). - person r2evans   schedule 12.08.2018