[R] Are you sure a table can become a data.frame?

[CE.KA]

Hi R users,

Imagine X as a data frame:

X=read.table(textConnection("
Var1 Var2
1 A H
2 B K
3 A H
4 B H
5 C L
"),header=TRUE)
closeAllConnections()

X                                                X is a data frame
  Var1 Var2
1    A    H
2    B    K
3    A    H
4    B    H
5    C    L

Y<-table(X$Var1,X$Var2)         Y is a cross table between Var1 and Var2
                                                  I want Y to become a data
frame

Y
   H K L
 A 2 0 0
 B 1 1 0
 C 0 0 1

Z<-as.data.frame(Y)                    I want Y to become a data frame: it
doesn't work 
Z
 Var1 Var2 Freq
1    A    H    2
2    B    H    1
3    C    H    0
4    A    K    0
5    B    K    1
6    C    K    0
7    A    L    0
8    B    L    0
9    C    L    1

I expect Z as following data frame
Z
   H K L
 A 2 0 0
 B 1 1 0
 C 0 0 1

I tried as.data.frame(array(x, dim(x), dimnames(x)))  and
as.data.frame.table
but it doesn'work
Kind regards

-- 
View this message in context: http://www.nabble.com/Are-you-sure-a-table-can-become-a-data.frame--tp20528308p20528308.html
Sent from the R help mailing list archive at Nabble.com.