R 데이터프레임 시간 계산

1 개요

R 데이터프레임 시간 계산
R 데이터프레임 기간 계산
R 데이터프레임 difftime 구하여 컬럼 추가

df <- read.csv( header=T, stringsAsFactors=FALSE, text="
session,started,finished,user
1,2019-06-01 01:00,2019-06-01 01:10,alice
2,2019-06-01 02:00,2019-06-01 02:30,bob
3,2019-06-01 03:00,2019-06-01 04:00,carol
4,2019-06-01 04:00,2019-06-01 05:20,alice
5,2019-06-01 05:00,2019-06-01 04:50,bob
")
df
##   session          started         finished  user
## 1       1 2019-06-01 01:00 2019-06-01 01:10 alice
## 2       2 2019-06-01 02:00 2019-06-01 02:30   bob
## 3       3 2019-06-01 03:00 2019-06-01 04:00 carol
## 4       4 2019-06-01 04:00 2019-06-01 05:20 alice
## 5       5 2019-06-01 05:00 2019-06-01 04:50   bob

df$started <- as.POSIXct(df$started)
df$finished <- as.POSIXct(df$finished)
df$duration <- df$finished - df$started
str(df$duration)
df
##   session             started            finished  user duration
## 1       1 2019-06-01 01:00:00 2019-06-01 01:10:00 alice  10 mins
## 2       2 2019-06-01 02:00:00 2019-06-01 02:30:00   bob  30 mins
## 3       3 2019-06-01 03:00:00 2019-06-01 04:00:00 carol  60 mins
## 4       4 2019-06-01 04:00:00 2019-06-01 05:20:00 alice  80 mins
## 5       5 2019-06-01 05:00:00 2019-06-01 04:50:00   bob -10 mins
df[df$duration < 60,]
##   session             started            finished  user duration
## 1       1 2019-06-01 01:00:00 2019-06-01 01:10:00 alice  10 mins
## 2       2 2019-06-01 02:00:00 2019-06-01 02:30:00   bob  30 mins
## 5       5 2019-06-01 05:00:00 2019-06-01 04:50:00   bob -10 mins

2 같이 보기