根据唯一标识符将数据聚合到行中?
我有一个数据框,其中包含唯一的id(音节)和持续时间。为了继续我的分析,我需要按音节聚合数据框。
因此,
syllable duration
ba 0.20414850
a 0.06804950
na 0.11525535
a 0.09877130
na 0.36774874
ba 0.18228837
ba 0.22232325
应该长成这样:
syllable duration_1 duration_2 duration_3
ba 0.20414850 0.18228837 0.22232325
a 0.06804950 0.09877130
na 0.11525535 0.36774874
我尝试使用dplyr的group_by函数
library(dplyr)
df %>%
group_by(syllable) %>%
summarise(duration = paste(duration, collapse = ","))
然而,这将产生以下结果:
syllable duration
ba c(0.20414850,0.18228837,0.22232325)
a c(0.06804950,0.09877130)
na c(0.11525535,0.36774874)
谢谢你
library(data.table) SO <- as.data.table(SO) SO[, Time_Var := seq(1:.N), by = "syllable"] SO <- reshape(data = SO, direction = "wide", idvar = "syllable", timevar = "Time_Var")
- Arturo Sbr