R help - Sep 2010 - Creating table from data frame

Hey,

I have a dataset where two columns are factors and another column consists
of values. Each combination of factors can only have a single value assigned
to it.
I'd like to represent this as a matrix or table where the rows are the first
column factors and the columns the second column factors. So that each cell
a_ij in the matrix represents the associated value for the factor
combination ij.
When no such value exists for the combination the value should be 0.

I've tried playing around with tables to get this to work, but I can't
seem
to get it right. I've also had little luck when trying to find a solution to
this.

Any help would be much appreciated!

Mike

	[[alternative HTML version deleted]]

Try this:

d <- data.frame(A = letters[1:10], B = sample(letters[11:20]), C sample(10))
xtabs(C ~ A + B, d)

On Tue, Sep 21, 2010 at 8:39 AM, ZeMajik <zemajik@gmail.com> wrote:
> Hey,
>
> I have a dataset where two columns are factors and another column consists
> of values. Each combination of factors can only have a single value
> assigned
> to it.
> I'd like to represent this as a matrix or table where the rows are the
> first
> column factors and the columns the second column factors. So that each cell
> a_ij in the matrix represents the associated value for the factor
> combination ij.
> When no such value exists for the combination the value should be 0.
>
> I've tried playing around with tables to get this to work, but I
can't seem
> to get it right. I've also had little luck when trying to find a
solution
> to
> this.
>
> Any help would be much appreciated!
>
> Mike
>
>        [[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.
>


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

	[[alternative HTML version deleted]]