emacs-orgmode
[Top][All Lists]
Advanced

[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



reply via email to

[Prev in Thread] Current Thread [Next in Thread]