R 데이터프레임 특정기간 추출

1 개요

R 데이터프레임 특정기간 추출

2 날짜(Date)

df <- read.table( header=T, sep=",", stringsAsFactors=FALSE, text="
date,fruit,ea
2019-05-30,apple,1
2019-06-01,apple,1
2019-06-03,banana, 2
2019-06-05,apple,3
2019-06-06,banana,4
")
df$date <- as.Date(df$date)
newdf <- df[df$date >= "2019-06-01" & df$date <= "2019-06-05",]
newdf
##         date  fruit ea
## 2 2019-06-01  apple  1
## 3 2019-06-03 banana  2
## 4 2019-06-05  apple  3

3 날짜시간(POSIXct)

df <- read.table( header=T, sep=",", stringsAsFactors=FALSE, text="
dt,fruit,ea
2019-05-30 13:00,apple,1
2019-06-01 13:00,apple,1
2019-06-03 13:00,banana, 2
2019-06-05 13:00,apple,3
2019-06-06 13:00,banana,4
")
df$dt <- as.POSIXct(df$dt)
df <- df[df$dt >= "2019-06-01 12:00" & df$dt < "2019-06-05 12:00",]
df
##                    dt  fruit ea
## 2 2019-06-01 13:00:00  apple  1
## 3 2019-06-03 13:00:00 banana  2

4 같이 보기

• R as.Date()
• R 데이터 전처리