I have a dataset in R that looks like this:
DF <- data.frame(name=c("A","b","c","d","B","e","f"),
x=c(NA,1,2,3,NA,4,5))
我希望你能将其改造成:
rDF <- data.frame(name=c("b","c","d","e","f"),
x=c(1,2,3,4,5),
head=c("A","A","A","B","B"))
第一行带有NA
的标识新列,并且将该“行值”保持到下一个带有NA
的行,然后更改“行值”。
我已经尝试过spread
和melt
,但它们没有给我我想要的结果。
library(tidyr)
DF %>% spread(name,x)
library(reshape2)
melt(DF, id=c('name'))
有什么建议吗?