From mboxrd@z Thu Jan 1 00:00:00 1970 From: Eric Schulte Subject: Re: [BABEL] Define tables with names in org? Date: Thu, 09 Jan 2014 12:25:01 -0700 Message-ID: <87k3e9j6i3.fsf@gmail.com> References: <52CE89A9.8060305@krugs.de> <52CEAA76.2090901@krugs.de> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:41639) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1W1LN6-0007mg-To for emacs-orgmode@gnu.org; Thu, 09 Jan 2014 14:34:33 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1W1LN1-0003eL-Tm for emacs-orgmode@gnu.org; Thu, 09 Jan 2014 14:34:28 -0500 Received: from mail-pd0-x234.google.com ([2607:f8b0:400e:c02::234]:64390) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1W1LN1-0003dk-MS for emacs-orgmode@gnu.org; Thu, 09 Jan 2014 14:34:23 -0500 Received: by mail-pd0-f180.google.com with SMTP id q10so3585040pdj.39 for ; Thu, 09 Jan 2014 11:34:20 -0800 (PST) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Rainer@krugs.de Cc: emacs-orgmode , Christian Moe Rainer M Krug writes: > On 01/09/14, 13:30 , Christian Moe wrote: >> >> Rainer M Krug writes: >> >>> I would like to define a table with named columns and rows, so >>> that the table is passed to R including the column and row names >>> - is this possible? >> >> Yes, just use the leftmost column for row names and include the >> header argument :rownames yes. >> >> By default, the first row will be used for column names if followed >> by a hline. Without a hline, use :colnames yes. >> >> E.g.: >> >> #+name: colrownamestbl | | Alpha | Beta | Gamma | >> |--------+-------+------+-------| | First | A1 | B1 | C1 >> | | Second | A2 | B2 | C2 | | Third | A3 | B3 | C3 >> | >> >> #+begin_src R :var data=colrownamestbl :rownames yes :results >> output colnames(data) rownames(data) #+end_src >> >> #+RESULTS: : [1] "Alpha" "Beta" "Gamma" : [1] "First" "Second" >> "Third" > > Ah - I see. Nice. Thanks. > > One problem though: > > I define my variables in the beginning of the document, in a not > exported heading so that they don't show in the report, and I want to > have some variables with rownames and some without. Is this possible? > See "Indexable variable values" under (info "(org)var"), it may help. > > * INTERNAL VARIABLES :noexport: > > ** Without column names > #+NAME: WITHCOLNAMES > | name | > |---------------| > | NPPyC | > | DBBVy | > | DBRFy | > | DBSSy | > | levelstress_2 | > #+PROPERTY: var+ WITHCOLNAMES=WITHCOLNAMES > > ** Without column names > #+NAME: COLS_TO_EVAL > | name | > |---------------| > | NPPyC | > | DBBVy | > | DBRFy | > | DBSSy | > | levelstress_2 | > #+PROPERTY: var+ COLS_TO_EVAL=COLS_TO_EVAL > > And this should be valid everywhere where I use WITHCOLNAMES and > WITHOUTCOLNAMES in R without having to specify :rownames true each time? > > Rainer > > >> >> Yours, Christian >> > > -- > 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 -- Eric Schulte https://cs.unm.edu/~eschulte PGP: 0x614CA05D