Re: [O] formatting org-babel output

2013-05-22 Thread Jay Kerns
Hi Joe,

On Wed, May 22, 2013 at 7:18 AM, Joe Bogner joebog...@gmail.com wrote:
 I am using org-mode and babel with R for reproducible research. I
 would like certain numbers in the output tables to be formatted for
 easier reading - such as eliminating decimals and adding commas for
 readability.


[snip]

Have you considered doing your formatting in R before it ever gets to
the org table?  The format function is very powerful. For instance,

 format(163328361.2423, nsmall = 2, big.mark =,)
[1] 163,328,361.24

Just an idea.

-- 
Jay



Re: [O] formatting org-babel output

2013-05-22 Thread Eric Schulte
Joe Bogner joebog...@gmail.com writes:

 I am using org-mode and babel with R for reproducible research. I
 would like certain numbers in the output tables to be formatted for
 easier reading - such as eliminating decimals and adding commas for
 readability.

 The best I came up with is to use a TBLFM line at the bottom of my
 results table using a function I found on the ElispCookbook on
 emacswiki. A simple example is below that doesn't require R to
 reproduce.

 It's a two step process currently to execute the R code in org-babel
 and then jump to the result table TBLFM line and  Ctrl+c Ctrl+c to
 format the table

 Is there a better way to format table outputs for simple things like
 currency? I would be content if it's only during the org export
 process too


You can use the recently introduced :post header argument to
post-process the output of a code block.  The following example
demonstrates the use of this argument to apply your number-grouper
function to table output.

#+BEGIN_SRC emacs-lisp :results silent
  (defun group-number (num optional size char)
Format NUM as string grouped to SIZE with CHAR.
;; Based on code for `math-group-float' in calc-ext.el
(let* ((size (or size 3))
   (char (or char ,))
   (str (if (stringp num)
(number-to-string (string-to-number
   (replace-regexp-in-string ,  num)))
  (number-to-string num)))
   (pt (or (string-match [^0-9a-zA-Z] str) (length str
  (while ( pt size)
(setq str (concat (substring str 0 (- pt size))
  char
  (substring str (- pt size)))
  pt (- pt size)))
  str))
#+END_SRC

The following code block will call the group-number Emacs Lisp
function on every cell in its input argument which is a number.

#+name: table-number-grouper
#+BEGIN_SRC emacs-lisp :var data='()
  (mapcar (lambda (row)
(if (equalp row 'hline) 'hline
  (mapcar (lambda (cell) (if (numberp cell) (group-number cell) cell))
  row)))
  data)
#+END_SRC

Here's a simple shell code block which produces the table (this is a
stand in for your R code block).
#+begin_src sh
  cat EOF
  1.55a
  23000   b
  3000c
  40004   e
  50003
  EOF
#+end_src

#+RESULTS:
| 1.55 | a |
|23000 | b |
| 3000 | c |
|40004 | e |
| 5000 | 3 |

Above is the poorly formatted output of your block.  Below we add the
post header argument to your block, which will use the
table-number-grouper code block above to post-process your results.

#+begin_src sh :post table-number-grouper(*this*)
  cat EOF
  1.55a
  23000   b
  3000c
  40004   e
  50003
  EOF
#+end_src

#+RESULTS:
| 100,000,000.55 | a |
| 23,000 | b |
| 3,000  | c |
| 40,004 | e |
| 5,000  | 3 |

Cheers,

-- 
Eric Schulte
http://cs.unm.edu/~eschulte


Re: [O] formatting org-babel output

2013-05-22 Thread Joe Bogner
Eric - That is perfect. It's exactly what I was looking for. Thank you
for very much!

Jay - format is a good option too.I also found the scales packages

 scales::comma(scales::dollar(5))
[1] $55,555

In the end, the org-mode post solution feels more automatic and in the
right layer - since I'm using org-mode for presentation of the R
results.

Thanks again
Joe

On Wed, May 22, 2013 at 9:12 AM, Eric Schulte schulte.e...@gmail.com wrote:
 Joe Bogner joebog...@gmail.com writes:

 I am using org-mode and babel with R for reproducible research. I
 would like certain numbers in the output tables to be formatted for
 easier reading - such as eliminating decimals and adding commas for
 readability.

 The best I came up with is to use a TBLFM line at the bottom of my
 results table using a function I found on the ElispCookbook on
 emacswiki. A simple example is below that doesn't require R to
 reproduce.

 It's a two step process currently to execute the R code in org-babel
 and then jump to the result table TBLFM line and  Ctrl+c Ctrl+c to
 format the table

 Is there a better way to format table outputs for simple things like
 currency? I would be content if it's only during the org export
 process too


 You can use the recently introduced :post header argument to
 post-process the output of a code block.  The following example
 demonstrates the use of this argument to apply your number-grouper
 function to table output.



 Cheers,

 --
 Eric Schulte
 http://cs.unm.edu/~eschulte