From mboxrd@z Thu Jan  1 00:00:00 1970
From: John Kitchin <jkitchin@andrew.cmu.edu>
Subject: using a table from one org-file as a variable in a code block in
 another org-file
Date: Mon, 26 Nov 2012 11:47:13 -0500
Message-ID: <CAJ51ETrxAw+nVYOTK-Rb4BCWY+pOEa-bXr1=MmQQg1gAvmH7rg@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:51215)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <johnrkitchin@gmail.com>) id 1Td1q8-0007Rt-MZ
	for emacs-orgmode@gnu.org; Mon, 26 Nov 2012 11:47:32 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <johnrkitchin@gmail.com>) id 1Td1pz-0006JA-3T
	for emacs-orgmode@gnu.org; Mon, 26 Nov 2012 11:47:24 -0500
Received: from mail-wi0-f177.google.com ([209.85.212.177]:40062)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <johnrkitchin@gmail.com>) id 1Td1py-0006Iy-T2
	for emacs-orgmode@gnu.org; Mon, 26 Nov 2012 11:47:15 -0500
Received: by mail-wi0-f177.google.com with SMTP id c10so2536517wiw.12
	for <emacs-orgmode@gnu.org>; Mon, 26 Nov 2012 08:47:13 -0800 (PST)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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 everyone,

I have been using tables as variables for codeblocks on an org-file, e.g.
#+tblname: class-data
| user      | oxide | xc |
| jkitchin  | TiO2  | LDA|
...

#+BEGIN_SRC python :var data=class-data
from pylab import *
import numpy as np

vol = [x[1]  if x[1] != '' else np.nan for x in data]
B = [x[2] if x[2] != '' else np.nan for x in data  ]

scatter(vol, B)
xlabel('Volume ($\AA^3$)')
ylabel('Bulk modulus (GPa)')
title('All polymorphs of all oxides for all functionals')
show()
#+END_SRC

This is a fantastic feature, since I can have some code that is
expensive to run create the table, but then have analysis code that is
quick, since it only reads the table.

But, sometimes the tables are defined in other org-files.  Is there a
way to specify a table from another org-file in the variable header?

Something like this would be pretty handy:

:var ./org-file.org::class-data

Especially if I could click on it, and have it open the other org-file
with point at the table!

Any thoughts? Thanks,

John

-----------------------------------
John Kitchin
Associate Professor
Doherty Hall A207F
Department of Chemical Engineering
Carnegie Mellon University
Pittsburgh, PA 15213
412-268-7803
http://kitchingroup.cheme.cmu.edu