From mboxrd@z Thu Jan  1 00:00:00 1970
From: Nick Dokos <ndokos@gmail.com>
Subject: Re: searching for csv utilities
Date: Wed, 03 Jun 2015 16:52:24 -0400
Message-ID: <87pp5ch5vb.fsf@alphaville.usersys.redhat.com>
References: <alpine.NEB.2.11.1506020733250.26150@panix2.panix.com>
	<CAEWDx5ctps-PRNK9dSqYKGgTeAda1Z4W9MkKf1ei2PXQ_4A3Jg@mail.gmail.com>
	<alpine.NEB.2.11.1506031204560.19373@panix2.panix.com>
	<87d21ciu82.fsf@alphaville.usersys.redhat.com>
	<CALn3zojAafcgcq49O6gWh=MpFi4SyKAcjuAJHhbG90xJZhdo1g@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:54804)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1Z0FeX-0004mV-3R
	for emacs-orgmode@gnu.org; Wed, 03 Jun 2015 16:52:45 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1Z0FeU-0001MH-B7
	for emacs-orgmode@gnu.org; Wed, 03 Jun 2015 16:52:45 -0400
Received: from plane.gmane.org ([80.91.229.3]:40127)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1Z0FeU-0001M2-4d
	for emacs-orgmode@gnu.org; Wed, 03 Jun 2015 16:52:42 -0400
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1Z0FeJ-000284-Fr
	for emacs-orgmode@gnu.org; Wed, 03 Jun 2015 22:52:31 +0200
Received: from nat-pool-bos-t.redhat.com ([66.187.233.206])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Wed, 03 Jun 2015 22:52:31 +0200
Received: from ndokos by nat-pool-bos-t.redhat.com with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Wed, 03 Jun 2015 22:52:31 +0200
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

Michael Brand <michael.ch.brand@gmail.com> writes:

> On Wed, Jun 3, 2015 at 7:21 PM, Nick Dokos <ndokos@gmail.com> wrote:
>> | Date                 |    Sys |   Dia |   Pul | Sugar |
>> |----------------------+--------+-------+-------+-------|
>> | [2014-04-27 Sun]     |    125 |    88 |    78 |    92 |
>> | [2014-04-28 Mon]     |    102 |    88 |    86 |    92 |
>> |----------------------+--------+-------+-------+-------|
>> | Averages:            | 113.50 | 88.00 | 82.00 | 92.00 |
>> | Counts:              |      2 |     2 |     2 |     2 |
>> | Maximums:            | 125.00 | 88.00 | 86.00 | 92.00 |
>> | Medians:             |        |       |       |       |
>> | Minimums:            |        |       |       |       |
>> | Modes:               |        |       |       |       |
>> | Standard Deviations: |        |       |       |       |
>> | Sums:                |        |       |       |       |
>> |----------------------+--------+-------+-------+-------|
>> #+TBLFM: @>>>>>>>>$2..@>>>>>>>>$> = vmean(@I..@II);%.2f ::
>> @>>>>>>>$2..@>>>>>>>$> = vcount(@I..@II) :: @>>>>>>$2..@>>>>>>$> =
>> vmax(@I..@II);%.2f
>
> 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, @I..@II); %.2f
>

Delicious!

Thanks,
Nick