From: Darlan Cavalcante Moreira <darcamo@gmail.com>
To: Dan Davison <davison@stats.ox.ac.uk>
Cc: Bernt Hansen <bernt@norang.ca>, emacs-orgmode@gnu.org
Subject: Re: Re: Merge tables
Date: Tue, 29 Sep 2009 12:15:32 -0300 [thread overview]
Message-ID: <4ac22497.9653f10a.6433.5abd@mx.google.com> (raw)
In-Reply-To: <87ljjy95gl.fsf@stats.ox.ac.uk>
At Mon, 28 Sep 2009 16:31:22 -0400,
Dan Davison wrote:
>
> 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
>
>
> _______________________________________________
> 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
If you only want to put the second table at the right of the first one I think
that the functions kill-rectangle and yank-rectangle are enough. Select the
second table (without the first | char) and run the command kill-rectangle (C-x r
k), then put the cursor at the end of the first line of the first table and run
the command yank-rectangle (C-x r y).
--
Darlan Cavalcante Moreira
darcamo@gmail.com
prev parent reply other threads:[~2009-09-29 17:17 UTC|newest]
Thread overview: 4+ messages / expand[flat|nested] mbox.gz Atom feed top
2009-08-19 16:08 Merge tables Hector Villafuerte
2009-08-19 16:16 ` Bernt Hansen
2009-09-28 20:31 ` Dan Davison
2009-09-29 15:15 ` Darlan Cavalcante Moreira [this message]
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=4ac22497.9653f10a.6433.5abd@mx.google.com \
--to=darcamo@gmail.com \
--cc=bernt@norang.ca \
--cc=davison@stats.ox.ac.uk \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.