[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] searching for csv utilities
From: |
e.fraga |
Subject: |
Re: [O] searching for csv utilities |
Date: |
Thu, 4 Jun 2015 08:21:15 +0100 |
User-agent: |
Gnus/5.130012 (Ma Gnus v0.12) Emacs/24.4 (gnu/linux) |
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 | 78 | 92 |
> | [2014-04-28 Mon] | 102 | 88 | 86 | 92 |
> |------------------+--------+--------+--------+--------|
> | vmean | 113.50 | 88.00 | 82.00 | 92.00 |
> | vcount | 2.00 | 2.00 | 2.00 | 2.00 |
> | vmax | 125.00 | 88.00 | 86.00 | 92.00 |
> | vmedian | 113.50 | 88.00 | 82.00 | 92.00 |
> | vmin | 102.00 | 88.00 | 78.00 | 92.00 |
> | vstdev | 0.00 | 0.00 | 0.00 | 0.00 |
> | vsum | 227.00 | 176.00 | 164.00 | 184.00 |
> |------------------+--------+--------+--------+--------|
>
> #+TBLFM: @>>>>>>>$2..@>$> = apply($1, @address@hidden); %.2f
>
> Michael
very nice! one to remember.
however, vstdev does not appear to work?
--
: Eric S Fraga (0xFFFCF67D), Emacs 24.4.1, Org release_8.3beta-790-gb719c1.dirty
- Re: [O] searching for csv utilities, (continued)
- Re: [O] searching for csv utilities, Jonathan Leech-Pepin, 2015/06/02
- Re: [O] searching for csv utilities, Nick Dokos, 2015/06/03
- Re: [O] searching for csv utilities, Nick Dokos, 2015/06/03
- Re: [O] searching for csv utilities, Michael Brand, 2015/06/03
- Re: [O] searching for csv utilities, Nick Dokos, 2015/06/03
- Re: [O] searching for csv utilities,
e.fraga <=
- Re: [O] searching for csv utilities, Michael Brand, 2015/06/04
- Re: [O] searching for csv utilities, Nick Dokos, 2015/06/04
- Re: [O] searching for csv utilities, Nick Dokos, 2015/06/04
- Re: [O] searching for csv utilities, Michael Brand, 2015/06/04
Re: [O] searching for csv utilities, Jude DaShiell, 2015/06/03
Re: [O] searching for csv utilities, Thierry Banel, 2015/06/04
Re: [O] searching for csv utilities, Jude DaShiell, 2015/06/18