這是我的問題:我的資料框有多個事件(下面的事件 1 到事件 4),其中跟進的結束是任何事件的時間。我使用 survSplit 將此資料幀從寬格式轉換為長格式。survSplit 似乎一次只處理一種事件型別,因此我決定使用嵌套的 ifelse 陳述句手動執行此操作,該陳述句似乎可以作業,直到我想在從事件列到事件列的 for 回圈中執行相同的操作(我的真實資料集有 33 種結果型別)。回圈失敗并給出以下錯誤訊息:
錯誤:分配的資料value必須與現有資料兼容。x 現有資料有 12 行。x 分配的資料有 0 行。i 只有大小為 1 的向量被回收。運行rlang::last_error()以查看錯誤發生的位置。另外:警告訊息:未知或未初始化的列:event。
install.packages("survival")
install.packages("dplyr")
library(survival)
library(dplyr)
cutpoints.l <- c(1.25)
f12 <- data.frame(id = 1:6,
next.ivl= c(22.348, 1.837, 2.051,1.782,1.692, 1.730),
event1 = c(0,1,0,0,1,0),
event2 = c(1,0,0,0,0,1),
event3 = c(0,0,1,1,0,0),
event4 = c(0,0,0,0,0,0),
enter= rep(0,6),
end=c(22.348, 1.837,2.051,1.782,1.629,1.730))
f12.split <- survSplit(Surv(next.ivl,event1)~.,f12,
cut = cutpoints.l,
event = "event1",
start = "enter",
end = "next.ivl",
episode = "ivl")
f12.split <- f12.split %>%
group_by(id) %>%
mutate(n = ifelse(row_number() == 1, 1, 0))%>%
mutate(N = ifelse(row_number() == n(), 1, 0))
events<-grep("event", colnames(f12.split), value = TRUE)
for (event in events) {
print(event)
f12.split$event<-ifelse(f12.split$N==1 & f12.split$event==1, ifelse(f12.split$n==1 &
f12.split$event==1,0,1),0)
}
uj5u.com熱心網友回復:
聽起來您只想重塑event*列而不做其余的事情。這可以直接使用tidyr::pivot_longeror來完成reshape2::melt:
tidyr::pivot_longer(f12, starts_with("event"), names_to = "event")
# # A tibble: 24 x 6
# id next.ivl enter end event value
# <int> <dbl> <dbl> <dbl> <chr> <dbl>
# 1 1 22.3 0 22.3 event1 0
# 2 1 22.3 0 22.3 event2 1
# 3 1 22.3 0 22.3 event3 0
# 4 1 22.3 0 22.3 event4 0
# 5 2 1.84 0 1.84 event1 1
# 6 2 1.84 0 1.84 event2 0
# 7 2 1.84 0 1.84 event3 0
# 8 2 1.84 0 1.84 event4 0
# 9 3 2.05 0 2.05 event1 0
# 10 3 2.05 0 2.05 event2 0
# # ... with 14 more rows
reshape2::melt(f12, id.vars = c("id", "next.ivl", "enter", "end"), variable.name = "event")
# id next.ivl enter end event value
# 1 1 22.348 0 22.348 event1 0
# 2 2 1.837 0 1.837 event1 1
# 3 3 2.051 0 2.051 event1 0
# 4 4 1.782 0 1.782 event1 0
# 5 5 1.692 0 1.629 event1 1
# 6 6 1.730 0 1.730 event1 0
# 7 1 22.348 0 22.348 event2 1
# 8 2 1.837 0 1.837 event2 0
# 9 3 2.051 0 2.051 event2 0
# 10 4 1.782 0 1.782 event2 0
# 11 5 1.692 0 1.629 event2 0
# 12 6 1.730 0 1.730 event2 1
# 13 1 22.348 0 22.348 event3 0
# 14 2 1.837 0 1.837 event3 0
# 15 3 2.051 0 2.051 event3 1
# 16 4 1.782 0 1.782 event3 1
# 17 5 1.692 0 1.629 event3 0
# 18 6 1.730 0 1.730 event3 0
# 19 1 22.348 0 22.348 event4 0
# 20 2 1.837 0 1.837 event4 0
# 21 3 2.051 0 2.051 event4 0
# 22 4 1.782 0 1.782 event4 0
# 23 5 1.692 0 1.629 event4 0
# 24 6 1.730 0 1.730 event4 0
轉載請註明出處,本文鏈接:https://www.uj5u.com/yidong/432507.html
