From mboxrd@z Thu Jan 1 00:00:00 1970 From: Renier Marchand Subject: Re: Complex numbers Date: Wed, 13 Apr 2011 11:16:41 +0200 Message-ID: References: <87tye24xlf.fsf@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([140.186.70.92]:39730) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Q9wBt-0008Sq-61 for emacs-orgmode@gnu.org; Wed, 13 Apr 2011 05:16:54 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Q9wBm-00086U-VS for emacs-orgmode@gnu.org; Wed, 13 Apr 2011 05:16:49 -0400 Received: from mail-pz0-f41.google.com ([209.85.210.41]:52441) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Q9wBm-00086K-HT for emacs-orgmode@gnu.org; Wed, 13 Apr 2011 05:16:42 -0400 Received: by pzk32 with SMTP id 32so209210pzk.0 for ; Wed, 13 Apr 2011 02:16:41 -0700 (PDT) In-Reply-To: <87tye24xlf.fsf@gmail.com> 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: Eric Schulte Cc: emacs-orgmode@gnu.org I have found the following way to reference my data correctly without having to quote it or have data rewritten. I do: #+tblname: my-data | hmin | |------| | | | 0.05 | | 0.2 | | 0.2 | #+TBLFM: @5$1=3D'(sbe "myfunc" (data "my-data[3:4,0]")) This also works for complex data as you suggested. But is there a way to refer in the formula to the current table instead of a specific table? Because this would obviously not work for multiple tables with the same name. (i.e. copy and paste for another dataset) Regards, Renier On Wed, Apr 13, 2011 at 5:52 AM, Eric Schulte wrot= e: > Hi Renier, > > The Org-mode table machinery is interpreting the values of your table > cells as emacs lisp (given that the table formula is an elisp, rather > than a calc formula). =A0Due to the "," the result is a weird nested list > which confuses your python code block. =A0Some options here include... > > 1. wrapping these cells in quotes so that they are passed to the python > =A0 block as strings... > > =A0 #+source: parameter-variation(data=3D0) > =A0 #+begin_src python :result values > =A0 =A0 return 'text' > =A0 #+end_src > > =A0 |---------------------------------------| > =A0 | "(0.0331901438056,0.000535222885197)" | > =A0 | "(0.0333434157791,0.000537930174356)" | > =A0 | "(0.0345727512157,0.000559346040457)" | > =A0 | "(0.0353146483908,0.000571501584524)" | > =A0 | "(0.0355522909393,0.000574387067408)" | > =A0 | "(0.0356575682336,0.000574851263615)" | > =A0 | "(0.0357806926897,0.000575051685084)" | > =A0 |---------------------------------------| > =A0 | text =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0| > =A0 #+TBLFM: @8$1=3D'(sbe parameter-variation (nums @1$1..@7$1)) > > 2. referencing the table from an external code block, rather than inside > =A0 of a table formula. =A0This is probably the easier solution, but it > =A0 doesn't insert the result into your table, unless you do something > =A0 tricky like give the code block and the table the same name so that > =A0 the results of the code block replace the table... > > =A0 #+results: complex-data > =A0 |-------------------------------------| > =A0 | (0.0331901438056,0.000535222885197) | > =A0 | (0.0333434157791,0.000537930174356) | > =A0 | (0.0345727512157,0.000559346040457) | > =A0 | (0.0353146483908,0.000571501584524) | > =A0 | (0.0355522909393,0.000574387067408) | > =A0 | (0.0356575682336,0.000574851263615) | > =A0 | (0.0357806926897,0.000575051685084) | > =A0 #+TBLFM: @8$1=3D'(sbe parameter-variation (nums @1$1..@7$1)) > > =A0 #+begin_src python :var data=3Dcomplex-data > =A0 =A0 return data > =A0 #+end_src > > Hope this helps -- Eric > > Renier Marchand writes: > >> Hi. >> >> I have been playing around with complex data that has been returned >> from Python. This is obviously not in calc.el format but if I change >> them to the correct format I can manipulate them using calc. >> >> but >> >> When I want to pass the complex numbers (python format) to python I >> get an error. If I pass real number everything works as expected >> >> For example: >> >> =A0 =A0 =A0 #+source: parameter-variation(data=3D0) >> =A0 =A0 =A0 #+begin_src python :result values >> =A0 =A0 =A0 =A0 return 'text' >> =A0 =A0 =A0 #+end_src >> >> >> =A0=A0=A0=A0=A0 |=A0=A0 |=A0 hmin | =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 | >> =A0=A0=A0=A0=A0 |---+-------+-------------------------------------| >> =A0=A0=A0=A0=A0 |=A0=A0 |=A0=A0=A0=A0=A0=A0 | =A0 =A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 | >> =A0=A0=A0=A0=A0 |=A0=A0 |=A0 0.05 | (0.0331901438056,0.000535222885197) = | >> =A0=A0=A0=A0=A0 |=A0=A0 |=A0=A0 0.1 | (0.0333434157791,0.000537930174356= ) | >> =A0=A0=A0=A0=A0 |=A0=A0 |=A0=A0 0.3 | (0.0345727512157,0.000559346040457= ) | >> =A0=A0=A0=A0=A0 |=A0=A0 |=A0=A0 0.6 | (0.0353146483908,0.000571501584524= ) | >> =A0=A0=A0=A0=A0 |=A0=A0 |=A0=A0 0.9 | (0.0355522909393,0.000574387067408= ) | >> =A0=A0=A0=A0=A0 |=A0=A0 |=A0=A0 1.2 | (0.0356575682336,0.000574851263615= ) | >> =A0=A0=A0=A0=A0 |=A0=A0 |=A0 10.0 | (0.0357806926897,0.000575051685084) = | >> =A0=A0=A0=A0=A0 | $ | x=3D0.1 | y=3D0.1=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 | >> =A0=A0=A0=A0=A0 |=A0=A0 |=A0 text | =A0 =A0 =A0 =A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 | >> =A0=A0=A0=A0=A0 #+TBLFM: @11$2=3D'(sbe "parameter-variation" (data >> @3$2..@9$2))::@11$3=3D'(sbe "parameter-variation" (data @3$3..@9$3)) >> >> i.e. I get the word 'text' returned for column 2 where there are real >> numbers but I don't get anything returned where there are complex >> numbers. As you can see, there are no actual calculation performed on >> the data I am just returning 'text' so I am expecting it to work in >> both instances. >> >> The debug sessions show the following for the real column: >> >> Substitution history of formula >> Orig: =A0 '(sbe "parameter-variation" (data @3$2..@9$2)) >> $xyz-> =A0'(sbe "parameter-variation" (data @3$2..@9$2)) >> @r$c-> =A0'(sbe "parameter-variation" (data #("0.05" 0 4 (fontified t >> face org-table)) #("0.1" 0 3 (fontified t face org-table)) #("0.3" 0 3 >> (fontified t face org-table)) #("0.6" 0 3 (fontified t face >> org-table)) #("0.9" 0 3 (fontified t face org-table)) #("1.2" 0 3 >> (fontified t face org-table)) #("10.0" 0 4 (fontified t face >> org-table)))) >> $1-> =A0 =A0'(sbe "parameter-variation" (data #("0.05" 0 4 (fontified t >> face org-table)) #("0.1" 0 3 (fontified t face org-table)) #("0.3" 0 3 >> (fontified t face org-table)) #("0.6" 0 3 (fontified t face >> org-table)) #("0.9" 0 3 (fontified t face org-table)) #("1.2" 0 3 >> (fontified t face org-table)) #("10.0" 0 4 (fontified t face >> org-table)))) >> Result: text >> Format: NONE >> Final: =A0text >> >> and for the complex column: >> >> Substitution history of formula >> Orig: =A0 '(sbe "parameter-variation" (data @3$3..@9$3)) >> $xyz-> =A0'(sbe "parameter-variation" (data @3$3..@9$3)) >> @r$c-> =A0'(sbe "parameter-variation" (data >> #("(0.0331901438056,0.000535222885197)" 0 35 (fontified t face >> org-table)) #("(0.0333434157791,0.000537930174356)" 0 35 (fontified t >> face org-table)) #("(0.0345727512157,0.000559346040457)" 0 35 >> (fontified t face org-table)) #("(0.0353146483908,0.000571501584524)" >> 0 35 (fontified t face org-table)) >> #("(0.0355522909393,0.000574387067408)" 0 35 (fontified t face >> org-table)) #("(0.0356575682336,0.000574851263615)" 0 35 (fontified t >> face org-table)) #("(0.0357806926897,0.000575051685084)" 0 35 >> (fontified t face org-table)))) >> $1-> =A0 =A0'(sbe "parameter-variation" (data >> #("(0.0331901438056,0.000535222885197)" 0 35 (fontified t face >> org-table)) #("(0.0333434157791,0.000537930174356)" 0 35 (fontified t >> face org-table)) #("(0.0345727512157,0.000559346040457)" 0 35 >> (fontified t face org-table)) #("(0.0353146483908,0.000571501584524)" >> 0 35 (fontified t face org-table)) >> #("(0.0355522909393,0.000574387067408)" 0 35 (fontified t face >> org-table)) #("(0.0356575682336,0.000574851263615)" 0 35 (fontified t >> face org-table)) #("(0.0357806926897,0.000575051685084)" 0 35 >> (fontified t face org-table)))) >> Result: >> Format: NONE >> Final: >> >> >> Thank you very much for your help. >> >> Renier >> >> > > -- > Eric Schulte > http://cs.unm.edu/~eschulte/ >