From mboxrd@z Thu Jan  1 00:00:00 1970
From: Dan Davison <davison@stats.ox.ac.uk>
Subject: Re: Re: Merge tables
Date: Mon, 28 Sep 2009 16:31:22 -0400
Message-ID: <87ljjy95gl.fsf@stats.ox.ac.uk>
References: <350f72300908190908l61b244dbn66d2f0b045ee9ccf@mail.gmail.com>
	<871vn7u6cy.fsf@gollum.intra.norang.ca>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1MsMsi-0004HF-9i
	for emacs-orgmode@gnu.org; Mon, 28 Sep 2009 16:31:36 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1MsMsd-0004AJ-Ej
	for emacs-orgmode@gnu.org; Mon, 28 Sep 2009 16:31:35 -0400
Received: from [199.232.76.173] (port=41407 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1MsMsd-0004A3-8X
	for emacs-orgmode@gnu.org; Mon, 28 Sep 2009 16:31:31 -0400
Received: from markov.stats.ox.ac.uk ([163.1.210.1]:56975)
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <davison@stats.ox.ac.uk>) id 1MsMsc-0003Yf-Ml
	for emacs-orgmode@gnu.org; Mon, 28 Sep 2009 16:31:31 -0400
In-Reply-To: <871vn7u6cy.fsf@gollum.intra.norang.ca> (Bernt Hansen's message
	of "Wed, 19 Aug 2009 12:16:13 -0400")
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Bernt Hansen <bernt@norang.ca>
Cc: emacs-orgmode@gnu.org

Bernt Hansen <bernt@norang.ca> writes:

> Hector Villafuerte <hectorvd@gmail.com> writes:
>
>> Hi,
>> I've just discovered Org and are truly impressed with it; using it for
>> more and more tasks.
>>
>> Here's what I want to do: I have 2 tables with the same number of rows
>> (one row per subject). I would like to make just one big table by
>> copying the second table to the right of the first one. This is a
>> no-brainer in a spreadsheet but my attempts in Org have failed. Any
>> ideas?

Hi Hector,

Here are two ways of doing this in org-babel.

* Binding tables together by columns

Suppose the tables are

#+tblname: tab1
| 1 | 2 | 3 |
| 7 | 8 | 9 |

#+tblname: tab2
|  4 |  5 |  6 |
| 10 | 11 | 12 |

Here's a solution in emacs lisp:

#+srcname: column-bind-elisp(a=tab1, b=tab2)
#+begin_src emacs-lisp 
(mapcar* 'append a b)
#+end_src

#+resname: column-bind-elisp
| 1 | 2 | 3 |  4 |  5 |  6 |
| 7 | 8 | 9 | 10 | 11 | 12 |

And here's a solution in R, which has the advantage that it copes with
column names (and the code is even simpler).

#+tblname: tab3
| a | b | c |
|---+---+---|
| 1 | 2 | 3 |
| 7 | 8 | 9 |

#+tblname: tab4
|  d |  e |  f |
|----+----+----|
|  4 |  5 |  6 |
| 10 | 11 | 12 |

#+srcname: column-bind-R(a=tab3, b=tab4)
#+begin_src R :colnames t
cbind(a, b)
#+end_src

#+resname: column-bind-R
| "a" | "b" | "c" | "d" | "e" | "f" |
|-----+-----+-----+-----+-----+-----|
|   1 |   2 |   3 |   4 |   5 |   6 |
|   7 |   8 |   9 |  10 |  11 |  12 |


Once someone has written them, even simple code blocks like these can be
stored in the "library of babel" for users who aren't familiar with a
suitable programming language (I'll add them on worg).

Dan

>
> Rectangular cut and paste maybe?
>
> -Bernt
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Remember: use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode