[R] Transform contingency table into data.frame ?

[Petr PIKAL]

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]]
> > >
> > > ______________________________________________
> > > 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.
> >
> >
> 
>    [[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.