[R] odfWeave - merged table cells, and adding information like totals and p-values

[Max Kuhn]

The devel version of odfWeave has some multicolumn capabilities. these
were added by Patrick Lenon and Zekai Otles recently, but I have not
had a chance to test it out.

You can go to:

   https://r-forge.r-project.org/projects/odfweave/

and download the version there if you want to evaluate the new
arguments to odfTable.

Thanks,

Max

On Sun, Feb 21, 2010 at 11:35 AM, Polwart Calum (County Durham and
Darlington NHS Foundation Trust) <calum.polwart at nhs.net> wrote:
> I'm hoping I'm missing some (probably fundamental basic process) which might make my life easier!
>
> Lets assume I have a 3 column table summarizing results from a trial from three arms (Arm A, B and C).
> For each arm there will be a number of pieces of information to report.  The simplest example might be to compare this to the demographic comparisons often seen in clinical traisl where you are setting out to prove that your randomization produced similar populations
>
> So I might have a table like this:
>
> ---------------------------------------
>                 A             B               C
> ---------------------------------------
>
> Male            50              50              50
> Female  49              51              50
>
> Age < 65        30              29              31
> Age 65+ 69              72              69
> ---------------------------------------
>
> I've got a matrix with that data in it which I'm passing to odfWeave's table function.   I just want to check a few basic things.
>
> Here's some short code which will create the matrix:
> groups = c("A","B","C")
> factors = c("Male","Female", "Age < 65", "Age 65+")
> mydata = matrix (c(50,49,30,69,50,51,29,72,50,50,31,69), nrow=4, dimnames = list(factors,groups))
>
> - Is there anyway to add a merged cell above ABC which would say Group?
> - If I want to total column I can do that using:
> total=as.numeric()
> for (fact in 1:length(factors)) {
>        total[fact]=sum(mydata[fact,])
> }
> mydata = cbind(mydata,total)
> Is there an easier way?
>
> - Now lets say i want to do a chi-squ test between the ages differences in Gp A and Gp B I run
> chisq.test(mydata[3:4,1:2])
> What I really want is the p-value and I'll want to repeat that for Gp A vs Gp C.  If I was just using R I'd simply print those and then add them to my table by hand.  But I'm trying to be smart and use odfWeave.  Now I know I can put them in my caption but I'd probably have added them as an extra row in my table or added it in brackets similar to the SDs/ORs and CIs shown in this example http://www.bmj.com/cgi/content-nw/full/340/feb05_1/c199/TBL2 depending which was more appropriate.
>
> - Is there an easy way to do anything like this?  I'm thinking that we often put crude numbers in and (%) in brackets, or CIs etc  - so my exported table would not ideally be pure numbers.
>
> - As a p value usually links two columns I might have expected to use a merged cell which again brings me back to my original question ;-)
>
> Thanks
>
>
>
>
>
> Calum Polwart BSc(Hons) MSc MRPharmS SP IP
> Network Pharmacist - North of England Cancer Network and
> Pharmacy Clinical Team Manager (Cancer & Aseptic Services) - County Durham & Darlington NHS Foundation Trust
>
> ********************************************************************************************************************
>
> This message may contain confidential information. If ...{{dropped:16}}