Re: [O] searching for csv utilities

2015-06-18 Thread Jude DaShiell
I spent time looking for vmode in info org using a regular expression search and couldn't find it either. That capability is probably in R though it may be under another name. I have emacs-ess package and R installed on this system though haven't used them yet. I also found sbcl so if it

Re: [O] searching for csv utilities

2015-06-05 Thread Eric S Fraga
On Thursday, 4 Jun 2015 at 23:24, Thierry Banel wrote: You may want to consider a slightly different approach. It may (or maynot) be relevant depending on your context. [...] Then using a package named org-aggregate (on Melpa) you can derivean aggregated table: Thanks for reminding me

Re: [O] searching for csv utilities

2015-06-04 Thread Thierry Banel
You may want to consider a slightly different approach. It may (or maynot) be relevant depending on your context. First, denormalize your table into a fact table (which is handy when dealingwith cubes): #+name: data | date | type | q | |--+---+-| |

Re: [O] searching for csv utilities

2015-06-04 Thread Michael Brand
Hi Nick On Thu, Jun 4, 2015 at 5:22 PM, Nick Dokos ndo...@gmail.com wrote: Also, if one uses a format on an undefined function (e.g. using vmode(@I..@II); %.2f), I get 0.0 as a result and the error is hidden - if the format is omitted, the literal vmode([...]) appears in the table, so in that

Re: [O] searching for csv utilities

2015-06-04 Thread Nick Dokos
Nick Dokos ndo...@gmail.com writes: I mispelled it the same way: I can never remember the right name. ... and I misspelled misspelled :-)

Re: [O] searching for csv utilities

2015-06-04 Thread Nick Dokos
Michael Brand michael.ch.br...@gmail.com writes: Hi Eric On Thu, Jun 4, 2015 at 9:21 AM, e.fr...@ucl.ac.uk wrote: however, vstdev does not appear to work? My mistake, it should be vsdev or vpsdev. I mispelled it the same way: I can never remember the right name. Also, if one uses a

Re: [O] searching for csv utilities

2015-06-04 Thread e.fraga
On Wednesday, 3 Jun 2015 at 22:05, Michael Brand wrote: [...] I just found the Calc function apply() which leads to this simplification: | Date |Sys |Dia |Pul | Sugar | |--++++| | [2014-04-27 Sun] |125 | 88 |

Re: [O] searching for csv utilities

2015-06-04 Thread Michael Brand
Hi Eric On Thu, Jun 4, 2015 at 9:21 AM, e.fr...@ucl.ac.uk wrote: however, vstdev does not appear to work? My mistake, it should be vsdev or vpsdev. Michael

Re: [O] searching for csv utilities

2015-06-03 Thread Nick Dokos
Michael Brand michael.ch.br...@gmail.com writes: On Wed, Jun 3, 2015 at 7:21 PM, Nick Dokos ndo...@gmail.com wrote: | Date |Sys | Dia | Pul | Sugar | |--++---+---+---| | [2014-04-27 Sun] |125 |88 |78 |92 | |

Re: [O] searching for csv utilities

2015-06-03 Thread Michael Brand
On Wed, Jun 3, 2015 at 7:21 PM, Nick Dokos ndo...@gmail.com wrote: | Date |Sys | Dia | Pul | Sugar | |--++---+---+---| | [2014-04-27 Sun] |125 |88 |78 |92 | | [2014-04-28 Mon] |102 |88 |86 |

Re: [O] searching for csv utilities

2015-06-03 Thread Jude DaShiell
From: Jonathan Leech-Pepin jonathan.leechpe...@gmail.com To: Jude DaShiell jdash...@panix.com Cc: Org Mode Mailing List emacs-orgmode@gnu.org Subject: Re: [O] searching for csv utilities Hello, On 2 June 2015 at 07:44, Jude DaShiell jdash...@panix.com wrote: | Date | Sys

Re: [O] searching for csv utilities

2015-06-03 Thread Nick Dokos
Jude DaShiell jdash...@panix.com writes: Hi Jonathan, calc has vmode if that helps any. I think Jonathan is right that calc does not have a vmode. I thought it did at first, but looking further I could not find any reference to it in the calc manual or in emacs help. Why do you think it

Re: [O] searching for csv utilities

2015-06-03 Thread Jude DaShiell
-Pepin jonathan.leechpe...@gmail.com To: Jude DaShiell jdash...@panix.com Cc: Org Mode Mailing List emacs-orgmode@gnu.org Subject: Re: [O] searching for csv utilities Hello, On 2 June 2015 at 07:44, Jude DaShiell jdash...@panix.com wrote: | Date | Sys | Dia | Pul | Sugar

Re: [O] searching for csv utilities

2015-06-03 Thread Jude DaShiell
: Date: Tue, 2 Jun 2015 08:04:20 From: Jonathan Leech-Pepin jonathan.leechpe...@gmail.com To: Jude DaShiell jdash...@panix.com Cc: Org Mode Mailing List emacs-orgmode@gnu.org Subject: Re: [O] searching for csv utilities Hello, On 2 June 2015 at 07:44, Jude DaShiell jdash...@panix.com wrote

Re: [O] searching for csv utilities

2015-06-03 Thread Jonathan Leech-Pepin
Leech-Pepin jonathan.leechpe...@gmail.com To: Jude DaShiell jdash...@panix.com Cc: Org Mode Mailing List emacs-orgmode@gnu.org Subject: Re: [O] searching for csv utilities Hello, On 2 June 2015 at 07:44, Jude DaShiell jdash...@panix.com wrote: | Date | Sys | Dia

Re: [O] searching for csv utilities

2015-06-03 Thread Jude DaShiell
First, I tried usinb multiple #+TBLFM: lines to do all of the math and that only did the first line of calculations which was the sums which appear last. After replacing the double colons between calculation lines in the single line form of the #+TBLFM: line seven of the 8 lines worked

Re: [O] searching for csv utilities

2015-06-03 Thread Nick Dokos
Nick Dokos ndo...@gmail.com writes: With that caveat, the above TBLFM line will calculate the first three of the eight statistics you want - the rest can be done similarly with the calc functions vmedian, vmin, vmode, vstdev and vsum As Jonathan Leech-Pepin points out, there is no vmode - my

Re: [O] searching for csv utilities

2015-06-03 Thread Nick Dokos
Leech-Pepin jonathan.leechpe...@gmail.com To: Jude DaShiell jdash...@panix.com Cc: Org Mode Mailing List emacs-orgmode@gnu.org Subject: Re: [O] searching for csv utilities Hello, On 2 June 2015 at 07:44, Jude DaShiell jdash...@panix.com wrote: | Date | Sys | Dia

Re: [O] searching for csv utilities

2015-06-02 Thread Jude DaShiell
| Date | Sys | Dia | Pul | Sugar | |--+---+-+-+---| | [2014-04-27 Sun] | 125 | 88 | 78 |92 | | [2014-04-28 Mon] | 102 | 88 | 86 |92 | | Averages:| =$2=vmean(@..@) | | |

Re: [O] searching for csv utilities

2015-06-02 Thread Jonathan Leech-Pepin
Hello, On 2 June 2015 at 07:44, Jude DaShiell jdash...@panix.com wrote: | Date | Sys | Dia | Pul | Sugar | |--+---+-+-+---| | [2014-04-27 Sun] | 125 | 88 | 78 |92 | | [2014-04-28 Mon] |