From mboxrd@z Thu Jan 1 00:00:00 1970 From: Karl Voit Subject: Re: Exploring data that is in org-mode format Date: Fri, 27 Sep 2013 10:29:39 +0200 Message-ID: <2013-09-27T10-25-20@devnull.Karl-Voit.at> References: Reply-To: news1142@Karl-Voit.at Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:40426) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VPTQy-0003Vo-6H for emacs-orgmode@gnu.org; Fri, 27 Sep 2013 04:30:01 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1VPTQt-0008D9-Bi for emacs-orgmode@gnu.org; Fri, 27 Sep 2013 04:29:56 -0400 Received: from plane.gmane.org ([80.91.229.3]:57757) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VPTQt-0008Ck-6B for emacs-orgmode@gnu.org; Fri, 27 Sep 2013 04:29:51 -0400 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1VPTQr-0005O2-HD for emacs-orgmode@gnu.org; Fri, 27 Sep 2013 10:29:49 +0200 Received: from mail.michael-prokop.at ([88.198.6.110]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 27 Sep 2013 10:29:49 +0200 Received: from news1142 by mail.michael-prokop.at with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 27 Sep 2013 10:29:49 +0200 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 * Alan Schmitt wrote: > Hello, Hi Alan! > The short version: what tools are available to explore data, typically > stored in org-mode tables? Great question! I did some very basic R-scripts to derive boxplots by myself. > The long version: I've tried an interesting website > (https://tictrac.com/) whose goal is to gain some insight about > ourselves by exploring some data we collect (think quantified self). I'm > not happy with this site for three reasons: > - I need to send it the data; I dislike cloud-based services which are not under my control. > - it focuses on health / activity data whereas there is much more that > interests me (I for instance have weekly records of natural gas use in my > gas-heated house and daily record of temperature average outside which I > would love to compare); Absolutely! > - it won't let you input arbitrary data (I asked about importing a CSV > of my daily coffee consumption, they answered they require an external > service to integrate the data). I understand. > So I collect all this data because it's something I enjoy doing, and I > would really like to explore it, from the comfortable position of my own > computer. All of this data is in org-mode tables (or can be easily > converted to org-mode table). Hence my questions: are there tools you > would recommend? I'm not afraid of programming (I suspect an answer will > be 'R'), but I would like pointers to tutorials to do these kind of > things. The kind of things I would like to do are: > - extract weekly or monthly tallies or estimation from data collected at > irregular intervals; > - compare data sources against each other; > - estimate future trends based on past data (how much will my gas bill be?); > - display the result in some kind of dashboard. I collect much data about myself using Memacs (see signature). However, I did not derive anything else but some boxplots from it (visualizing time-differences between periodic events). Something generic which I can feed Org-mode files (most preferably in Memacs-like Org-mode format) and derive some standard graphics (where I pick those that make sense) would be very great! -- mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode: > get Memacs from https://github.com/novoid/Memacs < https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github