Thank you for your suggestion, I will play around with it. I guess my concern
is that I need each test result to occupy its own "cell" rather than have
one or more in the same row.
Adaikalavan Ramasamy-2 wrote:
>
> There might be a more elegant way of doing this but here is a way of
> doing it without reshape().
>
> df <- data.frame( ID=c(1,1,1,1,2,2),
> TEST=c("A","A","B","C","B","B"),
> RESULT=c(17,12,15,12,8,9) )
>
> df.s <- split( df, df$ID )
>
> out <- sapply( df.s, function(m)
> tapply( m$RESULT, m$TEST, paste, collapse="," ) )
>
> t(out)
>
> A B C
> 1 "17,12" "15" "12"
> 2 NA "8,9" NA
>
> Not the same output as you wanted. This makes more sense unless you have
> a reason to priotize 17 instead of 12 in the first row.
>
> Regards, Adai
>
>
> jcarmichael wrote:
>> I have a dataset in "long" format that looks something like this:
>>
>> ID TEST RESULT
>> 1 A 17
>> 1 A 12
>> 1 B 15
>> 1 C 12
>> 2 B 8
>> 2 B 9
>>
>> Now what I would like to do is transpose it like so:
>>
>> ID TEST A TEST B TEST C
>> 1 17 15 12
>> 1 12 . .
>> 2 . 8 .
>> 2 . 9 .
>>
>> When I try:
>>
>> reshape(mydata, v.names="result", idvar="id",timevar="test",
>> direction="wide")
>>
>> It gives me only the first occurrence of each test for each subject. How
>> can I transpose my dataset in this way without losing information about
>> repeated tests?
>>
>> Any help or guidance would be appreciated! Thanks!
>
> ______________________________________________
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
>
--
View this message in context:
http://www.nabble.com/Maintaining-repeated-ID-numbers-when-transposing-with-reshape-tp19151853p19166910.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
