Hi Mark,
It is the underscores that are my issue, I'd prefer multiple level row
titles:
|ID1 |ID2
|Time1 |Time2 |Time1 |Time2
|OD |OS |OD |OS|OD |OS |OD |OS
Height | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Weight| 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Currently I'm using markdown in r-studio.
And yes, I know the same information is in the dcast solution but I'm
trying to convince people R is an alternative to excel.
On Tue, Nov 25, 2014 at 3:37 PM, Mark Sharp <msharp at txbiomed.org> wrote:
> Tom,
>
> If you are wanting PDF as your output, are you wanting to use LaTeX or
> Markdown with knitr. LaTeX will give you more options. You have not shown
> an attempt to use either for your table construction. Can you define what
> you mean by pretty? Is it the underscores in the column names that are the
> problem?
>
> Mark
> > On Nov 25, 2014, at 2:12 PM, Tom Wright <tom at maladmin.com> wrote:
> >
> > Hi,
> > This problem has me stumped so I thought I'd ask the experts. I'm trying
> > to create a pretty summary table of some data (which patients have had
> > what tests at what times). Ideally I'd like to knitr this into a pretty
> > PDF for presentation.
> > If anyone has pointers I'll be grateful.
> >
> > require(tables)
> > require(reshape2)
> >
> > data<-data.frame('ID'=paste0('pat',c(rep(1,8),rep(2,8))),
> > 'Time'=c(1,1,1,1,2,2,2,2,3,3,3,3,4,4,4,4),
> > 'Eye'=rep(c('OS','OS','OD','OD'),4),
> > 'Measure'=rep(c('Height','Weight'),8))
> >
> > tabular(Measure~factor(ID)*factor(Time)*factor(Eye),data)
> > #All levels of Time are repeated for all IDs, I'd prefer to just show
> > the relevant times.
> >
> > tabular(Measure~factor(ID)*Time*factor(Eye),data)
> > #Time is getting collapsed by ID
> >
> > data$value=1
> > dcast(data,Measure~ID+Time+Eye)
> > #close but not very pretty
> >
> > ______________________________________________
> > 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.
>
>
> NOTICE: This E-Mail (including attachments) is confidential and may be
> legally privileged. It is covered by the Electronic Communications Privacy
> Act, 18 U.S.C.2510-2521. If you are not the intended recipient, you are
> hereby notified that any retention, dissemination, distribution or copying
> of this communication is strictly prohibited. Please reply to the sender
> that you have received this message in error, then delete it.
>
[[alternative HTML version deleted]]