From mboxrd@z Thu Jan 1 00:00:00 1970 From: Thierry Banel Subject: [ANN] orgtbl-aggregate version 2 Date: Fri, 09 Jan 2015 22:38:44 +0100 Message-ID: <54B04A64.1090009@free.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:38645) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Y9hGb-0008UQ-Vo for emacs-orgmode@gnu.org; Fri, 09 Jan 2015 16:38:54 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Y9hGX-0003Jl-H8 for emacs-orgmode@gnu.org; Fri, 09 Jan 2015 16:38:49 -0500 Received: from smtp3-g21.free.fr ([212.27.42.3]:44209) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Y9hGX-0003Jh-Ae for emacs-orgmode@gnu.org; Fri, 09 Jan 2015 16:38:45 -0500 Received: from [IPv6:2a01:e35:2e21:def0:e9b7:d32b:ce8e:4713] (unknown [IPv6:2a01:e35:2e21:def0:e9b7:d32b:ce8e:4713]) by smtp3-g21.free.fr (Postfix) with ESMTP id E66C3A6320 for ; Fri, 9 Jan 2015 22:36:57 +0100 (CET) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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 Hi The List I am glad to announce the second version of the Org Aggregate package. It comes with more flexibility and performance, while being simpler. This new version is based on a clever idea of Michael Brand. Thanks Michael for your reviews and suggestions. * What is it? ---------------------------------------------------- An aggregated Org table is derived from a source table by grouping rows and computing aggregations like sums and averages. Example: #+NAME: sourcetbl | Day | Color | Level | Quantity | |-----+-------+-------+----------| | Mon | Red | 30 | 11 | | Mon | Blue | 25 | 3 | | Thu | Red | 51 | 12 | | Thu | Red | 45 | 15 | | Thu | Blue | 33 | 18 | | Wed | Red | 27 | 23 | | Wed | Blue | 12 | 16 | | Wed | Blue | 15 | 15 | | Tur | Red | 39 | 24 | | Tur | Red | 41 | 29 | | Tur | Red | 49 | 30 | | Fri | Blue | 7 | 5 | | Fri | Blue | 6 | 8 | | Fri | Blue | 11 | 9 | #+BEGIN: aggregate :table sourcetbl :cols "Day vmean(Level);%.1f vsum(Quantity)" | Day | vmean(Level);%.1f | vsum(Quantity) | |-----+-------------------+----------------| | Mon | 27.5 | 14 | | Thu | 43.0 | 45 | | Wed | 18.0 | 54 | | Tur | 43.0 | 83 | | Fri | 8.0 | 22 | #+END * What is new? ---------------------------------------------------- The new version of Aggregate is designed to be seamless with the Org spreadsheet. - Aggregations formulas are now general Calc expressions, they can be as complex as: sqrt(vsum((X-vmean(X))^2)) - The modifiers are those of the spreadsheet, with exactly the same meaning (f3, NE, p24, %.6f and so on). - Spreadsheet formulas can further enrich an aggregation table, with the #+TBLFM line surviving refreshes. - Performance on large data sets has dramatically improved. Documentation here: https://github.com/tbanel/orgaggregate/blob/master/README.org * Install it! ---------------------------------------------------------- The easiest way to install it is through Melpa. Add those lines to your .emacs: (require 'package) (add-to-list 'package-archives '("melpa" . "http://melpa.milkbox.net/packages/") t) (package-initialize) Type M-x package-list-packages Install orgtbl-aggregate * Happy new year! ------------------------------------------------------ Comments etc. welcome Happy new year, have fun, and stay tunned for more to come Thierry Banel