Transform contingency table into data.frame ?

Hi

and did you try my suggestion?

as.data.frame(as.matrix(t, row.names = names(t)))

Regards
Petr

r-help-bounces at r-project.org napsal dne 17.03.2010 11:16:43:

   

Dear list,

Sorry, I did not explain myself very well.

I want to obtain a data.frame like this :

Freq
a    1
b    1
c    1

This data.frame contains just one column (Freq) and each row is named.

But when I use this code :

df<- as.data.frame(t)

or this code :

df<- as.data.frame(t, row.names(t))

The "a" column remains.

Thanks,
Carlos

2010/3/17 Petr PIKAL<petr.pikal at precheza.cz>

     

Hi

r-help-bounces at r-project.org napsal dne 17.03.2010 10:45:48:

       

Dear list,

I have a contingency table :

a<- letters[1:3]
t<- table(a)

I'm looking for a way to transform this table into data frame, as
         

follows :
       

  Freq
a    1
b    1
c    1

I used :

df<- as.data.frame(t, row.names = names(t))

But, this function do not remove the duplicated column. Do you know
         

the
   

solution ?
         

You probably do not distinct between columns of data frame and row
       

names
   

of data frame. From what you told us it is not clear which one you
       

want to
   

keep

if row names use

as.data.frame(as.matrix(t, row.names = names(t)))

if you want to keep column

as.data.frame(t)

shall suffice.

Row names is not a data frame column.

Regards
Petr


       

Thanks in advance,
Carlos

    [[alternative HTML version deleted]]

    [[alternative HTML version deleted]]