? stato filtrato un testo allegato il cui set di caratteri non era indicato... Nome: non disponibile URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20120222/a28536ba/attachment.pl>
Multiple lines for each record: how do I handle that
5 messages · Sarah Goslee, Jorge I Velez, Luca Meyer
If you provide a small reproducible example of your data format and expected output, I'm sure someone here can offer a useful solution. Without knowing what your data look like, not so easy. Sarah
On Wed, Feb 22, 2012 at 2:22 PM, Luca Meyer <lucam1968 at gmail.com> wrote:
Hi Folks, I just discovered that my dataset (coming from QuestionPro platform) has got multiple lines for each respondent id, but what I would really need is a "regular" data matrix where each respondent's data is shown on a single line. Does anyone has already develop a procedure that automatically takes the multiple lines and aggregates them into a single line? Thank you in advance, Luca Mr. Luca Meyer www.lucameyer.com R version 2.14.1 (2011-12-22) Mac OS X 10.6.8
Sarah Goslee http://www.functionaldiversity.org
Sure, I am sorry I have not done that in the first place.
The datasets I have looks like:
id <- c(1,1,2,2,2,3)
v1 <- c(NA,1,NA,1,NA,1)
v2 <- as.character(c("yes","","no","","","yes"))
v3 <- as.factor(c(NA,1,NA,NA,3,2))
d0 <- data.frame(id,v1,v2,v3)
d0
What I would need is to derive a dataset that looks like:
id <- c(1,2,3)
v1 <- c(1,1,1)
v2 <- as.character(c("yes","no","yes"))
v3 <- as.factor(c(1,3,2))
d1 <- data.frame(id,v1,v2,v3)
d1
The issue is related to the need to have an automated procedure that reads in the different variable types and aggregates them accordingly as every dataset will be different from the previous in terms of number of variables and records involved.
Thank you,
Luca
Il giorno 22/feb/2012, alle ore 20.26, Sarah Goslee ha scritto:
If you provide a small reproducible example of your data format and expected output, I'm sure someone here can offer a useful solution. Without knowing what your data look like, not so easy. Sarah On Wed, Feb 22, 2012 at 2:22 PM, Luca Meyer <lucam1968 at gmail.com> wrote:
Hi Folks, I just discovered that my dataset (coming from QuestionPro platform) has got multiple lines for each respondent id, but what I would really need is a "regular" data matrix where each respondent's data is shown on a single line. Does anyone has already develop a procedure that automatically takes the multiple lines and aggregates them into a single line? Thank you in advance, Luca Mr. Luca Meyer www.lucameyer.com R version 2.14.1 (2011-12-22) Mac OS X 10.6.8
-- Sarah Goslee http://www.functionaldiversity.org
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20120222/7af9fff8/attachment.pl>
? stato filtrato un testo allegato il cui set di caratteri non era indicato... Nome: non disponibile URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20120222/5958fe00/attachment.pl>