[R] Tables, knitr markdown

[Gergely Daróczi]

On Mon, Feb 22, 2016 at 1:55 PM, Duncan Murdoch
<murdoch.duncan at gmail.com> wrote:
>
> On 22/02/2016 3:46 PM, Santosh wrote:
>>
>> Just figured out..
>>
>> as.data.frame(as.matrix(<tabular_object>),stringsAsFactors=F)
>>
>> could work! :)
>
>
> Why do you want to produce Markdown output?  the tables package (lowercase t!) can produce output in either LaTeX or HTML.  Just tell knitr to leave the output alone, e.g. for PDF output
>
> ```{r results="asis"}
> require(tables)
> tab <- tabular( (Species + 1) ~ (n=1) + Format(digits=2)*
>          (Sepal.Length + Sepal.Width)*(mean + sd), data=iris )
> latex(tab)
> ```
>
> or for HTML output
>
> ```{r results="asis"}
> require(tables)
> tab <- tabular( (Species + 1) ~ (n=1) + Format(digits=2)*
> (Sepal.Length + Sepal.Width)*(mean + sd), data=iris )
> html(tab)
> ```


In case of you would rather generate markdown instead of HTML/LaTeX to
be independent from the resulting output document format, you can give
a try to the "pander" package, which can transform quite many R object
types into markdown, eg:

#> library(tables)
#> tab <- tabular( (Species + 1) ~ (n=1) + Format(digits=2)*
#+          (Sepal.Length + Sepal.Width)*(mean + sd), data=iris )
#> pander::pander(tab)

------------------------------------------------------------
     \        \    Sepal.Length\    \    Sepal.Width\    \
  Species     n         mean        sd       mean        sd
------------ ---- ---------------- ---- --------------- ----
  *setosa*    50        5.01       0.35      3.43       0.38

*versicolor*  50        5.94       0.52      2.77       0.31

*virginica*   50        6.59       0.64      2.97       0.32

   *All*     150        5.84       0.83      3.06       0.44
------------------------------------------------------------

Please find more details at
http://rapporter.github.io/pander/#generic-pander-method, or the
knitr+pander vignette at
https://cran.rstudio.com/web/packages/pander/vignettes/knitr.html

Best,
Gergely


>
>
>
>
> Duncan Murdoch
>
>
>>
>>
>> On Mon, Feb 22, 2016 at 12:17 PM, Santosh <santosh2005 at gmail.com> wrote:
>>
>>> Dear Rxperts..
>>> I am able to generate tables using Tables R package..
>>> However, when I have been unsuccessful in using kable (from knitr package)
>>> to generate the table in R markdown script..
>>>
>>> It's because the output generated by "tabular" in Tables package is of
>>> class "tabular". The kable function in knitr package accepts data.frame.
>>>
>>> Is there a way to convert the tabular class objects into data.frame
>>>   objects?
>>>
>>> Or is there a way that kable can accept "tabular" class object?
>>>
>>>
>>> Thanks so much..
>>> Santosh
>>>
>>
>>         [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>> 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.
>>
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.