Re: [O] formatting org-babel output
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 wrote: > Joe Bogner 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 >
Re: [O] formatting org-babel output
Joe Bogner 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 < Cheers, -- Eric Schulte http://cs.unm.edu/~eschulte
Re: [O] formatting org-babel output
Hi Joe, On Wed, May 22, 2013 at 7:18 AM, Joe Bogner 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
[O] formatting org-babel output
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 #+BEGIN_SRC emacs-lisp (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 #+RESULTS: : group-number #+NAME: example-table | 1.55 | a | | 23000 | b | | 3000 | c | | 40004 | e | | 5000 | 3 | This is the table I want formatted #+BEGIN_SRC emacs-lisp :var data=example-table data #+END_SRC #+RESULTS: | 100,000,000.55 | a | | 23,000 | b | | 3,000 | c | | 40,004 | e | | 5,000 | 3 | #+TBLFM: $1='(group-number $1)'