* statistics with R, convert the result into an org table
@ 2018-04-11 12:30 Uwe Brauer
2018-04-11 14:53 ` Adonay Felipe Nogueira
2018-04-11 14:55 ` William Denton
0 siblings, 2 replies; 5+ messages in thread
From: Uwe Brauer @ 2018-04-11 12:30 UTC (permalink / raw)
To: emacs-orgmode
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
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: statistics with R, convert the result into an org table
2018-04-11 12:30 statistics with R, convert the result into an org table Uwe Brauer
@ 2018-04-11 14:53 ` Adonay Felipe Nogueira
2018-04-11 15:46 ` Uwe Brauer
2018-04-11 14:55 ` William Denton
1 sibling, 1 reply; 5+ messages in thread
From: Adonay Felipe Nogueira @ 2018-04-11 14:53 UTC (permalink / raw)
To: emacs-orgmode
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
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: statistics with R, convert the result into an org table
2018-04-11 12:30 statistics with R, convert the result into an org table Uwe Brauer
2018-04-11 14:53 ` Adonay Felipe Nogueira
@ 2018-04-11 14:55 ` William Denton
2018-04-11 15:46 ` Uwe Brauer
1 sibling, 1 reply; 5+ messages in thread
From: William Denton @ 2018-04-11 14:55 UTC (permalink / raw)
To: Uwe Brauer; +Cc: emacs-orgmode
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/
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: statistics with R, convert the result into an org table
2018-04-11 14:53 ` Adonay Felipe Nogueira
@ 2018-04-11 15:46 ` Uwe Brauer
0 siblings, 0 replies; 5+ messages in thread
From: Uwe Brauer @ 2018-04-11 15:46 UTC (permalink / raw)
To: emacs-orgmode
> 2018-04-11T14:30:58+0200 Uwe Brauer wrote:
> Remove ":results output"
Thanks! That works nicely.
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: statistics with R, convert the result into an org table
2018-04-11 14:55 ` William Denton
@ 2018-04-11 15:46 ` Uwe Brauer
0 siblings, 0 replies; 5+ messages in thread
From: Uwe Brauer @ 2018-04-11 15:46 UTC (permalink / raw)
To: emacs-orgmode
>>> "William" == William Denton <wtd@pobox.com> writes:
> 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).
Correct is leaves the :
But I can live with that.
^ permalink raw reply [flat|nested] 5+ messages in thread
end of thread, other threads:[~2018-04-11 15:47 UTC | newest]
Thread overview: 5+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2018-04-11 12:30 statistics with R, convert the result into an org table Uwe Brauer
2018-04-11 14:53 ` Adonay Felipe Nogueira
2018-04-11 15:46 ` Uwe Brauer
2018-04-11 14:55 ` William Denton
2018-04-11 15:46 ` Uwe Brauer
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).