Re: [問題] 依特定條件補足日期
以下提供兩種方式
library(data.table)
library(dplyr)
library(lubridate)
data <- data.frame(Group = c("A", "A", "B", "B", "C", "C"),
Status = rep(c("Start", "End"), times = 3),
Date = c("2016/01/01", "2016/01/15",
"2016/01/09", "2016/02/01",
"2016/01/02", "2016/01/07"))
# data.table
data %>%
setDT %>%
.[,
.(Date = seq(ymd(.SD[Status == "Start", Date]),
ymd(.SD[Status == "End", Date]),
by = "days")),
by = Group]
# dplyr
data %>%
group_by(Group) %>%
do({
subDf <- .
Date <- seq(ymd(filter(subDf, Status == "Start")$Date),
ymd(filter(subDf, Status == "End")$Date),
by = "days")
str(Date)
return(data.frame(Date = Date))
}) %>%
ungroup
※ 引述《menghsuanliu (庫庫少)》之銘言：
: [問題類型]:
: 程式諮詢(我想用R 做某件事情，但是我不知道要怎麼用R 寫出
: [軟體熟悉度]:
: 入門(寫過其他程式，只是對語法不熟悉)
: [問題敘述]:
: 我想依group,把日期補足(參考附圖)
: http://i.imgur.com/ef6uHfT.jpg
: [程式範例]:
: [環境敘述]:
: [關鍵字]:
:
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 223.141.2.216
※ 文章網址: https://www.ptt.cc/bbs/R_Language/M.1496746493.A.BDB.html
→
06/06 21:04, , 1F
06/06 21:04, 1F
→
06/06 21:28, , 2F
06/06 21:28, 2F
→
06/06 21:30, , 3F
06/06 21:30, 3F
→
06/06 21:34, , 4F
06/06 21:34, 4F
→
06/06 21:34, , 5F
06/06 21:34, 5F
→
06/06 21:35, , 6F
06/06 21:35, 6F
→
06/06 21:43, , 7F
06/06 21:43, 7F
→
06/06 21:46, , 8F
06/06 21:46, 8F
→
06/06 21:56, , 9F
06/06 21:56, 9F
→
06/06 21:57, , 10F
06/06 21:57, 10F
討論串 (同標題文章)
R_Language 近期熱門文章
PTT數位生活區 即時熱門文章
