From mboxrd@z Thu Jan 1 00:00:00 1970 From: Darlan Cavalcante Moreira Subject: Re: Tag table entries? Date: Tue, 04 May 2010 10:36:12 +0200 Message-ID: <4bdfdc7c.1067f10a.4239.3cc3@mx.google.com> References: <878w80674c.fsf@stats.ox.ac.uk> Mime-Version: 1.0 (generated by SEMI 1.14.6 - "Maruoka") Content-Type: text/plain; charset=US-ASCII Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1O9Dc3-0006wD-DP for emacs-orgmode@gnu.org; Tue, 04 May 2010 04:36:19 -0400 Received: from [140.186.70.92] (port=46920 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1O9Dc1-0006w3-Pb for emacs-orgmode@gnu.org; Tue, 04 May 2010 04:36:18 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1O9Dbz-00089T-Gk for emacs-orgmode@gnu.org; Tue, 04 May 2010 04:36:17 -0400 Received: from ey-out-1920.google.com ([74.125.78.146]:48979) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1O9Dbz-00088u-CF for emacs-orgmode@gnu.org; Tue, 04 May 2010 04:36:15 -0400 Received: by ey-out-1920.google.com with SMTP id 13so302891eye.34 for ; Tue, 04 May 2010 01:36:13 -0700 (PDT) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Johan Ekh Cc: emacs-orgmode@gnu.org For that I just use separate tables. I use a headline for each month, say "May 2010" and subheadings for each category (groceries, bills, transport, etc.) with a corresponding table in each one. Each table calculates the total for that category and has a unique name, say "BillsMay2010". All of the totals for each table are concatenated in a table "ExpensesMay2010" (also in a subheadings of the month headline) that has one line for each category and calculates the total. There is even gnuplot code with org-babel to plot the amount spent in each category from the "ExpensesMay2010" table. Of course there is a snippet (with yasnippet) for all of this and in the first day of the month I call the snippet and only provide the month name and the year (both used to make the name of each table unique). This snippet makes easy creating all the infrastructure for each month and org speedkeys makes easy navigating the categories to quickly add something. This works very well and I only need to be careful and update each table (C-u C-u C-c *) when I make some change. Darlan At Tue, 4 May 2010 08:36:05 +0200, Johan Ekh wrote: > > Thanks Dan! > My idea was to go through a long imported table and quickly categorize the > different rows > into a number of predefined categories, without having to actually type the > category for > each row. Can I do that? > > If babel is a way, I think I would prefer to use python as I am familiar > with it. But I have not used > it with babel, is that possible? > > Best regards, > Johan > > > On Mon, May 3, 2010 at 10:52 PM, Dan Davison wrote: > > > Johan Ekh writes: > > > > > Hi all, > > > I wonder if it is possible to tag rows in a table? > > > > > > For example, if I have a table of expenses, i.e. columns with "date", > > "note" and "sum", > > > and then want to group the entries into different categories such as > > "groceries", "car" etc. > > > > > > Can I do this someway? > > > > Hi Johan, > > > > You can't attach metadata such as tags to table rows. Two things come to > > mind. > > > > 1. If you just want the table for visual purposes (as opposed for doing > > calculations with it), then you could use column-view. I.e. you would > > have a subtree for groceries and a subtree for car; categories such > > as date, note and sum would be stored in properties. > > > > http://orgmode.org/manual/Column-view.html#Column-view > > > > Visibility cycling works in column view so you can group and ungroup the > > rows. > > > > [is there anyway of creating a normal Org table from a column view > > "table"?] > > > > 2. org-babel: If you're happy with a suitable supported language, then > > store the category label in a column and you can transform the master > > table however you want. R would be a convenient language for working > > with a table like this. > > > > Dan > > > > > > > > > > > > Best regards, > > > Johan > > > > > > _______________________________________________ > > > Emacs-orgmode mailing list > > > Please use `Reply All' to send replies to the list. > > > Emacs-orgmode@gnu.org > > > http://lists.gnu.org/mailman/listinfo/emacs-orgmode > >