>
> Wonderful, Phil! Your suggestion produced the exact format I desired.
> Thank you kindly,
>
AC Del Re
>
>
> On Sun, Oct 4, 2009 at 2:03 PM, Phil Spector <spec...@stat.berkeley.edu>wrote:
>
>> AC -
>> The easiest way I can think of is to create a time variable,
>> so reshape will know which observation to call 1, 2, or 3.
>>
>> data$time = unlist(sapply(split(data,data$id),function(x)1:nrow(x)))
>> or
>> data$time = unlist(tapply(data$id,data$id,function(x)1:length(x))
>>
>> Then
>>
>> reshape(data,idvar=c('id','author'),timevar='time',direction='wide')
>>
>> should give you what you want.
>> - Phil Spector
>> Statistical Computing Facility
>> Department of Statistics
>> UC Berkeley
>> spec...@stat.berkeley.edu
>>
>>
>>
>> On Sun, 4 Oct 2009, AC Del Re wrote:
>>
>> Dear R Community,
>>> I am attempting to transpose a dataset from rows to columns but am stuck.
>>> I
>>> have tried using reshape() with little luck, possibly due to the
>>> categorical
>>> nature of the data. For example:
>>>
>>> id<-c(1,2,2,3,3,3)
>>> author<-c("j","k","k","l","l","l")
>>> tmt<-c("cbt","act","dbt","act","act","cbt")
>>> alliance<-c("wai","other","calpas","wai","itas","other")
>>> data<-as.data.frame(cbind(id,author,tmt,alliance))
>>>
>>> data
>>>>
>>> id author tmt alliance
>>> 1 1 j cbt wai
>>> 2 2 k act other
>>> 3 2 k dbt calpas
>>> 4 3 l act wai
>>> 5 3 l act itas
>>> 6 3 l cbt other
>>>
>>> I would like the data to be in the following format:
>>>
>>> id author tmt.1 tmt.2 alliance.1 alliance.2 alliance.3
>>> 1 j cbt NA wai NA NA
>>> 2 k act dbt other calpas NA
>>> 3 l act act wai itas other
>>>
>>>
>>> I tried:
>>>
>>> wide <- reshape(data, idvar=c("id","author"), direction="wide")
>>>>
>>>
>>> Error in `[.data.frame`(data, , timevar) : undefined columns selected
>>>
>>> If I specify all columns, it gives the following format (which is not
>>> desired):
>>>
>>> wide <- reshape(data, idvar=c("id","author"),
>>> + direction="wide", *v.names="tmt", timevar="alliance"*)
>>>
>>> wide
>>>>
>>> id author tmt.wai tmt.other tmt.calpas tmt.itas
>>> 1 1 j cbt <NA> <NA> <NA>
>>> 2 2 k <NA> act dbt <NA>
>>> 4 3 l act cbt <NA> act
>>>
>>> Any help is much appreciated!
>>>
>>> AC
>>>
>>> [[alternative HTML version deleted]]
>>>
>>> ______________________________________________
>>> 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.
>>>
>>>
>
[[alternative HTML version deleted]]
______________________________________________
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.
