From: Nick Dokos <ndokos@gmail.com>
To: emacs-orgmode@gnu.org
Subject: Re: searching for csv utilities
Date: Wed, 03 Jun 2015 13:21:01 -0400 [thread overview]
Message-ID: <87d21ciu82.fsf@alphaville.usersys.redhat.com> (raw)
In-Reply-To: alpine.NEB.2.11.1506031204560.19373@panix2.panix.com
Jude DaShiell <jdashiel@panix.com> writes:
> This is a piece of a modified ecm that may show what's going on.
>
> cut here.
> |----------------------+---------+--------+--------+--------|
> | Averages: | | | | |
> | Counts: | | | | |
> | Maximums: | | | | |
> | Medians: | | | | |
> | Minimums: | | | | |
> | Modes: | | | | |
> | Standard Deviations: | | | | |
> | Sums: | 108.69) | 70.45) | 66.62) | 92.93) |
> |----------------------+---------+--------+--------+--------|
> #+TBLFM: @>$2..@>$>=vmean(@I..@>>;%.2f)
>
The syntax is wrong - the format has to go *outside* the parens
of the function. Also the row spec is almost certainly wrong -
something like the following is needed (but see below for a more
exact specification of what the table looks like and what the
actual TBLFM line should be):
#+TBLFM: @>$2..@>$>=vmean(@I..@II);%.2f
The @I..@II restricts the range of rows to be considered to be between
the first and the second hline. IOW, the assumption is that you have
three areas in your table: a header line, followed by an hline, a number
of rows with data, followed by an hline and a number of rows containing
calculated statistics, followed by an (optional) hline - something like
this:
| 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
The only challenges left are to refer to the correct row and to find the
appropriate calc function for the statistic at hand.
Unfortunately, org mode is not particularly flexible in referring to
cells (although it is a *lot* more flexible than it used to be). In
particular, referring to the "Averages:" row can not be done simply
(afaik): it's the first row after the second hline, so you'd think that
you can refer to it as @II+1 but hline-relative references are not
allowed on the LHS, so the best that I could do is refer to it as the
eightth column from the bottom: @>>>>>>>> and similarly for the others -
looks like chicken scratchings (or what amounts to the same thing, Perl
:-) ).
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; but you can see
it's getting unwieldy, particularly since the whole thing has to be on
one line (or has that changed? I'm not keeping track any longer...)
I believe that you are (partially or completely?) blind, which makes
this all the more difficult: counting how many "greater than" signs are
in each of those row specs is a pain for anybody, but I can't even
imagine how a blind person would deal with it.
> I haven't even attempted the rest of the math since I have no way to
> predict where any of the results will land.
> On Tue, 2
> Jun 2015, Jonathan Leech-Pepin wrote:
>
>> Date: Tue, 2 Jun 2015 08:04:20
>> From: Jonathan Leech-Pepin <jonathan.leechpepin@gmail.com>
>> To: Jude DaShiell <jdashiel@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 <jdashiel@panix.com> wrote:
>>
>>> | Date | Sys | Dia | Pul | Sugar |
>>> |------------------+-------------------+-----+-----+-------|
>>> | [2014-04-27 Sun] | 125 | 88 | 78 | 92 |
>>> | [2014-04-28 Mon] | 102 | 88 | 86 | 92 |
>>> | Averages: | =$2=vmean(@<..@>) | | | |
>>> #+TBLFM: $2=$2=vmean(@<..@>)
>>>
>>
>> The formula in question is the culprit in this case (at least as stated
>> there).
>>
>> : $2=$2=vmean(@<..@>)
>>
>> Second column is equal to the second column which is equal to the mean of
>> all the values in the second column (including the header "Sys").
>>
>> If you change the table as follows:
>>
>> | Date | Sys | Dia | Pul | Sugar |
>> |------------------+-------+-----+-----+-------|
>> | [2014-04-27 Sun] | 125 | 88 | 78 | 92 |
>> | [2014-04-28 Mon] | 102 | 88 | 86 | 92 |
>> |------------------+-------+-----+-----+-------|
>> | Averages: | 113.5 | 88 | 82 | 92 |
>> #+TBLFM: @>$2..@>$>=vmean(@I..@II)
>>
>> All the values will properly compute. If you want to avoid the second
>> HLINE above Averages: then change =@II= to =@>>= (penultimate row)
>>
>> Regards,
>> Jon
>>
>>
>>> This is a cut down version of my full record set. Sometimes when I key
>>> formulas in I get ?ERROR back for a result after keying in c-c+c-c once
>>> I've completed the formula and hit tab. If I do c-u+c-c+c-c that sometimes
>>> generated ?ERROR. Other times I key in a formula and the cursor gets
>>> locked and I have to hit c-g to exit #+TBLFM: mode; I don't know what's
>>> actually happening when that situation arises since other than suddenly
>>> finding the cursor locked I can neither tell what state I'm in or if a few
>>> more keystrokes are needed or if I've generated an error situation.
>>>
>>> --
>>>
>>>
>>>
>>
HTH,
Nick
next prev parent reply other threads:[~2015-06-03 17:21 UTC|newest]
Thread overview: 20+ messages / expand[flat|nested] mbox.gz Atom feed top
2015-06-02 11:44 searching for csv utilities Jude DaShiell
2015-06-02 12:04 ` Jonathan Leech-Pepin
2015-06-03 15:46 ` Jude DaShiell
2015-06-03 16:07 ` Jude DaShiell
2015-06-03 16:38 ` Jonathan Leech-Pepin
2015-06-03 21:12 ` Jude DaShiell
2015-06-03 22:01 ` Nick Dokos
2015-06-03 17:21 ` Nick Dokos [this message]
2015-06-03 18:04 ` Nick Dokos
2015-06-03 20:05 ` Michael Brand
2015-06-03 20:52 ` Nick Dokos
2015-06-04 7:21 ` e.fraga
2015-06-04 9:15 ` Michael Brand
2015-06-04 15:22 ` Nick Dokos
2015-06-04 15:43 ` Nick Dokos
2015-06-04 15:45 ` Michael Brand
2015-06-04 1:21 ` Jude DaShiell
2015-06-04 21:24 ` Thierry Banel
2015-06-05 7:13 ` Eric S Fraga
-- strict thread matches above, loose matches on Subject: below --
2015-06-19 0:58 Jude DaShiell
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=87d21ciu82.fsf@alphaville.usersys.redhat.com \
--to=ndokos@gmail.com \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
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).