[R] How to print the frequency table (produced by the command "table" to Excel

[jpm miao]

Hi,

   How could we print the frequency table (produced by "table") to an Excel
file?
   Is there an easy way to do so? Thanks,

Miao

> df <- data.frame(x = 1:3, y = 3:1, z = letters[1:3])

> table(df[,c("y","z")])
   z
y   a b c
  1 0 0 1
  2 0 1 0
  3 1 0 0
> test<-table(df[,c("y","z")])
> as.data.frame(test)
  y z Freq
1 1 a    0
2 2 a    0
3 3 a    1
4 1 b    0
5 2 b    1
6 3 b    0
7 1 c    1
8 2 c    0
9 3 c    0
> as.matrix(test)
   z
y   a b c
  1 0 0 1
  2 0 1 0
  3 1 0 0
> testm<-as.matrix(test)
> testm
   z
y   a b c
  1 0 0 1
  2 0 1 0
  3 1 0 0
> typeof(testm)
[1] "integer"

	[[alternative HTML version deleted]]