table column with trailing 0s

table column with trailing 0s

[Andreas Leha]

Hi all,

I am trying to get a table generated from R to be pretty printed in
org mode (and the export).

Suppose, I have a table like this (typical statistical table):

#+attr_latex: align=lr
#+begin_src R :colnames yes :exports results
  data.frame(parameter=c("param1", "param2", "param3", "param4"),
             pvalue=c("0.80", "0.15", "*0.03*", "*< 0.01*"))
#+end_src

#+results:
| parameter | pvalue   |
|-----------+----------|
| param1    | 0.8      |
| param2    | 0.15     |
| param3    | *0.03*   |
| param4    | *< 0.01* |

Here, org mode strips the trailing 0 from param1 which makes the
table a lot less readable.

How can I tell org not to trim the contents of string(!) columns?

Regards,
Andreas

Re: table column with trailing 0s

[Thomas S. Dye]

Andreas Leha <andreas.leha@med.uni-goettingen.de> writes:

> Hi all,
>
> I am trying to get a table generated from R to be pretty printed in
> org mode (and the export).
>
> Suppose, I have a table like this (typical statistical table):
>
> #+attr_latex: align=lr
> #+begin_src R :colnames yes :exports results
>   data.frame(parameter=c("param1", "param2", "param3", "param4"),
>              pvalue=c("0.80", "0.15", "*0.03*", "*< 0.01*"))
> #+end_src
>
> #+results:
> | parameter | pvalue   |
> |-----------+----------|
> | param1    | 0.8      |
> | param2    | 0.15     |
> | param3    | *0.03*   |
> | param4    | *< 0.01* |
>
> Here, org mode strips the trailing 0 from param1 which makes the
> table a lot less readable.
>
> How can I tell org not to trim the contents of string(!) columns?
>
> Regards,
> Andreas
>
>
>
Aloha Andreas,

I've been very happy using David Hajage's ascii package for R.  See
http://orgmode.org/worg/org-contrib/babel/languages/ob-doc-R.html#sec-4-2
for a few examples of how it works with tabular and non-tabular data.

hth,
Tom

-- 
Thomas S. Dye
http://www.tsdye.com

Re: table column with trailing 0s

[Andreas Leha]

tsd@tsdye.com (Thomas S. Dye) writes:

> Andreas Leha <andreas.leha@med.uni-goettingen.de> writes:
>
>> Hi all,
>>
>> I am trying to get a table generated from R to be pretty printed in
>> org mode (and the export).
>>
>> Suppose, I have a table like this (typical statistical table):
>>
>> #+attr_latex: align=lr
>> #+begin_src R :colnames yes :exports results
>>   data.frame(parameter=c("param1", "param2", "param3", "param4"),
>>              pvalue=c("0.80", "0.15", "*0.03*", "*< 0.01*"))
>> #+end_src
>>
>> #+results:
>> | parameter | pvalue   |
>> |-----------+----------|
>> | param1    | 0.8      |
>> | param2    | 0.15     |
>> | param3    | *0.03*   |
>> | param4    | *< 0.01* |
>>
>> Here, org mode strips the trailing 0 from param1 which makes the
>> table a lot less readable.
>>
>> How can I tell org not to trim the contents of string(!) columns?
>>
>> Regards,
>> Andreas
>>
>>
>>
> Aloha Andreas,
>
> I've been very happy using David Hajage's ascii package for R.  See
> http://orgmode.org/worg/org-contrib/babel/languages/ob-doc-R.html#sec-4-2
> for a few examples of how it works with tabular and non-tabular data.
>
> hth,
> Tom

Hi Tom,

thanks for this pointer.  I have used the ascii package on several
occasions already, but completely forgot about it this time.

Cheers,
Andreas