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 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.
--
Peter Dalgaard
Center for Statistics, Copenhagen Business School
Solbjerg Plads 3, 2000 Frederiksberg, Denmark
Phone: (+45)38153501
Email: pd.mes at cbs.dk Priv: PDalgd at gmail.com