From mboxrd@z Thu Jan 1 00:00:00 1970 From: Johan Ekh Subject: Re: Tag table entries? Date: Tue, 4 May 2010 08:36:05 +0200 Message-ID: References: <878w80674c.fsf@stats.ox.ac.uk> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1307936018==" Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1O9BlY-00020B-JS for emacs-orgmode@gnu.org; Tue, 04 May 2010 02:38:00 -0400 Received: from [140.186.70.92] (port=49187 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1O9BlW-0001xd-2g for emacs-orgmode@gnu.org; Tue, 04 May 2010 02:37:59 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1O9Bjq-0002iV-8e for emacs-orgmode@gnu.org; Tue, 04 May 2010 02:36:15 -0400 Received: from fg-out-1718.google.com ([72.14.220.153]:19551) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1O9Bjp-0002iM-Dv for emacs-orgmode@gnu.org; Tue, 04 May 2010 02:36:13 -0400 Received: by fg-out-1718.google.com with SMTP id e21so1244582fga.12 for ; Mon, 03 May 2010 23:36:12 -0700 (PDT) In-Reply-To: <878w80674c.fsf@stats.ox.ac.uk> 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: emacs-orgmode@gnu.org --===============1307936018== Content-Type: multipart/alternative; boundary=001485f7d2ec89b3950485beeca5 --001485f7d2ec89b3950485beeca5 Content-Type: text/plain; charset=ISO-8859-1 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 > --001485f7d2ec89b3950485beeca5 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Thanks Dan!
My idea was to go through a long imported table and quickly = categorize the different rows
into a number of predefined categories, wi= thout 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 familia= r with it. But I have not used
it with babel, is that possible?

B= est regards,
Johan


On Mon, May 3, = 2010 at 10:52 PM, Dan Davison <davison@stats.ox.ac.uk> wrote:
<= div class=3D"h5">Johan Ekh <ekh.j= ohan@gmail.com> writes:

> Hi all,
> I wonder if it is possible to tag rows in a table?
>
> For example, if=A0 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 &= quot;groceries", "car" etc.
>
> Can I do this someway?

Hi Johan,

You can't attach metadata such as tags to table rows. Two things come t= o
mind.

1. If you just want the table for visual purposes (as opposed for doing
=A0 calculations with it), then you could use column-view. I.e. you would<= br> =A0 have a subtree for groceries and a subtree for car; categories such =A0 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 ro= ws.

[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<= br> =A0 store the category label in a column and you can transform the master<= br> =A0 table however you want. R would be a convenient language for working =A0 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

--001485f7d2ec89b3950485beeca5-- --===============1307936018== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ 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 --===============1307936018==--