emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Rainer M Krug <Rainer@krugs.de>
To: Eric Schulte <schulte.eric@gmail.com>
Cc: emacs-orgmode <emacs-orgmode@gnu.org>,
	Christian Moe <mail@christianmoe.com>
Subject: Re: [BABEL] Define tables with names in org?
Date: Fri, 10 Jan 2014 10:20:43 +0100	[thread overview]
Message-ID: <52CFBB6B.5040406@krugs.de> (raw)
In-Reply-To: <87k3e9j6i3.fsf@gmail.com>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



On 01/09/14, 20:25 , Eric Schulte wrote:
> Rainer M Krug <Rainer@krugs.de> 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.

Thanks - but I don't see how this could help me in this case?

To correct my example (to fast copy - paste):

* INTERNAL VARIABLES                                 :noexport:

** With column names
#+NAME: WITH_COLNAMES
|   | name          |
|---|---------------|
| a | NPPyC         |
| b | DBBVy         |
| c | DBRFy         |
| d | DBSSy         |
| e | levelstress_2 |
#+PROPERTY: var+ WITH_COLNAMES=WITH_COLNAMES

** Without column names
#+NAME: WITHOUT_COLNAMES
| name          |
|---------------|
| NPPyC         |
| DBBVy         |
| DBRFy         |
| DBSSy         |
| levelstress_2 |
#+PROPERTY: var+ WITHOUT_COLNAMES=WITHOUT_COLNAMES

* The code
#+begin_src R
  # here WITH_COLNAMES will have colnames and WITHOUT_COLNAMES not
#+end_src

* And some more code
#+begin_src R
  # here WITH_COLNAMES will have colnames and WITHOUT_COLNAMES not
#+end_src

So my concern is not about having rownames where I don't need them,
but in having always to enter rownames in the definition (INTERNAL
VARIABLES section), as I need them in the WITH_COLNAMES table.

Rainer

> 
>> 
>> * 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
> 

- -- 
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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.22 (Darwin)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBAgAGBQJSz7tqAAoJENvXNx4PUvmCfYUH/i9HoQyLcOxgrdQbfCjjHbft
WHbclImYXB7IPtCFb9j3M07IpwompjJU9fQpiRLudYgFlLqIre9qhM+uSxnVdbYo
82dKVORwfN+oZYG4+EwEV5v/aO7L6DhS90EZCik1e5jRUzLpyMrCHEyJEFZsLmIJ
UT4emf4IA6qxhRdt0ulNeuu4TSUyYxD9+otx85hvPXkwCUzYoOJ26KRfAbX2sY/P
E3OJ4g+tm7zU8GzH+7KMDCkOROTKlYfIMos+XisrQOrL1MdohVMISdrs63zXQRal
WEGcTjMuXCXEoX6KGYmUCc4pS5WdALNObcd/9P3NFUm1Zd8DH95FDkWJT53inpE=
=B5r8
-----END PGP SIGNATURE-----

  reply	other threads:[~2014-01-10  9:20 UTC|newest]

Thread overview: 6+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2014-01-09 11:36 [BABEL] Define tables with names in org? Rainer M Krug
2014-01-09 12:30 ` Christian Moe
2014-01-09 13:56   ` Rainer M Krug
2014-01-09 19:25     ` Eric Schulte
2014-01-10  9:20       ` Rainer M Krug [this message]
2014-01-10 12:31         ` Christian Moe

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

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=52CFBB6B.5040406@krugs.de \
    --to=rainer@krugs.de \
    --cc=emacs-orgmode@gnu.org \
    --cc=mail@christianmoe.com \
    --cc=schulte.eric@gmail.com \
    /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 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).