From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Brand Subject: Re: feature request: transpose a table Date: Wed, 07 Apr 2010 21:52:04 +0200 Message-ID: <4BBCE264.3000407@alumni.ethz.ch> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1NzbIL-0003aa-40 for emacs-orgmode@gnu.org; Wed, 07 Apr 2010 15:52:13 -0400 Received: from [140.186.70.92] (port=57931 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NzbIJ-0003aS-ES for emacs-orgmode@gnu.org; Wed, 07 Apr 2010 15:52:12 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1NzbID-0004oD-HO for emacs-orgmode@gnu.org; Wed, 07 Apr 2010 15:52:11 -0400 Received: from mail05.solnet.ch ([212.101.4.139]:65244) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1NzbID-0004nz-B5 for emacs-orgmode@gnu.org; Wed, 07 Apr 2010 15:52:05 -0400 References: 87tyzajwav.fsf@gmail.com List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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: zwz Cc: Eric S Fraga , Org Mode Hi zwz, > I do not know if I can do org-plot on rows instead of columns. > But today after I finished a table, I found I have to transpose the > table by hand so that I can plot it as I want. > Here is original table: > | x | y | x | y | ... | > |-----+----+----+----+-----| > | 1 | 2 | 3 | 4 | | > | 5 | 6 | 7 | 8 | | > | 9 | 0 | 1 | 2 | | > | ... | | | | | > And I have to convert it into: > | x | y | x | y | x | y | ... | > |-----+---+---+---+---+---+-----| > | 1 | 2 | 5 | 6 | 9 | 0 | | > | 3 | 4 | 7 | 8 | 1 | 2 | | > | ... | | | | | | | > > so that every two columns stand for a line. If someone had trouble to understand like me first, maybe looking also at the last table below with the column groups `<>' could help. This use case seems quite funny and well suited to be solved with the `field coordinates in formulas' for which I proposed a patch some time ago that is included in org-mode now. Since org-version 6.35 you could try this hack: step 1) Remove the header and use column editing from Emacs http://www.gnu.org/software/emacs/manual/html_node/emacs/Rectangles.html to change your original version of the table | x | y | x | y | |---+---+---+---| | 1 | 2 | 3 | 4 | | 5 | 6 | 7 | 8 | | 9 | 0 | 1 | 2 | to this 3x2 table with Calc vectors in short notation: #+TBLNAME: FOO | [1 2] | [3 4] | | [5 6] | [7 8] | | [9 0] | [1 2] | step 2) Transpose the table like described here http://orgmode.org/worg/org-hacks.php in the section `Transpose a table', currently with this numbering http://orgmode.org/worg/org-hacks.php#sec-17.2.3 to this 2x3 table with the same Calc vectors in the default notation: | [1, 2] | [5, 6] | [9, 0] | | [3, 4] | [7, 8] | [1, 2] | #+TBLFM: $1 = remote(FOO, @$#$@#) :: $2 = remote(FOO, @$#$@#) :: $3 = remote(FOO, @$#$@#) step 3) query-replace `['->`', `]'->`', `,'->`|' and add the header manually to get finally this: | | x | f.a(x) | x | f.b(x) | x | f.c(x) | | / | < | > | < | > | < | > | |---+---+--------+---+--------+---+--------| | | 1 | 2 | 5 | 6 | 9 | 0 | | | 3 | 4 | 7 | 8 | 1 | 2 | > I also wonder how do you guys draw multiple lines in one image, since > here there are multiple inds. I guess you want a xy graph something like this with three lines a, b and c for f.a, f.b and f.c: f.n(x) ^ 08 | b 07 | b 06 | b 05 | 04 | a 03 | a 02 |*c 01 | ccccc 00 +-------cc--> x 000000000011 012345678901 see http://thread.gmane.org/gmane.emacs.orgmode/21979 I assume that this could be done also with org-babel together with R http://en.wikipedia.org/wiki/R_%28programming_language%29 possibly even with your original version of the table... - Michael