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 ? Thanks in advance, Carlos [[alternative HTML version deleted]]
Hi, I don't really understand what the problem is... There is no duplicated column... Maybe you mean the row names? If it is so, then just don't use row names. Ivan Le 3/17/2010 10:45, Carlos Petti a ?crit :> 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 ? > > 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. > >-- Ivan CALANDRA PhD Student University of Hamburg Biozentrum Grindel und Zoologisches Museum Abt. S?ugetiere Martin-Luther-King-Platz 3 D-20146 Hamburg, GERMANY +49(0)40 42838 6231 ivan.calandra at uni-hamburg.de ********** http://www.for771.uni-bonn.de http://webapp5.rrz.uni-hamburg.de/mammals/eng/mitarbeiter.php
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, asfollows :> > 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 guidehttp://www.R-project.org/posting-guide.html> and provide commented, minimal, self-contained, reproducible code.
Hi Carlos, try as.data.frame.table(t) hth. Carlos Petti schrieb:> 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 ? > > 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. >-- Eik Vettorazzi Institut f?r Medizinische Biometrie und Epidemiologie Universit?tsklinikum Hamburg-Eppendorf Martinistr. 52 20246 Hamburg T ++49/40/7410-58243 F ++49/40/7410-57790