From mboxrd@z Thu Jan  1 00:00:00 1970
From: William Denton <wtd@pobox.com>
Subject: Re: statistics with R, convert the result into an org table
Date: Wed, 11 Apr 2018 10:55:20 -0400 (EDT)
Message-ID: <alpine.DEB.2.02.1804111050120.5760@shell.miskatonic.org>
References: <87604xx6v1.fsf@mat.ucm.es>
Mime-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:38741)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <wtd@pobox.com>) id 1f6H9g-00032P-1v
	for emacs-orgmode@gnu.org; Wed, 11 Apr 2018 10:55:25 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <wtd@pobox.com>) id 1f6H9d-0007Ni-DH
	for emacs-orgmode@gnu.org; Wed, 11 Apr 2018 10:55:24 -0400
Received: from shell.miskatonic.org ([65.39.236.119]:49588)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <wtd@pobox.com>) id 1f6H9d-0007NL-7f
	for emacs-orgmode@gnu.org; Wed, 11 Apr 2018 10:55:21 -0400
In-Reply-To: <87604xx6v1.fsf@mat.ucm.es>
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"
	<emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: Uwe Brauer <oub@mat.ucm.es>
Cc: emacs-orgmode@gnu.org

I don't think it is possible without a step in the middle, because
"Min.   :2.0000" is all one string (in a cell in a matrix).

#+begin_src R :results output :var qual=qual :colnames yes
s <- summary(qual)
s[1]
#+end_src

#+RESULTS:
: [1] "Min.   :2.000  "

You would have to split each cell into two parts by splitting on the colon.  I 
think extract from tidyr [1] might do the job.

Bill

[1] http://tidyr.tidyverse.org/reference/extract.html

On 11 April 2018, Uwe Brauer wrote:

> Hi
>
> I use structure like this
>
> Statistics with R
>
> #+tblname: qual
> | 8.3 | 1.4 |
> | 7.3 | 5.6 |
> |   2 | 1.3 |
> | 5.7 | 9.3 |
> | 5.3 | 5.9 |
> |   4 |     |
> | 6.9 |     |
> #+begin_src R :results output :var qual=qual
> summary(qual)
> #+end_src
>
> And obtain
>
> #+RESULTS:
> :        V1              V2
> :  Min.   :2.000   Min.   :1.3
> :  1st Qu.:4.650   1st Qu.:1.4
> :  Median :5.700   Median :5.6
> :  Mean   :5.643   Mean   :4.7
> :  3rd Qu.:7.100   3rd Qu.:5.9
> :  Max.   :8.300   Max.   :9.3
> :                  NA's   :2.0
>
> Is there a way to have the result already translated into an org table
> resulting in
>
> | V1      |       |         |  V2 |   |
> | Min.    | 2.000 | Min.    | 1.3 |   |
> | 1st Qu. | 4.650 | 1st Qu. | 1.4 |   |
> | Median  | 5.700 | Median  | 5.6 |   |
> | Mean    | 5.643 | Mean    | 4.7 |   |
> | 3rd Qu. | 7.100 | 3rd Qu. | 5.9 |   |
> | Max.    | 8.300 | Max.    | 9.3 |   |
>
>
> Uwe Brauer
>
>
>

--
William Denton :: Toronto, Canada   ---   Listening to Art: https://listeningtoart.org/
https://www.miskatonic.org/         ---   GHG.EARTH: http://ghg.earth/
Caveat lector.                      ---   STAPLR: http://staplr.org/