From mboxrd@z Thu Jan  1 00:00:00 1970
From: Rob Stewart <robstewart57@gmail.com>
Subject: import R data frame into org-mode table
Date: Tue, 16 Jul 2013 16:19:07 +0100
Message-ID: <CA+ZOasK8vN1dT_tVePVzOpTM3VdojoWCsvmhPZCzvV-k1CSjug@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:53948)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <robstewart57@gmail.com>) id 1Uz72K-0004Tj-AS
	for emacs-orgmode@gnu.org; Tue, 16 Jul 2013 11:19:35 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <robstewart57@gmail.com>) id 1Uz72H-0004RT-7V
	for emacs-orgmode@gnu.org; Tue, 16 Jul 2013 11:19:32 -0400
Received: from mail-pb0-x22b.google.com ([2607:f8b0:400e:c01::22b]:47293)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <robstewart57@gmail.com>) id 1Uz72H-0004Ql-1U
	for emacs-orgmode@gnu.org; Tue, 16 Jul 2013 11:19:29 -0400
Received: by mail-pb0-f43.google.com with SMTP id md12so805342pbc.30
	for <emacs-orgmode@gnu.org>; Tue, 16 Jul 2013 08:19:27 -0700 (PDT)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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: emacs-orgmode@gnu.org

I have an R script that generates a data frame, that I export to a CSV
file. The data looks something like this:

    "","Variant","Xaxis","N","mean","sd","se"
    "1","line1",10,5,111.11,9.33,3.11
    "1","line1",20,5,112.11,9.13,3.14
    "1","line1",30,5,113.11,9.43,3.10
    "1","line2",10,5,101.11,8.33,2.11
    "1","line2",20,5,100.11,8.13,2.12
    "1","line2",30,5,108.11,8.03,2.10

I have an ongoing org-mode document in which I'd like to report this
data. I'd like to add a table that looks something like this:

    | Variant | X Axis | Y Axis | N | Mean | Standard Deviation |
Standard Error |
    |----------------------------------------------------------------------------|

The data will change frequently over the coming months. I'd like
org-mode to auto-magically read a CSV file, to construct my org-table
on-the-fly. I'd hoping to avoid copying and pasting results each time.

Is there some org-mode or emacs+ESS magic I can use to populate my
empty table, with source data from my CSV file?

--
Rob