
    h                    f   S SK rS SKrS SKJr  S SKJr  S SKrS SKJ	r	J
r
JrJrJrJrJrJrJr  S SKJr  S SKJr  S rS r\R2                  R5                  S/ S	Q5      \R2                  R5                  S
S S S S S S S S S S S S S S S S // SQS9S 5       5       r\R2                  R5                  S/ S	Q5      \R2                  R5                  S
S S S  S! S" S# S$ S% S& S' S( S) S* S+ S, S- S. // S/QS9S0 5       5       r\R2                  R5                  S/ S	Q5      S1 5       rS2 r\R2                  R5                  S3\R>                  " S S45      \
" S5S4/5      /5      S6 5       r S7 r!S8 r"S9 r#S: r$S; r%S< r&\R2                  R5                  S3S= S> S? S@ // SAQS9SB 5       r'SC r(SD r)\R2                  R5                  SESFSG/0SHSG0SISG0/5      SJ 5       r*SK r+SL r,SM r-SN r.SO r/\R2                  R5                  SPSQ SR SS /5      ST 5       r0SU r1SV r2SW r3SX r4\R2                  R5                  SYS3SZ/5      S[ 5       r5S\ r6S] r7\R2                  R5                  S^S_ S 4S` S44Sa S 4Sb S 4// ScQS9Sd 5       r8\R2                  R5                  Se\" S5S4/SGSf9\	" SGS5S4/05      /5      Sg 5       r9\R2                  R5                  Se\" S5S4/SGSf9\	" SGS5S4/05      /5      Sh 5       r:Si r;Sj r<Sk r=Sl r>\R2                  R5                  SmSnS5\R~                  4/5      So 5       r@\R2                  R5                  SpSqSr/5      Ss 5       rA\R2                  R5                  S
St Su Sv Sw /5      Sx 5       rBSy rCSz rDS{ rE\R2                  R5                  S|SGS}S5S~.S S5S S~./5      S 5       rF\R2                  R5                  S
SS/5      S 5       rG\R2                  R5                  Se\" S5S4/5      \	" SGS5S4/05      /5      S 5       rH\R2                  R5                  Se\" S5S4/5      \	" SGS5S4/05      /5      S 5       rIS rJS rK\R2                  R5                  S\" / SQSGSf90 4\	" SG/ SQ05      SSG04/5      S 5       rL\R2                  R5                  S\" / SQSGSf90 4\	" SG/ SQ05      SSG04/5      S 5       rM\R2                  R5                  S/ SQ5      S 5       rNS rOS rP\R2                  R5                  Se\" / SQ5      \	" SG/ SQ05      /5      S 5       rQS rRS rSS rT\R2                  R5                  S|SS0S3S0/5      S 5       rU\R2                  R5                  SSS/5      S 5       rVS rWS rXS rY\R2                  R5                  SSS/5      S 5       rZ\R2                  R5                  SSS/5      S 5       r[\R2                  R5                  SSS/5      S 5       r\\R2                  R5                  SSrS\]4S/5      S 5       r^\R2                  R5                  SSS/5      \R2                  R5                  SPS S /5      S 5       5       r_\R2                  R5                  SSS/5      \R2                  R5                  SPS S /5      S 5       5       r`\R2                  R5                  SSS/5      \R2                  R5                  SPS S /5      S 5       5       ra\R2                  R5                  SPSS/5      S 5       rbS rcS rdS reS rf\R2                  R5                  SSS/SS/S9S 5       rgS rh\R2                  R5                  SSGSG//5      S 5       ri\R2                  R5                  SSS/5      \R2                  R5                  SSS/SS/S9S 5       5       rj\R2                  R5                  SS S5/5      \R2                  R5                  SSS/5      S 5       5       rkS rlS rmS rnS roS rp\R2                  R5                  SSS/5      S 5       rqS rrS rsS rtS ruS rvS rwS rxS ryS rzS r{g)    N)HAS_PYARROW)SettingWithCopyWarning)		DataFrameIndex
MultiIndexPeriodSeries	Timestamp
date_rangeoption_contextperiod_range)	get_arrayc                    [        / SQ/ SQ/ SQS.5      nUR                  5       nUR                  UR                  Ld   eUR                  UR                  Ld   eUR                  R	                  UR                  5      (       d   eUR                  R	                  UR                  5      (       d   e[
        R                  " [        US5      [        US5      5      (       a   eU (       ap  UR                  R                  S   R                  R                  5       (       a   eUR                  R                  S   R                  R                  5       (       a   eSUR                  S'   UR                  S   S:X  d   eg )	N                  g?g?g333333?abcr   r   r   r   r   )r   copyindexcolumnsis_npshares_memoryr   _mgrblocksrefshas_referenceiloc)using_copy_on_writedfdf_copys      [/var/www/html/shao/venv/lib/python3.13/site-packages/pandas/tests/copy_view/test_methods.py	test_copyr-      s0   	I	JBggiG ==(((??"**,,,==RXX&&&&??rzz**** 	'3 72s9KLLLL<<&&q)..<<>>>><<&&q)..<<>>>> GLL774=A    c                 b   [        / SQ/ SQ/ SQS.5      nUR                  SS9nU (       a  UR                  UR                  Ld   eUR                  UR                  Ld   eUR                  R	                  UR                  5      (       d   eUR                  R	                  UR                  5      (       d   eO6UR                  UR                  L d   eUR                  UR                  L d   e[
        R                  " [        US5      [        US5      5      (       d   eU (       ap  UR                  R                  S   R                  R                  5       (       d   eUR                  R                  S	   R                  R                  5       (       d   eU (       a  SUR                  S
'   UR                  S
   S	:X  d   e[
        R                  " [        US5      [        US5      5      (       a   e[
        R                  " [        US5      [        US5      5      (       d   eg [        R                  " U5         SUR                  S
'   S S S 5        UR                  S
   S:X  d   e[
        R                  " [        US5      [        US5      5      (       d   eg ! , (       d  f       NV= f)Nr   r   r   r   Fdeepr   r   r   r   r   )r   r   r   r    r!   r"   r#   r   r$   r%   r&   r'   r(   tmassert_cow_warning)r)   warn_copy_on_writer*   r+   s       r,   test_copy_shallowr5   ,   s   	I	JBgg5g!G }}BHH,,,bjj000}}  ****""2::....}}((("**,,, Igs3Yr35GHHHH||""1%**88::::||""1%**88::::Twwt}!!!##Igs$;Yr3=OPPPP	'3 72s9KLLLL ""#56!"GLL 7wwt}!!!	'3 72s9KLLLL	 76s    J  
J.r   )TNFmethodc                 >    U R                  [        R                  US9$ )Nr    r   )renamestrlowerr*   r   s     r,   <lambda>r=   U   s    3994@r.   c                 &    U R                  SS/US9$ )Nr   r   r8   )reindexr<   s     r,   r=   r=   V   s    S#JTBr.   c                      U R                  XS9$ Nr   reindex_liker<   s     r,   r=   r=   W   s    7r.   c                 &    U R                  XS9S   $ NrB   r   alignr<   s     r,   r=   r=   X   s    "03r.   c                 (    U R                  / SQSUS9$ Nr   r   )axisr   set_axisr<   s     r,   r=   r=   Y   s    _7Nr.   c                 "    U R                  SUS9$ Ntestr   r   rename_axisr<   s     r,   r=   r=   Z   s    f4@r.   c                 "    U R                  SUS9$ )NrP   r8   rR   r<   s     r,   r=   r=   [   s    TBr.   c                 &    U R                  SS0US9$ )Nr   int64rB   astyper<   s     r,   r=   r=   \   s    C>=r.   c                 $    U R                  SSUS9$ Nr   rB   swapaxesr<   s     r,   r=   r=   ^       Q5r.   c                 $    U R                  SSUS9$ Nr   r   rB   truncater<   s     r,   r=   r=   _   r]   r.   c                      U R                  US9$ rA   infer_objectsr<   s     r,   r=   r=   `   s    ))t)4r.   c                      U R                  US9$ rA   to_timestampr<   s     r,   r=   r=   a   s    d3r.   c                 "    U R                  SUS9$ ND)freqr   	to_periodr<   s     r,   r=   r=   b   s    3T:r.   c                 "    U R                  SUS9$ N
US/CentralrB   tz_localizer<   s     r,   r=   r=   c   s    4@r.   c                 "    U R                  SUS9$ ro   
tz_convertr<   s     r,   r=   r=   d   s    |$?r.   c                 "    U R                  SUS9$ NF)allows_duplicate_labelsr   	set_flagsr<   s     r,   r=   r=   e   s    e$Or.   )r9   r?   rD   rH   rM   rename_axis0rename_axis1rX   r\   ra   rd   rg   rm   rr   ru   rz   )idsc                     S nSU R                   R                  R                  ;   a  [        SSSS9nOSU R                   R                  R                  ;   a  [	        SSSS9nO`SU R                   R                  R                  ;   a  [	        SSSS9nO0SU R                   R                  R                  ;   a  [	        SSSS	S
9n[        / SQ/ SQ/ SQS.US9nSU R                   R                  R                  ;   a+  Sn[        R                  " [        US9   U" XbS9nS S S 5        OU" XbS9nU=(       d    USL n	U R                   R                  R                  R                  S5      (       a  U(       d  U(       d  USL a  Sn	U	(       a3  [        R                  " [        WS5      [        US5      5      (       d   eg [        R                  " [        WS5      [        US5      5      (       a   eg ! , (       d  f       N= f)Nrg   
2012-01-01rj   r   rk   periodsrm   rr   ru   Europe/Brusselsrk   r   tzr   r   r   r   r   r\   "'DataFrame.swapaxes' is deprecatedmatchrB   Fzreindex-r   )nodecallspecidr   r   r   r2   assert_produces_warningFutureWarning
startswithr"   r#   r   )
requestr6   r   r)   using_array_managerr   r*   msgdf2share_memorys
             r,   test_methods_copy_keywordr   Q   s   Z E..111\Q?	--00	0<c1=	',,//22	2<c1=	..11	1<c1ARS	IQV	WBW\\**---2''SA'C BA R#&7$%-L||**:66"+>45= L	#s 3Yr35GHHHH##Ic3$72s9KLLLLL BAs   G//
G=c                 &    U R                  SS0US9$ )Nr   d   rQ   r9   serr   s     r,   r=   r=      s    #**As8$*?r.   c                 "    U R                  S US9$ rA   r   r   s     r,   r=   r=      s    #**T*5r.   c                 6    U R                  U R                  US9$ )NrQ   )r?   r   r   s     r,   r=   r=      s    #++CIID+Ar.   c                      U R                  XS9$ rA   rC   r   s     r,   r=   r=      s    #**3*:r.   c                 &    U R                  XS9S   $ rF   rG   r   s     r,   r=   r=      s    #))C)3A6r.   c                 (    U R                  / SQSUS9$ rJ   rL   r   s     r,   r=   r=      s    #,,W4,Pr.   c                 "    U R                  SUS9$ rO   rR   r   s     r,   r=   r=      s    #//T/Br.   c                 "    U R                  SUS9$ )NrV   rB   rW   r   s     r,   r=   r=      s    #**W4*8r.   c                 $    U R                  SSUS9$ )Nr   r   rB   )	swaplevelr   s     r,   r=   r=      s    #--14-8r.   c                 $    U R                  SSUS9$ rZ   r[   r   s     r,   r=   r=          #,,q!$,7r.   c                 $    U R                  SSUS9$ r_   r`   r   s     r,   r=   r=      r   r.   c                      U R                  US9$ rA   rc   r   s     r,   r=   r=      s    #+++6r.   c                      U R                  US9$ rA   rf   r   s     r,   r=   r=      s    #***5r.   c                 "    U R                  SUS9$ ri   rl   r   s     r,   r=   r=      s    #--St-<r.   c                 "    U R                  SUS9$ ro   rq   r   s     r,   r=   r=      s    #//,T/Br.   c                 "    U R                  SUS9$ ro   rt   r   s     r,   r=   r=      s    #..D.Ar.   c                 "    U R                  SUS9$ rw   ry   r   s     r,   r=   r=      s    #--D-Qr.   )zrename (dict)r9   r?   rD   rH   rM   r{   rX   r   r\   ra   rd   rg   rm   rr   ru   rz   c                    S nSU R                   R                  R                  ;   a  [        SSSS9nOSU R                   R                  R                  ;   a  [	        SSSS9nOSU R                   R                  R                  ;   a  [	        SSSS9nOqSU R                   R                  R                  ;   a  [	        SSSS	S
9nO@SU R                   R                  R                  ;   a  [
        R                  " / SQ/ SQ/5      n[        / SQUS9nSU R                   R                  R                  ;   a+  Sn[        R                  " [        US9   U" XRS9nS S S 5        OU" XRS9nU=(       d    USL nU(       a1  [        R                  " [        W5      [        U5      5      (       d   eg [        R                  " [        W5      [        U5      5      (       a   eg ! , (       d  f       N= f)Nrg   r   rj   r   r   rm   rr   ru   r   r   r   r   r   r   r\   z'Series.swapaxes' is deprecatedr   rB   F)r   r   r   r   r   r   from_arraysr	   r2   r   r   r"   r#   r   )	r   r6   r   r)   r   r   r   ser2r   s	            r,    test_methods_series_copy_keywordr      s   V E..111\Q?	--00	0<c1=	',,//22	2<c1=	..11	1<c1ARS	--00	0&&	9'=>
%
(CW\\**---/''SA#)D BA c%&7$%-L	$3@@@@##IdOYs^DDDDD BAs   G
G)c                 n   [        / SQ/ SQS.5      nUR                  US9nU =(       d    USL =(       d    US L nU=(       a    U(       + nU(       a3  [        R                  " [	        US5      [	        US5      5      (       d   eg [        R                  " [	        US5      [	        US5      5      (       a   eg )Nr   r   r   r   rB   Fr   r   )r   	transposer"   r#   r   )r)   r   r   r*   resultr   s         r,   test_transpose_copy_keywordr      s    	3	4B\\t\$F&G$%-G44<L;(;$;L	"c 2Ifa4HIIII##Ib#$6	&!8LMMMMMr.   c                    [        / SQ/ SQ/ SQS./ SQS9nUR                  5       nUR                  5       nUR                  R	                  5         U (       ad  [
        R                  " [        US5      [        US5      5      (       d   e[
        R                  " [        US5      [        US5      5      (       d   eS	UR                  S
'   [
        R                  " [        US5      [        US5      5      (       a   eU (       a2  [
        R                  " [        US5      [        US5      5      (       d   e[        R                  " X5        g )Nr   r   r   r   )
         r   r   r   r   )r   r   )r   r   reset_indexr$   _verify_integrityr"   r#   r   r(   r2   assert_frame_equalr)   r*   df_origr   s       r,   test_reset_indexr      s     
io>l
B ggiG
..
CHH 	#s 3Yr35GHHHH	#s 3Yr35GHHHHCHHTN	#s 3Yr35GHHHH	#s 3Yr35GHHHH"&r.   r   r   r   c                    [        SS/US9nUR                  5       nUR                  SS9nU (       aS  [        R                  " [        U5      [        U5      5      (       d   eUR                  R                  S5      (       a   eO0[        R                  " [        U5      [        U5      5      (       a   eSUR                  S'   [        R                  " X#5        g )Nr   r   r   T)dropr   r   )r	   r   r   r"   r#   r   r$   _has_no_referencer(   r2   assert_series_equalr)   r   r   ser_origr   s        r,   test_reset_index_series_dropr     s    
!Qu
%CxxzH???%D	#	$@@@@88--a00000##IcNIdODDDDDIIaL3)r.   c                      [        / SQ/ SQ/ SQS.5      n U R                  S5      n U S   nU R                  USS9R                  5       nU R                  SSS9R                  5       n[        R
                  " X#5        g )	Nr   r   r   dr   r   r   r   )r   r   r   r   ABCr   r   T)observed)r   	set_indexgroupbysumr2   r   )r*   keyr   expecteds       r,   'test_groupby_column_index_in_referencesr     st    	"<PQ
B 
c	B
S'CZZdZ+//1Fzz#z-113H&+r.   c                 p   [        / SQ/ SQ/ SQS.5      nUR                  5       nUR                  [        R                  S9nU (       a2  [
        R                  " [        US5      [        US5      5      (       d   eSUR                  S	'   [
        R                  " [        US5      [        US5      5      (       a   eU (       a2  [
        R                  " [        US
5      [        US5      5      (       d   e[        / SQ/ SQ/ SQS.5      n[        R                  " X45        [        R                  " X5        g )Nr   r   r   r   r    r   r   r   r   r   r   r   r   r   r   )r   r   r9   r:   upperr"   r#   r   r(   r2   r   r)   r*   r   r   r   s        r,   test_rename_columnsr   '  s     
I	JBggiG
))CII)
&C	#s 3Yr35GHHHHCHHTN	#s 3Yr35GHHHH	#s 3Yr35GHHHHyyOPH#("&r.   c                    [        / SQ/ SQ/ SQS.5      nUR                  [        R                  S9nUR	                  5       nU (       a3  [
        R                  " [        US5      [        US5      5      (       d   eO2[
        R                  " [        US5      [        US5      5      (       a   eSUR                  S	'   [
        R                  " [        US5      [        US5      5      (       a   eU (       a2  [
        R                  " [        US
5      [        US5      5      (       d   e[        / SQ/ SQ/ SQS.5      n[        R                  " X5        [        R                  " X#5        g )Nr   r   r   r   r   r   r   r   r   r   r   r   )r   r9   r:   r   r   r"   r#   r   r(   r2   r   )r)   r*   r   df2_origr   s        r,   !test_rename_columns_modify_parentr   9  s    
I	JB
))CII)
&CxxzH	#s 3Yr35GHHHH##Ic3$72s9KLLLLBGGDM	#s 3Yr35GHHHH	#s 3Yr35GHHHHyyOPH"'#(r.   c                    [        / SQSS.5      nUR                  5       nS nUR                  U5      n[        R                  " [        US5      [        US5      5      (       d   eSUR                  S'   U (       aI  [        R                  " X5        [        R                  " [        US5      [        US5      5      (       a   eOX[        / SQSS.5      n[        R                  " X5        [        R                  " [        US5      [        US5      5      (       d   e[        R                  " [        US	5      [        US	5      5      (       d   eg )
Nr         ?r   c                     U $ N r*   s    r,   testfunctest_pipe.<locals>.testfuncQ  s    	r.   r   r   r   r   r   )	r   r   piper"   r#   r   r(   r2   r   r)   r*   r   r   r   r   s         r,   	test_piper   M  s   	-	.BggiG ''(
CIc3/2s1CDDDD CHHTN
b*##Ic3$72s9KLLLLL9378
b+	#s 3Yr35GHHHHIc3/2s1CDDDDr.   c                    [        / SQSS.5      nUR                  5       nS nUR                  U5      n[        R                  " [        US5      [        US5      5      (       d   eU (       aI  [        R                  " X5        [        R                  " [        US5      [        US5      5      (       a   eOX[        / SQSS.5      n[        R                  " X5        [        R                  " [        US5      [        US5      5      (       d   e[        R                  " [        US5      [        US5      5      (       d   eg )Nr   r   r   c                 $    SU R                   S'   U $ )Nr   r   r(   r   s    r,   r   %test_pipe_modify_df.<locals>.testfunci  s    	r.   r   r   r   r   r   )r   r   r   r"   r#   r   r2   r   r   s         r,   test_pipe_modify_dfr   e  s    	-	.BggiG ''(
CIc3/2s1CDDDD
b*##Ic3$72s9KLLLLL;S9:
b+	#s 3Yr35GHHHHIc3/2s1CDDDDr.   c                 h   [        / SQ/ SQ/ SQS.5      nUR                  5       nUR                  SS/S9nU (       a3  [        R                  " [        US5      [        US5      5      (       d   eO2[        R                  " [        US5      [        US5      5      (       a   eSUR                  S	'   [        R                  " [        US5      [        US5      5      (       a   eU (       a2  [        R                  " [        US5      [        US5      5      (       d   e[        R                  " X5        g )
Nr   r   r   r   r   r   r   r   r   )	r   r   r?   r"   r#   r   r(   r2   r   r   s       r,   test_reindex_columnsr   |  s     
I	JBggiG
**c3Z*
(C	#s 3Yr35GHHHH##Ic3$72s9KLLLLCHHTN	#s 3Yr35GHHHH	#s 3Yr35GHHHH"&r.   c                     U $ r   r   idxs    r,   r=   r=     s    Cr.   c                 "    U R                  5       $ r   )viewr   s    r,   r=   r=     
    CHHJr.   c                 "    U R                  5       $ r   rB   r   s    r,   r=   r=     r   r.   c                     [        U 5      $ r   )listr   s    r,   r=   r=     s    DIr.   )	identicalr   r   valuesc                    [        / SQ/ SQ/ SQS.5      nUR                  5       nUR                  U " UR                  5      S9nU(       a3  [        R
                  " [        US5      [        US5      5      (       d   eO2[        R
                  " [        US5      [        US5      5      (       a   eSUR                  S'   [        R
                  " [        US5      [        US5      5      (       a   eU(       a2  [        R
                  " [        US	5      [        US	5      5      (       d   e[        R                  " X#5        g )
Nr   r   r   r   r   r   r   r   r   )
r   r   r?   r   r"   r#   r   r(   r2   r   )r   r)   r*   r   r   s        r,   test_reindex_rowsr     s     
I	JBggiG
**5?*
+C	#s 3Yr35GHHHH##Ic3$72s9KLLLLCHHTN	#s 3Yr35GHHHH	#s 3Yr35GHHHH"&r.   c                 `   [        / SQ/ SQ/ SQS.5      nUR                  5       nUR                  SS9nUR                  R	                  5         U (       ae  [
        R                  " [        US5      [        US5      5      (       d   e[
        R                  " [        US5      [        US5      5      (       d   eOd[
        R                  " [        US5      [        US5      5      (       a   e[
        R                  " [        US5      [        US5      5      (       a   eS	UR                  S
'   [
        R                  " [        US5      [        US5      5      (       a   eU (       a2  [
        R                  " [        US5      [        US5      5      (       d   e[        R                  " X5        g )Nr   r   r   r   r   r   r   r   r   r   )r   r   r   r$   r   r"   r#   r   r(   r2   r   r   s       r,   test_drop_on_columnr     sI   	I	JBggiG
''#'
CHH 	#s 3Yr35GHHHH	#s 3Yr35GHHHH##Ic3$72s9KLLLL##Ic3$72s9KLLLLCHHTN	#s 3Yr35GHHHH	#s 3Yr35GHHHH"&r.   c                 8   [        / SQ/ SQ/ SQS.5      nUR                  5       nUR                  S5      nUR                  R	                  5         U (       a3  [
        R                  " [        US5      [        US5      5      (       d   eO2[
        R                  " [        US5      [        US5      5      (       a   eSUR                  S'   U (       a2  [
        R                  " [        US5      [        US5      5      (       a   e[        R                  " X5        g )	Nr   r   r   r   rV   r   r   r   )r   r   select_dtypesr$   r   r"   r#   r   r(   r2   r   r   s       r,   test_select_dtypesr    s     
I	JBggiG


7
#CHH 	#s 3Yr35GHHHH##Ic3$72s9KLLLL CHHTN##Ic3$72s9KLLLL"&r.   filter_kwargsitemsr   likeregexc                    [        / SQ/ SQ/ SQS.5      nUR                  5       nUR                  " S0 UD6nU (       a3  [        R                  " [        US5      [        US5      5      (       d   eO2[        R                  " [        US5      [        US5      5      (       a   eU (       aA  SUR                  S'   [        R                  " [        US5      [        US5      5      (       a   e[        R                  " X#5        g )	Nr   r   r   r   r   r   r   r   )	r   r   filterr"   r#   r   r(   r2   r   )r)   r  r*   r   r   s        r,   test_filterr	    s     
I	JBggiG
))
$m
$C	#s 3Yr35GHHHH##Ic3$72s9KLLLL ##Ic3$72s9KLLLL"&r.   c                 z   [        SS/SS/SS//[        SS5      S	S
/S9nUR                  5       nUR                  SS9nU (       a3  [        R
                  " [        US	5      [        US	5      5      (       d   eO2[        R
                  " [        US	5      [        US	5      5      (       a   eSUR                  S'   U (       ad  [        R
                  " [        US	5      [        US	5      5      (       a   e[        R
                  " [        US
5      [        US
5      5      (       d   e[        R                  " X25        g )Nr   r   r   r   r   r   
2020-01-01
2020-01-03r   r   r   r    r   )r   r   )
r   r   r   shiftr"   r#   r   r(   r2   r   r   s       r,   test_shift_no_opr    s   	
Q!Q!Q |4c

B
 ggiG
((1(
C	#s 3Yr35GHHHH##Ic3$72s9KLLLLBGGDM##Ib#$6	#s8KLLLL	"c 2Ic34GHHHH#'r.   c                     [        SS/SS/SS//[        SS5      S	S
/S9nUR                  SSS9n[        R                  " [        US	5      [        US	5      5      (       a   eg )Nr   r   r   r   r   r   r  r  r   r   r  r   r   rK   )r   r   r  r"   r#   r   )r)   r*   r   s      r,   test_shift_indexr    sq    	
Q!Q!Q |4c

B
 ((11(
%C	#s 3Yr35GHHHHHr.   c                 :   [        SS/SS/SS//[        SS5      S	S
/S9nUR                  5       n[        SS5      Ul        UR	                  SSS9nU (       a3  [
        R                  " [        US	5      [        US	5      5      (       d   eO2[
        R                  " [        US	5      [        US	5      5      (       a   eSUR                  S'   U (       a2  [
        R                  " [        US	5      [        US	5      5      (       a   e[        R                  " X25        g )Nr   r   r   r   r   r   r  r  r   r   r  
2020-01-02z
2020-01-041Dr   rk   r   r   )r   r   r   r   r  r"   r#   r   r(   r2   r   r   s       r,   test_shift_rows_freqr  
  s    	
Q!Q!Q |4c

B
 ggiG|\:GM
((14(
(C	#s 3Yr35GHHHH##Ic3$72s9KLLLLBGGDM##Ib#$6	#s8KLLLL#'r.   c                 n   [        SS/SS/SS//[        SS5      S	9nUR                  SSS
9n[        R                  " [        US5      [        US5      5      (       d   e[        R                  " U5         SUR                  S'   S S S 5        U (       a  [        R                  " [        US5      [        US5      5      (       a   e[        [        R                  S/[        R                  S/[        R                  S//[        SS5      S	9n[        R                  " X45        g g ! , (       d  f       N= f)Nr   r   r   r   r   r   r  r  r   r  r   r   )r   r   r  r"   r#   r   r2   r3   r(   nanr   )r)   r4   r*   r   r   s        r,   test_shift_columnsr    s   	
Q!Q!Q *\<*P
B ((11(
%CIc<8)B:UVVVV			1	2 
3##c<()B*E
 
 	
 
 ffa[2661+{3|\:
 	c,  
3	2s   6D&&
D4c                 F   [        / SQ/ SQ/ SQS.5      nUR                  5       nUS S  nUR                  S5      n[        R                  " UR
                  [        US5      5      (       d   e[        R                  " [        US5      [        US5      5      (       d   eU (       aA  SUR                  S'   [        R                  " UR
                  [        US5      5      (       a   e[        R                  " U5         SUR                  S'   S S S 5        U (       aI  [        R                  " [        US5      [        US5      5      (       a   e[        R                  " XC5        g [        / SQ/ S	Q/ SQS.5      n[        R                  " XF5        g ! , (       d  f       N= f)
Nr   r   r   r   r   r   r   r   )r   r   r   )r   r   popr"   r#   r   r   r(   r2   r3   r   )r)   r4   r*   r   view_originalr   r   s          r,   test_popr  3  s5   	I	JBggiGqEMVVC[FFMM9]C+HIIIIIb#.	-0MNNNNA##FMM9]C3PQQQQ			1	2 
3##Ib#$6	-QT8UVVVV
m599?ST
m6 
3	2s   >F
F funcc                 $    U R                  U5      $ r   rG   xys     r,   r=   r=   L  s    QWWQZr.   c                 6    U R                  UR                  SS9$ )Nr   rK   )rH   r   r!  s     r,   r=   r=   M  s    QWWQSSqW)r.   c                 d    U R                  UR                  R                  [        SS5         SS9$ )Nr   r   r%  )rH   r   r(   slicer!  s     r,   r=   r=   N  s$    QWWQSSXXeAqk2W;r.   c                    [        / SQSS.5      nUR                  5       nUSS/   R                  5       nU" X$5      u  pVU (       a3  [        R                  " [	        US5      [	        US5      5      (       d   eO2[        R                  " [	        US5      [	        US5      5      (       a   eSUR
                  S'   U (       a2  [        R                  " [	        US5      [	        US5      5      (       a   e[        R                  " X#5        g )Nr   r   r   r   r   r   r   r   r"   r#   r   r(   r2   r   )r)   r  r*   r   
df_changedr   _s          r,   test_align_framer,  I  s     
-	.BggiGS#J$$&J"!FC	#s 3Yr35GHHHH##Ic3$72s9KLLLLCHHTN##Ic3$72s9KLLLL"&r.   c                    [        SS/5      nUR                  5       nUR                  5       nUR                  U5      u  pEU (       ae  [        R                  " UR
                  UR
                  5      (       d   e[        R                  " UR
                  UR
                  5      (       d   eOd[        R                  " UR
                  UR
                  5      (       a   e[        R                  " UR
                  UR
                  5      (       a   eSUR                  S'   SUR                  S'   U (       ad  [        R                  " UR
                  UR
                  5      (       a   e[        R                  " UR
                  UR
                  5      (       a   e[        R                  " X5        [        R                  " X25        g )Nr   r   r   )	r	   r   rH   r"   r#   r   r(   r2   r   )r)   r   r   	ser_otherr   ser_other_results         r,   test_align_seriesr0  b  sK   
!Q.CxxzH
I YYy1DSZZ8888 0 7 79I9IJJJJ##DKK<<<<##$4$;$;Y=M=MNNNNDIIaL !##DKK<<<<##$4$;$;Y=M=MNNNN3)9/r.   c                    [        / SQ/ SQS.5      nUR                  5       nUR                  USS9u  p4[        R                  " [        US5      [        US5      5      (       d   e[        R                  " [        US5      [        US5      5      (       d   eU (       aK  SUR                  S	'   [        R                  " X5        SUR                  S	'   [        R                  " X5        g g )
Nr   r   r   FrB   r   r   r   r   r   )	r   r   rH   r"   r#   r   locr2   r   )r)   r*   r   r   df3s        r,   test_align_copy_falser5  x  s    	3	4BggiGxxx'HCIb#.	#s0CDDDDIb#.	#s0CDDDD
b*
b* r.   c                 v   [        / SQ/ SQS.5      n[        / SQSS9nUR                  5       nUR                  5       nUR                  USSS9u  pV[        R
                  " [        US	5      [        US	5      5      (       d   e[        R
                  " [        US
5      [        US
5      5      (       d   e[        R
                  " [        US5      [        US5      5      (       d   eU (       aK  SUR                  S'   [        R                  " X5        SUR                  S'   [        R                  " X#5        g g )Nr   r   r   r"  nameFr   )r   rK   r   r   r2  )r   r	   r   rH   r"   r#   r   r3  r2   r   r   )r)   r*   r   r   r   r   r   s          r,   !test_align_with_series_copy_falser9    s    	3	4B

%CxxzHggiG5q1ICIb#.	#s0CDDDDIb#.	#s0CDDDDIc3/41EFFFF
b*
s- r.   c                    [        / SQ5      nUR                  5       nUS S  R                  5       n[        R                  " UR
                  [        US5      5      (       d   e[        R                  " U5         SUR                  S'   S S S 5        U (       aI  [        R                  " UR
                  [        US5      5      (       a   e[        R                  " X#5        O5UR                  5       nSUR                  S'   [        R                  " X%5        US S  R                  5       n[        R                  " U5         SUR                  S'   S S S 5        U (       a%  [        R                  " XCR                  5       5        g UR                  5       R                  5       nSUR                  S'   [        R                  " XE5        g ! , (       d  f       GNE= f! , (       d  f       N= f)Nr   r   r   )r	   r   to_framer"   r#   r   r   r2   r3   r(   r   r   )r)   r4   r   r   r*   r   s         r,   test_to_framer<    s_   

CxxzH	Q	B CJJ	"a(89999			1	2 
3 ##CJJ	"a0@AAAA
s- ==?a
s- 
Q	B			1	2 
3 
b"3"3"56==?++-d
b+/ 
3	2 
3	2s   9G?G
G
G'axr    c                 h   [        / SQ/ SQS.5      nUR                  5       nSn[        R                  " [        US9   UR                  X5      nS S S 5        U (       a3  [        R                  " [        WS5      [        US5      5      (       d   eO2[        R                  " [        WS5      [        US5      5      (       a   eSUR                  S'   U (       a2  [        R                  " [        US5      [        US5      5      (       a   e[        R                  " X#5        g ! , (       d  f       N= f)	Nr   r   r   r   r   r   r   r   r   r   r2   r   r   r\   r"   r#   r   r(   r   )r)   r=  r*   r   r   r   s         r,   test_swapaxes_noopr@    s    	3	4BggiG
.C		#	#M	=kk"! 
> 	#s 3Yr35GHHHH##Ic3$72s9KLLLL CHHTN##Ic3$72s9KLLLL"& 
>	=s   D##
D1c                 l   [        / SQ/ SQS./ SQS9nUR                  5       nSn[        R                  " [        US9   UR                  SS	5      nS S S 5        U (       a3  [        R                  " [        WS
5      [        US5      5      (       d   eO2[        R                  " [        WS
5      [        US5      5      (       a   eSUR                  S'   U (       a2  [        R                  " [        US
5      [        US5      5      (       a   e[        R                  " X5        g ! , (       d  f       N= f)Nr   r   r   )r"  r#  zr   r   r   r   r    r"  r   r   r   r?  )r)   r*   r   r   r   s        r,   test_swapaxes_single_blockrC    s    	3?	KBggiG
.C		#	#M	=kk'9- 
> 	#s 3Yr35GHHHH##Ic3$72s9KLLLL CHHTN##Ic3$72s9KLLLL"& 
>	=s   D%%
D3c                     [        SS/SS.5      n Sn[        R                  " [        US9   U R	                  SSS	9n S S S 5        S
U R
                  S'   [        S
S/SS/S.SS/S9n[        R                  " X5        g ! , (       d  f       NG= f)Nr   r   r   r   r   r   r   r    )axis1axis2r   r   r   r   r   r   r   )r   r2   r   r   r\   r(   r   )r*   r   r   s      r,   test_swapaxes_read_only_arrayrH    s    	!Qa(	)B
.C		#	#M	=[[wi[8 
>BGGDMc1X1a&1#sDH"'	 
>	=s   A>>
Bzmethod, idxc                 :    U R                  SS9R                  SS9$ )NFr0   rB   r   s    r,   r=   r=     s    BGGG',,%,8r.   c                 >    U R                  5       R                  5       $ r   )r   r   s    r,   r=   r=     s    BNN$002r.   c                 r    U R                  [        R                  S9R                  [        R                  S9$ )Nr   )r9   r:   r   r;   r   s    r,   r=   r=     s%    BIIciiI077		7Jr.   c                 :    U R                  SS9R                  SS9$ )NFr0   number)include)r   r  r   s    r,   r=   r=     s    BGGG'55h5Gr.   )shallow-copyr   r9   r  c                    [        / SQ/ SQ/ SQS.5      nUR                  5       nU(       + =(       a#    U R                  R                  R                  S:H  nU" U5      n[
        R                  " U=(       a    U5         SUR                  SU4'   S S S 5        U(       d  [
        R                  " XV5        U" U5      n[
        R                  " U=(       a    U5         SUR                  S'   S S S 5        U(       d+  [
        R                  " UR                  S S 2US 24   U5        g g ! , (       d  f       N= f! , (       d  f       NR= f)Nr   r   r   r   rO  r   r   )	r   r   r   r   r   r2   r3   r(   r   )	r   r6   r   r)   r4   r*   r   df2_is_viewr   s	            r,   test_chained_methodsrR    s     
I	JBggiG *)Xgll.C.C.F.F..XK *C			1Ak	BC 
C
b* *C			1Ak	B 
C
chhq#$w/9  
C	B 
C	Bs   >D'D8'
D58
Eobjr7  c                    [        [        SSS9[        SSS9/5      Ul        UR                  5       nUR	                  5       nU (       a3  [
        R                  " [        US5      [        US5      5      (       d   eO2[
        R                  " [        US5      [        US5      5      (       a   eSUR                  S'   [
        R                  " [        US5      [        US5      5      (       a   e[        R                  " X5        g )Nz2012-1-1rj   rk   z2012-1-2r   r   )r   r   r   r   rg   r"   r#   r   r(   r2   assert_equalr)   rS  obj_origobj2s       r,   test_to_timestamprZ    s    vjs3VJS5QRSCIxxzHD	$ 4iS6IJJJJ##IdC$8)C:MNNNN DIIaL	$ 4iS6IJJJJOOC"r.   c                    [        [        S5      [        S5      /5      Ul        UR                  5       nUR	                  SS9nU (       a3  [
        R                  " [        US5      [        US5      5      (       d   eO2[
        R                  " [        US5      [        US5      5      (       a   eSUR                  S'   [
        R                  " [        US5      [        US5      5      (       a   e[        R                  " X5        g )N
2019-12-31
2020-12-31YrU  r   r   )r   r
   r   r   rm   r"   r#   r   r(   r2   rV  rW  s       r,   test_to_periodr_  "  s    y.	,0GHICIxxzH==c="D	$ 4iS6IJJJJ##IdC$8)C:MNNNN DIIaL	$ 4iS6IJJJJOOC"r.   c                    [        / SQ/ SQ/ SQS.5      nUR                  5       nUR                  S5      nU (       a3  [        R                  " [        US5      [        US5      5      (       d   eO2[        R                  " [        US5      [        US5      5      (       a   eSUR                  S'   [        R                  " [        US	5      [        US	5      5      (       a   e[        R                  " X5        g )
Nr   r   r   r   r   r   r   rG  r   )	r   r   r   r"   r#   r   r(   r2   r   r   s       r,   test_set_indexra  4  s    	I	JBggiG
,,s
C	#s 3Yr35GHHHH##Ic3$72s9KLLLL CHHTN	#s 3Yr35GHHHH"&r.   c                      [        / SQSS.5      n U R                  S5      nUR                  5       nSU R                  S'   [        R
                  " X5        g )Nr   r   r   r   r   r   )r   r   r   r(   r2   r   r*   r   r   s      r,   4test_set_index_mutating_parent_does_not_mutate_indexrd  E  sE    	+	,B\\#F{{}HBGGDM&+r.   c                 X   [        / SQ/ SQ/ SQS.5      nUR                  5       nUR                  S5      nU (       a2  [        R                  " [        US5      [        US5      5      (       d   eSUR                  S	'   [        R                  " [        US5      [        US5      5      (       a   eU (       a2  [        R                  " [        US
5      [        US5      5      (       d   e[        / SQ/ SQ/ SQS.5      n[        R                  " X45        [        R                  " X5        g )Nr   r   r   r   CoW_CoW_ar   r   r   CoW_cr   r   )rg  CoW_brh  )	r   r   
add_prefixr"   r#   r   r(   r2   r   r   s        r,   test_add_prefixrk  N  s    	I	JBggiG
--
C	#w 72s9KLLLLCHHTN	#w 72s9KLLLL	#w 72s9KLLLLi/JH #("&r.   c                 X   [        / SQ/ SQ/ SQS.5      nUR                  5       nUR                  S5      nU (       a2  [        R                  " [        US5      [        US5      5      (       d   eSUR                  S	'   [        R                  " [        US5      [        US5      5      (       a   eU (       a2  [        R                  " [        US
5      [        US5      5      (       d   e[        / SQ/ SQ/ SQS.5      n[        R                  " X45        [        R                  " X5        g )Nr   r   r   r   _CoWa_CoWr   r   r   c_CoWr   r   )rn  b_CoWro  )	r   r   
add_suffixr"   r#   r   r(   r2   r   r   s        r,   test_add_suffixrr  c  s    	I	JBggiG
--
C	#w 72s9KLLLLCHHTN	#w 72s9KLLLL	#w 72s9KLLLLi/JH #("&r.   z	axis, val)r         @c                    [        / SQSUS/SS.5      nUR                  5       nUR                  US9nU (       a3  [        R                  " [        US5      [        US5      5      (       d   eO2[        R                  " [        US5      [        US5      5      (       a   eSUR                  S	'   U (       a2  [        R                  " [        US5      [        US5      5      (       a   e[        R                  " X45        g )
Nr   r   r   r   r   r%  r   r   r   )	r   r   dropnar"   r#   r   r(   r2   r   )r)   rK   valr*   r   r   s         r,   test_dropnarw  u  s    	!S!3?	@BggiG
)))
C	#s 3Yr35GHHHH##Ic3$72s9KLLLLCHHTN##Ic3$72s9KLLLL"&r.   rv  r   rs  c                    [        SUS/5      nUR                  5       nUR                  5       nU (       a3  [        R                  " UR
                  UR
                  5      (       d   eO2[        R                  " UR
                  UR
                  5      (       a   eSUR                  S'   U (       a2  [        R                  " UR
                  UR
                  5      (       a   e[        R                  " X#5        g )Nr   r   r   )	r	   r   ru  r"   r#   r   r(   r2   r   )r)   rv  r   r   r   s        r,   test_dropna_seriesry    s    
!S!
CxxzH::<DSZZ8888##DKK<<<<DIIaL##DKK<<<<3)r.   c                 "    U R                  5       $ r   headr   s    r,   r=   r=     
    2779r.   c                 $    U R                  S5      $ )Nr   r{  r   s    r,   r=   r=         2771:r.   c                 "    U R                  5       $ r   tailr   s    r,   r=   r=     r}  r.   c                 $    U R                  S5      $ )Nr   r  r   s    r,   r=   r=     r  r.   c                    [        / SQ/ SQS.5      nUR                  5       nU " U5      nUR                  R                  5         U(       ad  [        R
                  " [        US5      [        US5      5      (       a   e[        R
                  " [        US5      [        US5      5      (       a   e[        R                  " U5         SUR                  S'   S S S 5        U(       ae  [        R
                  " [        US5      [        US5      5      (       a   e[        R
                  " [        US5      [        US5      5      (       a   eO`[        R
                  " [        US5      [        US5      5      (       d   e[        R                  " U5         SUR                  S'   S S S 5        [        R                  " X45        g ! , (       d  f       N= f! , (       d  f       N6= f)	Nr   r   r   r   r   r   r   r   )r   r   r$   r   r"   r#   r   r2   r3   r(   r   )r6   r)   r4   r*   r   r   s         r,   test_head_tailr    sk    
9	:BggiG
*CHH  ##Ic3$72s9KLLLL##Ic3$72s9KLLLL 
		1	2 
3##Ic3$72s9KLLLL##Ic3$72s9KLLLLL 	#s 3Yr35GHHHH""#56CHHTN 7"& 
3	2 76s   GG
G
G c                    [        SS/[        SS/[        S9SSS.5      nUR                  5       nUR	                  5       nU (       a  [
        R                  " [        US5      [        US5      5      (       d   eU(       a3  [        R                  " [        US5      [        US5      5      (       a   eO[
        R                  " [        US5      [        US5      5      (       d   eOd[
        R                  " [        US5      [        US5      5      (       a   e[
        R                  " [        US5      [        US5      5      (       a   eS	UR                  S
'   SUR                  S'   U (       ad  [
        R                  " [        US5      [        US5      5      (       a   e[
        R                  " [        US5      [        US5      5      (       a   e[        R                  " X#5        g )Nr   r   r"  r#  dtyper   r   r   r   r   r   rG  )r   r	   objectr   rd   r"   r#   r   r2   r(   r   )r)   using_infer_stringr*   r   r   s        r,   test_infer_objectsr    s   	!f63*F;!#N
B ggiG



C	#s 3Yr35GHHHH''	#s(;Yr3=OPPPPP##Ic3$72s9KLLLL ##Ic3$72s9KLLLL##Ic3$72s9KLLLLCHHTNCHHTN##Ic3$72s9KLLLL##Ic3$72s9KLLLL"&r.   c                    [        SS/[        SS/[        S9S[        [        S5      [        S5      /SS9[        S	S
/[        S9S.5      nUR	                  5       n[        US5      n[        US5      n[        US5      nSUR                  S'   SUR                  S'   [        S5      UR                  S'   U (       a  [        R                  " U[        US5      5      (       d   eU(       a)  [        R                  " U[        US5      5      (       d   eO([        R                  " U[        US5      5      (       a   e[        R                  " U[        US5      5      (       d   eg g )Nr   r   r"  r#  r  r\  r]  r  rB  w)r   r   r   r   er   r   r   r   r   rG  
2018-12-31r   r   )
r   r	   r  r
   rd   r   r(   r"   r#   r2   )r)   r  r*   arr_aarr_barr_ds         r,   test_infer_objects_no_referencer    sD   	Qc
&1<()L*AB( c
&1	


B 
			Bb#Eb#Eb#EBGGDMBGGDMl+BGGDMyS'9:::: ##E9R+=>>>> ''yS/ABBBByS'9:::: r.   c                 ~   [        SS/[        SS/[        S9S[        [        S5      [        S5      /SS9S	.5      nUS S  nUR	                  5       n[        US
5      n[        US5      n[        US5      nSUR                  S'   SUR                  S'   [        S5      UR                  S'   U (       a  [        R                  " U[        US
5      5      (       a   eU(       a  [        (       a(  [        R                  " U[        US5      5      (       a   e[        R                  " U[        US5      5      (       d   eg g )Nr   r   r"  r#  r  r\  r]  r  r   r   r   r   r   r   rG  r  r  )
r   r	   r  r
   rd   r   r(   r"   r#   r   )r)   r  r*   r   r  r  r  s          r,   test_infer_objects_referencer    s   	Qc
&1<()L*AB(		
	
B a5D				Bb#Eb#Eb#EBGGDMBGGDMl+BGGDM##E9R+=>>>>![[''yS/ABBBByS'9::::	 r.   kwargsr   )beforeafterrK   c                 2   [        / SQSSS.5      nUR                  5       nUR                  " S0 UD6nUR                  R	                  5         U (       a3  [
        R                  " [        US5      [        US5      5      (       d   eO2[
        R                  " [        US5      [        US5      5      (       a   eSUR                  S'   U (       a2  [
        R                  " [        US5      [        US5      5      (       a   e[        R                  " X#5        g )	Nr   r   r   r   r   r   r   r   )r   r   ra   r$   r   r"   r#   r   r(   r2   r   r)   r  r*   r   r   s        r,   test_truncater    s     
3	4BggiG
++

CHH 	#s 3Yr35GHHHH##Ic3$72s9KLLLLCHHTN##Ic3$72s9KLLLL"&r.   assigndrop_duplicatesc                 *   [        S/ SQ05      nUR                  5       n[        X!5      " 5       nUR                  R	                  5         U (       a3  [
        R                  " [        US5      [        US5      5      (       d   eO2[
        R                  " [        US5      [        US5      5      (       a   eSUR                  S'   U (       a2  [
        R                  " [        US5      [        US5      5      (       a   e[        R                  " X#5        g )Nr   r   r   r   )r   r   getattrr$   r   r"   r#   r   r(   r2   r   )r)   r6   r*   r   r   s        r,   test_assign_drop_duplicatesr  *  s    	C#	$BggiG
"

CHH 	#s 3Yr35GHHHH##Ic3$72s9KLLLLCHHTN##Ic3$72s9KLLLL"&r.   c                    UR                  5       nUR                  SS/5      nU (       a3  [        R                  " UR                  UR                  5      (       d   eO2[        R                  " UR                  UR                  5      (       a   eSUR
                  S'   U (       a2  [        R                  " UR                  UR                  5      (       a   e[        R                  " X5        g )Nr   r   )r   taker"   r#   r   r(   r2   rV  rW  s       r,   	test_taker  <  s     xxzH88QFDSZZ8888##DKK<<<<DIIaL##DKK<<<<OOC"r.   c                    [        SSSS9Ul        UR                  5       nUR                  SS5      nU (       a3  [        R
                  " UR                  UR                  5      (       d   eO2[        R
                  " UR                  UR                  5      (       a   eSUR                  S'   U (       a2  [        R
                  " UR                  UR                  5      (       a   e[        R                  " X5        g )Nz
2018-04-09r   1D20minr  z0:00z1:00r   )
r   r   r   between_timer"   r#   r   r(   r2   rV  rW  s       r,   test_between_timer  M  s    <CCIxxzHFF+DSZZ8888##DKK<<<<DIIaL##DKK<<<<OOC"r.   c                    [        SS/SS.5      n[        SSS/S.5      nUR                  5       nUR                  U5      nU (       a3  [        R                  " [        US5      [        US5      5      (       d   eO2[        R                  " [        US5      [        US5      5      (       a   eSUR                  S'   U (       a2  [        R                  " [        US5      [        US5      5      (       a   e[        R                  " X5        g )Nr   r   r   r   )r   r   r   rG  )	r   r   rD   r"   r#   r   r(   r2   r   )r)   r*   otherr   r   s        r,   test_reindex_liker  ^  s    	!Qc*	+BCq!f-.EggiG
//%
 C	#s 3Yr35GHHHH##Ic3$72s9KLLLLCHHTN##Ic3$72s9KLLLL"&r.   c                    [        / SQ5      nUR                  5       nUR                  5       nU (       a3  [        R                  " UR
                  UR
                  5      (       d   eO2[        R                  " UR
                  UR
                  5      (       a   eSUR                  S'   [        R                  " UR
                  UR
                  5      (       a   e[        R                  " X5        g )Nr   r   )	r	   r   
sort_indexr"   r#   r   r(   r2   r   r)   r   r   r   s       r,   test_sort_indexr  p  s    

CxxzH>>D

DKK8888##CJJ<<<< DIIaLSZZ88883)r.   zobj, kwargsr   byc                    UR                  5       nUR                  " S0 UD6nU (       a3  [        R                  " [	        US5      [	        US5      5      (       d   eO2[        R                  " [	        US5      [	        US5      5      (       a   eSUR
                  S'   [        R                  " [	        US5      [	        US5      5      (       a   e[        R                  " X5        g )Nr   r   r   )r   sort_valuesr"   r#   r   r(   r2   rV  )r)   rS  r  rX  rY  s        r,   test_sort_valuesr    s    
 xxzH??$V$D	$ 4iS6IJJJJ##IdC$8)C:MNNNN DIIaL	$ 4iS6IJJJJOOC"r.   c                 <   UR                  5       nUS S  nUR                  " SSS0UD6  [        R                  " [	        US5      [	        US5      5      (       d   e[
        R                  " U5         SUR                  S'   S S S 5        U (       aI  [        R                  " [	        US5      [	        US5      5      (       a   e[
        R                  " XT5        g [        R                  " [	        US5      [	        US5      5      (       d   eg ! , (       d  f       N= f)NinplaceTr   r   r   )	r   r  r"   r#   r   r2   r3   r(   rV  )r)   rS  r  r4   rX  r   s         r,   test_sort_values_inplacer    s    
 xxzHq6DOO+D+F+Ic3/41EFFFF 
		1	2 
3##Ic3$749MNNNN
'	#s 3YtS5IJJJJ 
3	2s   2D
Ddecimals)r   r   c                    [        SS/SS.5      nUR                  5       nUR                  US9nU (       a  [        R                  " [        US5      [        US5      5      (       d   eUS:  a3  [        R                  " [        US5      [        US5      5      (       d   eO[        R                  " [        US5      [        US5      5      (       a   eOd[        R                  " [        US5      [        US5      5      (       a   e[        R                  " [        US5      [        US5      5      (       a   eS	UR                  S
'   SUR                  S'   U (       ad  [        R                  " [        US5      [        US5      5      (       a   e[        R                  " [        US5      [        US5      5      (       a   e[        R                  " X45        g )Nr   r   r   r   )r  r   r   r   r   rG  r   r   )	r   r   roundr2   r#   r   r"   r(   r   )r)   r4   r  r*   r   r   s         r,   
test_roundr    sy   	!Qc*	+BggiG
((H(
%C	#s 3Yr35GHHHHq=##Ic3$72s9KLLLL''	#s(;Yr3=OPPPPP##Ic3$72s9KLLLL##Ic3$72s9KLLLLCHHTNCHHTN##Ic3$72s9KLLLL##Ic3$72s9KLLLL"&r.   c                 (   [         R                  " / SQSS/S9n[        S/ SQ0US9nUR                  5       nUR	                  SS/S9nU (       a3  [
        R                  " [        US5      [        US5      5      (       d   eO2[
        R                  " [        US5      [        US5      5      (       a   eS	UR                  S
'   U (       a2  [
        R                  " [        US5      [        US5      5      (       a   e[        R                  " X#5        g )Nr   r   r   r   r   r   )r   r   onetwonamesr   r   r   orderr   r   )r   from_tuplesr   r   reorder_levelsr"   r#   r   r(   r2   r   r)   r   r*   r   r   s        r,   test_reorder_levelsr    s    ""(E 
C&e	4BggiG


5%.

1C	#s 3Yr35GHHHH##Ic3$72s9KLLLLCHHTN##Ic3$72s9KLLLL"&r.   c                 $   [         R                  " / SQSS/S9n[        / SQUS9nUR                  5       nUR	                  SS/S9nU (       a3  [
        R                  " UR                  UR                  5      (       d   eO2[
        R                  " UR                  UR                  5      (       a   eSUR                  S'   U (       a2  [
        R                  " UR                  UR                  5      (       a   e[        R                  " X#5        g )	Nr  r  r  r  r   r   r  r   )r   r  r	   r   r  r"   r#   r   r(   r2   r   r   s        r,   test_series_reorder_levelsr    s    ""(E U
+CxxzHUEN3DSZZ8888##DKK<<<<DIIaL##DKK<<<<3)r.   c                    [         R                  " / SQSS/S9nX!l        UR                  5       nUR	                  5       nU (       a3  [
        R                  " UR                  UR                  5      (       d   eO2[
        R                  " UR                  UR                  5      (       a   eSUR                  S'   U (       a2  [
        R                  " UR                  UR                  5      (       a   e[        R                  " X5        g )Nr  r  r  r  r  r  r   )r   r  r   r   r   r"   r#   r   r(   r2   rV  )r)   rS  r   rX  rY  s        r,   test_swaplevelr    s    ""#;E5>REIxxzH==?DSZZ8888##DKK<<<<DIIaL##DKK<<<<OOC"r.   c                    [        / SQ/ SQ/ SQS.5      nUR                  5       nUR                  / SQSS9nU (       a3  [        R                  " [        US5      [        US5      5      (       d   eO2[        R                  " [        US5      [        US5      5      (       a   eSUR                  S	'   [        R                  " [        US5      [        US5      5      (       a   e[        R                  " X5        g )
Nr   r   r   r   r   r%  r   r   r   )	r   r   rM   r"   r#   r   r(   r2   r   r   s       r,   test_frame_set_axisr    s    	I	JBggiG
++oG+
4C	#s 3Yr35GHHHH##Ic3$72s9KLLLL CHHTN	#s 3Yr35GHHHH"&r.   c                 j   [        / SQ5      nUR                  5       nUR                  / SQSS9nU (       a  [        R                  " X5      (       d   eO[        R                  " X5      (       a   eSUR
                  S'   [        R                  " X15      (       a   e[        R                  " X5        g )Nr   r   r   r%  r   )r	   r   rM   r"   r#   r(   r2   r   r  s       r,   test_series_set_axisr    s    

CxxzH<<g<6D****##C.... DIIaL****3)r.   c                 
   [        / SQ5      nUR                  5       nUR                  SS9n[        R                  " X$5      (       d   e[
        R                  " U5         SUR                  S'   S S S 5        U (       a4  [        R                  " XB5      (       a   e[
        R                  " X#5        g [        R                  " XB5      (       d   e[        / SQ5      n[
        R                  " X%5        g ! , (       d  f       N= f)Nr   F)rx   r   r   )	r	   r   rz   r"   r#   r2   r3   r(   r   r)   r4   r   r   r   r   s         r,   test_set_flagsr    s    

CxxzH===7DC&&&& 
		1	2		! 
3##D....
s-****)$
s- 
3	2s    C44
DmapperrP   c                    [        S/ SQ0[        / SQSS9S9nUR                  5       nUR                  " S0 UD6nU (       a3  [        R
                  " [        US5      [        US5      5      (       d   eO2[        R
                  " [        US5      [        US5      5      (       a   eSUR                  S'   U (       a2  [        R
                  " [        US5      [        US5      5      (       a   e[        R                  " X#5        g )Nr   r   r7  r   r   r   r   )
r   r   r   rS   r"   r#   r   r(   r2   r   r  s        r,   test_rename_axisr  0  s    	C&eLs.K	LBggiG
..
"6
"C	#s 3Yr35GHHHH##Ic3$72s9KLLLLCHHTN##Ic3$72s9KLLLL"&r.   zfunc, tz)ru   zEurope/Berlin)rr   Nc           
         [        SS/[        SSSUS9S9nUR                  5       n[        X15      " S5      nU (       a3  [        R
                  " UR                  UR                  5      (       d   eO2[        R
                  " UR                  UR                  5      (       a   eSUR                  S'   [        R
                  " UR                  UR                  5      (       a   e[        R                  " X45        g )	Nr   r   z2014-08-01 09:00h)startrk   r   r   r   rp   r   )
r	   r   r   r  r"   r#   r   r(   r2   r   )r)   r  r   r   r   r   s         r,   test_tz_convert_localizer  A  s    
 	
Aj'9QSUVC xxzH3l+D

DKK8888##CJJ<<<< DIIaLSZZ88883)r.   c                 `   [         R                  " / SQSS/S9n[        / SQ/ SQ/ SQS.US	9nUR                  5       nUR	                  S
5      nU (       ae  [
        R                  " [        US5      [        US5      5      (       d   e[
        R                  " [        US5      [        US5      5      (       d   eOd[
        R                  " [        US5      [        US5      5      (       a   e[
        R                  " [        US5      [        US5      5      (       a   eS
UR                  S'   [
        R                  " [        US5      [        US5      5      (       a   eU (       a2  [
        R                  " [        US5      [        US5      5      (       d   e[        R                  " X#5        g )Nr  r  r  r  r   r         	   r   r   r   r   r   r   r   )r   r  r   r   	droplevelr"   r#   r   r(   r2   r   r  s        r,   test_droplevelr  W  sQ   ""#;E5>RE	C5	QBggiG
,,q/C	#s 3Yr35GHHHH	#s 3Yr35GHHHH##Ic3$72s9KLLLL##Ic3$72s9KLLLL CHHTN	#s 3Yr35GHHHH	#s 3Yr35GHHHH"&r.   c                 r   [        S/ SQ05      nUR                  5       nUR                  5       n[        R                  " UR
                  [        US5      5      (       d   e[        R                  " U5         SUR                  S'   S S S 5        U (       aI  [        R                  " UR
                  [        US5      5      (       a   e[        R                  " X#5        g [        R                  " UR
                  [        US5      5      (       d   eUR                  S   S:X  d   eg ! , (       d  f       N= f)Nr   r   r   r2  )r   r   squeezer"   r#   r   r   r2   r3   r(   r   r3  )r)   r4   r*   r   seriess        r,   test_squeezer  o  s    	C#	$BggiGZZ\F FMM9R+=>>>> 
		1	2A 
3##FMM9R3EFFFF
b* yS/ABBBBvvf~""" 
3	2s   8D((
D6c           	      N   [        / SQ/ SQ/ SQS.5      nUR                  5       n[        S5       H  nUR                  5        H  u  pV[        R
                  " [        Xe5      [        X%5      5      (       d   e[        R                  " U5         SUR                  S'   S S S 5        U (       aH  [        R
                  " [        Xe5      [        X%5      5      (       a   e[        R                  " X#5        M  UR                  SU4   S:X  a  M   e   M     g ! , (       d  f       N}= f)Nr   r   r  r   r   r   )r   r   ranger  r"   r#   r   r2   r3   r(   r   r3  )r)   r4   r*   r   ir8  r   s          r,   
test_itemsr    s    	C	DBggiG 1XID##Ic$8)B:MNNNN &&'9: ; #++Ic,@)BBUVVVV%%b2 vvag!+++ $ 
 ;:s   D
D$r  rV   Int64c                    [        SS/SSS.US9nUS S  nUR                  5       n[        R                  " U5         SX3U:H  '   S S S 5        U (       aI  [        R
                  " [        US5      [        US5      5      (       a   e[        R                  " XE5        g [        R
                  " [        US5      [        US5      5      (       d   eUR                  S   S:X  d   eg ! , (       d  f       N= f)Nr   r   r   r  r   r   r   )	r   r   r2   r3   r"   r#   r   r   r(   )r)   r  r4   r*   r   r   s         r,   test_putmaskr    s    	!Qaa0	>Ba5DggiG			1	28 
3 ##IdC$8)B:LMMMM
d, 	$ 4iC6HIIIIyy!### 
3	2s   C$$
C2c                     [        SS/SSS.US9n[        US5      nSX"U:H  '   U (       a)  [        R                  " U[        US5      5      (       d   eg g )Nr   r   r   r  r   r   r   r   r"   r#   r)   r  r*   r  s       r,   test_putmask_no_referencer    sX    	!Qaa0	>Bb#EBRxLyS'9:::: r.   float64Float64c                     [        SS/SS.US9n[        US5      n[        SSS/05      X"U:H  '   U (       a)  [        R                  " U[        US5      5      (       d   eg g )Nr   r   r   r  r   rs  r   r  r  s       r,   $test_putmask_aligns_rhs_no_referencer    sc    	#q,E	:Bb#EcC8_-BRxLyS'9:::: r.   zval, exp, warnT)r   FNc                 J   [        SS/SSS.5      nUS S  nUR                  5       n[        / SQ/ SQ/[        S5      S9nU(       a#  [        R                  " 5          XU'   S S S 5        O"[        R
                  " USS	9   XU'   S S S 5        U (       a  [        R                  " [        US
5      [        US
5      5      (       a   e[        R                  " [        US5      [        US5      5      UL d   e[        R                  " [        US5      [        US5      5      (       d   eUR                  R                  S5      ULd   eUR                  R                  S5      (       a   e[        R                  " Xg5        g US:X  az  [        R                  " [        US
5      [        US
5      5      (       d   e[        R                  " [        US5      [        US5      5      (       d   eUR                  S   S:X  d   eg g ! , (       d  f       GN= f! , (       d  f       GN= f)Nr   r   r   r   )TFFabcr   zincompatible dtyper   r   r   r   r   r   )r   r   r   r2   r3   r   r"   r#   r   r$   r   r   r(   )	r)   rv  expwarnr4   r*   r   r   indexers	            r,   "test_putmask_dont_copy_some_blocksr    s    
!Qac2	3Ba5DggiG	34d5kG ""$wK %$ ''4HIwK J ##IdC$8)B:LMMMM	$ 4iC6HISPPP	$ 4iC6HIIIIww((+366677,,Q////
d,		$ 4iC6HIIII	$ 4iC6HIIIIyy!###	 
 %$ JIs   H?H
H
H"c                 ,    U R                  U S:  S5      $ Nr   r   wherer   s    r,   r=   r=         CIIcAgr*r.   c                 ,    U R                  U S:*  S5      $ r  maskr  s    r,   r=   r=         CHHSAXr*r.   c                    [        / SQUS9nUR                  5       nU" U5      nU (       a1  [        R                  " [	        U5      [	        U5      5      (       d   eO0[        R                  " [	        U5      [	        U5      5      (       a   eSUR
                  S'   U (       a0  [        R                  " [	        U5      [	        U5      5      (       a   e[        R                  " X45        g )Nr   r  r   r   )r	   r   r"   r#   r   r(   r2   r   r)   r  r  r   r   r   s         r,   test_where_mask_noopr
    s     %
(CxxzH#YF	#	&0ABBBB##IcNIf4EFFFFFKKN##IcNIf4EFFFF3)r.   c                 ,    U R                  U S:  S5      $ r  r   r  s    r,   r=   r=     r  r.   c                 ,    U R                  U S:  S5      $ r  r  r  s    r,   r=   r=     r  r.   c                     [        / SQUS9nUR                  5       nU" U5      n[        R                  " [	        U5      [	        U5      5      (       a   e[
        R                  " X45        g )Nr   r  )r	   r   r"   r#   r   r2   r   r	  s         r,   test_where_maskr    sT     %
(CxxzH#YF	#	&0ABBBB3)r.   z
dtype, val)rV   g      %@)r  r   c                 ,    U R                  U S:  U5      $ Nr   r   r*   rv  s     r,   r=   r=     s    a-r.   c                 ,    U R                  U S:  U5      $ r  r  r  s     r,   r=   r=     s    a-r.   c                 N   [        / SQ/ SQS.US9nUR                  5       nU" XB5      nU (       ae  [        R                  " [	        US5      [	        US5      5      (       d   e[        R                  " [	        US5      [	        US5      5      (       a   eO2[        R                  " [	        US5      [	        US5      5      (       a   eSUR
                  S'   U (       a2  [        R                  " [	        US5      [	        US5      5      (       a   e[        R                  " XE5        g )	Nr   )ir   r  r   r   r   rG  r)  )r)   r  rv  r  r*   r   r   s          r,   %test_where_mask_noop_on_single_columnr    s     
6e	DBggiG"]F	"c 2Ifc4JKKKK##Ib#$6	&#8NOOOOO##Ib#$6	&#8NOOOOFKK##Ib#$6	&#8NOOOO"&r.   r  r  c                 F   [        / SQSS.5      nUR                  5       nU (       a  [        R                  " 5          [	        US   U5      " US   S:  SSS9  S S S 5        [        R
                  " X#5        [        R                  " 5          [	        US/   U5      " US   S:  SSS9  S S S 5        [        R
                  " X#5        g [        R                  " [        S	S
9   [	        US   U5      " US   S:  SSS9  S S S 5        [        R                  " S 5         [        SS 5         [	        US/   U5      " US   S:  SSS9  S S S 5        S S S 5        [        R                  " S 5         [        SS 5         [	        X"S   S:     U5      " US   S:  SSS9  S S S 5        S S S 5        g ! , (       d  f       GNX= f! , (       d  f       GN= f! , (       d  f       N= f! , (       d  f       N= f! , (       d  f       N= f! , (       d  f       Nn= f! , (       d  f       g = f)N)r   r   r   r   r   r   r   r   Tr  inplace methodr   mode.chained_assignment)	r   r   r2   raises_chained_assignment_errorr  r   r   r   r   )r)   r  r*   r   s       r,   test_chained_where_maskr  %  s   	+	,BggiG//1BsGT"2c7Q;4@ 2
b*//1BuIt$RWq[!TB 2
b*''=MNBsGT"2c7Q;4@ O ''- 94@C5	4(C1aF A . ''- 94@c7Q;.r#w{AtL A .- 21 21 ON A@ .-
 A@ .-sk   F*F<!GG0(GG0+H8!HH*
F9<
G
G
G-	)G00
G>
H	H
H c           	         [        S/ SQ0[        SSSS9S9nUR                  5       nUR                  SS9nU (       a3  [        R
                  " [        US5      [        US5      5      (       d   eO2[        R
                  " [        US5      [        US5      5      (       a   eS	UR                  S
'   [        R
                  " [        US5      [        US5      5      (       a   e[        R                  " X5        g )Nr   )g        N       @      @z1/1/2000r   minr  r   rU  r   r   )
r   r   r   asfreqr"   r#   r   r(   r2   r   r   s       r,   test_asfreq_noopr"  >  s    		#$QU;
B ggiG
)))
C	#s 3Yr35GHHHH##Ic3$72s9KLLLL CHHTN	#s 3Yr35GHHHH"&r.   c                     [        SSS./ SQS9nUR                  5       nUR                  5        H  u  p4SUR                  S'   M     U (       a  [        R
                  " X5        g g )Nr   r   r   r   r   r   )r   r   iterrowsr(   r2   r   )r)   r*   r   r+  subs        r,   test_iterrowsr&  R  sS    	#9	5BggiG++-  
b* r.   c                    [        SS[        R                  S/05      nUS S  nUR                  5       n[        R
                  " U5         UR                  SS9  S S S 5        [        R
                  " U5         SUR                  S'   S S S 5        U (       a  [        R                  " X45        g [        S/ SQ05      n[        R                  " X45        g ! , (       d  f       N= f! , (       d  f       Nc= f)	Nr   r   r   Tr        Y@r   )r(  r   r   )	r   r"   r  r   r2   r3   ffillr(   r   )r)   r4   r*   r   r   s        r,   test_interpolate_creates_copyr*  \  s    	C#rvvq)*	+Ba5DwwyH			1	2
 
3			1	2 
3 
d-c?34
d- 
3	2	2	2s   
C8C%
C"%
C3c                 ~   [        / SQ/ SQ/ SQS.5      nUR                  5       nUR                  S S9nUR                  S[        R                  " / SQ5      5        U (       ae  [        R
                  " [        US5      [        US5      5      (       d   e[        R
                  " [        US	5      [        US	5      5      (       d   eOd[        R
                  " [        US5      [        US5      5      (       a   e[        R
                  " [        US	5      [        US	5      5      (       a   eS
UR                  S'   [        R                  " X5        U (       a3  [        R
                  " [        US5      [        US5      5      (       d   eg [        R
                  " [        US5      [        US5      5      (       a   eg )Nr   r   r  r   r0   r   )r  r   r   r   r2  )
r   r   isetitemr"   arrayr#   r   r3  r2   r   r   s       r,   test_isetitemr0  n  sS   	C	DBggiG
''t'
CLLBHH\*+	"c 2Ic34GHHHH	"c 2Ic34GHHHH##Ib#$6	#s8KLLLL##Ib#$6	#s8KLLLLCGGFO"&	"c 2Ic34GHHHH##Ib#$6	#s8KLLLLLr.   zsingle-blockzmixed-blockc                    [        / SQ[        R                  " / SQUS9S.5      n[        / SQ5      nUR	                  5       nUR                  SU5        U (       aS  [        R                  " [        US5      [        U5      5      (       d   eUR                  R                  S5      (       a   eSUR                  S'   [        R                  " X45        [        / SQ[        R                  " / SQUS9S.5      n[        / SQ5      nUR                  SU5        SUR                  S'   [        / SQ[        R                  " / SQUS9S.5      n[        R                  " X%5        g )	Nr   r   r  r   r  r   r   r2  )r   r"   r/  r	   r   r.  r#   r   r$   r   r3  r2   r   r   )r)   r  r*   r   r   r   s         r,   test_isetitem_seriesr2    s	    
)5)IJ	KB

CxxzHKK3	"c 2IcNCCCC77,,Q//// BFF6N3) 
)5)IJ	KB

CKK3CGGAJyrxx	/OPQH"'r.   c                    [        / SQSSS.5      n[        / SQSS.5      nUR                  SS/U5        U (       a  [        R                  " [	        US5      [	        US5      5      (       d   e[        R                  " [	        US	5      [	        US	5      5      (       d   eUR
                  R                  S5      (       a   eOd[        R                  " [	        US5      [	        US5      5      (       a   e[        R                  " [	        US	5      [	        US	5      5      (       a   eUR                  5       nS
UR                  S'   S
UR                  S'   [        R                  " X5        g )Nr   r   r   r   r   r   r   r   r   r   r   rG  )r   r.  r"   r#   r   r$   r   r   r(   r2   r   )r)   r*   rhsr   s       r,   test_isetitem_framer5    s$   	3	4B
)!,
-CKKA	"c 2Ic34GHHHH	"c 2Ic34GHHHH77,,Q/////##Ib#$6	#s8KLLLL##Ib#$6	#s8KLLLLwwyHCHHTNCHHTN"'r.   r   c                 \   [        / SQ/ SQS.5      nUR                  5       nUR                  U5      nU (       a  [        R                  " [        US5      [        US5      5      (       d   eSUR                  S'   [        R                  " [        US5      [        US5      5      (       a   e[        R                  " X45        g U(       a  [        U[        5      (       a  [        OS nO[        U[        5      (       a  [        OS n[        SS5         [        R                  " U5         SUR                  S'   S S S 5        S S S 5        [        U[        5      (       a  [        R                  " X45        g UR                  S   S:X  d   eg ! , (       d  f       NX= f! , (       d  f       Na= f)	Nr   r   r   r   r   chained_assignmentr  r   )r   r   getr"   r#   r   r(   r2   r   
isinstancer:   r   r   r   r   r   )r)   r4   r   r*   r   r   r  s          r,   test_getr:    s6   	3	4BggiGVVC[F	&# 6	"c8JKKKKA##Ifc$:Ib#<NOOOO
b* $.sC$8$8=dD-7T-B-B)D0&9++D1!"A 2 : c4  !!".774=A%%% 21 :9s$   F*F:F
F	F
F+z	axis, keyr   )r   r   c           	         US:H  =(       a    U(       + nU=(       d    U=(       a    US:H  n[        / SQ/ SQ[        R                  " / SQUS9S.5      nUR                  5       n	UR	                  XCS9n
US:X  d  U(       a2  [        R
                  " [        US	5      [        U
5      5      (       d   eO)U (       a"  U
R                  R                  S
5      (       d   eU (       d  U(       a  U(       d  S
U
R                  S
'   OU(       a;  [        R                  " U=(       d    US:H  5         S
U
R                  S
'   S S S 5        OG[        SS5         [        R                  " [        5         S
U
R                  S
'   S S S 5        S S S 5        U (       d  U(       d  US
:X  a  [        R                  " X5        g UR                  S   S
:X  d   eg ! , (       d  f       NO= f! , (       d  f       Nh= f! , (       d  f       Nq= f)NrV   r   r   r   r  r  r   r%  r   r   r7  r  r   )r   r"   r/  r   xsr#   r   r$   r   r(   r2   r3   r   r   r   r   )r)   r4   r   rK   r   r  single_blockis_viewr*   r   r   s              r,   test_xsr?    sx    W$A.A*ALA2@tqyG	ibhhy.NO
B ggiGUU3U"FqyL	"c 2If4EFFFF	{{,,Q////w/AA	""<#<419=FKKN >= 0&9++,BC!"A D : <DAI
b*wwt}!!! >= DC :9s0   (G	G+(G8G+	
G
G(	$G++
G9rK   z
key, level)l1r   r  c                 (   [         R                  " S5      R                  SS5      n[        R                  " SS// SQ/SS/S	9n[        Xg[        S
5      S9nUS:X  a  UR                  5       R                  5       nUR                  5       n	UR                  X4US9n
US:X  aJ  [         R                  " [        XR                  S   5      [        XR                  S   5      5      (       d   eU(       a  US:X  a  [        OS nOU (       d  U(       d  [        nOS n[        SS5         [         R"                  " U5         SU
R$                  S'   S S S 5        S S S 5        [         R&                  " X5        g ! , (       d  f       N-= f! , (       d  f       N6= f)N   r   r   r@  l2r   lev1lev2r  r  r  r   )levelrK   r   r7  r  r   )r"   arangereshaper   from_productr   r   r   r   r<  r#   r   r    r   r   r   r2   r   r(   r   )r)   r4   r   r   rF  rK   arrr   r*   r   r   r  s               r,   test_xs_multiindexrK    s?   
 ))B-

1
%C##dD\9$=ffEUVE	3T%[	9Bqy\\^  "ggiGUU3$U/Fzb**Q-()FNN1<M*N
 
 	
 
  %
} )<%	,f	5''- !FKK . 
6 "& .- 
6	5s$   $F;E2F2
F 	<F
Fc                 p   [        / SQ/ SQS.5      n[        SS/0S/S9nUR                  5       nUS S  n[        R                  " U5         UR	                  U5        S S S 5        [        / SQ/ SQS.5      n[        R
                  " X&5        U (       a{  [        R
                  " XT5        [        R                  " [        US	5      [        US	5      5      (       d   e[        R                  " [        US5      [        US5      5      (       a   eg [        R
                  " XV5        g ! , (       d  f       N= f)
N      ?r  r  )      @g      @      @r   r         Y@r   r   )rO  rQ  rP  r   )	r   r   r2   r3   updater   r"   r#   r   )r)   r4   df1r   df1_origr   r   s          r,   test_update_framerU    s    
/@
AC
S5'N1#
.CxxzHq6D 
		1	2

3 
3 5FGHH#(
d-	#s 3YtS5IJJJJ##Ic3$749MNNNNN
d- 
3	2s   D''
D5c                    [        / SQ5      n[        S/S/S9nUR                  5       nUS S  nU(       a0  [        R                  " 5          UR	                  U5        S S S 5        OUR	                  U5        [        / SQ5      n[        R
                  " X&5        U (       a  [        R
                  " XT5        g [        R
                  " XV5        g ! , (       d  f       Nf= f)NrM  rQ  r   r   )rN  rQ  r  )r	   r   r2   r3   rR  r   )r)   r4   ser1r   	ser1_origr   r   s          r,   test_update_seriesrY  '  s    /"D5'!%D		I7D""$KK %$ 	D'(H4*
t/
t. %$s   C
Cc                 j   [        S/ SQ05      n[        S/S/S9nUR                  5       nU (       a  [        R                  " 5          US   R                  U5        S S S 5        [        R                  " X5        [        R                  " 5          US/   R                  UR                  5       5        S S S 5        [        R                  " X5        g [        R                  " [        SS9   US   R                  U5        S S S 5        [        R                  " S 5         [        SS 5         US/   R                  UR                  5       5        S S S 5        S S S 5        [        R                  " S 5         [        SS 5         XS   S:     R                  UR                  5       5        S S S 5        S S S 5        g ! , (       d  f       GNf= f! , (       d  f       GN!= f! , (       d  f       N= f! , (       d  f       N= f! , (       d  f       N= f! , (       d  f       Nn= f! , (       d  f       g = f)	Nr   r   rQ  r   r   r  r   r  )r   r	   r   r2   r  rR  r   r;  r   r   r   )r)   r*   r   r   s       r,   test_update_chained_assignmentr[  <  s   	C#	$B5'!%DggiG//1sGNN4  2
b*//1uIT]]_- 2
b*''=MNsGNN4  O ''- 94@C5	  1 A . ''- 94@c7Q;&&t}}7 A .- 21 21 ON A@ .-
 A@ .-sl   F<$G,G H,$G1H6H$(H+H$<
G
G 
G.1
G?	;H
H
H!	H$$
H2c                    [        / SQ5      nUR                  5       n[        U5      nUS-  nU (       aH  [        R                  " [        U5      U5      (       a   e[
        R                  " U[        U5      5        g [        R                  " [        U5      U5      (       d   e[
        R                  " U[        U5      5        g Nr   r   )r	   r   r   r"   r#   r2   assert_numpy_array_equal)r)   r   r   datas       r,   test_inplace_arithmetic_seriesr`  U  s    

CxxzHS>D1HC ##IcND9999
##D)H*=>	#5555
##D)C.9r.   c                    [        / SQ5      nUR                  5       nUS S  n[        R                  " U5         US-  nS S S 5        U (       aG  [        R
                  " [        U5      [        U5      5      (       a   e[        R                  " X45        g [        R
                  " [        U5      [        U5      5      (       d   eg ! , (       d  f       N= fr]  )r	   r   r2   r3   r"   r#   r   r   )r)   r4   r   r   r   s        r,   -test_inplace_arithmetic_series_with_referencerb  g  s     
CxxzHq6D			1	2q 
3##IcNIdODDDD
x.	#	$@@@@ 
3	2s   C
CFc                    [        / SQSS.5      nUR                  5       nUR                  US9nU(       d  U(       a  U (       a3  [        R                  " [        US5      [        US5      5      (       d   eO2[        R                  " [        US5      [        US5      5      (       a   eSUR                  S'   U (       a  [        R                  " X45        g g )	Nr   r   r   rB   r   r   r   r   )	r   r   r   r"   r#   r   r(   r2   r   )r)   r   r   r*   r   r   s         r,   test_transposerd  v  s    	+	,BggiG\\t\$F+/B	"c 2Ifa4HIIII##Ib#$6	&!8LMMMMFKK
b* r.   c                    [        / SQSS.5      nUR                  5       nUR                  n[        R                  " [        US5      [        US5      5      (       a   eSUR                  S'   U (       a  [        R                  " X5        g g )Nr   r   r   r   r   r   r   )	r   r   Tr"   r#   r   r(   r2   r   r)   r*   r   r   s       r,   test_transpose_different_dtypesrh    sp    	-	.BggiGTTF	"c 2Ifa4HIIIIFKK
b* r.   c                     [        S/ SQ0SS9nUR                  n[        R                  " [	        US5      [	        US5      5      (       a   eg )Nr   r   r  r  r   )r   rf  r"   r#   r   )r)   r*   r   s      r,   test_transpose_ea_single_columnrj    sF    	C#7	3BTTF	"c 2Ifa4HIIIIIr.   c                    [        / SQSS.5      nUR                  5       nS n[        R                  " U5         UR	                  U5        S S S 5        U (       a  [        R
                  " X#5        g g ! , (       d  f       N-= f)Nr   r   r   c                 $    SU R                   S'   U $ Nr   r   r   r  s    r,   r  "test_transform_frame.<locals>.func      
r.   )r   r   r2   r3   	transformr   )r)   r4   r*   r   r  s        r,   test_transform_framerq    sb    	+	,BggiG 
		1	2
T 
3
b*  
3	2s   A33
Bc                    [        / SQ5      nUR                  5       nS n[        R                  " U5         UR	                  U5        S S S 5        U (       a  [        R
                  " X#5        g g ! , (       d  f       N-= f)Nr   c                 $    SU R                   S'   U $ rm  r   r  s    r,   r  #test_transform_series.<locals>.func  ro  r.   )r	   r   r2   r3   rp  r   )r)   r4   r   r   r  s        r,   test_transform_seriesru    s]    

CxxzH 
		1	2d 
3
s-  
3	2s   A00
A>c                      [        SS/SS.5      n U R                  5       nSUR                  S'   [        SS/SS/S	9n[        R
                  " X5        g )
Nr   r   r   r   r   r   r   r   r   )r   countr(   r	   r2   r   rc  s      r,   test_count_read_only_arrayrx    sO    	!Qa(	)BXXZFFKKNsAhsCj1H6,r.   c                 v   [        / SQ5      nUR                  5       n[        R                  " [        SS9   UR                  5       nS S S 5        [        R                  " [        U5      [        W5      5      (       d   eU (       a"  UR                  R                  S5      (       a   e[        R                  " U5         SUR                  S'   S S S 5        U (       a  [        R                  " X25        g [        / SQ5      n[        R                  " X%5        g ! , (       d  f       N= f! , (       d  f       Na= f)Nr   zis deprecatedr   r   r   r   )r	   r   r2   r   r   r   r"   r#   r   r$   r   r3   r(   r   r  s         r,   test_series_viewrz    s    

CxxzH		#	#M	Ixxz 
JIcNIdO<<<<99..q1111			1	2		! 
3 
x-+&
s- 
J	I 
3	2s   D?D*
D'*
D8c                    [        S/ SQ05      n[        / SQ5      nUR                  5       nUR                  SUSS9  U (       aT  [        R
                  " [        U5      [        US5      5      (       d   eUR                  R                  S5      (       a   eO1[        R
                  " [        U5      [        US5      5      (       a   eSUR                  S'   [        R                  " X#5        g )Nr   r   r   r   )r3  valuecolumnr   rG  )r   r	   r   insertr"   r#   r   r$   r   r(   r2   r   )r)   r*   r   r   s       r,   test_insert_seriesr    s    	C#	$B

CxxzHII!3sI+	#	"c0BCCCC77,,Q/////##IcNIb#4FGGGGBGGDM3)r.   c                    [        / SQSS.5      nUR                  5       nUR                  S5      nU (       a3  [        R                  " [        US5      [        US5      5      (       d   eO2[        R                  " [        US5      [        US5      5      (       a   eSUR                  S'   [        R                  " X5        g )Nr   r   r   c = a+br   r   r   )	r   r   evalr"   r#   r   r(   r2   r   rg  s       r,   	test_evalr    s    	+	,BggiGWWYF	"c 2Ifc4JKKKK##Ib#$6	&#8NOOOOFKK"&r.   c                    [        / SQSS.5      nUR                  5       nUS S  nUR                  SSS9  [        R                  " [        US5      [        US5      5      (       d   e[        R                  " U5         SUR                  S	'   S S S 5        U (       a  [        R                  " XC5        g g ! , (       d  f       N-= f)
Nr   r   r   r  Tr  r   r   r   )
r   r   r  r"   r#   r   r2   r3   r(   r   )r)   r4   r*   r   df_views        r,   test_eval_inplacer    s    	+	,BggiGeGGGItG$Ib#.	'30GHHHH			1	2 
3
g/  
3	2s   >B55
Cc                 $   [        SS/SS/S.5      nUR                  5       nS n[        R                  " U5         UR	                  USS9  S S S 5        U (       a  [        R
                  " X#5        OUR                  S   S	:X  d   e[        SS/S
S/S.5      nUR                  5       n[        R                  " S 5         UR	                  USS9  S S S 5        [        R
                  " X#5        g ! , (       d  f       N= f! , (       d  f       N6= f)Nr   r   r   r   )r   r   c                     SU S'   U $ )Nr   r   r   )rows    r,   rp  (test_apply_modify_row.<locals>.transform  s    C
r.   r%  )r   r   r   r   r   )r   r   r2   r3   applyr   r3  r   )r)   r4   r*   r   rp  s        r,   test_apply_modify_rowr    s     
!Qq!f-	.BggiG 
		1	2
# 
3 
b*vvf~$$$ 
!QsCj1	2BggiG		#	#D	)
# 
* "& 
3	2 
*	)s   C0 D0
C>
D)|numpyr"   pytestpandas.compatr   pandas.errorsr   pandaspdr   r   r   r   r	   r
   r   r   r   pandas._testing_testingr2   pandas.tests.copy_view.utilr   r-   r5   markparametrizer   r   r   r   
RangeIndexr   r   r   r   r   r   r   r   r   r  r	  r  r  r  r  r  r,  r0  r5  r9  r<  r@  rC  rH  rR  rZ  r_  ra  rd  rk  rr  r  rw  ry  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r   r  r
  r  r  r  r"  r&  r*  r0  r2  r5  r:  r?  rK  rU  rY  r[  r`  rb  rd  rh  rj  rq  ru  rx  rz  r  r  r  r  r   r.   r,   <module>r     s\
     % 0 
 
 
  1*"MJ !45@B73N@B=5543:@?O#&	+  (R MS( 6T MF !45?5A:6PB887765<BAQ#&	+  (RES( 6TE< !45	N 6	N ', 2==A#6q!f"FG* H*,'$)(E0E.'( 	 	0  	'	'('&'( w&~F''$(*I(*-(7, 
);''"0,+ .&!,H 34' 5'&'&( 	8!<	2A6	JAN	GK	 	C  	:	:, AS!99cAq6];S TU# V#" AS!99cAq6];S TU# V#"'",'*'$ x!RVV&=>' ?'  C)* **  	''4'4;D;8 a0q!,''" H.?#@A' B'" AC!Q=1I JK# L#  AC!Q=1I JK# L# '$*" YS!2&C3C)DtSk(RS#	# YS!2&C3C)DtSk(RSK	K" Z0' 1'2'&*& 	!2IsI>N4O PQ# R#"'"*".& Xv$6&8I#JK' L'  02GH**&'0#(,, 7G"45$ 6$  7G"45; 6; 9i"89; :; T=13CD$$> 7G"45
*** 6*" 7G"45
*** 6* 'GH
--' I'$ &'!23M 4M0'(+.$M, gy!'F  ((0(" se-& .&8 vx&89gy!'F  " :"B !Q(	6':;' < )'<.*/*82:$A $/+ 0++J+.-.(*'0'r.   