Re: [O] statistics with R, convert the result into an org table

2018-04-11 Thread Uwe Brauer
>>> "William" == William Denton  writes:

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

Correct is leaves the :

But I can live with that.




Re: [O] statistics with R, convert the result into an org table

2018-04-11 Thread Uwe Brauer

   > 2018-04-11T14:30:58+0200 Uwe Brauer wrote:

   > Remove ":results output"

Thanks! That works nicely.




Re: [O] statistics with R, convert the result into an org table

2018-04-11 Thread William Denton

I don't think it is possible without a step in the middle, because
"Min.   :2." 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/



Re: [O] statistics with R, convert the result into an org table

2018-04-11 Thread Adonay Felipe Nogueira
2018-04-11T14:30:58+0200 Uwe Brauer wrote:
> #+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

Remove ":results output"

-- 
- Formas de contato: https://libreplanet.org/wiki/User:Adfeno#vCard

- Ativista do /software/ livre (não confundir com gratuito). Avaliador
  da liberdade de /software/ e de /sites/.

- Membro do LibrePlanet Brasil:
  https://libreplanet.org/wiki/Group:LibrePlanet_Brasil

- Comunicações sociais federadas padronizadas, onde o "social"
  permanece independente do fornecedor.

- #DeleteWhatsApp. Use o pai dele, #XMPP, federado e com padrão
  internacional: https://libreplanet.org/wiki/XMPP.pt

- #DeleteFacebook #DeleteInstagram #DeleteTwitter #DeleteYouTube. Use
  redes sociais federadas que suportam #ActivityPub, padrão
  internacional, como a rede Mastodon: https://joinmastodon.org/

- #DeleteNetflix #CancelNetflix. Evite #DRM:
  https://www.defectivebydesign.org/

- Quer enviar arquivos para mim? Veja:
  https://libreplanet.org/wiki/User:Adfeno#Arquivos

- Quer doar para mim, ou me contratar? Veja:
  https://libreplanet.org/wiki/User:Adfeno#Suporte

- Minhas contribuições:
  https://libreplanet.org/wiki/User:Adfeno#Contributions



[O] statistics with R, convert the result into an org table

2018-04-11 Thread Uwe Brauer
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