Re: [O] How to pass named table reference in source block variable
Eric Schulte gmail.com> writes: > > It sounds like you want to use tables like key-value stores. I think > adding such behavior directly to Org-mode would overly complicate the > data structures passed between code blocks (which currently only > consists of scalars and tables). However, maybe the following could > work. > > > Attachment (key-value.org): text/x-org, 776 bytes > > > Cheers, > Thanks for the attachment. It works fine indeed! But should it be so complicated to add this behavior to Org-mode? I can rewrite your table as follows : #+name: table | | keys | values | |---+--+| | | foo | 1 | | ^ | | foo| | | bar | 2 | | ^ | | bar| Now I can refer to bar value as $bar in org-table. So, my suggestion is only to mimic this feature to assign value of source block variable like : #+headers: :results verbatim #+begin_src sh :var foo=table$foo :var bar=table$bar cat <
Re: [O] How to pass named table reference in source block variable
Roland Donat writes:
> Thomas S. Dye tsdye.com> writes:
>
>>
>> Roland Donat gmail.com> writes:
>>
>> >>
>> >> Perhaps this can help:
>> >>
>> >> http://orgmode.org/worg/org-contrib/babel/examples/lob-table-
>> > operations.html
>> >>
>> >> Alternatively, you might pass the table to a code block of a language
>> >> that understands tables, such as an R data frame, and use that language
>> >> to retrieve values by name.
>> >>
>> >> hth,
>> >> Tom
>> >>
>> >
>> > Thank you for the link, I'll check it but seems that it won't solve the
>> > problem. But anyway, I found a workaround that doesn't involve to insert
>> > table reference.
>>
>> What is the workaround?
>>
>> All the best,
>> Tom
>
> Well, my main objective was to write piece of code in a given language X
> including information stored in some org-table.
>
> So my solution for now was to create some python functions able to generate
> my code. I use babel to pass my org-table as input to the python function
> and the result is another source block of language X containing the code
> taking into account the information of my org-table.
>
> I recognized that the solution seems quite heavy but I have already
> developped some python wrapper for my language X so It takes me only 2 hours
> to do the job.
>
> All the best.
>
It sounds like you want to use tables like key-value stores. I think
adding such behavior directly to Org-mode would overly complicate the
data structures passed between code blocks (which currently only
consists of scalars and tables). However, maybe the following could
work.
Here's an example table with key/value data.
#+name: table
| keys | values |
|--+|
| foo | 1 |
| bar | 2 |
| baz | 3 |
| qux | 4 |
Here's a code block which can access the data in such a table by key.
This could be added to the library of babel to make it usable from any
Org-mode file.
#+name: by-key
#+begin_src sh :var data="" :var key=""
echo "$data"|awk "{if(\$1 == \"$key\") print \$2}"
#+end_src
And here's an example usage.
#+headers: :results verbatim
#+begin_src sh :var foo=by-key(table,"foo") :var baz=by-key(table,"baz")
cat <
Cheers,
--
Eric Schulte
http://cs.unm.edu/~eschulte
PGP: 0x614CA05D
Re: [O] How to pass named table reference in source block variable
Thomas S. Dye tsdye.com> writes: > > Roland Donat gmail.com> writes: > > >> > >> Perhaps this can help: > >> > >> http://orgmode.org/worg/org-contrib/babel/examples/lob-table- > > operations.html > >> > >> Alternatively, you might pass the table to a code block of a language > >> that understands tables, such as an R data frame, and use that language > >> to retrieve values by name. > >> > >> hth, > >> Tom > >> > > > > Thank you for the link, I'll check it but seems that it won't solve the > > problem. But anyway, I found a workaround that doesn't involve to insert > > table reference. > > What is the workaround? > > All the best, > Tom Well, my main objective was to write piece of code in a given language X including information stored in some org-table. So my solution for now was to create some python functions able to generate my code. I use babel to pass my org-table as input to the python function and the result is another source block of language X containing the code taking into account the information of my org-table. I recognized that the solution seems quite heavy but I have already developped some python wrapper for my language X so It takes me only 2 hours to do the job. All the best. Roland.
Re: [O] How to pass named table reference in source block variable
Roland Donat writes: >> >> Perhaps this can help: >> >> http://orgmode.org/worg/org-contrib/babel/examples/lob-table- > operations.html >> >> Alternatively, you might pass the table to a code block of a language >> that understands tables, such as an R data frame, and use that language >> to retrieve values by name. >> >> hth, >> Tom >> > > Thank you for the link, I'll check it but seems that it won't solve the > problem. But anyway, I found a workaround that doesn't involve to insert > table reference. What is the workaround? All the best, Tom -- Thomas S. Dye http://www.tsdye.com
Re: [O] How to pass named table reference in source block variable
Thomas S. Dye tsdye.com> writes: > > Perhaps this can help: > > http://orgmode.org/worg/org-contrib/babel/examples/lob-table- operations.html > > Alternatively, you might pass the table to a code block of a language > that understands tables, such as an R data frame, and use that language > to retrieve values by name. > > hth, > Tom > Thank you for the link, I'll check it but seems that it won't solve the problem. But anyway, I found a workaround that doesn't involve to insert table reference. It's a pity that I am so bad at Lisp because I feel this feature wouldn't be too complicated to code, especially if the reference mechanism is already implemented. Thank you again! Cheers, Roland.
Re: [O] How to pass named table reference in source block variable
Roland Donat writes: > Thorsten Jolitz gmail.com> writes: > >> >> This does the job in Emacs Lisp: >> >> #+TBLNAME: T >> | | x | 1 | >> | ^ | | varx | >> >> #+begin_src emacs-lisp :var x=T[0,-1] >> x >> #+end_src >> >> #+results: >> : 1 >> > > Thanks for the answer but in fact, my objective is precisely to avoid using > the indices of the value I want to pass as input of the code block. > > My goal is to use the cell name reference "varx" which would make the code > block simpler to maintain. Indeed, if I add new data on the top of table T, > I wouldn't have to change the reference in the code block since the name > reference is fixed. > > Perhaps this can help: http://orgmode.org/worg/org-contrib/babel/examples/lob-table-operations.html Alternatively, you might pass the table to a code block of a language that understands tables, such as an R data frame, and use that language to retrieve values by name. hth, Tom -- Thomas S. Dye http://www.tsdye.com
Re: [O] How to pass named table reference in source block variable
Thorsten Jolitz gmail.com> writes: > > This does the job in Emacs Lisp: > > #+TBLNAME: T > | | x | 1 | > | ^ | | varx | > > #+begin_src emacs-lisp :var x=T[0,-1] > x > #+end_src > > #+results: > : 1 > Thanks for the answer but in fact, my objective is precisely to avoid using the indices of the value I want to pass as input of the code block. My goal is to use the cell name reference "varx" which would make the code block simpler to maintain. Indeed, if I add new data on the top of table T, I wouldn't have to change the reference in the code block since the name reference is fixed.
Re: [O] How to pass named table reference in source block variable
Thorsten Jolitz writes: > Roland Donat writes: > >> Hello, >> >> I have the following table : >> #+TBLNAME: T > > This does the job in Emacs Lisp: > > #+TBLNAME: T > | | x | 1 | > | ^ | | varx | > > #+begin_src emacs-lisp :var x=T[0,-1] > x > #+end_src > > #+results: > : 1 Nit: I believe #+TBLNAME is obsolete/deprecated/frowned upon - use #+name going forward. -- Nick
Re: [O] How to pass named table reference in source block variable
Roland Donat writes: > Hello, > > I have the following table : > #+TBLNAME: T > | | x | 1 | > | ^ | | varx | > > And I would like to use the reference T$var_x (=1) as input in a source block > variable. > For example, I would have expected the following behavior for this source > code : > #+begin_src python :var x=T$varx :return x > x > #+end_src > > #+RESULTS: > : 1 > > But instead, I get the emacs message : org-babel-ref-resolve: Reference > 'T$varx' not found in this > buffer > > Any idea to produce the desired result would be much appreciated! > > Thanks you in advance. > > Roland. This does the job in Emacs Lisp: #+TBLNAME: T | | x | 1 | | ^ | | varx | #+begin_src emacs-lisp :var x=T[0,-1] x #+end_src #+results: : 1 -- cheers, Thorsten
[O] How to pass named table reference in source block variable
Hello, I have the following table : #+TBLNAME: T | | x | 1 | | ^ | | varx | And I would like to use the reference T$var_x (=1) as input in a source block variable. For example, I would have expected the following behavior for this source code : #+begin_src python :var x=T$varx :return x x #+end_src #+RESULTS: : 1 But instead, I get the emacs message : org-babel-ref-resolve: Reference 'T$varx' not found in this buffer Any idea to produce the desired result would be much appreciated! Thanks you in advance. Roland.
