[R] reshaping data

[Henrique Dallazuanna]

Try:

 as.data.frame(with(x, tapply(Val, list(Var1, Var2), sum)))


On Wed, Mar 31, 2010 at 3:37 PM, Kim Jung Hwa <kimhwamaillist at gmail.com> wrote:
> Thanks Henrique and Stephan for your reply!
>
> Henrique, I'm planning to do some arthitmetic operations on tranformed
> (matrix) data and then would like to convert it back to original format (as
> a data frame)... is there an equivalent easy command for this too? Thanks,
>
> On Wed, Mar 31, 2010 at 2:26 PM, Henrique Dallazuanna <wwwhsd at gmail.com>
> wrote:
>>
>> Try this:
>>
>>  xtabs(Val ~ Var1 + Var2, data = x)
>>
>> On Wed, Mar 31, 2010 at 3:23 PM, Kim Jung Hwa <kimhwamaillist at gmail.com>
>> wrote:
>> > Hi All,
>> >
>> > Can someone help me reshape following data:
>> >
>> > Var1 Var2 Val
>> > A X 1
>> > A Y 2
>> > A Z 3
>> > B X 4
>> > B Y 5
>> > B Z 6
>> >
>> > to some kind of matrix/tabular format (preferably as a matrix), may be
>> > like
>> >
>> > Var1 X Y Z
>> > A 1 2 3
>> > B 4 5 6
>> >
>> > Any help would be greatly appreciated,
>> > Kim
>> >
>> >        [[alternative HTML version deleted]]
>> >
>> > ______________________________________________
>> > R-help at 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.
>> >
>>
>>
>>
>> --
>> Henrique Dallazuanna
>> Curitiba-Paraná-Brasil
>> 25° 25' 40" S 49° 16' 22" O
>
>



-- 
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O