* Combine tables which are results from calculations?
@ 2015-11-03 13:18 Rainer M Krug
[not found] ` <20151103202732.GA10994@eyeBook.home>
0 siblings, 1 reply; 3+ messages in thread
From: Rainer M Krug @ 2015-11-03 13:18 UTC (permalink / raw)
To: emacs-orgmode
[-- Attachment #1: Type: text/plain, Size: 1374 bytes --]
Hi
Considering the following example:
--8<---------------cut here---------------start------------->8---
#+NAME t1
#+begin_src R :colnames yes
data.frame(a = 1:3)
#+end_src
#+RESULTS:
| a |
|---|
| 1 |
| 2 |
| 3 |
#+NAME t2
#+begin_src R :colnames yes
data.frame(b = 1:10)
#+end_src
#+RESULTS:
| b |
|----|
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
#+NAME t3
#+begin_src R :colnames yes
data.frame(c = 1:7)
#+end_src
#+RESULTS:
| c |
|---|
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
What I would like to have is:
| a | b | c |
|----|----|----|
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | 3 |
| | 4 | 4 |
| | 5 | 5 |
| | 6 | 6 |
| | 7 | 7 |
| | 8 | |
| | 9 | |
| | 10 | |
--8<---------------cut here---------------end--------------->8---
How can I combine t1, t2 and t3 column wise?
Thanks,
Rainer
--
Rainer M. Krug, PhD (Conservation Ecology, SUN), MSc (Conservation Biology, UCT), Dipl. Phys. (Germany)
Centre of Excellence for Invasion Biology
Stellenbosch University
South Africa
Tel : +33 - (0)9 53 10 27 44
Cell: +33 - (0)6 85 62 59 98
Fax : +33 - (0)9 58 10 27 44
Fax (D): +49 - (0)3 21 21 25 22 44
email: Rainer@krugs.de
Skype: RMkrug
PGP: 0x0F52F982
[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 454 bytes --]
^ permalink raw reply [flat|nested] 3+ messages in thread
* Re: Combine tables which are results from calculations?
[not found] ` <m2oafa3zm3.fsf@krugs.de>
@ 2015-11-04 17:50 ` Rick Frankel
2015-11-05 8:20 ` Rainer M Krug
0 siblings, 1 reply; 3+ messages in thread
From: Rick Frankel @ 2015-11-04 17:50 UTC (permalink / raw)
To: Rainer M Krug; +Cc: emacs-orgmode
On Wed, Nov 04, 2015 at 10:03:48AM +0100, Rainer M Krug wrote:
> Rick Frankel <rick@rickster.com> writes:
>
> > On Tue, Nov 03, 2015 at 02:18:05PM +0100, Rainer M Krug wrote:
> >> Hi
> >>
> >> Considering the following example:
> >
> > here's a way to do it in ruby. There is probably a way in {emacs,cl}-lisp, but
> > I'm not sure how...
> >
> > #+BEGIN_SRC ruby :var a=t1[,0] b=t2[,0] c=t3[,0] :colnames '(a b c)
> > r = [a, b, c]
> > len = r.collect(&:length).max
> > r.each { |l| l.fill('', l.length, len - l.length) }
> > a.zip(b, c)
> > #+END_SRC
>
> Thanks - I'll look into this and see if I can do something similar in R
> or elisp.
Here's a elisp version:
* zip lists
#+name: a
| a |
|---|
| 1 |
| 2 |
#+name: b
| b |
|---|
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
#+name: c
| c |
|----|
| 9 |
| 10 |
| 11 |
#+BEGIN_SRC emacs-lisp :var a=a[,0] b=b[,0] c=c[,0] :colnames '(a b c)
(let* ((l (list a b c))
(max (apply #'max (mapcar #'length l))))
(apply
#'mapcar* #'list
(mapcar (lambda (x) (append x (make-list (- max (length x)) ""))) l)))
#+END_SRC
rick
Note: previous reply was not to list (whoops) CC'ing the list on this so the
answer is saved for posterity :).
^ permalink raw reply [flat|nested] 3+ messages in thread
* Re: Combine tables which are results from calculations?
2015-11-04 17:50 ` Rick Frankel
@ 2015-11-05 8:20 ` Rainer M Krug
0 siblings, 0 replies; 3+ messages in thread
From: Rainer M Krug @ 2015-11-05 8:20 UTC (permalink / raw)
To: emacs-orgmode
[-- Attachment #1: Type: text/plain, Size: 1980 bytes --]
Rick Frankel <rick@rickster.com> writes:
> On Wed, Nov 04, 2015 at 10:03:48AM +0100, Rainer M Krug wrote:
>> Rick Frankel <rick@rickster.com> writes:
>>
>> > On Tue, Nov 03, 2015 at 02:18:05PM +0100, Rainer M Krug wrote:
>> >> Hi
>> >>
>> >> Considering the following example:
>> >
>> > here's a way to do it in ruby. There is probably a way in {emacs,cl}-lisp, but
>> > I'm not sure how...
>> >
>> > #+BEGIN_SRC ruby :var a=t1[,0] b=t2[,0] c=t3[,0] :colnames '(a b c)
>> > r = [a, b, c]
>> > len = r.collect(&:length).max
>> > r.each { |l| l.fill('', l.length, len - l.length) }
>> > a.zip(b, c)
>> > #+END_SRC
>>
>> Thanks - I'll look into this and see if I can do something similar in R
>> or elisp.
>
> Here's a elisp version:
>
> * zip lists
> #+name: a
> | a |
> |---|
> | 1 |
> | 2 |
>
>
> #+name: b
> | b |
> |---|
> | 4 |
> | 5 |
> | 6 |
> | 7 |
> | 8 |
>
> #+name: c
> | c |
> |----|
> | 9 |
> | 10 |
> | 11 |
>
> #+BEGIN_SRC emacs-lisp :var a=a[,0] b=b[,0] c=c[,0] :colnames '(a b c)
> (let* ((l (list a b c))
> (max (apply #'max (mapcar #'length l))))
> (apply
> #'mapcar* #'list
> (mapcar (lambda (x) (append x (make-list (- max (length x)) ""))) l)))
> #+END_SRC
Thanks a lot - I think this should possibly go ito worg?
I'll keep it for reference as I implemented the whole layouting in R.
Thanks,
Rainer
>
>
> rick
>
> Note: previous reply was not to list (whoops) CC'ing the list on this so the
> answer is saved for posterity :).
--
Rainer M. Krug, PhD (Conservation Ecology, SUN), MSc (Conservation Biology, UCT), Dipl. Phys. (Germany)
Centre of Excellence for Invasion Biology
Stellenbosch University
South Africa
Tel : +33 - (0)9 53 10 27 44
Cell: +33 - (0)6 85 62 59 98
Fax : +33 - (0)9 58 10 27 44
Fax (D): +49 - (0)3 21 21 25 22 44
email: Rainer@krugs.de
Skype: RMkrug
PGP: 0x0F52F982
[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 454 bytes --]
^ permalink raw reply [flat|nested] 3+ messages in thread
end of thread, other threads:[~2015-11-05 8:20 UTC | newest]
Thread overview: 3+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2015-11-03 13:18 Combine tables which are results from calculations? Rainer M Krug
[not found] ` <20151103202732.GA10994@eyeBook.home>
[not found] ` <m2oafa3zm3.fsf@krugs.de>
2015-11-04 17:50 ` Rick Frankel
2015-11-05 8:20 ` Rainer M Krug
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).