[R] RE SHAPE package question.

[hadley wickham]

On Sat, Aug 2, 2008 at 4:00 PM, hpdutra <hpdutra at yahoo.com> wrote:
>
> I am sorry but here is an example
>> test
>  t1 t2 t3 t4 M F id
> 1  1  0  0  0 1 0  1
> 2  1  0  0  0 1 0  1
> 3  1  0  0  0 0 1  1
> 4  1  0  1  1 1 0  1
> 5  1  0  1  1 1 0  1
> 6  1  0  1  1 1 0  1
> 7  1  0  1  1 0 1  1
>
>> test<-read.table(h=T, file.choose())
>> dfm <- melt(test, m = "id")
>> summarised <- cast(dfm, t1+ t2 + t3 + t4 + M + F ~ variable, sum)
>> summarised
>  t1 t2 t3 t4 M F id
> 1  1  0  0  0 0 1  1
> 2  1  0  0  0 1 0  2
> 3  1  0  1  1 0 1  1
> 4  1  0  1  1 1 0  3
>
>
>
> So it works partially because it does not add the male and females columns.
> I am sure it is simple but I just don't know how to do it. I was hoping that
> it would give me the following data

I think that you need to treat M and F as measured variables as well:

dfm <- melt(test, m = c("id", "M", "F"))

Then the same cast command will get you the format that you want.

Hadley

-- 
http://had.co.nz/