Re: [O] extract a column from a table but but an name on the new table
> On 26/05/2018 10:32, Uwe Brauer wrote: > You may like the out-of-the-boxtable remote references: > | 3 | > | 4 | > | 6 | > | 7 | > | | > | | > #+TBLFM: $1=remote(raw-data,@@#$3) > The downside is that you need to create an empty table with the right > size before filling it with C-u C-c * > I get a result. Maybe you used downcase "notasA" where uppercase > "NotasA" was expected? You are right!! I did not pay attention! Now it works, thanks very very much, that simplifies my workflow. Uwe smime.p7s Description: S/MIME cryptographic signature
Re: [O] extract a column from a table but but an name on the new table
On 26/05/2018 10:32, Uwe Brauer wrote: > You may name the Lisp block like that: > -- > #+TBLNAME: raw-data > | 1 | a | 3 | > | 2 | b | 4 | > | 3 | c | 6 | > | 4 | d | 7 | Thank you! BTW I found it strange that the extracting function does not exist in vanilla org. You may like the out-of-the-boxtable remote references: | 3 | | 4 | | 6 | | 7 | | | | | #+TBLFM: $1=remote(raw-data,@@#$3) The downside is that you need to create an empty table with the right size before filling it with C-u C-c * My situation is a bit different, since I later want to use R. So I have #+TBLNAME: raw-data | 1 | a | 3 | | 2 | b | 4 | | 3 | c | 6 | | 4 | d | 7 | #+NAME: NotasA #+BEGIN_SRC elisp :var data=raw-data (mapcar (lambda (line) (list (nth 2 line))) data) #+END_SRC #+RESULTS: NotasA | 3 | | 4 | | 6 | | 7 | #+begin_src R :var notasA=notasA summary(notasA) #+end_src And the last call does not work. It seems that R needs a table name. Uwe I get a result. Maybe you used downcase "notasA" where uppercase "NotasA" was expected? #+begin_src R :var notasA=NotasA summary(notasA) #+end_src #+RESULTS: | Min. :3.00 | | 1st Qu.:3.75 | | Median :5.00 | | Mean :5.00 | | 3rd Qu.:6.25 | | Max. :7.00 |
Re: [O] extract a column from a table but but an name on the new table
> You may name the Lisp block like that: > -- > #+TBLNAME: raw-data > | 1 | a | 3 | > | 2 | b | 4 | > | 3 | c | 6 | > | 4 | d | 7 | Thank you! BTW I found it strange that the extracting function does not exist in vanilla org. My situation is a bit different, since I later want to use R. So I have #+TBLNAME: raw-data | 1 | a | 3 | | 2 | b | 4 | | 3 | c | 6 | | 4 | d | 7 | #+NAME: NotasA #+BEGIN_SRC elisp :var data=raw-data (mapcar (lambda (line) (list (nth 2 line))) data) #+END_SRC #+RESULTS: NotasA | 3 | | 4 | | 6 | | 7 | #+begin_src R :var notasA=notasA summary(notasA) #+end_src And the last call does not work. It seems that R needs a table name. Uwe smime.p7s Description: S/MIME cryptographic signature
Re: [O] extract a column from a table but but an name on the new table
On 24/05/2018 15:08, Uwe Brauer wrote: Hi Thierry Banel one of the authors of orgtbl-aggregate.el Suggested to me the following code, if just want to extract one column of a table. #+TBLNAME: raw-data | 1 | a | 3 | | 2 | b | 4 | | 3 | c | 6 | | 4 | d | 7 | #+BEGIN_SRC elisp :var data="" (mapcar (lambda (line) (list (nth 2 line))) data) #+END_SRC #+RESULTS: | 3 | | 4 | | 6 | | 7 | It works nicely but how could I obtain the result with a table name, like: #+TBLNAME: RESULTS | 3 | | 4 | | 6 | | 7 | Or something like this? Thanks Uwe Brauer You may name the Lisp block like that: -- #+TBLNAME: raw-data | 1 | a | 3 | | 2 | b | 4 | | 3 | c | 6 | | 4 | d | 7 | #+NAME: just-one-column #+BEGIN_SRC elisp :var data=""> (mapcar (lambda (line) (list (nth 2 line))) data) #+END_SRC #+RESULTS: just-one-column | 3 | | 4 | | 6 | | 7 | -- Then you can use the new table in a further processing: -- #+BEGIN_SRC elisp :var data=""> (mapcar (lambda (line) (list (* 1000 (nth 0 line data) #+END_SRC #+RESULTS: | 3000 | | 4000 | | 6000 | | 7000 | --