From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Eric Schulte" Subject: Re: Complex numbers Date: Wed, 13 Apr 2011 10:35:05 -0600 Message-ID: <87aafum7nq.fsf@gmail.com> References: <87tye24xlf.fsf@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([140.186.70.92]:39094) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QA32D-00069D-0P for emacs-orgmode@gnu.org; Wed, 13 Apr 2011 12:35:22 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1QA32B-0006Vk-Cp for emacs-orgmode@gnu.org; Wed, 13 Apr 2011 12:35:16 -0400 Received: from mail-iw0-f169.google.com ([209.85.214.169]:39665) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QA32B-0006VI-6k for emacs-orgmode@gnu.org; Wed, 13 Apr 2011 12:35:15 -0400 Received: by iwg8 with SMTP id 8so1052976iwg.0 for ; Wed, 13 Apr 2011 09:35:13 -0700 (PDT) In-Reply-To: (Renier Marchand's message of "Wed, 13 Apr 2011 11:16:41 +0200") 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: Renier Marchand Cc: emacs-orgmode@gnu.org Renier Marchand writes: > 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. > Very cool, I would never have thought to use a reference within a table formula. > > 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) > No, there is no support for that sort of usage, and adding such a position dependent reference would be a fairly large change from the existing reference resolution mechanisms. Best -- Eric > > Regards, > > Renier > > On Wed, Apr 13, 2011 at 5:52 AM, Eric Schulte wr= ote: >> 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). =C2=A0Due to the "," the result is a weird nested = list >> which confuses your python code block. =C2=A0Some options here include... >> >> 1. wrapping these cells in quotes so that they are passed to the python >> =C2=A0 block as strings... >> >> =C2=A0 #+source: parameter-variation(data=3D0) >> =C2=A0 #+begin_src python :result values >> =C2=A0 =C2=A0 return 'text' >> =C2=A0 #+end_src >> >> =C2=A0 |---------------------------------------| >> =C2=A0 | "(0.0331901438056,0.000535222885197)" | >> =C2=A0 | "(0.0333434157791,0.000537930174356)" | >> =C2=A0 | "(0.0345727512157,0.000559346040457)" | >> =C2=A0 | "(0.0353146483908,0.000571501584524)" | >> =C2=A0 | "(0.0355522909393,0.000574387067408)" | >> =C2=A0 | "(0.0356575682336,0.000574851263615)" | >> =C2=A0 | "(0.0357806926897,0.000575051685084)" | >> =C2=A0 |---------------------------------------| >> =C2=A0 | text =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| >> =C2=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 >> =C2=A0 of a table formula. =C2=A0This is probably the easier solution, b= ut it >> =C2=A0 doesn't insert the result into your table, unless you do something >> =C2=A0 tricky like give the code block and the table the same name so th= at >> =C2=A0 the results of the code block replace the table... >> >> =C2=A0 #+results: complex-data >> =C2=A0 |-------------------------------------| >> =C2=A0 | (0.0331901438056,0.000535222885197) | >> =C2=A0 | (0.0333434157791,0.000537930174356) | >> =C2=A0 | (0.0345727512157,0.000559346040457) | >> =C2=A0 | (0.0353146483908,0.000571501584524) | >> =C2=A0 | (0.0355522909393,0.000574387067408) | >> =C2=A0 | (0.0356575682336,0.000574851263615) | >> =C2=A0 | (0.0357806926897,0.000575051685084) | >> =C2=A0 #+TBLFM: @8$1=3D'(sbe parameter-variation (nums @1$1..@7$1)) >> >> =C2=A0 #+begin_src python :var data=3Dcomplex-data >> =C2=A0 =C2=A0 return data >> =C2=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: >>> >>> =C2=A0 =C2=A0 =C2=A0 #+source: parameter-variation(data=3D0) >>> =C2=A0 =C2=A0 =C2=A0 #+begin_src python :result values >>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 return 'text' >>> =C2=A0 =C2=A0 =C2=A0 #+end_src >>> >>> >>> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0 |=C2=A0 hmin | =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= | >>> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |---+-------+---------------------------= ----------| >>> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 | =C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | >>> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0 |=C2=A0 0.05 | (0.03319014= 38056,0.000535222885197) | >>> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0 |=C2=A0=C2=A0 0.1 | (0.033= 3434157791,0.000537930174356) | >>> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0 |=C2=A0=C2=A0 0.3 | (0.034= 5727512157,0.000559346040457) | >>> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0 |=C2=A0=C2=A0 0.6 | (0.035= 3146483908,0.000571501584524) | >>> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0 |=C2=A0=C2=A0 0.9 | (0.035= 5522909393,0.000574387067408) | >>> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0 |=C2=A0=C2=A0 1.2 | (0.035= 6575682336,0.000574851263615) | >>> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0 |=C2=A0 10.0 | (0.03578069= 26897,0.000575051685084) | >>> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | $ | x=3D0.1 | y=3D0.1=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 | >>> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0 |=C2=A0 text | =C2=A0 =C2= =A0 =C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | >>> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 #+TBLFM: @11$2=3D'(sbe "parameter-variat= ion" (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: =C2=A0 '(sbe "parameter-variation" (data @3$2..@9$2)) >>> $xyz-> =C2=A0'(sbe "parameter-variation" (data @3$2..@9$2)) >>> @r$c-> =C2=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-> =C2=A0 =C2=A0'(sbe "parameter-variation" (data #("0.05" 0 4 (fonti= fied 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: =C2=A0text >>> >>> and for the complex column: >>> >>> Substitution history of formula >>> Orig: =C2=A0 '(sbe "parameter-variation" (data @3$3..@9$3)) >>> $xyz-> =C2=A0'(sbe "parameter-variation" (data @3$3..@9$3)) >>> @r$c-> =C2=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-> =C2=A0 =C2=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/ >> > --=20 Eric Schulte http://cs.unm.edu/~eschulte/