
    4i%              %       >   S SK J r   S SKrS SKrS SKJr  S SKrS SKJ	r
  S SKJr  S SKJr  \R                  R!                  S\R"                  " S5      SS	/S
4\R"                  " S5      S	-  S	S/S4\R"                  " S5      R%                  5       SS/S4\R"                  " S5      S-   S	S/S4S\R"                  " S5      -   S	S/S4\R"                  " S5      S-
  S S/S4S\R"                  " S5      -
  S S/S4\R"                  " S5      S-  SS	/S4S\R"                  " S5      -  SS	/S4\R"                  " S5      S-  SS/S4S\R"                  " S5      -  SS/S4\R"                  " S5      S-  SS	/S4S\R"                  " S5      -  SS /S4\R"                  " S5      S-  S S /S4S\R"                  " S5      -  S S/S4\R"                  " S5      S:  SS /S!4\R"                  " S5      S:  S S /S"4\R"                  " S5      S:  SS/S#4\R"                  " S5      S:*  S S/S$4\R"                  " S5      S:H  S S/S%4\R&                  " \R"                  " S5      S	5      SS/S&4\R(                  " \R"                  " S5      \R"                  " S5      5      SS/S'4\R"                  " S5      S-   \R"                  " S(5      S	-   -  S)S*/S+4\R"                  " S5      S-
  R+                  S,5      SS /S-4\R"                  " S5      * SS./S/4\R"                  " S5      7SS	/S04\R"                  " S5      S-   * S.S1/S24\R"                  " S5      * S	-  S.S3/S44\" \R"                  " S5      5      SS	/S54\" \R"                  " S5      S	-
  5      SS /S64/5      S7\S8\\   S9\S:S4S; j5       rS\S< jrS\S= jrS\S> jrS\S? jr\R                  R!                  S\R"                  " S5      R>                  R@                  S@/SA4\R"                  " S5      R>                  RC                  SB5      SC/SD4\R"                  " S(5      R2                  RE                  5       SE/SF4/5      S7\S8\\   S9\S:S4SG j5       r#S\SH jr$S\SI jr%\R                  R!                  S\R"                  " S5      \R"                  " S(5      -  / SJQSK4\R"                  " S5      S -  / SLQSM4\R"                  " S5      \R"                  " S(5      -  / SNQSO4\R"                  " S5      S-  / SLQSP4\R"                  " S5      \R"                  " S(5      -  / SQQSR4\R"                  " S5      S -  / SSQST4\R"                  " S5      ) / SSQSU4/5      S7\S8\\&   S9\S:S4SV j5       r'S\SW jr(S\SX jr)S\SY jr*S\SZ jr+S\S[ jr,g)]    )datetimeN)cache_readonly)
Expression)ensure_removed)exprexpected_valuesexpected_stra      zcol('a')   zcol('a') * 2   zcol('a').sum()zcol('a') + 1z1 + col('a')zcol('a') - 1z1 - col('a')zcol('a') * 1z1 * col('a')g      ?       @zcol('a') / 1g      ?z1 / col('a')zcol('a') // 1z1 // col('a')zcol('a') % 1z1 % col('a')FTzcol('a') > 1zcol('a') >= 1zcol('a') < 1zcol('a') <= 1zcol('a') == 1zpower(col('a'), 2)zdivide(col('a'), col('a'))b
      z(col('a') + 1) * (col('b') + 2)boolz(col('a') - 1).astype('bool')z	-col('a')z	+col('a')z-(col('a') + 1)z(-col('a')) * 2zabs(col('a'))zabs(col('a') - 2)r   r   r	   returnc                     [         R                  " SS/SS/S.5      nUR                  U S9n[         R                  " SS/SS/US.5      n[        R                  " XE5        [        U 5      U:X  d   eg )Nr   r   r   r   r
   r   cr
   r   r   )pd	DataFrameassigntmassert_frame_equalstrr   r   r	   dfresultexpecteds         W/var/www/html/dynamic-report/venv/lib/python3.13/site-packages/pandas/tests/test_col.pytest_col_simpler)      sm    ^ 
QF!Q0	1BYYYF||1a&1vOLMH&+t9$$$    c                      [         R                  " SS/SS/S.5      n [         R                  " S5      S:H  nX   nU R                  S/   n[        R
                  " X#5        g )Nr   r   r   r   r   r
   )r   r   colilocr!   r"   r%   r   r&   r'   s       r(   test_frame_getitemr/   D   sS    	QF!Q0	1B66#;!DXFwws|H&+r*   c                      [         R                  " SS/SS/S.5      n [         R                  " S5      S:H  nU R                  5       nSX!'   [         R                  " SS/SS/S.5      n[        R
                  " X#5        g Nr   r   r   r   r   r
   d   )r   r   r,   copyr!   r"   r.   s       r(   test_frame_setitemr4   M   sj    	QF!Q0	1B66#;!DWWYFFL||1c(!S:;H&+r*   c                     [         R                  " SS/SS/S.5      n [         R                  " S5      S:H  nU R                  5       nSUR                  US4'   [         R                  " SS/SS/S.5      n[
        R                  " X#5        g )	Nr   r   r   r   r   r
   r2   r   )r   r   r,   r3   locr!   r"   r.   s       r(   test_frame_locr7   X   su    	QF!Q0	1B66#;!DWWYFFJJtSy||1a&3x89H&+r*   c                     [         R                  " SS/SS/S.5      n [         R                  " S5      S:H  nU R                  5       nSUR                  US4'   [         R                  " SS/SS/S.5      n[
        R                  " X#5        g r1   )r   r   r,   r3   r-   r!   r"   r.   s       r(   test_frame_ilocr9   b   su    	QF!Q0	1B66#;!DWWYFFKKa||1a&3x89H&+r*     zcol('a').dt.yearz%BJanuaryzcol('a').dt.strftime('%B')FOOzcol('b').str.upper()c                    [         R                  " [        SSS5      /S/S.5      nUR                  U S9n[         R                  " [        SSS5      /S/US.5      n[        R
                  " XESS9  [        U 5      U:X  d   eg )	Nr:   r   foor   r   r   F)check_dtype)r   r   r   r    r!   r"   r#   r$   s         r(   test_namespacesr@   l   s     
XdAq12%A	BBYYYF||a#$E7IH &>t9$$$r*   c                  H   [         R                  " SS/SS/S.5      n [        R                  " [        SS9   U R                  [         R                  " S5      R                  5       S	9  S S S 5        [         R                  " [        S
5       Vs0 s H
  nSU 3S/_M     sn5      n Sn [        R                  " [        US9   U R                  [         R                  " S5      R                  5       S	9  S S S 5        g ! , (       d  f       N= fs  snf ! , (       d  f       g = f)Nr   r   r   r   r   z(did you mean one of \['a', 'b'\] instead)matchr   r      col_r   zdid you mean one of \['col_0', 'col_1', 'col_2', 'col_3', 'col_4', 'col_5', 'col_6', 'col_7', 'col_8', 'col_9',\.\.\.\] instead)	r   r   pytestraises
ValueErrorr    r,   meanrange)r%   imsgs      r(   test_invalidrL      s    	QF!Q0	1B	z)T	U
		BFF3K$$&	' 
V	b	:	1aSzA3	:	;B	-  	z	-
		BFF3K$$&	' 
.	- 
V	U: 
.	-s   2C=D2D=
D
D!c                     [         R                  " S/ SQ05      n  " S S5      n[        [         R                  S5         [         R                  R
                  R                  S5      " U5        U R                  [         R                  " S5      R                  R                  5       S9nS S S 5        [         R                  " / SQ/ SQS.5      n[        R                  " WU5        g ! , (       d  f       NC= f)	Nr
   r   r   r   c                        \ rS rSrS rS rSrg))test_custom_accessor.<locals>.XYZAccessor   c                     Xl         g N_obj)self
pandas_objs     r(   __init__2test_custom_accessor.<locals>.XYZAccessor.__init__   s    "Ir*   c                 6    U R                   R                  5       $ rS   )rU   rH   )rV   s    r(   rH   .test_custom_accessor.<locals>.XYZAccessor.mean   s    99>>##r*   rT   N)__name__
__module____qualname____firstlineno__rX   rH   __static_attributes__ r*   r(   XYZAccessorrP      s    	#	$r*   rb   xyzr   )r   r   r   r   )r   r   r   Seriesapi
extensionsregister_series_accessorr    r,   rc   rH   r!   r"   )r%   rb   r&   r'   s       r(   test_custom_accessorri      s    	sI&	'B$ $ 
		5	)
2259+FRVVC[__1134 
* ||)/BCH&(+	 
*	)s   A+C''
C5)FFTFzcol('a') & col('b')TFTFzcol('a') & True)TTTTzcol('a') | col('b')zcol('a') | False)TTFTzcol('a') ^ col('b'))FTFTzcol('a') ^ Truez	~col('a')c                 8   [         R                  " / SQ/ SQS.5      nUR                  U S9n[         R                  " / SQ/ SQUS.5      n[        R                  " XE5        [        U 5      U:X  d   eUR                  U    nX1   n[        R                  " XE5        g )Nrj   )FTTTr   r   r   )r   r   r    r!   r"   r#   r6   r$   s         r(   test_col_logical_opsrl      s    X 
6=VW	XBYYYF||+* 	
H &+t9$$$ VVD\F"H&+r*   c                     [         R                  " S/ SQ05      n [         R                  " S5      S   nSn[        U5      U:X  d   eU R	                  US9n[         R                  " / SQ/ SQS.5      n[
        R                  " X45        g )Nr
   rN   r   zcol('a')[1]rd   )r   r   r   r   )r   r   r,   r#   r    r!   r"   r%   r   r	   r&   r'   s        r(   test_expression_getitemro      sn    	sI&	'B66#;q>D Lt9$$$YYYF||))<=H&+r*   c                  "   [         R                  " S/ SQ05      n [         R                  " S5      R                  nSn[	        U5      U:X  d   eU R                  US9n[         R                  " / SQ/ SQS.5      n[        R                  " X45        g )Nr
   rN   zcol('a').indexrd   )r   r   r   r   )r   r   r,   indexr#   r    r!   r"   rn   s        r(   test_propertyrr      sp    	sI&	'B66#;D#Lt9$$$YYYF||))<=H&+r*   c                     [        [        R                  R                  [        5      (       d   e[        R
                  " S/ SQ05      n [        R                  " S5      R                  R                  nSn[        U5      U:X  d   eU R                  US9n[        R
                  " / SQ[        R                  S.5      n[        R                  " X45        g )Nr
   rN   zcol('a').index.dtyperd   r   )
isinstancer   Indexdtyper   r   r,   rq   r#   r    npint64r!   r"   rn   s        r(   test_cached_propertyry      s     bhhnnn5555	sI&	'B66#;""D)Lt9$$$YYYF||)"((;<H&+r*   c                     [         R                  " S/ SQ05      n [         R                  " [         R                  " S5      S5      nSn[	        U5      U:X  d   [	        U5      5       eU R                  US9n[         R                  " / SQ[         R                  " U S   S5      S.5      n[        R                  " X45        g )Nr
   rN   r   z>qcut(x=col('a'), q=3, labels=None, retbins=False, precision=3)rd   r   )r   r   qcutr,   r#   r    r!   r"   rn   s        r(   	test_qcutr|     s    	sI&	'B77266#;"DSLt9$/c$i/$YYYF||)"''"S'12EFGH&+r*   c                     [         R                  " / SQ/ SQS.5      n [         R                  " S5      R                  [         R                  " S5      S:H  S5      nSn[	        U5      U:X  d   [	        U5      5       eU R                  US	9n[         R                  " / SQ/ SQ/ S
QS.5      n[        R                  " X45        [         R                  " S5      R                  [         R                  " S5      S:H  [         R                  " S5      S-   5      nSn[	        U5      U:X  d   [	        U5      5       eU R                  US	9n[         R                  " / SQ/ SQ/ SQS.5      n[        R                  " X45        g )NrN   )r         r   r
   r   r~   r2   z"col('a').where(col('b') == 5, 100)r   )r2   r   r2   r   r   z+col('a').where(col('b') == 5, col('a') + 1))r   r   r   )r   r   r,   wherer#   r    r!   r"   rn   s        r(   
test_wherer     s   	II6	7B66#;RVVC[A-s3D7Lt9$/c$i/$YYYF||))-PQH&+66#;RVVC[A-rvvc{Q?D@Lt9$/c$i/$YYYF||)))LMH&+r*   )r   N)-r   numpyrw   rE   pandas._libs.propertiesr   pandasr   pandas._testing_testingr!   pandas.api.typingr   #pandas.tests.test_register_accessorr   markparametrizer,   sumpowerdivideastypeabslistobjectr#   r)   r/   r4   r7   r9   dtyearstrftimeupperr@   rL   ri   r   rl   ro   rr   ry   r|   r   ra   r*   r(   <module>r      s      2   ( > /	q!fj)	q1a&.1		QF$45	q1a&.1	
RVVC[1a&.1	q1a&.1	
RVVC[1b'>2	q1a&.1	
RVVC[1a&.1	q3*n5	
RVVC[3*n5		Aq6?3	
bffSk	Aq6?3	q1a&.1	
RVVC[1a&.1	q5$-8		D$<9	q5%..9		D%=/:		D%=/:	"&&+q	!Aq6+?@	266#;s	,sCj:VWVVC[1_q1H-	
 VVC[1_$$V,DM+	
 &&+Bx-
&&+1v{+66#;?	b"X'89
&&+	B8%67	RVVC[	Aq6?3	RVVC[1_	1v':;O(+X%
%'+F|%CF%	%Y+X%,,,, /			tf&89		 	 	&5QR				 5'+AB	%
	%'+F|	%CF	%		%	%( ," / FF3K"&&+%'!	
 FF3K$&	
 FF3K"&&+%$!	
 FF3K%&	
 FF3K"&&+%%!	
 FF3K$&	
 VVC[L&	
?$'P,
,'+Dz,AD,	,Q'P,,
,
,,	,,r*   