[R] Tables, knitr markdown

[Santosh]

Sorry.. I forgot to mention that I wanted it be published in MS Word,
because it goes into a Report this is prepared using MS Word.

Hence,the above effort.. yes, it's a lot easier to send it to Latex..

I was also wondering if it is possible to add "\hline" separating the
categories in a table..

Using tabular, I get this:

\begin{tabular}{lcccc}
\hline
"Name"  & "Value1" & \multicolumn{1}{c}{"Value2"} \\
\hline
\nopagebreak A1  &   0.06 &   1.2 \\
\nopagebreak A5  &   0.62 &   8.9 \\
\nopagebreak A6  &   0.48 &   4.2 \\
\rule{0pt}{1.7\normalbaselineskip}A2  &   1.50 &   1.27 \\
\nopagebreak A7  &   0.11 &   4.3 \\
\nopagebreak A3  &   0.01 &   3.1 \\
\rule{0pt}{1.7\normalbaselineskip}A4  &   2.19 &   1.0 \\
\nopagebreak B1.  &  0.03 &   2.0 \\
\nopagebreak B2.  &  0.011 &  1.8 \\
\rule{0pt}{1.7\normalbaselineskip}B3  &  0.10 &  2.7 \\
\nopagebreak B4.  &  0.02 &   1.6 \\
\nopagebreak C1.  &  0.01 &   1.1 \\
\hline
\end{tabular}

But, I want in this way.. (with horizontal lines and customized text
inserted at the beginning of a group..

\begin{tabular}{lcccc}
\hline
"Name"  & "Value1" & \multicolumn{1}{c}{"Value2"} \\
\hline
\multicolumn{5}{l}{\textbf{Hardened}}\\
\hline
\nopagebreak A1  &   0.06 &   1.2 \\
\nopagebreak \tA5  &   0.62 &   8.9 \\
\nopagebreak \tA6  &   0.48 &   4.2 \\
\rule{0pt}{1.7\normalbaselineskip}A2  &   1.50 &   1.27 \\
\nopagebreak \tA7  &   0.11 &   4.3 \\
\nopagebreak \tA3  &   0.01 &   3.1 \\
\rule{0pt}{1.7\normalbaselineskip}A4  &   2.19 &   1.0 \\
\hline
\multicolumn{3}{l}{\textbf{Pulverized}}\\
\hline
\nopagebreak B1.  &  0.03 &   2.0 \\
\nopagebreak B2.  &  0.011 &  1.8 \\
\rule{0pt}{1.7\normalbaselineskip}B3  &  0.10 &  2.7 \\
\nopagebreak B4.  &  0.02 &   1.6 \\
\hline
\multicolumn{3}{l}{\textbf{Molten}}\\
\hline
\nopagebreak C1.  &  0.01 &   1.1 \\
\hline
\end{tabular}

Thanks so much for your help!
Santosh

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)
> ```
>
>
> 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.
>>
>>
>

	[[alternative HTML version deleted]]