我有一个像这样的数据框:
FID <- c(1,2,3,4)
d <- c(1,1,2,2)
IID_1 <- c("1A","2A","NA","4A")
IID_2 <- c("1B","2B","3B","4B")
PS_1 <- c(0.5,0.8, NA, 0.3)
PS_2 <- c(0.3,0.4, 0.1, 0.4)
EA_1 <- c(0.2,0.8, NA, 0.3)
EA_2 <- c(0.5,0.5, 0.1, 0.2)
df <- data.frame (FID,d,IID_1,IID_2, PS_1, PS_2, EA_1, EA_2)
我需要将它转换为长格式,就像这个:
FID <- c(1,1,2,2,3,3,4,4)
d <- c(1,1,1,1,2,2,2,2)
IID <- c("1A","1B", "2A", "2B","NA","3B", "4A", "4B")
PS <- c(0.5,0.3, 0.8,0.4, NA,0.1, 0.3, 0.4)
EA <- c(0.2,0.5,0.8,0.5 ,NA,0.1, 0.3,0.2)
df2 <- data.frame (FID,d,IID, PS, EA)
我卡住了,因为我尝试使用pivot_longer,但无法使其正常工作。我不知道是不是因为分隔符的原因。
非常感谢您的帮助。