
    Mh                    Z   S SK rS SK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\R.                  R1                  S/ SQ5      \R.                  R1                  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\R.                  R1                  S/ SQ5      \R.                  R1                  S	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\R.                  R1                  S/ SQ5      S0 5       rS1 r\R.                  R1                  S2\R:                  " S S35      \" S4S3/5      /5      S5 5       rS6 rS7 r S8 r!S9 r"S: r#S; r$\R.                  R1                  S2S< S= S> S? // S@QS9SA 5       r%SB r&SC r'\R.                  R1                  SDSESF/0SGSF0SHSF0/5      SI 5       r(SJ r)SK r*SL r+SM r,SN r-\R.                  R1                  SOSP SQ SR /5      SS 5       r.ST r/SU r0SV r1SW r2\R.                  R1                  SXS2SY/5      SZ 5       r3S[ r4S\ r5\R.                  R1                  S]S^ S 4S_ S34S` S 4Sa S 4// SbQS9Sc 5       r6\R.                  R1                  Sd\" S4S3/SFSe9\" SFS4S3/05      /5      Sf 5       r7\R.                  R1                  Sd\" S4S3/SFSe9\" SFS4S3/05      /5      Sg 5       r8Sh r9Si r:Sj r;Sk r<\R.                  R1                  SlSmS4\Rz                  4/5      Sn 5       r>\R.                  R1                  SoSpSq/5      Sr 5       r?\R.                  R1                  S	Ss St Su Sv /5      Sw 5       r@Sx rASy rBSz rC\R.                  R1                  S{SFS|S4S}.S S4S S}./5      S~ 5       rD\R.                  R1                  S	SS/5      S 5       rE\R.                  R1                  Sd\" S4S3/5      \" SFS4S3/05      /5      S 5       rF\R.                  R1                  Sd\" S4S3/5      \" SFS4S3/05      /5      S 5       rGS rHS rI\R.                  R1                  S\" / SQSFSe90 4\" SF/ SQ05      SSF04/5      S 5       rJ\R.                  R1                  S\" / SQSFSe90 4\" SF/ SQ05      SSF04/5      S 5       rK\R.                  R1                  S/ SQ5      S 5       rLS rMS rN\R.                  R1                  Sd\" / SQ5      \" SF/ SQ05      /5      S 5       rOS rPS rQS rR\R.                  R1                  S{SS0S2S0/5      S 5       rS\R.                  R1                  SSS/5      S 5       rTS rUS rVS rW\R.                  R1                  SSS/5      S 5       rX\R.                  R1                  SSS/5      S 5       rY\R.                  R1                  SSS/5      S 5       rZ\R.                  R1                  SSqS\[4S/5      S 5       r\\R.                  R1                  SSS/5      \R.                  R1                  SOS S /5      S 5       5       r]\R.                  R1                  SSS/5      \R.                  R1                  SOS S /5      S 5       5       r^\R.                  R1                  SSS/5      \R.                  R1                  SOS S /5      S 5       5       r_\R.                  R1                  SOSS/5      S 5       r`S raS rbS rcS rd\R.                  R1                  SSS/SS/S9S 5       reS rf\R.                  R1                  SSFSF//5      S 5       rg\R.                  R1                  SSS/5      \R.                  R1                  SSS/SS/S9S 5       5       rh\R.                  R1                  SS S4/5      \R.                  R1                  SSS/5      S 5       5       riS rjS rkS rlS rmS rn\R.                  R1                  SSS/5      S 5       roS rpS rqS rrS rsS rtS ruS rvS rwS rxS ryg)    N)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      U/var/www/html/env/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_shallowr4   +   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<   T   s    3994@r-   c                 &    U R                  SS/US9$ )Nr   r   r7   )reindexr;   s     r+   r<   r<   U   s    S#JTBr-   c                      U R                  XS9$ Nr   reindex_liker;   s     r+   r<   r<   V   s    7r-   c                 &    U R                  XS9S   $ NrA   r   alignr;   s     r+   r<   r<   W   s    "03r-   c                 (    U R                  / SQSUS9$ Nr   r   )axisr   set_axisr;   s     r+   r<   r<   X   s    _7Nr-   c                 "    U R                  SUS9$ Ntestr   r   rename_axisr;   s     r+   r<   r<   Y   s    f4@r-   c                 "    U R                  SUS9$ )NrO   r7   rQ   r;   s     r+   r<   r<   Z   s    TBr-   c                 &    U R                  SS0US9$ )Nr   int64rA   astyper;   s     r+   r<   r<   [   s    C>=r-   c                 $    U R                  SSUS9$ Nr   rA   swapaxesr;   s     r+   r<   r<   ]       Q5r-   c                 $    U R                  SSUS9$ Nr   r   rA   truncater;   s     r+   r<   r<   ^   r\   r-   c                      U R                  US9$ r@   infer_objectsr;   s     r+   r<   r<   _   s    ))t)4r-   c                      U R                  US9$ r@   to_timestampr;   s     r+   r<   r<   `   s    d3r-   c                 "    U R                  SUS9$ ND)freqr   	to_periodr;   s     r+   r<   r<   a   s    3T:r-   c                 "    U R                  SUS9$ N
US/CentralrA   tz_localizer;   s     r+   r<   r<   b   s    4@r-   c                 "    U R                  SUS9$ rn   
tz_convertr;   s     r+   r<   r<   c   s    |$?r-   c                 "    U R                  SUS9$ NF)allows_duplicate_labelsr   	set_flagsr;   s     r+   r<   r<   d   s    e$Or-   )r8   r>   rC   rG   rL   rename_axis0rename_axis1rW   r[   r`   rc   rf   rl   rq   rt   ry   )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)Nrf   
2012-01-01ri   r   rj   periodsrl   rq   rt   Europe/Brusselsrj   r   tzr   r   r   r   r   r[   "'DataFrame.swapaxes' is deprecatedmatchrA   Fzreindex-r   )nodecallspecidr   r
   r   r1   assert_produces_warningFutureWarning
startswithr!   r"   r   )
requestr5   r   r(   using_array_managerr   r)   msgdf2share_memorys
             r+   test_methods_copy_keywordr   P   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   rP   r8   serr   s     r+   r<   r<      s    #**As8$*?r-   c                 "    U R                  S US9$ r@   r   r   s     r+   r<   r<      s    #**T*5r-   c                 6    U R                  U R                  US9$ )NrP   )r>   r   r   s     r+   r<   r<      s    #++CIID+Ar-   c                      U R                  XS9$ r@   rB   r   s     r+   r<   r<      s    #**3*:r-   c                 &    U R                  XS9S   $ rE   rF   r   s     r+   r<   r<      s    #))C)3A6r-   c                 (    U R                  / SQSUS9$ rI   rK   r   s     r+   r<   r<      s    #,,W4,Pr-   c                 "    U R                  SUS9$ rN   rQ   r   s     r+   r<   r<      s    #//T/Br-   c                 "    U R                  SUS9$ )NrU   rA   rV   r   s     r+   r<   r<      s    #**W4*8r-   c                 $    U R                  SSUS9$ )Nr   r   rA   )	swaplevelr   s     r+   r<   r<      s    #--14-8r-   c                 $    U R                  SSUS9$ rY   rZ   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$ r@   rb   r   s     r+   r<   r<      s    #+++6r-   c                      U R                  US9$ r@   re   r   s     r+   r<   r<      s    #***5r-   c                 "    U R                  SUS9$ rh   rk   r   s     r+   r<   r<      s    #--St-<r-   c                 "    U R                  SUS9$ rn   rp   r   s     r+   r<   r<      s    #//,T/Br-   c                 "    U R                  SUS9$ rn   rs   r   s     r+   r<   r<      s    #..D.Ar-   c                 "    U R                  SUS9$ rv   rx   r   s     r+   r<   r<      s    #--D-Qr-   )zrename (dict)r8   r>   rC   rG   rL   rz   rW   r   r[   r`   rc   rf   rl   rq   rt   ry   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)Nrf   r~   ri   r   r   rl   rq   rt   r   r   r   r   r   r   r[   z'Series.swapaxes' is deprecatedr   rA   F)r   r   r   r   r
   r   from_arraysr   r1   r   r   r!   r"   r   )	r   r5   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   rA   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'   r1   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'   r1   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sumr1   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   r8   r9   upperr!   r"   r   r'   r1   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   r8   r9   r   r   r!   r"   r   r'   r1   r   )r(   r)   r   df2_origr   s        r+   !test_rename_columns_modify_parentr   8  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>.testfuncP  s    	r-   r   r   r   r   r   )	r   r   piper!   r"   r   r'   r1   r   r(   r)   r   r   r   r   s         r+   	test_piper   L  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>.testfunch  s    	r-   r   r   r   r   r   )r   r   r   r!   r"   r   r1   r   r   s         r+   test_pipe_modify_dfr   d  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'   r1   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   rA   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'   r1   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'   r1   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   rU   r   r   r   )r   r   select_dtypesr#   r   r!   r"   r   r'   r1   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'   r1   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'   r1   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   rJ   )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   rj   r   r   )r   r
   r   r   r  r!   r"   r   r'   r1   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   r1   r2   r'   nanr   )r(   r3   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'   r1   r2   r   )r(   r3   r)   r   view_originalr   r   s          r+   test_popr  2  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   rF   xys     r+   r<   r<   K  s    QWWQZr-   c                 6    U R                  UR                  SS9$ )Nr   rJ   )rG   r   r   s     r+   r<   r<   L  s    QWWQSSqW)r-   c                 d    U R                  UR                  R                  [        SS5         SS9$ )Nr   r   r$  )rG   r   r'   slicer   s     r+   r<   r<   M  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'   r1   r   )r(   r  r)   r   
df_changedr   _s          r+   test_align_framer+  H  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   rG   r!   r"   r   r'   r1   r   )r(   r   r   	ser_otherr   ser_other_results         r+   test_align_seriesr/  a  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   FrA   r   r   r   r   r   )	r   r   rG   r!   r"   r   locr1   r   )r(   r)   r   r   df3s        r+   test_align_copy_falser4  w  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   rJ   r   r   r1  )r   r   r   rG   r!   r"   r   r2  r1   r   r   )r(   r)   r   r   r   r   r   s          r+   !test_align_with_series_copy_falser8    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   r1   r2   r'   r   r   )r(   r3   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   r1   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_blockrB    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   r1   r   r   r[   r'   r   )r)   r   r   s      r+   test_swapaxes_read_only_arrayrG    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$ )NFr/   rA   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   )r8   r9   r   r:   r   s    r+   r<   r<     s%    BIIciiI077		7Jr-   c                 :    U R                  SS9R                  SS9$ )NFr/   number)include)r   r   r   s    r+   r<   r<     s    BGGG'55h5Gr-   )shallow-copyr   r8   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   rN  r   r   )	r   r   r   r   r   r1   r2   r'   r   )	r   r5   r   r(   r3   r)   r   df2_is_viewr   s	            r+   test_chained_methodsrQ    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objr6  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-1ri   rj   z2012-1-2r   r   )r   r   r   r   rf   r!   r"   r   r'   r1   assert_equalr(   rR  obj_origobj2s       r+   test_to_timestamprY    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YrT  r   r   )r   r	   r   r   rl   r!   r"   r   r'   r1   rU  rV  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   rF  r   )	r   r   r   r!   r"   r   r'   r1   r   r   s       r+   test_set_indexr`  3  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'   r1   r   r)   r   r   s      r+   4test_set_index_mutating_parent_does_not_mutate_indexrc  D  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   )rf  CoW_brg  )	r   r   
add_prefixr!   r"   r   r'   r1   r   r   s        r+   test_add_prefixrj  M  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   )rm  b_CoWrn  )	r   r   
add_suffixr!   r"   r   r'   r1   r   r   s        r+   test_add_suffixrq  b  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'   r1   r   )r(   rJ   valr)   r   r   s         r+   test_dropnarv  t  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-   ru  r   rr  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   rt  r!   r"   r   r'   r1   r   )r(   ru  r   r   r   s        r+   test_dropna_seriesrx    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   rz  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   r1   r2   r'   r   )r5   r(   r3   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                 F   [        SS/SSSS.5      nUR                  5       nUR                  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	'   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!  r   r   r   r   r   r   rF  )	r   r   rc   r!   r"   r   r'   r1   r   r   s       r+   test_infer_objectsr    sL   	!Qc<	=BggiG



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CHHTN##Ic3$72s9KLLLL##Ic3$72s9KLLLL"&r-   c                 6   [        SS/SS[        [        S5      [        S5      /SS9S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 (       ay  [        R                  " U[	        US
5      5      (       d   e[        R                  " U[	        US5      5      (       a   e[        R                  " U[	        US5      5      (       d   eg g )Nr   r   r   r[  r\  objectdtyper   )r   r   r   r   er   r   r   r   rF  
2018-12-31r   r   r   r   r	   rc   r   r'   r!   r"   )r(   r)   arr_aarr_barr_ds        r+   test_infer_objects_no_referencer    s   	Q<()L*AB( 	


B 
			Bb#Eb#Eb#EBGGDMBGGDMl+BGGDMyS'9::::##E9R+=>>>>yS'9::::	 r-   c                 >   [        SS/S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 (       ay  [        R                  " U[	        US	5      5      (       a   e[        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   rF  r  r  r  )r(   r)   r   r  r  r  s         r+   test_infer_objects_referencer    s   	Q<()L*AB(		
	
B a5D				Bb#Eb#Eb#EBGGDMBGGDMl+BGGDM##E9R+=>>>>##E9R+=>>>>yS'9:::: r-   kwargsr   )beforeafterrJ   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   r`   r#   r   r!   r"   r   r'   r1   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'   r1   r   )r(   r5   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'   r1   rU  rV  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'   r1   rU  rV  s       r+   test_between_timer  @  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   rF  )	r   r   rC   r!   r"   r   r'   r1   r   )r(   r)   otherr   r   s        r+   test_reindex_liker  Q  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'   r1   r   r(   r   r   r   s       r+   test_sort_indexr  c  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'   r1   rU  )r(   rR  r  rW  rX  s        r+   test_sort_valuesr  t  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   r1   r2   r'   rU  )r(   rR  r  r3   rW  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   rF  r   r   )	r   r   roundr!   r"   r   r'   r1   r   )r(   r3   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'   r1   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'   r1   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'   r1   rU  )r(   rR  r   rW  rX  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   rL   r!   r"   r   r'   r1   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   rL   r!   r"   r'   r1   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)rw   r   r   )	r   r   ry   r!   r"   r1   r2   r'   r   r(   r3   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mapperrO   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   r6  r   r   r   r   )
r   r   r   rR   r!   r"   r   r'   r1   r   r  s        r+   test_rename_axisr  #  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)rt   zEurope/Berlin)rq   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)startrj   r   r   r   ro   r   )
r   r
   r   r  r!   r"   r   r'   r1   r   )r(   r  r   r   r   r   s         r+   test_tz_convert_localizer  4  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'   r1   r   r  s        r+   test_droplevelr  J  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   r1  )r   r   squeezer!   r"   r   r   r1   r2   r'   r   r2  )r(   r3   r)   r   seriess        r+   test_squeezer  b  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   r1   r2   r'   r   r2  )r(   r3   r)   r   ir7  r   s          r+   
test_itemsr  v  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  rU   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   r1   r2   r!   r"   r   r   r'   )r(   r  r3   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   rr  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   r1   r2   r   r!   r"   r   r#   r   r   r'   )	r(   ru  expwarnr3   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'   r1   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   r1   r   r  s         r+   test_where_maskr    sT     %
(CxxzH#YF	#	&0ABBBB3)r-   z
dtype, val)rU   g      %@)r  r   c                 ,    U R                  U S:  U5      $ Nr   r  r)   ru  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   rF  r(  )r(   r  ru  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   r1   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   rT  r   r   )
r   r
   r   asfreqr!   r"   r   r'   r1   r   r   s       r+   test_asfreq_noopr   1  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'   r1   r   )r(   r)   r   r*  subs        r+   test_iterrowsr$  E  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   r1   r2   ffillr'   r   )r(   r3   r)   r   r   s        r+   test_interpolate_creates_copyr(  O  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   r/   r   )r  r   r   r   r1  )
r   r   isetitemr!   arrayr"   r   r2  r1   r   r   s       r+   test_isetitemr.  a  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   r1  )r   r!   r-  r   r   r,  r"   r   r#   r   r2  r1   r   r   )r(   r  r)   r   r   r   s         r+   test_isetitem_seriesr0  w  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   rF  )r   r,  r!   r"   r   r#   r   r   r'   r1   r   )r(   r)   rhsr   s       r+   test_isetitem_framer3    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'   r1   r   
isinstancer9   r   r   r   r   r   )r(   r3   r   r)   r   r   r  s          r+   test_getr8    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)NrU   r   r   r   r  r  r   r$  r   r   r5  r  r   )r   r!   r-  r   xsr"   r   r#   r   r'   r1   r2   r   r   r   r   )r(   r3   r   rJ   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rJ   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   )levelrJ   r   r5  r  r   )r!   arangereshaper   from_productr   r   r   r   r:  r"   r   r   r   r   r   r1   r   r'   r   )r(   r3   r   r   rD  rJ   arrr   r)   r   r   r  s               r+   test_xs_multiindexrI    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   )rM  rO  rN  r   )	r   r   r1   r2   updater   r!   r"   r   )r(   r3   df1r   df1_origr   r   s          r+   test_update_framerS    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)NrK  rO  r   r   )rL  rO  r  )r   r   r1   r2   rP  r   )r(   r3   ser1r   	ser1_origr   r   s          r+   test_update_seriesrW    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   rO  r   r   r  r   r  )r   r   r   r1   r  rP  r   r:  r   r   r   )r(   r)   r   r   s       r+   test_update_chained_assignmentrY  /  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"   r1   assert_numpy_array_equal)r(   r   r   datas       r+   test_inplace_arithmetic_seriesr^  H  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   r1   r2   r!   r"   r   r   )r(   r3   r   r   r   s        r+   -test_inplace_arithmetic_series_with_referencer`  Z  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   rA   r   r   r   r   )	r   r   r   r!   r"   r   r'   r1   r   )r(   r   r   r)   r   r   s         r+   test_transposerb  i  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'   r1   r   r(   r)   r   r   s       r+   test_transpose_different_dtypesrf  y  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   rd  r!   r"   r   )r(   r)   r   s      r+   test_transpose_ea_single_columnrh    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   r1   r2   	transformr   )r(   r3   r)   r   r  s        r+   test_transform_framero    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 $ rk  r   r   s    r+   r  #test_transform_series.<locals>.func  rm  r-   )r   r   r1   r2   rn  r   )r(   r3   r   r   r  s        r+   test_transform_seriesrs    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   r1   r   rb  s      r+   test_count_read_only_arrayrv    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   r1   r   r   r   r!   r"   r   r#   r   r2   r'   r   r  s         r+   test_series_viewrx    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   )r2  valuecolumnr   rF  )r   r   r   insertr!   r"   r   r#   r   r'   r1   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'   r1   r   re  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   r1   r2   r'   r   )r(   r3   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+   rn  (test_apply_modify_row.<locals>.transform  s    C
r-   r$  )r   r   r   r   r   )r   r   r1   r2   applyr   r2  r   )r(   r3   r)   r   rn  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)znumpyr!   pytestpandas.errorsr   pandaspdr   r   r   r   r   r	   r
   r   r   pandas._testing_testingr1   pandas.tests.copy_view.utilr   r,   r4   markparametrizer   r   r   r   
RangeIndexr   r   r   r   r   r   r   r   r   r  r  r  r  r  r  r  r+  r/  r4  r8  r;  r?  rB  rG  rQ  rY  r^  r`  rc  rj  rq  r  rv  rx  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(  r.  r0  r3  r8  r=  rI  rS  rW  rY  r^  r`  rb  rf  rh  ro  rs  rv  rx  r}  r  r  r  r   r-   r+   <module>r     sX
     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'*;8;6 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-   