
    m*i                      % S SK Jr  S SKJr  S SKJr  S SKrS SKrS SK	r	S SK
Jr  S SKJr  S SKJrJrJr  S SKJs  Jr  S SKJrJrJrJr  S SKrS S	KJrJrJrJ r J!r!J"r"  S SK#J$r%  S S
K&J'r'J(r(  S SK)J*r*  S SK+J,r,J-r-J.r.  S SK/J0r0J1r1  S SK2J3r3J4r4J5r5J6r6J7r7  S SK8J9r9  S SK:J;r;  \" SSS9r<\	Rz                  " S \* 5       S9S 5       r>\	Rz                  " \'R~                  S9S 5       r@S rA\	Rz                  " \B" \C" S5      5      / SQS9S 5       rD\DrE\DrF\	Rz                  S 5       rG " S S5      rH " S  S!5      rIS" rJ " S# S$5      rK " S% S&5      rL " S' S(5      rM\R                  R                  S)5      R                  S*5      rQ " S+ S,5      rR\R                  " S5      S- 5       rT\R                  " S5      \	R                  R                  S.S/5      S0 5       5       rW\R                  " S5      S1 5       rX\R                  " S5      S2 5       rY\.\(R                  \-S3.r[S4\\S5'   \	R                  R                  S6\*5      \	R                  R                  S7\[5      S8 5       5       r]S9 r^S: r_\	R                  R                  S;/ S<Q5      S= 5       r`S> raS? rbS@ rcSA rd\	R                  R                  SBSC5      \	R                  R                  SD\e\f45      \	R                  R                  SE\e\f45      SF 5       5       5       rg\	R                  R                  SGSHSI/5      SJ 5       rhSK ri\	R                  R                  SLSMSN/5      SO 5       rjSP rk\	R                  R                  SL\9R                  " 5       5      SQ 5       rmSR rn " SS ST5      rog)U    )annotations)reduce)productN)PY312)import_optional_dependency)NumExprClobberingErrorPerformanceWarningUndefinedVariableError)is_boolis_floatis_list_like	is_scalar)	DataFrameIndexSeries
date_rangeperiod_rangetimedelta_range)exprpytables)ENGINES)BaseExprVisitorPandasExprVisitorPythonExprVisitor)NUMEXPR_INSTALLEDUSE_NUMEXPR)ARITH_OPS_SYMSSPECIAL_CASE_ARITH_OPS_SYMS_binary_math_ops_binary_ops_dict_unary_math_ops)DEFAULT_GLOBALS)Versionnumexprignore)errorsc              #     #    U  Ho  n[         R                  " U[         R                  R                  US :H  =(       a    [        (       + S[         S[
         3S9[        R                  " S 5      /S9v   Mq     g7f)r$   znumexpr enabled->z, installed->reasonmarksN)pytestparammarkskipifr   r   td
skip_if_no).0engines     b/var/www/html/land-doc-ocr/venv/lib/python3.13/site-packages/pandas/tests/computation/test_eval.py	<genexpr>r5   @   sw       F 	""i';O.{m <""3!46 # 
 i(
	
 s   A7A9)paramsc                    U R                   $ Nr-   requests    r4   r3   r3   ?   s    " ==    c                    U R                   $ r8   r9   r:   s    r4   parserr>   S   s    ==r<   c                    [         U   n[        U   R                  (       a	   U" X5      $ U" X5      $ ! [         a:  n[	        U5      R                  S5      (       a  [        R                  s S nA$ e S nAff = f)Nz6negative number cannot be raised to a fractional power)r    r   has_neg_frac
ValueErrorstr
startswithnpnan)lhscmp1rhsr3   ces         r4   _eval_single_binrK   X   sn    Av##	S; S;  	1v  H  vv	s    3 
A7.A2+A71A22A7   )r   r   	SeriesNaNDataFrameNaNfloat)r6   idsc           	     B   [        [        R                  R                  S5      R	                  S5      5      n[        R
                  XS:  '   [        [        R                  R                  S5      R	                  S5      5      [        [        R                  R                  S5      R	                  S5      5      [        SS[        R
                  [        R
                  S/5      U[        R                  R                  S5      R	                  5       4nX R                     $ )N   )
   rL         ?rL      )r   rD   randomdefault_rngstandard_normalrE   r   r-   )r;   nan_df1optss      r4   rF   rF   g   s    
 		--a0@@IJGVVGcM 	"))''*::7CDryy$$Q'77:;1bffbffa()
		a 002D r<   c                      S S S S S S S.$ )Nc                Z    [        [        R                  " U 5      [        R                  S9$ Ndtype)r   rD   arangeint64ns    r4   <lambda>idx_func_dict.<locals>.<lambda>   s    uRYYq\:r<   c                Z    [        [        R                  " U 5      [        R                  S9$ r]   )r   rD   r`   float64rb   s    r4   rd   re      s    uRYYq\<r<   c           
     x    [        [        SSU -   5       Vs/ s H  o S[        U5       3PM     sn5      $ s  snf )Na   _)r   rangechr)rc   is     r4   rd   re      s4    uuRa7HI7H!1SVHo7HIJIs   7c                    [        SU S9$ )N
2020-01-01periods)r   rb   s    r4   rd   re      s    
<;r<   c                    [        SU S9$ )Nz1 dayrp   )r   rb   s    r4   rd   re      s    ;r<   c                    [        SU SS9$ )Nro   D)rq   freq)r   rb   s    r4   rd   re      s    |L!#Fr<   )rm   fsdtr0   p rz   r<   r4   idx_func_dictr{   }   s      ;<J;;F r<   c                  |   \ rS rSr\R
                  R                  S/ SQ/ SQS9\R
                  R                  SSS/S	S
/S9\R
                  R                  S\R                  5      S 5       5       5       r	\R
                  R                  S\R                  5      S 5       r\R
                  R                  S\R                  5      S 5       r\R
                  R                  SSS/5      \R
                  R                  SSS/5      S 5       5       r\R
                  R                  S\" \" \5      R#                  \5      5      5      S 5       rS rS r\R.                  S 5       rS rS rS rS rS r\R
                  R                  S\" \R@                  RC                  S5      RE                  S5      5      \" \R@                  RC                  S5      RG                  SSS 95      \" \R@                  RC                  S5      RE                  S5      S!:  5      /5      S" 5       r$\R
                  R                  S\%" \R@                  RC                  S5      RE                  S5      5      \%" \R@                  RC                  S5      RG                  SSS 95      \%" \R@                  RC                  S5      RE                  S5      S!:  5      /5      S# 5       r&S$ r'S% r(\R
                  R                  S&S'S(/5      S) 5       r)S* r*\R
                  R                  S+S,5      S- 5       r+S. r,S/ r-S0 r.S1 r/S2 r0S3 r1S4r2g5)6TestEval   rG   )z!=z==z<=z>=<>)neeqlegeltgt)rP   cmp2r   r   r   r   binopc                   US:X  aL  US;   aF  Sn[         R                  " [        US9   SU SU SU S3n	[        R                  " XUS	9  S S S 5        g [        XAXV5      n
[        XBXV5      n[        XX5      nSU SU SU S3n	[        R                  " XUS	9n[        R                  " X5        g ! , (       d  f       g = f)
Npythonandor"'BoolOp' nodes are not implementedmatch(lhs z rhs) z (lhs  rhs)r3   r>   )r,   raisesNotImplementedErrorpdevalrK   tmassert_equal)selfrG   r   r   rF   rH   r3   r>   msgexlhs_newrhs_newexpectedresults                 r4   test_complex_cmp_opsTestEval.test_complex_cmp_ops   s     X%="86C2#>TF&vdV5A&9 ? "3c:"3c:#GGDTF&vdV596:
) ?> s   "B//
B=cmp_opc           	     8   US:  nUS:  nUS:X  aF  US;   a@  Sn[         R                  " [        US9   SU S3n[        R                  " XtUS9  S S S 5        g SU S3nS	R                  S
S/5      nUS;   aL  [        U5      (       d<  [         R                  " [        US9   [        R                  " UUUX#S.S9  S S S 5        g [        X!X45      n[        R                  " XtUS9n	[        R                  " X5        g ! , (       d  f       g = f! , (       d  f       g = f)Nr   r   innot in&'(In|NotIn)' nodes are not implementedr   lhs  rhsr   |zvonly list-like( or dict-like)? objects are allowed to be passed to (DataFrame\.)?isin\(\), you passed a (`|')bool(`|')z'argument of type 'bool' is not iterablerF   rH   r3   r>   
local_dict)r,   r   r   r   r   joinr   	TypeErrorrK   r   r   )
r   r   rF   rH   r3   r>   r   r   r   r   s
             r4   test_simple_cmp_opsTestEval.test_simple_cmp_ops   s   AgAgX&,<"<:C2#>F84(&9 ? F84 hh" :	
 %%l3.?.?y4!!'*7	 54 (SAHWWRv>FOOF-3 ?>  54s   C:D:
D
Dopc           	     x   US:X  aF  US;   a@  Sn[         R                  " [        US9   SU S3n[        R                  " XUS9  S S S 5        g [        U5      (       aP  [        U5      (       d@  US;   a:  US:X  a4  US:X  a.  [         R                  R                  S	S
9n	UR                  U	5        SS/n
SU S3nSR                  SS/5      n[        U5      (       aA  X;   a<  [         R                  " [        US9   [        R                  " UUUX#S.S9  S S S 5        g [        U5      (       a  [        U5      (       a  S X#4 5       u  p#[        X!X55      n[        U5      (       a  U(       + nOU) n[        R                  " XUS9n[        R                  " X5        g ! , (       d  f       g = f! , (       d  f       g = f)Nr   r   r   r   z~(lhs r   r   pandasz]Looks like expected is negative, unclear whether expected is incorrect or result is incorrectr(   r   r   r   zwonly list-like( or dict-like)? objects are allowed to be passed to (DataFrame\.)?isin\(\), you passed a (`|')float(`|')z(argument of type 'float' is not iterabler   r   c              3  P   #    U  H  n[         R                  " U/5      v   M     g 7fr8   )rD   arrayr2   xs     r4   r5   3TestEval.test_compound_invert_op.<locals>.<genexpr>   s     >:aBHHaSMM:s   $&)r,   r   r   r   r   r   r.   xfailapplymarkerr   r   r   rK   r   assert_almost_equal)r   r   rF   rH   r;   r3   r>   r   r   r.   
skip_theser   r   s                r4   test_compound_invert_op TestEval.test_compound_invert_op   s   X"(8"8:C2#>bT'&9 ?  SMMSMM&&("(";;$$? % D %H%
bThh# ;	
 S>>b.y4!!'*7	 54 ~~)C..>C:>'=H""'<$9WWRv>F""84] ?> 4 54s   F8F+
F(+
F9c                   UnUS:X  aC  SU SU S3n	Sn
[         R                  " [        U
S9   [        R                  " XUS9  S S S 5        g [        X1X5      n[        XXV5      nUbd  Ub`  SU SU S3n	SU SU S3nS	U S
U S3n[        USX5      nXU4 H/  n[        R                  " UXgS9n[        R                  " UU5        M1     g g g ! , (       d  f       g = f)Nr   r    mid r   r   r   r    mid and mid r    mid) & (mid r   &)r,   r   r   r   r   rK   r   r   )r   rG   r   rF   midhsrH   r3   r>   midex1r   r   r   ex2ex3r   r   r   s                     r4   test_chained_cmp_opTestEval.test_chained_cmp_op   s     XeD6.C6C2#>6: ?"3c:"3c:7#6eD6.CmD66C$}TF%8C'gFHoFB&&vx8 & $7 ?>s   C
Carith1c                   SU S3n[         R                  " XdUS9n[        X!X45      n[        R                  " Xx5        SU SU S3n[         R                  " XdUS9n[        X!X45      n	 U	R                  U5      u  pUS:X  a;  SS KnUR                  SU S35      n[        R                  " UR                  U5        g [        SU S35      n[        R                  " Xx5        g ! [        [        [        4 a     g f = f)	Nr   r   r   z rhs r$   r   znlhs z ghs)r   r   rK   r   r   alignr$   evaluatevaluesrA   r   AttributeError)r   r   rF   rH   r3   r>   r   r   r   nlhsghsr   s               r4   test_binary_arith_opsTestEval.test_binary_arith_ops  s     F84 6:#C=
v0F85-6:S9	9

3ID "$ ;;vhd';<
 &&v}}h?%xt 45&&v8# I~6 	 	s   )C# #C;:C;c                   Sn[         R                  " XSUS9nX-  n[        R                  " Xg5        US:X  aw  SS KnUR                  S5      n[        U[        [        45      (       a"  [        R                  " UR                  U5        g [        R                  " XgR                  5       5        g [        USX#5      n[        R                  " Xg5        g )Nz	lhs % rhsr   r$   r   zexpected % rhs%)r   r   r   r   r$   r   
isinstancer   r   r   itemrK   )	r   rF   rH   r3   r>   r   r   r   r   s	            r4   test_modulusTestEval.test_modulus4  s    6:9
v0Y {{#45H&9f"566&&v}}h?&&v}}?'#sCH""64r<   c                h   SnUS:X  d,  US:X  aV  [        [        R                  5      [        S5      :  a0  [        R                  " XSUS9nX-  n[
        R                  " Xg5        g Sn[        R                  " [        US9   [        R                  " UXS.UUS	9  S S S 5        g ! , (       d  f       g = f)
Nz
lhs // rhsr   r$   2.13.0r   zGunsupported operand type\(s\) for //: 'VariableNode' and 'VariableNode'r   r   r   r3   r>   )
r#   r$   __version__r   r   r   r   r,   r   r   )	r   rF   rH   r3   r>   r   resr   r   s	            r4   test_floor_divisionTestEval.test_floor_divisionF  s    XiGG,?,?$@GHDU$U''"F;CzHOOC*!  y4'*7!!	 544s    B##
B1c                ^   Sn[        USX#5      n[        R                  " XSUS9n[        U5      (       a  [        U5      (       a{  [	        U[
        [        R                  45      (       aV  [        R                  " U5      (       a;  Sn[        R                  " [        US9   [        R                  " Xv5        S S S 5        g [        R                  " Xv5        Sn[        R                  " XSUS9n[        USX#5      n	[        U	SX#5      n[        R                  " Xv5        g ! , (       d  f       g = f)Nz
lhs ** rhs**r   z-(DataFrame.columns|numpy array) are differentr   z(lhs ** rhs) ** rhs)rK   r   r   r   r   complexrD   complexfloatingisnanr,   r   AssertionErrorr   assert_numpy_array_equalr   )
r   rF   rH   r3   r>   r   r   r   r   middles
             r4   test_powTestEval.test_pow\  s     #Cs;6: cNN#8gr/A/A%BCC  AC~S9++F= :9 ""64&BWWRv>F%c4=F'cBH""64 :9s    D
D,c                     UR                  [        5      nU) n[
        R                  " SX#S9n[        R                  " XV5        g ! [         a#    [        R                  " [        U5      /5      n N[f = f)Nz~elbr   )	astypeboolr   rD   r   r   r   r   r   )r   rF   r3   r>   elbr   r   s          r4   test_check_single_invert_op$TestEval.test_check_single_invert_opv  sa    	(**T"C 4>
x0	  	(((DI;'C	(s   A *A32A3c                   Sn[        [        R                  R                  S5      R	                  S5      5      nUS:X  a:  Sn[
        R                  " [        US9   [        R                  " X1US9  S S S 5        O9Sn[
        R                  " [        US9   [        R                  " X1US9  S S S 5        [        [        R                  R                  S5      R                  S	SS
95      nUS:X  a`  [        [        R                  5      [        S5      :  a:  Sn[
        R                  " [        US9   [        R                  " X1US9  S S S 5        O.U) n[        R                  " X1US9n[        R                   " Xg5        [        [        R                  R                  S5      R	                  S5      S:  5      nU) n[        R                  " X1US9n[        R                   " Xg5        [        / SQ[        R                  R                  S5      R	                  S5      S:  S.5      nUS:X  a8  [
        R                  " ["        SS9   [        R                  " X1US9  S S S 5        g Sn[
        R                  " [        US9   [        R                  " X1US9  S S S 5        g ! , (       d  f       GN= f! , (       d  f       GN
= f! , (       d  f       GNR= f! , (       d  f       g = f! , (       d  f       g = f)N~lhsrR   rL   rR   r$   -couldn't find matching opcode for 'invert_dd'r   r   0ufunc 'invert' not supported for the input typesrL   sizer   )couldn't find matching opcode for 'invertrT   arU   g       @   )brI   unknown type object#bad operand type for unary ~: 'str')r   rD   rV   rW   rX   r,   r   r   r   r   r   integersr#   r$   r   r   assert_frame_equalrA   )r   r3   r>   r   rF   r   expectr   s           r4   test_frame_invertTestEval.test_frame_invert  s1   
 		--a0@@HIYAC2#>F; ?> ECy4F; 5 		--a099!&9IJY77+>+>#?'(BS#S=C2#>F; ?> TFWWT@F!!&1 		--a0@@H3NOV<
f- bii&;&;A&>&N&Nq&QTW&WX
 Yz1FGF; HG 8Cy4F; 54C ?> 54 ?>$ HG 54s<   JJ.0K K=K#
J+.
J= 
K
K #
K1c                   Sn[        [        R                  R                  S5      R	                  S5      5      nUS:X  a:  Sn[
        R                  " [        US9   [        R                  " X1US9nS S S 5        O9Sn[
        R                  " [        US9   [        R                  " X1US9  S S S 5        [        [        R                  R                  S5      R                  SSS	95      nUS:X  a`  [        [        R                  5      [        S
5      :  a:  Sn[
        R                  " [        US9   [        R                  " X1US9  S S S 5        O.U) n[        R                  " X1US9n[        R                   " Xv5        [        [        R                  R                  S5      R	                  S5      S:  5      nU) n[        R                  " X1US9n[        R                   " Xv5        [        / SQ5      nUS:X  a8  [
        R                  " ["        SS9   [        R                  " X1US9  S S S 5        g Sn[
        R                  " [        US9   [        R                  " X1US9  S S S 5        g ! , (       d  f       GN= f! , (       d  f       GN= f! , (       d  f       GN = f! , (       d  f       g = f! , (       d  f       g = f)Nr   rR   rL   r$   r   r   r   r   r   r   r   rT   r   r   r  )r   rD   rV   rW   rX   r,   r   r   r   r   r   r  r#   r$   r   r   assert_series_equalrA   )r   r3   r>   r   rF   r   r   r  s           r4   test_series_invertTestEval.test_series_invert  s	    RYY**1-==a@AYAC2#>VD ?> ECy4F; 5 RYY**1-66qq6ABY77+>+>#?'(BS#S=C2#>F; ?> TFWWT@F""62 RYY**1-==a@3FGV<
v. ]#Yz1FGF; HG 8Cy4F; 54G ?> 54 ?>( HG 54s<   I*I<0JJ J1*
I9<
J
J 
J.1
J?c                   Sn[        [        R                  R                  S5      R	                  S5      5      nU* n[
        R                  " X1US9n[        R                  " XV5        [        [        R                  R                  S5      R                  SSS95      nU* n[
        R                  " X1US9n[        R                  " XV5        [        [        R                  R                  S5      R	                  S5      S:  5      nUS:X  a:  S	n[        R                  " [        US
9   [
        R                  " X1US9  S S S 5        g U* n[
        R                  " X1US9n[        R                  " XV5        g ! , (       d  f       g = f)N-lhsrR   r   r   rL   r   rT   r$   *couldn't find matching opcode for 'neg_bb'r   )r   rD   rV   rW   rX   r   r   r   r  r  r,   r   r   r   r3   r>   r   rF   r  r   r   s           r4   test_frame_negateTestEval.test_frame_negate  s/    		--a0@@HIV<
f- 		--a099!&9IJV<
f- 		--a0@@H3NOY>C2#>F; ?> TFWWT@F!!&1 ?>   'E55
Fc                   Sn[        [        R                  R                  S5      R	                  S5      5      nU* n[
        R                  " X1US9n[        R                  " XV5        [        [        R                  R                  S5      R                  SSS95      nU* n[
        R                  " X1US9n[        R                  " XV5        [        [        R                  R                  S5      R	                  S5      S:  5      nUS:X  a:  Sn[        R                  " [        US	9   [
        R                  " X1US9  S S S 5        g U* n[
        R                  " X1US9n[        R                  " XV5        g ! , (       d  f       g = f)
Nr  rR   rL   r   r   rT   r$   r  r   )r   rD   rV   rW   rX   r   r   r   r  r  r,   r   r   r  s           r4   test_series_negateTestEval.test_series_negate  s/    RYY**1-==a@AV<
v. RYY**1-66qq6ABV<
v. RYY**1-==a@3FGY>C2#>F; ?> TFWWT@F""62 ?>r  rF   rR   r   rL   r   rT   c                b    SnUn[         R                  " XBUS9n[        R                  " XV5        g Nz+lhsr   )r   r   r   r  r   rF   r3   r>   r   r  r   s          r4   test_frame_posTestEval.test_frame_pos  s,     V<
f-r<   c                b    SnUn[         R                  " XBUS9n[        R                  " XV5        g r  )r   r   r   r  r  s          r4   test_series_posTestEval.test_series_pos"  s,     V<
v.r<   c                   SnS n[         (       a  US:X  a  US:X  d  [        n[        R                  " [        US9   [
        R                  " SXS9  S S S 5        [
        R                  " SX!S9S	:X  d   e[
        R                  " S
X!S9S:X  d   e[
        R                  " SX!S9S:X  d   e[
        R                  " SX!S9S:X  d   e[
        R                  " SX!S9S:X  d   e[        R                  " USSS9   [
        R                  " SX!S9S:X  d   e S S S 5        [        R                  " USSS9   [
        R                  " SX!S9S:X  d   e S S S 5        [
        R                  " SX!S9S:X  d   e[
        R                  " SX!S9S:X  d   e[
        R                  " SX!S9S:X  d   e[
        R                  " SX!S9S:X  d   eg ! , (       d  f       GNy= f! , (       d  f       N= f! , (       d  f       N= f)Nz%bad operand type for unary ~: 'float'r$   r   r   z~1.0r   z-1.0r>   r3   g      z+1.0g      ?z~1z-1z+1rU   zBitwise inversionF)r   check_stacklevelz~Truez~Falsez-Truez-Falser   z+Truez+False)	r   DeprecationWarningr,   r   r   r   r   r   assert_produces_warning)r   r3   r>   r   warns        r4   test_scalar_unaryTestEval.test_scalar_unary4  s   55&I-&H2D%D]]9C0GGF69 1 wwvf<DDDwwvf<DDDwwtF:b@@@wwtF:b@@@wwtF:b@@@''+e
 7776AUJJJ
 ''+e
 778FBfLLL
 wwwv=FFFwwx>&HHHwwwv=FFFwwx>&HHH' 10
 

 
s#   G6G1G&
G
G#&
G4c                    [         R                  " [        R                  " S5      [         R                  S9n[         R                  " / SQ[         R                  S9n[
        R                  " X5        g )Nz>[-True, True, +True, -False, False, +False, -37, 37, ~37, +37]r^   )
r   TrU   r   Fr   i%   ir(  )rD   r   r   r   object_r   r   )r   r   r   s      r4   test_unary_in_arrayTestEval.test_unary_in_arrayN  sT     GGTU**
 88 **
 	##F5r<   r   zx < -0.1z-5 > xc                    [        S[        R                  " S/US905      nUR                  U5      nUR                  [        R                  " S/5      :X  d   eg )Nr   r   r^   F)r   rD   r   r   r   )r   float_numpy_dtyper   dfr   s        r4   test_float_comparison_bin_op%TestEval.test_float_comparison_bin_opg  sK     RXXqc1BCDEggdmzzRXXug....r<   c                f   [        SSS[        R                  /05      nUR                  S5      nUR                  R                  S5      n[        R                  " X#[        (       + S9  UR                  S5      nUR                  R                  SSS9n[        R                  " X#[        (       + S9  g )	Nr   r   rU   zx.fillna(-1)r   check_nameszx.shift(1, fill_value=-1))
fill_value)
r   rD   rE   r   r   fillnar   r  r   shiftr   r.  r   r   s       r4   test_unary_in_functionTestEval.test_unary_in_functionn  s    aBFF^,-(44;;r? 	v_M4544::aB:/
v_Mr<   r   )z1 or 2z1 and 2za and bza or bz1 or 2 and (3 + 2) > 3z2 * x > 2 or 1 and 2z2 * df > 3 and 1 or ac                h   [         R                  R                  S5      R                  S5      SSpen[	        [         R                  R                  S5      R                  S5      5      nSn[
        R                  " [        US9   [        R                  " XUS9  S S S 5        g ! , (       d  f       g = f)NrR   r   rU   r   rR   ;cannot evaluate scalar only bool ops|'BoolOp' nodes are notr   r   )
rD   rV   rW   rX   r   r,   r   r   r   r   )	r   r   r3   r>   r   r   r   r.  r   s	            r4   test_disallow_scalar_bool_ops&TestEval.test_disallow_scalar_bool_ops|  s{     ))''*::1=q!aryy,,Q/??GHK]].c:GGBf5 ;::s   B##
B1c                   Sn[         R                  " SXS9nUS:X  d   e[        U5      (       d   eSn[         R                  " SXS9nUS:X  d   e[        U5      (       d   eSn[         R                  " SXS9nU(       a   e[        U5      (       d   e[        U5      (       d   e[        R
                  " S/5      n[         R                  " SXS9n[        R                  " U[        R
                  " S/5      5        UR                  S:X  d   e[        R
                  " S/5      n[         R                  " SXS9n[        R                  " U[        R
                  " S/5      5        UR                  S:X  d   e[        R
                  " S/5      n[         R                  " SXS9n[        R                  " U[        R
                  " S/5      5        UR                  S:X  d   eg )NrU   r   r   g      ?F)rU   )	r   r   r   r   rD   r   r   r   shape)r   r3   r>   r   r   s        r4   test_identicalTestEval.test_identical  s   V;{{    V;}}    V;zv    HHaSMV;
##FBHHaSM:||t###HHcUOV;
##FBHHcUO<||t###HHeWV;
##FBHHeW,=>||t###r<   c                B    Sn[         R                  " X1US9nUS:X  d   eg )Nz1 + 2 *         5 - 1 + 2 r      )r   r   )r   r3   r>   expr   s        r4   test_line_continuationTestEval.test_line_continuation  s%    F;||r<   c                   Sn[         R                  " X1US9n[        R                  " U5      nXE:X  d   e[	        S/ SQ05      nSnUR                  SUS 35      nUR                  (       d   eSnUR                  S	US 35      nUR                  S
S/S S 24   n[        R                  " XT5        SnUR                  SUS 35      nUR                  S
/S S 24   n[        R                  " XT5        g )Nz1000000000.006r   A)g~  eA$  eAg'1  eAg  eAzA < z.4fg   eAzA > rU   rR   rJ  A == )
r   r   rD   rg   r   queryemptylocr   r  )	r   r3   r>   rE  r   r   r.  cutoffexacts	            r4   test_float_truncationTestEval.test_float_truncation  s    F;::c?!!!PQR D-.||| D-.661a&!)$
h/E%-.661#q&>
h/r<   c                l   [        / SQ// SQS9nSn[        R                  " [        US9   UR	                  S5        S S S 5        [        5       nSUR
                  l        [        R                  " [        US9   UR	                  S5        S S S 5        g ! , (       d  f       N]= f! , (       d  f       g = f)	N)r   r   r   )foobarclasscolumnsz4Python keyword not valid identifier in numexpr queryr   z
class == 0lambdazlambda == 0)r   r,   r   SyntaxErrorrL  indexnamer   r.  r   s      r4   test_disallow_python_keywords&TestEval.test_disallow_python_keywords  s}    	{,CDD]];c2HH\" 3 [ ]];c2HH]# 32 32
 32s   B9B%
B"%
B3c                   [         R                  " [        [        SS9   [        R
                  " S5      S:X  d   e[        R
                  " S5      S:X  d   e[        R
                  " S5      S:X  d   e S S S 5        g ! , (       d  f       g = f)	NF)r!  znot Truer  z	not Falser   zTrue and not Truer   )r   maybe_produces_warningr"  r   r   r   )r   s    r4   test_true_false_logicTestEval.test_true_false_logic  sq     &&
 77:&",,,77;'2---77./1444
 
 
s   AA>>
Bc                z   [        SS05      n[        R                  " UR                  R	                  S5      R
                   5      (       d   e[        R                  " UR                  R	                  S5      R
                  =(       a%    UR                  R	                  S5      R
                   5      (       d   eg )Nr   hello)r   r   r   rB   r   r   )r   events     r4   test_and_logic_string_match$TestEval.test_and_logic_string_match  s~    W~&ww%))//'24457777ww%))//'244S9Q9S9STVVVVr<   rz   N)3__name__
__module____qualname____firstlineno__r,   r.   parametrizer   BOOL_OPS_SYMSr   CMP_OPS_SYMSr   r   r   sortedsetr   
differencer   r   r   r   r0   skip_if_windowsr   r   r  r	  r  r  r   rD   rV   rW   rX   r  r  r   r  r%  r*  r/  r8  r=  rA  rF  rQ  r^  rb  rg  __static_attributes__rz   r<   r4   r}   r}      sU   [[*0  
 [[Vc3ZdD\B[[Wd&8&89* : C*  [[Xt'8'89 . : .D [[T4#4#4515 615f [[Vc3Z0[[Vc3Z09 1 19. [[&^,778STU99@5$, 5 521+<Z-<^2434 [[ bii++A.>>vFGbii++A.777GHbii++A.>>vFLM	

.
. [[ 299((+;;A>?299((+44QQ4?@299((+;;A>DE	

/
/I462 [[Vj(%;</ =/N [[	
66$B0,
$5Wr<   r}   c                      \ rS rSr\R
                  R                  S/ SQ5      \R
                  R                  SSS/5      S 5       5       rSrg	)
TestTypeCastingi  r   )+-*r   /
left_right)r.  3)r|  r.  c                   Un[        [        R                  R                  S5      R	                  S5      US9nUu  pU	 SU SU
 3n[
        R                  " XUS9nUS:X  a4  US:X  a.  [        R                  R                  SS	9nUR                  U5        UR                  R                  U:X  d   eUR                  R                  U:X  d   e[        R                  " U[        U5      S
S9  g )NrR   rL   r   r^    r   	complex64r$   zfnumexpr issue with complex that are upcast to complex 128 https://github.com/pydata/numexpr/issues/492r(   F)check_exact)r   rD   rV   rW   rX   r   r   r,   r.   r   r   r   r_   r   r  )r   r3   r>   r   complex_or_float_dtyper{  r;   r_   r.  leftrightrw   r   r.   s                 r4   test_binop_typecasting&TestTypeCasting.test_binop_typecasting  s     'ryy,,Q/??GuU fAbT5'"ggav6KFi$7;;$$? % D
 %yy%'''zz5(((
c47>r<   rz   N)	ri  rj  rk  rl  r,   r.   rm  r  rt  rz   r<   r4   rv  rv    sG    [[T#=> [[\K+EF? G ??r<   rv  c                     [        [        [        R                  " S5      U 5      5      (       + n[	        [        R
                  S U  5       5      nU=(       a    U$ )Nis_monotonic_increasingc              3  ~   #    U  H3  n[        UR                  R                  [        R                  5      v   M5     g 7fr8   )
issubclassr_   typerD   
datetime64r   s     r4   r5   should_warn.<locals>.<genexpr>  s&     M1z!'',,>>s   ;=)anymapoperator
attrgetterr   xor)argsnot_monoonly_one_dts      r4   should_warnr    sH    s8../HI4PQQHMMK ##r<   c                  T   \ rS rSr/ SQr\S/-   rS r\R                  R                  S5      \R                  R                  S\5      \R                  R                  S\5      \R                  R                  S\5      S	 5       5       5       5       r\R                  R                  S
\5      \R                  R                  S\5      S 5       5       r\R                  R                  S5      \R                  R                  S\5      \R                  R                  S\5      \R                  R                  S\5      \R                  R                  S\5      S 5       5       5       5       5       r\R                  R                  S5      \R                  R                  SSS/5      \R                  R                  S\5      \R                  R                  S
\5      S 5       5       5       5       r\R                  R                  SSS/5      \R                  R                  S\" \" SS/SS/5      5      S/-   5      \R                  R                  S5      S 5       5       5       r\R                  R                  S5      \R                  R                  S\5      \R                  R                  S
\5      \R                  R                  SSS/5      \R                  R                  SSS/5      S 5       5       5       5       5       r\R                  R                  S5      \R                  R                  S\5      \R                  R                  S\5      \R                  R                  S\5      \R                  R                  S\5      S 5       5       5       5       5       rS rS rg!)"TestAlignmenti  )rm   rw   rx   rw   c                    Sn[        [        R                  R                  S5      R	                  S5      5      n[
        R                  " X1US9n[        R                  " XTS-  5        g )Nzdf * ~2rR   r~  r   )	r   rD   rV   rW   rX   r   r   r   r  )r   r3   r>   rw   r.  r   s         r4   test_align_nested_unary_op(TestAlignment.test_align_nested_unary_op  sM    ryy,,Q/??GHggav6
c7+r<   zalways::RuntimeWarninglr_idx_typerr_idx_type
c_idx_typec                Z   [        [        R                  R                  S5      R	                  S5      Xc   " S5      Xe   " S5      S9n[        [        R                  R                  S5      R	                  S5      Xd   " S5      Xe   " S5      S9n[        UR                  UR                  5      (       a9  [        R                  " [        5         [        R                  " SXS9n	S S S 5        O[        R                  " SXS9n	[        R                  " W	Xx-   5        g ! , (       d  f       N(= f)	NrR   rS   rS   rS   r[  rX  )   rS   r  zdf + df2r   r   rD   rV   rW   rX   r  r[  r   r#  RuntimeWarningr   r   r  )
r   r3   r>   r  r  r  r{   r.  df2r   s
             r4   test_basic_frame_alignment(TestAlignment.test_basic_frame_alignment  s     II!!!$44X>,R0!-b1

 II!!!$44X>,R0!-b1
 rxx++++N;ggjG <; ''*VCC
c28,	 <;s   D
D*
r_idx_typec                   [        [        R                  R                  S5      R	                  S5      XS   " S5      XT   " S5      S9n[
        R                  " SXS9n[        R                  " XvS:  5        [        [        R                  R                  S5      R	                  UR                  5      UR                  UR                  S9n[
        R                  " SXS9n[        R                  " XvU:  5        g )NrR   r  rS   r  df < 2r   zdf < df3)r   rD   rV   rW   rX   r   r   r   r  r@  r[  rX  )	r   r3   r>   r  r  r{   r.  r   df3s	            r4   test_frame_comparison#TestAlignment.test_frame_comparison8  s    
 II!!!$44X>+B/!-b1

 gghv=
c6*II!!!$44RXX>((JJ

 ggj?
c8,r<   zignore::RuntimeWarningr1c1r2c2c                   [        [        R                  R                  S5      R	                  S5      Xs   " S5      Xt   " S5      S9n[        [        R                  R                  S5      R	                  S5      Xu   " S5      Xv   " S5      S9n	[        [        R                  R                  S5      R	                  S5      Xu   " S5      Xv   " S5      S9n
[        UR                  U	R                  U
R                  5      (       a9  [        R                  " [        5         [        R                  " S	XS
9nS S S 5        O[        R                  " S	XS
9n[        R                  " WX-   U
-   5        g ! , (       d  f       N+= f)NrR   r;  r   r  )   rR   r  r   rL   zdf + df2 + df3r   r  )r   r3   r>   r  r  r  r  r{   r.  r  r  r   s               r4   #test_medium_complex_frame_alignment1TestAlignment.test_medium_complex_frame_alignmentM  s5    II!!!$44V<#A&!%a(

 II!!!$44V<#A&!%a(

 II!!!$44V<#A&!%a(

 rxxCII66++N;gg.vM <; ''*6IC
c28c>2	 <;s    E11
E?
index_namer[  rX  c                   [        [        R                  R                  S5      R	                  S5      Xd   " S5      Xe   " S5      S9n[        Xs5      n[        [        R                  R                  S5      R	                  S5      US S 5      n	[        UR                  U	R                  5      (       a9  [        R                  " [        5         [        R                  " SXS9n
S S S 5        O[        R                  " SXS9n
US:X  d  US:X  a  US	:X  a  UR                  U	5      OXy-   nOXy-   n[        R                  " W
U5        g ! , (       d  f       NR= f)
NrR   r  rS   r  rL   df + sr   rx   r$   )r   rD   rV   rW   rX   getattrr   r  r[  r   r#  r  r   r   addr  )r   r3   r>   r  r  r  r{   r.  r[  rw   r   r   s               r4   !test_basic_frame_series_alignment/TestAlignment.test_basic_frame_series_alignmentk  s    II!!!$44X>+B/!-b1

 '299((+;;A>bq	Jrxx))++N;gghvE <; ''(6ACt!3$*i$7rvvayRVHvH
c8, <;s   E
Ezr_idx_type, c_idx_typerm   )rx   rx   c           
     d   US:X  aV  US;   aP  US:X  aJ  US:X  aD  US:X  a>  SU SU SU S	U S
U 3
nUR                  [        R                  R                  USS95        [	        [
        R                  R                  S5      R                  S5      Xu   " S5      Xv   " S5      S9n	[        X5      n
[        [
        R                  R                  S5      R                  S5      U
S S 5      n[        UR                  U	R                  5      (       a9  [        R                  " [        5         [         R"                  " SX#S9nS S S 5        O[         R"                  " SX#S9nUS:X  d  US:X  a  US:X  a  U	R%                  U5      OX-   nOX-   n[        R&                  " WU5        g ! , (       d  f       NR= f)Nr$   )r   r   r[  rm   rw   z"Flaky column ordering when engine=z	, parser=z, index_name=z, r_idx_type=z, c_idx_type=F)r)   strictrR   )rS      rS   r  r  rL   zs + dfr   rx   )r   r,   r.   r   r   rD   rV   rW   rX   r  r   r  r[  r   r#  r  r   r   r  r  )r   r;   r3   r>   r  r  r  r{   r)   r.  r[  rw   r   r   s                 r4   !test_basic_series_frame_alignment/TestAlignment.test_basic_series_frame_alignment  s    i..g%c!c! 5VH = zl ;(\zlD 
  1 1 1 NOII!!!$44W=+B/!-a0

 '299((+;;A>bq	Jqww))++N;gghvE <; ''(6ACt!3$*i$7rvvayQVHvH
c8, <;s   )F!!
F/r   rw  ry  c                R   [        [        R                  R                  S5      R	                  S5      Xu   " S5      Xv   " S5      S9n[        X5      n	[        [        R                  R                  S5      R	                  S5      U	S S 5      n
SU S3nSU S	3n[        UR                  U
R                  5      (       aq  [        R                  " [        5         [        R                  " XUS
9nS S S 5        [        R                  " [        5         [        R                  " XUS
9nS S S 5        O*[        R                  " XUS
9n[        R                  " XUS
9nUS:w  a&  US:w  a  US:X  a  [        R                  " WW5        g g g g ! , (       d  f       N= f! , (       d  f       NL= f)NrR   r  rS   r  rL   zs z dfzdf z sr   rx   r$   )r   rD   rV   rW   rX   r  r   r  r[  r   r#  r  r   r   r  )r   r3   r>   r  r   r  r  r{   r.  r[  rw   rF   rH   r   r   s                  r4   test_series_frame_commutativity-TestAlignment.test_series_frame_commutativity  sW    II!!!$44X>+B/!-b1

 '299((+;;A>bq	J2$clB4rlrxx))++N;GGCv> <++N;GGCv> <; 6:A6:A*"4"%%a+ # #5 <;;;s   FF
F
F&c                   SnSn	SU	-  n
[        [        R                  R                  S5      R	                  X45      Xs   " U	5      Xt   " U5      S9n[        [        R                  R                  S5      R	                  X45      Xu   " U
5      Xv   " U5      S9nUR
                  n[        [        R                  R                  S5      R	                  U5      US U 5      nUS:X  d  US:X  a  US:X  a  UR                  U5      nO	X-   nOX-   nUS:X  d  US:X  a  US:X  a  UR                  U5      nO	X-   nOX-   n[        UR                  UR                  UR                  5      (       a9  [        R                  " [        5         [        R                  " SXS9nS S S 5        O[        R                  " SXS9nWR                  UR                  :X  d   e[        R                   " UU5        g ! , (       d  f       NB= f)	Nr   rL   rR   r  rx   r$   zdf2 + ser + dfr   )r   rD   rV   rW   rX   rX  r   r  r  r[  r   r#  r  r   r   r@  r  )r   r3   r>   r  r  r  r  r{   rc   m1m2r.  r  r[  ser	expected2r   r   s                     r4   #test_complex_series_frame_alignment1TestAlignment.test_complex_series_frame_alignment  s    VII!!!$44bW=#B'!%a(

 II!!!$44bW=#B'!%a(

 RYY**1-==a@%)L:t"GGCL	I		I:t"$==,$> ~Hsyy#))RXX66++N;gg.vM <; ''*6ICyyHNN***
c8, <;s   G--
G;c                X   [        [        R                  R                  S5      R	                  S5      5      n[        [        R                  R                  S5      R	                  S5      5      nUS:X  a  [        nOSn[        R                  " U5         [        R                  " SXS9  S S S 5        [        [        R                  R                  S5      R	                  S5      5      n[        R                  " S5         [        R                  " SXS9  S S S 5        [        [        R                  R                  S5      R	                  S	5      5      n[        [        R                  R                  S5      R	                  S5      5      n[        R                  " S5         [        R                  " SXS9  S S S 5        [        [        R                  R                  S5      R	                  S
5      5      n[        [        R                  R                  S5      R	                  S5      5      nUS:H  nU(       d  [        nOSn[        R                  " U5       n[        R                  " SXS9  U(       dg  [        U5      S:X  d   e[        US   R                  5      n	[        R                  " UR                  UR                   S   -
  5      n
SU
S S3nX:X  d   eS S S 5        g ! , (       d  f       GNB= f! , (       d  f       GN= f! , (       d  f       GNY= f! , (       d  f       g = f)NrR   )  rS   '  r$   Fr  r   r  )rS   r  r  r   rU   r   z_Alignment difference on axis 1 is larger than an order of magnitude on term 'df', by more than z.4gz; performance may suffer.)r   rD   rV   rW   rX   r   r	   r   r#  r   r   lenrB   messagelog10r   r@  )r   r3   r>   r.  rw   seenis_python_enginewrnwr   loggedr   s               r4   +test_performance_warning_for_poor_alignment9TestAlignment.test_performance_warning_for_poor_alignment  sE   ryy,,Q/??
KL299((+;;EBCY%DD''-GGHV; . 299((+;;DAB''.GGHV; / ryy,,Q/??LM299((+;;EBC''.GGHV; / ryy,,Q/??IJ299((+;;EBC!X-$CC'',GGHV;#1v{"{!A$,,'!&&288A;"67$$*3</HJ 
 & -,- .- /.
 /. -,s1   K%?K7!L	BL%
K47
L	
L
L)rz   N)ri  rj  rk  rl  index_typeslhs_index_typesr  r,   r.   filterwarningsrm  r  r  r  r  listr   r  r  r  r  rt  rz   r<   r4   r  r    s`   "K!SE)O, [[ 89[[]O<[[]K8[[\;7- 8 9 = :-* [[\?;[[\?;- < <-& [[ 89[[T?3[[T;/[[T;/[[T;/3 0 0 0 4 :
32 [[ 89[[\GY+?@[[\;7[[\?;- < 8 A :-. [[\GY+?@[[ Wc3Z#s,-> [[ 89!- :	 A!-F [[ 89[[\;7[[\?;[[\GY+?@[[TC:., / A < 8 :
,4 [[ 89[[T?3[[T;/[[T;/[[T;/)- 0 0 0 4 :
)-V*'r<   r  c            
         \ rS rSrS rS r\R                  R                  SSS/5      \R                  R                  SSS/5      \R                  R                  S\	R                  5      S	 5       5       5       r\R                  R                  SSS/5      \R                  R                  SSS/5      \R                  R                  S\	R                  5      S
 5       5       5       rS rS rS rS rS rS rS rS rS rS rS rS rS rS rS rS rS r\R                  R=                  SS9S 5       rS r S  r!S! r"S" r#S# r$S$ r%S% r&\R                  R                  S&S'S(S'S)/\'RP                  " / 5      S*/5      S+ 5       r)\R                  R                  S&/ S,Q5      S- 5       r*\R                  R                  S.S'S(S'S)/\'RP                  " / 5      S*S'S)0/5      S/ 5       r+S0 r,S1 r-S2 r.S3 r/S4 r0S5 r1\R                  R                  S6/ S7Q5      S8 5       r2\R                  R                  S9S:S;/5      S< 5       r3S=r4g>)?TestOperationsi/  c                ^    UR                  SS5      S-   US'   [        R                  " U0 UD6$ Nlevelr   rU   popr   r   r   r  kwargss      r4   r   TestOperations.eval0  /     **Wa014www'''r<   c                p   / nUS:X  a  SS/n[         R                  [         R                  -    Vs/ s H  nXC;  d  M
  UPM     nnS U 5       nU H  nSU S3nSU S3nSU S3n	US	;   a;  S
n
[        R                  " [
        U
S9   [        R                  " XqUS9  S S S 5        MV  [        SUSU5      nU R                  XqUS9nX:X  d   e[        XSU5      nU R                  USU0XS9nX:X  d   e[        SXLS-   U5      nU R                  U	SU0XS9nX:X  a  M   e   g s  snf ! , (       d  f       M  = f)Nr   r   r   c              3  4   #    U  H  oS :w  d  M
  Uv   M     g7f)z//Nrz   )r2   r   s     r4   r5   7TestOperations.test_simple_arith_ops.<locals>.<genexpr>?  s     4IbtrrIs   		z1 z 1zx z (x + 1)r   z&argument of type 'int' is not iterabler   r   rU   r   r   )	r   r   ro  r,   r   r   r   r   rK   )r   r3   r>   exclude_arithr   	arith_opsopsr   r   r   r   expecr   ys                 r4   test_simple_arith_ops$TestOperations.test_simple_arith_ops4  sb   X!8,M ))D,=,==
=& = 	 
 5I4BbTBrd"+Crd(#C%%>]]9C8GGBf= 98 )B6:IIbI?z!z(6:IIcsAhvIUz!z(BAv>IIcsAhvIUz!z) 
 98s   	D!D!D&&
D5	rH   TFrF   r   c                   U SU SU 3n[         S:X  a<  US;   a6  Sn[        R                  " [        US9   U R	                  U5        S S S 5        g U R	                  U5      n[	        U5      nXg:X  d   eg ! , (       d  f       g = fNr  r   r   r   r   r>   r,   r   r   r   r   rH   rF   r   r   r   r   rE  s           r4   test_simple_bool_ops#TestOperations.test_simple_bool_opsW  |     uAbT3% X""56C2#>		" ?iim2hzz ?>   A55
Bc                   U SU SU 3n[         S:X  a<  US;   a6  Sn[        R                  " [        US9   U R	                  U5        S S S 5        g U R	                  U5      n[	        U5      nXg:X  d   eg ! , (       d  f       g = fr  r  r  s           r4   test_bool_ops_with_constants+TestOperations.test_bool_ops_with_constantsg  r  r  c                \   [         R                  R                  S5      R                  S5      n[	        [         R                  R                  S5      R                  S5      5      nSn[
        R                  " [        US9   U R                  SXS.S9  S S S 5        g ! , (       d  f       g = f)	NrR   )r   r  rL      rS   z?N-dimensional objects, where N > 2, are not supported with evalr   x + yr   r  r   )	rD   rV   rW   rX   r   r,   r   r   r   )r   r   r  r   s       r4   test_4d_ndarray_fails$TestOperations.test_4d_ndarray_failsw  sx    II!!!$44\B299((+;;B?@O]].c:IIg*:I; ;::s   B
B+c                6    U R                  S5      nUS:X  d   eg )N1rU   )r   )r   r   s     r4   test_constantTestOperations.test_constant~  s    IIcNAvvr<   c                    [        [        R                  R                  S5      R	                  S5      5      nU R                  SSU0S9n[        R                  " X5        g )NrR   rS   rR   r.  r  r   rD   rV   rW   rX   r   r   r  )r   r.  r  s      r4   test_single_variable#TestOperations.test_single_variable  sJ    ryy,,Q/??HIii$i4
b&r<   c                    [        [        R                  R                  S5      R	                  S5      5      n[
        R                  " [        SS9   U R                  S5        S S S 5        g ! , (       d  f       g = f)NrR   r~  name 'x' is not definedr   zdf[x > 2] > 2)	r   rD   rV   rW   rX   r,   r   	NameErrorr   r   r.  s     r4   &test_failing_subscript_with_name_error5TestOperations.test_failing_subscript_with_name_error  sN    ryy,,Q/??GH]]9,EFIIo& GFFs   A,,
A:c                    [        [        R                  R                  S5      R	                  S5      5      nU R                  SSU0S9nUS-   US:     n[        R                  " X#5        g )NrR   r~  z(df + 1)[df > 2]r.  r  rU   r  r7  s       r4   test_lhs_expression_subscript,TestOperations.test_lhs_expression_subscript  s]    ryy,,Q/??GH-4*EFBF#
f/r<   c           	        [        [        R                  R                  S5      R	                  S5      [        S5      S9nSnUR                  UR                  :  nSnUR                  UR                  -   UR                  -   nSnUR                  UR                  -   UR                  UR                  S:     -   nX$U4nX5U4n	[        X5       H+  u  p[        R                  " XR                  U
S	U0S
95        M-     g )NrR   r~  abcrW  zdf.a < df.bzdf.a + df.b + df.czdf.a + df.b + df.c[df.b < 0]r   r.  r  )r   rD   rV   rW   rX   r  r   r   rI   zipr   r  r   )r   r.  expr1expec1expr2expec2expr3expec3exprsexpecsrJ   r  s               r4   test_attr_expression#TestOperations.test_attr_expression  s    II!!!$44V<d5k
 $rtt#.rttBDD1H~-e#'E*HA""5))A4*)*MN +r<   c                   [        [        R                  R                  S5      R	                  S5      [        S5      S9n[        [        R                  R                  S5      R	                  S5      5      nSnSn[        R                  " [        US9   U R                  X1US.S	9  S S S 5        g ! , (       d  f       g = f)
NrR   r~  r  rW  zdf = df2%cannot assign without a target objectr   )r.  r  r  )
r   rD   rV   rW   rX   r  r,   r   rA   r   )r   r.  r  r  r   s        r4   test_assignment_fails$TestOperations.test_assignment_fails  s    II!!!$44V<d5k
 		--a0@@HI5]]:S1IIe#(>I? 211s   B00
B>c                
   [        [        R                  R                  S5      R	                  S5      [        S5      S9n[        R                  " [        SS9   UR                  S5        S S S 5        g ! , (       d  f       g = f)NrR   r   abrW  invalid syntaxr   zd c = a + b
r   rD   rV   rW   rX   r  r,   r   rZ  r   r  s     r4   %test_assignment_column_multiple_raise4TestOperations.test_assignment_column_multiple_raise  sY    II!!!$44V<d4j
 ]];.>?GGM" @??s   A44
Bc                   [        [        R                  R                  S5      R	                  S5      [        S5      S9nSn[        R                  " [        US9   UR                  S5        S S S 5        g ! , (       d  f       g = f)NrR   r   r)  rW  z5left hand side of an assignment must be a single namer   zd,c = a + br+  r]  s      r4   %test_assignment_column_invalid_assign4TestOperations.test_assignment_column_invalid_assign  s]    II!!!$44V<d4j
 F]];c2GGM" 322   A66
Bc                   [        [        R                  R                  S5      R	                  S5      [        S5      S9nSn[        R                  " [        US9   UR                  S5        S S S 5        g ! , (       d  f       g = f)NrR   r   r)  rW  zcannot assign to function callr   zTimestamp("20131001") = a + br+  r]  s      r4   3test_assignment_column_invalid_assign_function_callBTestOperations.test_assignment_column_invalid_assign_function_call  s]    II!!!$44V<d4j
 /]];c2GG34 322r1  c                
   [        [        R                  R                  S5      R	                  S5      [        S5      S9nUR                  5       nUS   US   -   US'   UR                  SSS	9  [        R                  " X5        g )
NrR   r   r)  rW  r   r   	a = a + bTinplace
r   rD   rV   rW   rX   r  copyr   r   r  r   r.  r   s      r4   &test_assignment_single_assign_existing5TestOperations.test_assignment_single_assign_existing  p    II!!!$44V<d4j
 779 5
T*
b+r<   c                
   [        [        R                  R                  S5      R	                  S5      [        S5      S9nUR                  5       nUS   US   -   US'   UR                  SS	S
9  [        R                  " X5        g )NrR   r   r)  rW  r   r   rI   	c = a + bTr7  r9  r;  s      r4   !test_assignment_single_assign_new0TestOperations.test_assignment_single_assign_new  r>  r<   c                (   [        [        R                  R                  S5      R	                  S5      [        S5      S9nUR                  5       nSnUR                  SSS9  UR                  5       nSUS	   -   US
'   [        R                  " X5        g )NrR   r   r)  rW  rU   z	a = 1 + bTr7  r   r   r9  )r   r.  r   r   s       r4   +test_assignment_single_assign_local_overlap:TestOperations.test_assignment_single_assign_local_overlap  s|    II!!!$44V<d4j
 WWY
T*779HSM)
b+r<   c                R   [        [        R                  R                  S5      R	                  S5      [        S5      S9nSnUR                  R                  5       nUR                  SSS9  X1R                  -   n[        R                  " XAR                  S	S
9  UR                  b   eg )NrR   r   r)  rW  rU   r6  Tr7  Fr2  )r   rD   rV   rW   rX   r  r   r:  r   r   r   r  r\  )r   r.  r   old_ar   s        r4   "test_assignment_single_assign_name1TestOperations.test_assignment_single_assign_name  s    II!!!$44V<d4j
 		
T*
vtt?{{"""r<   c                .   [        [        R                  R                  S5      R	                  S5      [        S5      S9nUR                  SSS9  Sn[        R                  " [        US	9   UR                  S
5        S S S 5        g ! , (       d  f       g = f)NrR   r   r)  rW  r@  Tr7  z#can only assign a single expressionr   z	c = a = b)
r   rD   rV   rW   rX   r  r   r,   r   rZ  r]  s      r4   test_assignment_multiple_raises.TestOperations.test_assignment_multiple_raises  sl    II!!!$44V<d4j
 	T*3]];c2GGK  322s   +B
Bc                   [        [        R                  R                  S5      R	                  S5      [        S5      S9nU R                  SSU0USS9  UR                  5       nUS	   US
   -   US'   [        R                  " X5        g )NrR   r   r)  rW  zc = df.a + df.br.  T)r   targetr8  r   r   rI   
r   rD   rV   rW   rX   r  r   r:  r   r  r;  s      r4   test_assignment_explicit'TestOperations.test_assignment_explicit  sy    II!!!$44V<d4j
 			#r
2t	T779 5
b+r<   c                    [        S/S/S.5      nUR                  S5      n[        S/5      n[        R                  " X#SS9  g )N   ir   r   za in [11, -32]TFr2  )r   r   r   r   r  r7  s       r4   test_column_inTestOperations.test_column_in  sA    bT./)*4&> 	vUCr<   z%Unknown: Omitted test_ in name prior.r(   c                   [        [        R                  R                  S5      R	                  S5      [        S5      S9nUR                  SSS9nUc   eUR                  5       nUS   US	   -   US
'   [        R                  " X5        g )NrR   r   r)  rW  r@  Fr7  r   r   rI   rO  )r   r.  actualr   s       r4   test_assignment_not_inplace*TestOperations.test_assignment_not_inplace  s     II!!!$44V<d4j
 e4!!!779 5
b+r<   c                   [        / SQ/ SQS.5      nUR                  5       nUS   US   -   US'   US   US   -   US'   UR                  SS	S
9n[        R                  " X25        Ub   eUS   S-
  US'   US   S-   US'   UR                  SS	S
9n[        R                  " X25        Ub   eSn[
        R                  " [        US9   UR                  SSS
9  S S S 5        g ! , (       d  f       g = f)NrU   rR   r   r  rL   r  rT  r   r   rI   d$
        c = a + b
        d = c + bTr7  rU   rR   rJ   $
        a = a - 1
        e = a + 2z@Multi-line expressions are only valid if all expressions containr   z(
            a = b + 2
            b - 2F)r   r:  r   r   r  r,   r   rA   )r   warn_copy_on_writer.  r   answerr   s         r4   test_multi_line_expression)TestOperations.test_multi_line_expression  s   YY78779 5 5 	  
 	h+~~ ) ) 	  
 	h+~~ Q]]:S1GG 	   211s   C  
C.c                D   [        / SQ/ SQS.5      nUR                  5       nUS   US   -   US'   US   US   -   US'   UR                  SS	S
9n[        R                  " X!5        US   S-
  US'   US   S-   US'   UR                  SS	S
9n[        R                  " X!5        g )Nr\  r]  rT  r   r   rI   r^  r_  Fr7  rU   rR   rJ   r`  r   r:  r   r   r  r;  s      r4   &test_multi_line_expression_not_inplace5TestOperations.test_multi_line_expression_not_inplace@  s    YY78779 5 5WW 	  
 	h+ ) )WW 	  
 	h+r<   c                    [        / SQ/ SQS.5      nUR                  5       nSnUS   U-  US'   US   U-   US'   UR                  SS	S
9n[        R                  " X!5        Ub   eg )Nr\  r]  rT  r  r   rI   r^  z?
        c = a * @local_var
        d = c + @local_var
        Tr7  rf  )r   r.  r   	local_varrb  s        r4   )test_multi_line_expression_local_variable8TestOperations.test_multi_line_expression_local_variableY  s|    YY78779	 	1 	1   
 	h+~~r<   c                    [        / SQ/ SQS.5      nS nUR                  5       nUS   U" SS5      -  US'   US   U" SS5      -   US	'   UR                  S
SS9n[        R                  " X15        Ub   eg )Nr\  r]  rT  c                    U$ r8   rz   rT  s     r4   
local_funcUTestOperations.test_multi_line_expression_callable_local_variable.<locals>.local_funco      Hr<   r   rU   r  rI   r^  zM
        c = a * @local_func(1, 7)
        d = c + @local_func(1, 7)
        Tr7  rf  r   r.  ro  r   rb  s        r4   2test_multi_line_expression_callable_local_variableATestOperations.test_multi_line_expression_callable_local_variablek  s    YY78	 779 
1a(88 
1a(88   
 	h+~~r<   c                    [        / SQ/ SQS.5      nS nUR                  5       nUS   U" SSS9-  US	'   US	   U" SSS9-   US
'   UR                  SSS9n[        R                  " X15        Ub   eg )Nr\  r]  rT  c                    U$ r8   rz   rT  s     r4   ro  aTestOperations.test_multi_line_expression_callable_local_variable_with_kwargs.<locals>.local_func  rq  r<   r   r  rU   )r   r   rI   r^  zU
        c = a * @local_func(b=7, a=1)
        d = c + @local_func(b=7, a=1)
        Tr7  rf  rr  s        r4   >test_multi_line_expression_callable_local_variable_with_kwargsMTestOperations.test_multi_line_expression_callable_local_variable_with_kwargs  s    YY78	 779 
Q!(<< 
Q!(<<   
 	h+~~r<   c                    [        / SQ/ SQS.5      nUR                  5       nSn[        R                  " [        US9   UR                  S5        S S S 5        [        R                  " X5        g ! , (       d  f       N%= f)Nr\  r]  rT  r%  r   za = 1)r   r:  r,   r   rA   rL  r   r  )r   r.  df_origr   s       r4   test_assignment_in_query'TestOperations.test_assignment_in_query  sW    YY78'')5]]:S1HHW 2
b* 21s   A//
A=c                   [        / SQ/ SQS.5      nUR                  5       nX"S   S:H     nUR                  SSS9  [        R                  " X!5        0 nSS	0nU R                  S
USS9  [        R                  " X5        g )Nr\  r]  rT  r   rR   za == 2Tr7  r   	a = 1 + 2rN  r8  )r   r:  rL  r   r  r   assert_dict_equalr;  s      r4   test_query_inplace!TestOperations.test_query_inplace  sy    YY78779SMQ./
4(
h+8		+b$	7
R*r<   invalid_targetrU   catrR   rU   r   c                <   SnSn[         R                  " [        US9   U R                  X1SS9  S S S 5        [	        US5      (       a3  [         R                  " [        US9   U R                  X1SS9  S S S 5        g g ! , (       d  f       NS= f! , (       d  f       g = f)Nz)Cannot assign expression output to targetr  r   Tr  r:  F)r,   r   rA   r   hasattrr   r  r   
expressions       r4   test_cannot_item_assign&TestOperations.test_cannot_item_assign  s{    9 
]]:S1IIjIF 2 >6**z5		*U	K 65 + 21 65s   A<!B<
B

B)rU   r  r  c                    SnSn[         R                  " [        US9   U R                  X1SS9  S S S 5        g ! , (       d  f       g = f)Nz"Cannot return a copy of the targetr  r   Fr  )r,   r   rA   r   r  s       r4   test_cannot_copy_item$TestOperations.test_cannot_copy_item  s6    2 
]]:S1IIjIG 211s	   8
ArN  c                    SnU R                  X!SS9S:X  d   eSn[        R                  " [        US9   U R                  X!SS9  S S S 5        g ! , (       d  f       g = f)N1 + 2Fr  r   z0Cannot operate inplace if there is no assignmentr   T)r   r,   r   rA   )r   rN  r  r   s       r4   test_inplace_no_assignment)TestOperations.test_inplace_no_assignment  sQ    
yyEyBaGGG@]]:S1IIjI> 211s   A
Ac           	        [        [        R                  R                  S5      R	                  S5      [        SSSS9S9nUS:  nU R                  SSU0S	9nUS:  n[        R                  " X25        [        R                  " XB5        g )
NrR   rR   rR   ro   rt   ru   rq   rW  r  r.  r  	r   rD   rV   rW   rX   r   r   r   r  )r   r.  rJ   rr   s        r4   *test_basic_period_index_boolean_expression9TestOperations.test_basic_period_index_boolean_expression  s{    II!!!$44V< CC
 FIIhD":I6F
a#
a#r<   c           	         [        [        R                  R                  S5      R	                  S5      [        SSSS9S9nU R                  SSU0S	9nXS
:     n[        R                  " X#5        g )NrR   r  ro   rt   r  rW  zdf[df < 2 + 3]r.  r  rL   r  r   r.  r  rJ   s       r4   ,test_basic_period_index_subscript_expression;TestOperations.test_basic_period_index_subscript_expression  sg    II!!!$44V< CC
 II&D":I>EzN
a#r<   c           	         [        [        R                  R                  S5      R	                  S5      [        SSSS9S9nU R                  SSU0S	9nXUS:     S:     US-  -   n[        R                  " X#5        g )
NrR   r  ro   rt   r  rW  zdf[df[df < 2] < 2] + df * 2r.  r  r  r  s       r4   -test_nested_period_index_subscript_expression<TestOperations.test_nested_period_index_subscript_expression  sy    II!!!$44V< CC
 II3r
IK"q&zA~a'
a#r<   c                    [        [        R                  R                  S5      R	                  S5      5      n[        SSS9US'   U R                  SSU0UUS	9nUR                  S
:  n[        R                  " XESS9  g )NrR   r~  z1/1/2012rL   rp   dates1zdf.dates1 < 20130101r.  r   20130101Fr2  )
r   rD   rV   rW   rX   r   r   r  r   r  )r   r3   r>   r.  r   r  s         r4   test_date_boolean TestOperations.test_date_boolean  sy    ryy,,Q/??GH!*a88ii"bz	  
 		J&
su=r<   c                   US:w  Ga-  [         R                  " SXS9nU(       d   e[         R                  " SXS9nU(       d   e[         R                  " SXS9nU(       a   e[         R                  " SXS9nU(       d   e[         R                  " SXS9nU(       d   e[         R                  " SXS9nU(       d   e[         R                  " S	XS9nU(       d   e[         R                  " S
XS9nU(       d   e[         R                  " SXS9nU(       a   e[         R                  " SXS9nU(       d   eg Sn[        R                  " [        US9   [         R                  " SXS9  S S S 5        [        R                  " [        US9   [         R                  " SXS9  S S S 5        [        R                  " [        US9   [         R                  " SXS9  S S S 5        [        R                  " [        US9   [         R                  " SXS9  S S S 5        Sn[        R                  " [        US9   [         R                  " SXS9  S S S 5        [        R                  " [        US9   [         R                  " SXS9  S S S 5        g ! , (       d  f       GN%= f! , (       d  f       GN = f! , (       d  f       N= f! , (       d  f       N= f! , (       d  f       N= f! , (       d  f       g = f)Nr   z1 in [1, 2]r   z2 in (1, 2)z3 in (1, 2)z3 not in (1, 2)z[3] not in (1, 2)z[3] in ([3], 2)z[[3]] in [[[3]], 2]z(3,) in [(3,), 2]z(3,) not in [(3,), 2]z[(3,)] in [[(3,)], 2]z'In' nodes are not implementedr   z[(3,)] in (1, 2, [(3,)])z!'NotIn' nodes are not implementedz[3] not in (1, 2, [[3]]))r   r   r,   r   r   )r   r3   r>   r   r   s        r4   test_simple_in_ops!TestOperations.test_simple_in_ops  s   X''-FCJ3''-FCJ3''-FCN7''+FJCJ3''-fLCJ3''+FJCJ3''/NCJ3''-fLCJ3''1&PCN7''1&PCJ32C2#>fD ?2#>fD ?2#>fD ?2#>26Q ?5C2#>)&H ?2#>26Q ?> ?>>>>>>> ?>>>sH   JJ>J(5J9.K
%K
J
J%(
J69
K

K
K)c                f    SnSR                  S5      nSn[        R                  " XAUS9nXe:X  d   eg )NrU   z * !aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaar   )r   r   r   )r   r3   r>   r   r   r   r   s          r4   test_check_many_exprs$TestOperations.test_check_many_exprs!  s4    zz(#ggd&9r<   r   )zdf > 2 and df > 3zdf > 2 or df > 3z
not df > 2c                ^   [        [        R                  R                  S5      R	                  S5      5      nUS:X  aF  SnSU;   a  Sn[
        R                  " [        US9   [        R                  " USU0UUS	9  S S S 5        g [        R                  " USU0UUS	9  g ! , (       d  f       g = f)
NrR   r~  r   r   not'Not' nodes are not implementedr   r.  )r   r>   r3   
r   rD   rV   rW   rX   r,   r   r   r   r   )r   r   r3   r>   r.  r   s         r4   test_fails_and_or_not$TestOperations.test_fails_and_or_not(  s     ryy,,Q/??GHX6C}72#> $bz!!	 ?> GG ":	 ?>s   !B
B,charr   r   c                J   [        [        R                  R                  S5      R	                  S5      5      nSU S3nUS:X  a:  Sn[
        R                  " [        US9   [        R                  " XSUS9  S S S 5        g [        R                  " XSUS9  g ! , (       d  f       g = f)	NrR   r~  z(df + 2)[df > 1] > 0 z	 (df > 0)r   z$cannot evaluate scalar only bool opsr   r  r  )r   r  r3   r>   r.  r   r   s          r4   test_fails_ampersand_pipe(TestOperations.test_fails_ampersand_pipeG  s    ryy,,Q/??GH$TF)4X8C2#>&9 ?> GGBf5	 ?>s   B
B"rz   N)5ri  rj  rk  rl  r   r  r,   r.   rm  r   rn  r  r  r  r  r  r  r  r"  r&  r,  r/  r3  r<  rA  rD  rH  rK  rP  rU  r   rY  rc  rg  rk  rs  rx  r|  r  rD   r   r  r  r  r  r  r  r  r  r  r  r  rt  rz   r<   r4   r  r  /  s   (!"F [[UT5M2[[UT5M2[[T4#5#56 7 3 3 [[UT5M2[[UT5M2[[T4#5#56 7 3 3<'
'
0O@##5,,
,
#!,D [[EF, G,#J,2$((++ [[-51a&"((2,PV/WX	L Y	L [[-/ABH CH [[X51a&"((2,QRTUPV'WX? Y?
$$$
>-R^ [[	
. [[Vc3Z0	6 1	6r<   r  c                  X   \ rS rSrS r\R                  R                  \(       + SS9\R                  R                  S\
5      S 5       5       r\R                  R                  S\5      S 5       rS rS	 r\R                  R                  S
\R"                  \R$                  4\R&                  \R$                  4\R(                  \R(                  4\R$                  \R$                  4\R*                  " \R,                  \R,                  \R0                  S9/5      S 5       rS rS rSrg)TestMathiT  c                ^    UR                  SS5      S-   US'   [        R                  " U0 UD6$ r  r  r  s      r4   r   TestMath.evalU  r  r<   z&Unary ops only implemented for numexprr(   fnc                n   [        S[        R                  R                  S5      R	                  S5      05      nUR
                  nU S3nU R                  U5      n[        R                  " SS9   [        [        U5      " U5      nS S S 5        [        R                  " UWSS9  g ! , (       d  f       N%= f)	Nr   rR   rS   z(a)r%   allFr2  )r   rD   rV   rW   rX   r   r   errstater  r   r  )r   r  r.  r   r   gotr  s          r4   test_unary_functionsTestMath.test_unary_functionsY  s    
 RYY2215EEbIJKDDSziio[[X&R_Q'F '
sF> '&s   0B&&
B4c                   [        [        R                  R                  S5      R	                  S5      [        R                  R                  S5      R	                  S5      S.5      nUR
                  nUR                  nU S3nU R                  U5      n[        R                  " SS9   [        [        U5      " X45      nS S S 5        [        R                  " UWSS9  g ! , (       d  f       N%= f)	NrR   rS   rT  z(a, b)r%   r  Fr2  )r   rD   rV   rW   rX   r   r   r   r  r  r   r   )r   r  r.  r   r   r   r  r  s           r4   test_binary_functionsTestMath.test_binary_functionsg  s    YY**1-==bAYY**1-==bA
 DDDDV}iio[[X&R_Q*F '
sF> '&s   )C
C-c                   [        [        R                  R                  S5      R	                  S5      [        R                  R                  S5      R	                  S5      S.5      nUR                  SUUSS9  UR                  n[        R                  " [        R                  " UR                  5      UR                  5      n[        R                  " XESS9  g )	NrR   rS   rT  ze = arctan2(sin(a), b)Tr3   r>   r8  Fr2  )r   rD   rV   rW   rX   r   rJ   arctan2sinr   r   r   r  r   r3   r>   r.  r  r  s         r4   test_df_use_caseTestMath.test_df_use_casex  s    YY**1-==bAYY**1-==bA
 	$	 	 	
 ddBFF244L"$$/
s>r<   c                   [        [        R                  R                  S5      R	                  S5      [        R                  R                  S5      R	                  S5      S.5      nUR                  SXSS9  UR                  n[        R                  " UR                  UR                  -   5      n[        R                  " XESS9  g )	NrR   rS   rT  ze = sin(a + b)Tr  Fr2  )r   rD   rV   rW   rX   r   rJ   r  r   r   r   r  r  s         r4    test_df_arithmetic_subexpression)TestMath.test_df_arithmetic_subexpression  s    YY**1-==bAYY**1-==bA
 	 Mddrtt$
s>r<   zdtype, expect_dtyper*   c                   [        S[        R                  R                  S5      R	                  S5      R                  U5      05      nUR                  R                  U:X  d   eUR                  SX4SS9  UR                  n[        R                  " UR                  5      nUR                  UR                  :X  d   eX&R                  :X  d   e[        R                  " XgSS9  g )	Nr   rR   rS   z
b = sin(a)Tr  Fr2  )r   rD   rV   rW   rX   r   r   r_   r   r   r  r   r  )r   r_   expect_dtyper3   r>   r.  r  r  s           r4   test_result_typesTestMath.test_result_types  s      "))''*::2>EEeLM
 ttzzU"""
VDIdd||syy(((yy(((
s>r<   c                    [        S[        R                  R                  S5      R	                  S5      05      nSn[
        R                  " [        US9   UR                  SXS9  S S S 5        g ! , (       d  f       g = f)Nr   rR   rS   z#"mysin" is not a supported functionr   zmysin(a)r   )	r   rD   rV   rW   rX   r,   r   rA   r   r   r3   r>   r.  r   s        r4   test_undefined_funcTestMath.test_undefined_func  sZ    RYY2215EEbIJK3]]:S1GGJvG= 211   A//
A=c                    [        S[        R                  R                  S5      R	                  S5      05      nSn[
        R                  " [        US9   UR                  SXS9  S S S 5        g ! , (       d  f       g = f)Nr   rR   rS   z1Function "sin" does not support keyword argumentsr   zsin(x=a)r   )	r   rD   rV   rW   rX   r,   r   r   r   r  s        r4   test_keyword_argTestMath.test_keyword_arg  sZ    RYY2215EEbIJKA]]9C0GGJvG= 100r  rz   N)ri  rj  rk  rl  r   r,   r.   r/   r   rm  r!   r  r   r  r  r  rD   int32rg   ra   float32r-   
complex128r0   rs  r  r  r  rt  rz   r<   r4   r  r  T  s   ( [[&N   [[T?3? 4? [[T#34? 5? ?"
? [[XXrzz"XXrzz"ZZ$ZZ$LLR=O=OP	
	?	?">>r<   r  rR   rS   c                  2    \ rS rSrS rS rS rS rS rSr	g)		TestScopei  c           	     j    Sn[         R                  " [        S-  [        R                  " X1US95        g )N
_var_s * 2rR   r   )r   r   _var_sr   r   )r   r3   r>   rJ   s       r4   test_global_scopeTestScope.test_global_scope  s)    
##QJ@	
r<   c                    Sn[        5       R                  5       n[        R                  " SXAUS9  [        5       R                  5       nUR	                  S5        XE:X  d   eg )NrU   x + 1r   lcls)localsr:  r   r   r  )r   r3   r>   r   r  lcls2s         r4   test_no_new_localsTestScope.test_no_new_locals  sG    x}}
DG		&}}r<   c                    Sn[        5       R                  5       n[        R                  " SXS9  [        5       R                  5       nXE:X  d   eg )NrU   r  r   )globalsr:  r   r   )r   r3   r>   r   gblsgbls2s         r4   test_no_new_globalsTestScope.test_no_new_globals  s;    y~~
6	 }}r<   c                    SnSn[         R                  " [        US9   [        R                  " SX0 S9  S S S 5        g ! , (       d  f       g = f)NrU   r  r   r  r   r,   r   r
   r   r   )r   r3   r>   r   r   s        r4   test_empty_localsTestScope.test_empty_locals  s7    ']]1=GGGFbI >==	   >
Ac                    SnSn[         R                  " [        US9   [        R                  " XAU0 S9  S S S 5        g ! , (       d  f       g = f)Nzname '_var_s' is not definedr  r   )r3   r>   global_dictr  )r   r3   r>   r   rJ   s        r4   test_empty_globalsTestScope.test_empty_globals  s7    ,]]1=GGAVD >==r  rz   N)
ri  rj  rk  rl  r  r  r  r  r  rt  rz   r<   r4   r  r    s    
JEr<   r  c                     Sn [         R                  " [        U S9   [        R                  " SSSS.SS9  S S S 5        g ! , (       d  f       g = f)	NzInvalid engine 'asdf' passedr   r   rU   rR   r  asdf)r   r3   r,   r   KeyErrorr   r   r   s    r4   test_invalid_enginer    6    
(C	xs	+
!!$4VD 
,	+	+	   ?
A)use_numexprr   ))Tr$   )Fr   c                    SSK Jn  [        R                  " SU 5         U" S 5      nX1:X  d   e S S S 5        g ! , (       d  f       g = f)Nr   )_check_enginecompute.use_numexpr)pandas.core.computation.evalr  r   option_context)r  r   r  r   s       r4   test_numexpr_option_respectedr    s:     ;			0+	>t$!!! 
?	>	>s	   8
Ac                     [         R                  " SS5         [        / SQ/ SQS.5      n U R                  S5      n[        S S /SS/S.S	S/S
9n[        R
                  " X5        S S S 5        g ! , (       d  f       g = f)Nr  F)TFTFNN)rU   rR   r   r  rL   r  )rI  Bz
A.isnull()rL   r  r  )r[  )r   r
  r   rL  r   r  )r.  r   r   s      r4   #test_numexpr_option_incompatible_opr    so     
		0%	88?QR
 ,'D$<q!f=aVL
f/ 
9	8	8s   AA..
A<c                     Sn [         R                  " [        U S9   [        R                  " SSSS.SS9  S S S 5        g ! , (       d  f       g = f)	NzInvalid parser 'asdf' passedr   r   rU   rR   r  r  )r   r>   r  r  s    r4   test_invalid_parserr    r  r  )r   r   r   z dict[str, type[BaseExprVisitor]]_parsersr3   r>   c                    [         U   nU" SX5      nUR                   H7  nSn[        R                  " [        US9   [        X45      " 5         S S S 5        M9     g ! , (       d  f       MK  = f)Nr  znodes are not implementedr   )r  unsupported_nodesr,   r   r   r  )r3   r>   VisitorClassinstr  r   s         r4   test_disallowed_nodesr    sX     F#L0D--)]].c:D  ;: .::s   A
A*	c                    Sn[         R                  " [        SS9   [        R                  " X US9  S S S 5        g ! , (       d  f       g = f)Nzs +r*  r   r   r,   r   rZ  r   r   )r3   r>   rJ   s      r4   test_syntax_error_exprsr  %  s0    A	{*:	;
0 
<	;	;	   ;
A	c                    SnSn[         R                  " [        US9   [        R                  " X US9  S S S 5        g ! , (       d  f       g = f)Nzs + tzname 's' is not definedr   r   )r,   r   r  r   r   )r3   r>   rJ   r   s       r4   test_name_error_exprsr  +  s4    A
#C	y	,
0 
-	,	,s	   =
Aexpress)za + @bz@a + bz@a + @bc                :   Su  p4US:w  a8  [         R                  " [        SS9   [        R                  " X US9  S S S 5        g [         R                  " [        SS9   [        R                  " X US9  S S S 5        g ! , (       d  f       g = f! , (       d  f       g = f)NrU   rR   r   zThe '@' prefix is onlyr   r   zThe '@' prefix is notr  )r3   r>   r  r   r   s        r4   %test_invalid_local_variable_referencer   2  ss    DA]];.FGGGG6: HG ]];.EFGGG6: GF HG GFs   A;B;
B	
Bc                    Su  p#U S:X  a:  Sn[         R                  " [        US9   [        R                  " SXS9  S S S 5        g [        R                  " SXS9nXRU-   :X  d   eg ! , (       d  f       g = f)Nr  r$   zVariables in expression .+r   zsin + dotted_liner   )r,   r   r   r   r   )r3   r>   r  dotted_liner   r   s         r4   test_numexpr_builtin_raisesr#  >  sj    C*]]1=GG'F >= gg)&HK''''	 >=s   A%%
A3c                    Sn[         R                  " [        SS9   [        R                  " SX US9  S S S 5        g ! , (       d  f       g = f)N)*   g      @zResolver of type .+r   r  )	resolversr3   r>   )r,   r   r   r   r   )r3   r>   cannot_resolves      r4   test_bad_resolver_raisesr(  I  s2    N	y(=	>
>P 
?	>	>s	   <
A
c                    [         R                  " [        SS9   [        R                  " SXS9  S S S 5        g ! , (       d  f       g = f)Nzexpr cannot be an empty stringr    r   r,   r   rA   r   r   r   s     r4   test_empty_string_raisesr,  O  s,    	z)I	J
61 
K	J	J	   9
Ac                    [         R                  " [        SS9   [        R                  " SXS9  S S S 5        g ! , (       d  f       g = f)Nz#only a single expression is allowedr   z1 + 1; 2 + 2r   r  r   s     r4   $test_more_than_one_expression_raisesr/  U  s,    	{*O	P
v= 
Q	P	Pr-  cmpr   rF   rH   c                   [         S [        [        R                  R	                  S5      R
                  0nXP   " 5       nXP   " 5       n XR   " 5       nSU SU S3nSU SU S3nSU SU S	3n	XxU	4 H<  n
S
n[        R                  " [        US9   [        R                  " XUS9  S S S 5        M>     g ! , (       d  f       MP  = f)Nc                 ^    [         R                  R                  S5      R                  S5      $ )NrR   rS   )rD   rV   rW   r  rz   r<   r4   rd   0test_bool_ops_fails_on_scalars.<locals>.<lambda>_  s    RYY**1-66r:r<   rR   r   r   r   r   r   r   r   r<  r   r   )intrO   rD   rV   rW   rX   r,   r   r   r   r   )rF   r0  rH   r3   r>   genr   r   r   r   r   r   s               r4   test_bool_ops_fails_on_scalarsr6  Z  s    
 	:ryy$$Q'77C
 (*C
(*C
(*CU3%t
$C]3%t
,C#mC5
.CoK]].c:GGBf5 ;: ::s   B22
C	otherz'x'z...c                    [        S/ SQ0[        S9nUR                  SU  35      n[        / SQSS9n[        (       a  S Ul        [        R                  " X#5        g )NrI  )r   r   rI   r^   rK  )FFFr\  )r   objectr   r   r   r\  r   r  )r7  r.  r   r   s       r4   test_equals_variousr;  p  sR     
C)	8BWWuUG_%F+#6H{ 6,r<   c                `    Sn[         R                  n[        R                  " X US9nXC:X  d   eg )Nzinf + 1r   )rD   infr   r   )r3   r>   rw   r   r   s        r4   test_infr>    s,    AvvHWWQf5Fr<   columnu	   Temp(°C)u   Capacitance(μF)c                    [        [        R                  R                  S5      R	                  S5      US/S9nX"U   S:     nSU S3nUR                  X@S9n[        R                  " XS5        g )	NrR   r   r   rW  rL   `z` > 5)r3   )r   rD   rV   rW   rX   rL  r   r  )r3   r?  r.  r   query_stringr   s         r4   test_query_tokenrC    so     

		a 00863-
B V*q.!Hvhe$LXXlX2F&+r<   c                |   [        SS/SS//SS/S9nX"R                  S:  )    nUR                  SXS	9n[        R                  " XC5        US
:X  a5  Sn[
        R                  " [        US9   UR                  SXS	9  S S S 5        g UR                  SXS	9n[        R                  " XC5        g ! , (       d  f       g = f)Nr   rS   rU   r  r  countrW  z
~(cat > 0)r   r   r  r   znot (cat > 0))r   r  rL  r   r  r,   r   r   )r3   r>   r.  r   r   r   s         r4   test_negate_lt_eq_lerF    s    	QGaW%w/?	@BFFQJ- HXXl6XAF&+/]].c:HH_VHC ;: /&H
f/	 ;:s   ,B--
B;c                P   US;   a4  U R                  [        R                  R                  [        SU 3S95        [        [        R                  R                  S5      R                  SSSS9US	/S
9nX"U   S:     nUR                  U S35      n[        R                  " XC5        g )N)TrueFalser=  Infz+GH 47859 DataFrame eval not supported with )r   r)   rR   r   d   r
  r   col1rW  r  z>6)r   r,   r.   r   r   r   rD   rV   rW   r  rL  r   r  )r;   r?  r.  r   r   s        r4    test_eval_no_support_column_namerM    s     00KKDVHM  	
 

		a ))!Sw)? 
B V*q.!HXXm$F&+r<   c                   [        / SQ/ SQ/ SQS.5      nUS S  nUS   n[        R                  " U5         UR                  SSS9  S S S 5        [        / S	Q/ SQ/ SQS.5      n[        R                  " X%5        U (       d7  [        R
                  " XES   5        [        R
                  " US   US   5        g [        / SQSS
9n[        R
                  " XE5        [        R
                  " US   U5        g ! , (       d  f       N= f)Nr\  r]  )r     	   )rI  r  CrI  z	A = B + CTr7  )rS        r9  )r   r   assert_cow_warningr   r  r  r   )using_copy_on_writera  r.  result_viewr  r   s         r4   test_set_inplacerW    s     
C	DBQ%K
S'C			1	2
T* 
3|))LMH"'
sSM2
{3/#?)#.
s-
{3/: 
3	2s   C55
Dc                  d    \ rS rSr\R
                  R                  SSS/ SQS/5      S 5       rSrg	)
TestValidatei  valuerU   rH  r\  g      @c                    Sn[         R                  " [        US9   [        R                  " SUS9  S S S 5        g ! , (       d  f       g = f)Nz8For argument "inplace" expected type bool, received typer   z2+2r7  r+  )r   rZ  r   s      r4   test_validate_bool_args$TestValidate.test_validate_bool_args  s/    H]]:S1GGE5) 211r  rz   N)	ri  rj  rk  rl  r,   r.   rm  r\  rt  rz   r<   r4   rY  rY    s/    [[Wq&)S&AB* C*r<   rY  )p
__future__r   	functoolsr   	itertoolsr   r  numpyrD   r,   pandas.compatr   pandas.compat._optionalr   pandas.errorsr   r	   r
   pandas.util._test_decoratorsutil_test_decoratorsr0   pandas.core.dtypes.commonr   r   r   r   r   r   r   r   r   r   r   r   pandas._testing_testingr   pandas.core.computationr   r   pandas.core.computation.enginesr   pandas.core.computation.exprr   r   r   #pandas.core.computation.expressionsr   r   pandas.core.computation.opsr   r   r   r    r!   pandas.core.computation.scoper"   pandas.util.versionr#   r$   fixturer3   PARSERSr>   rK   r  rk   rF   rH   r   r{   r}   rv  r  r  r  r  rV   rW   rX   r  r  r1   r  r.   rm  r  r  r  PyTablesExprVisitorr  __annotations__r  r  r  r   r#  r(  r,  r/  r4  rO   r6  r;  r>  rC  rF  keysrM  rW  rY  rz   r<   r4   <module>rw     s   "       > 
 * )     4 
  : '
$Yx
@   !  t||$ % a>E	 
  _	W _	WL? ?<$S' S'tb6 b6Jh> h>V 
		q	!	1	1"	5"E "EJ yE E y" " y0 0 yE E  ,,.
*  7+8,! - ,!11 $CD; E;(Q2>
 .e-e-6 . . /6& -- K1C#DE, F,0  ,	,(;(* *r<   