[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] import R data frame into org-mode table
From: |
Andreas Leha |
Subject: |
Re: [O] import R data frame into org-mode table |
Date: |
Thu, 18 Jul 2013 00:09:24 +0200 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/24.3 (gnu/linux) |
Rob Stewart <address@hidden> writes:
> 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
Definitely there is:
--8<---------------cut here---------------start------------->8---
#+begin_src R :results table :colnames yes
read.csv('test.csv')
#+end_src
#+results:
| X | 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.1 |
| 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.1 |
--8<---------------cut here---------------end--------------->8---
Regards,
Andreas
- [O] import R data frame into org-mode table, Rob Stewart, 2013/07/16
- Re: [O] import R data frame into org-mode table,
Andreas Leha <=
- Re: [O] import R data frame into org-mode table, Rob Stewart, 2013/07/29
- Re: [O] import R data frame into org-mode table, Cook, Malcolm, 2013/07/29
- Re: [O] import R data frame into org-mode table, John Hendy, 2013/07/29
- Re: [O] import R data frame into org-mode table, Nick Dokos, 2013/07/29
- Re: [O] import R data frame into org-mode table, Cook, Malcolm, 2013/07/29
- Re: [O] import R data frame into org-mode table, Nick Dokos, 2013/07/29
- Re: [O] import R data frame into org-mode table, Cook, Malcolm, 2013/07/30
Re: [O] import R data frame into org-mode table, Thomas S. Dye, 2013/07/17