On Jul 22, 2010, at 4:00 PM, Liat wrote: > > Hi guys, > I hope you can help me with this. > Here is the problem: > I have some data (myData) that looks similar to this: > > [,1] [,2] [,3] [,4] > [1,] "A" "A" "B" "B" > [2,] "B" "B" "B" "B" > [3,] "C" "C" "C" "C" > > When I build a contingency table for the first and second row using: > tb <- table(myData[1, ], myData[2, ], useNA="ifany") > I get: > B > A 2 > B 2 > But - I would like to also see "C" there (with a zero). > Actually, I would like to give a list of n characters that would be used to > build an n*n table and the data for this table should then come from myData > (and if there are characters in my list that do not appear in the data at > all I would like to see a zero row or a zero column). > Is that possible to do? > What would be the simplest way? > Many many thanks!!! > Liat.
Just convert each character vector to a factor with the appropriate level set, as in table(factor(myData[1, ], levels=c("A","B","C"))) > -- > View this message in context: > http://r.789695.n4.nabble.com/how-to-force-a-table-to-be-square-tp2298707p2298707.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@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. -- Peter Dalgaard Center for Statistics, Copenhagen Business School Solbjerg Plads 3, 2000 Frederiksberg, Denmark Phone: (+45)38153501 Email: pd....@cbs.dk Priv: pda...@gmail.com ______________________________________________ R-help@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.