
    Mhl                        S SK rS SKrS SKJr  S SKJs  Jr  S SK	J
r
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 S5      rS rS r\R8                  R;                  S	S
S/5      S 5       r\R8                  R;                  S\R>                  \R>                  S\R>                  \R>                  \R>                  S\R>                  \R>                  /	\R>                  \R>                  SSSSS\R>                  \R>                  /	SSS04\R>                  \R>                  S\R>                  \R>                  \R>                  S\R>                  \R>                  /	\R>                  \R>                  SS\R>                  \R>                  S\R>                  \R>                  /	SSSS.4\R>                  \R>                  S\R>                  \R>                  \R>                  S\R>                  \R>                  /	\R>                  \R>                  S\R>                  \R>                  \R>                  SSS/	SSS04\R>                  \R>                  S\R>                  \R>                  \R>                  S\R>                  \R>                  /	\R>                  \R>                  S\R>                  \R>                  \R>                  SS\R>                  /	SSSS.4\R>                  \R>                  \R>                  \R>                  \R>                  \R>                  \R>                  /\R>                  \R>                  \R>                  \R>                  \R>                  \R>                  \R>                  /SSSS.4\ " S5      \ " S5      SSSS.4\R>                  \R>                  S\R>                  \R>                  \R>                  S\R>                  \R>                  /	\R>                  \R>                  SSSSS\R>                  \R>                  /	SSS04\R>                  \R>                  S\R>                  \R>                  \R>                  S\R>                  \R>                  /	\R>                  \R>                  S\R>                  \R>                  SS\R>                  \R>                  /	SSSS.4\R>                  \R>                  S\R>                  \R>                  \R>                  S\R>                  \R>                  /	SSS\R>                  \R>                  \R>                  S\R>                  \R>                  /	SSS04\R>                  \R>                  S\R>                  \R>                  \R>                  S\R>                  \R>                  /	\R>                  SS\R>                  \R>                  \R>                  S\R>                  \R>                  /	SSSS.44
5      S 5       r!g)    N)using_pyarrow_string_dtype)
Categorical	DataFrameDatetimeIndexNaTPeriodIndexSeriesTimedeltaIndex	Timestamp
date_rangeto_datetime)_check_mixed_floatc                   D   \ rS rSrS r\R                  S 5       rS r\	R                  R                  \" 5       SS9S 5       rS rS	 rS
 rS rS rS rS rS rS rS rS rS r\	R                  R5                  S/ SQSS//5      S 5       rS r\	R                  R5                  SSS\R<                  S/5      S 5       rS r S r!S  r"S! r#S" r$S# r%\	R                  R5                  S$\&\'/5      S% 5       r(\	R                  R5                  S$\&\'/5      S& 5       r)S' r*S( r+S) r,S* r-S+ r.S, r/S- r0\	R                  R                  \" 5       SS9S. 5       r1S/ r2S0 r3S1 r4S2 r5\Rl                  \	R                  R5                  SS3S3S3S4./5      S5 5       5       r7S6 r8S7 r9S8r:g9):
TestFillNA   c                 P   [        [        R                  /S-  [        [	        S5      [        /[        R                  SS/S.5      n/ SQUl        US S  n[        R                  " U5         UR                  SS0SS	9  S S S 5        [        S
/S-  S[	        S5      S// SQS.5      n/ SQUl        [        R                  " X55        U(       d@  [        R                  " UR                  S S 2S4   UR                  S S 2S4   5      (       d   e[        R                  " UR                  S S 2S4   UR                  S S 2S4   5      (       a   eU(       dA  [        R                  " UR                  S S 2S4   UR                  S S 2S4   5      (       d   eg g ! , (       d  f       GN= f)N      foo   ABC)r   r   r   r   Tinplace       @)r   r   r   r   )r   npnanr   r   columnstmassert_cow_warningfillnaassert_frame_equalshares_memoryiloc)selfusing_copy_on_writewarn_copy_on_writedforigexpecteds         X/var/www/html/env/lib/python3.13/site-packages/pandas/tests/frame/methods/test_fillna.py*test_fillna_dict_inplace_nonunique_columns5TestFillNA.test_fillna_dict_inplace_nonunique_columns   s]    66(Q,c9Q<%=RVVUTUDVW
 %
!u ""#56IIsAhI- 7 %!)1ilA"6]K
 +
b+ ###BGGAqDM499QT?CCCC##BGGAqDM499QT?CCCC"##BGGAqDM499QT?CCCC # 76s   +F
F%c                    [         R                  " S[         R                  5      n[        USS9nU(       ad  [        R
                  " 5          US   R                  SSS9  S S S 5        [         R                  " US S 2S4   5      R                  5       (       d   eOV[        R                  " [        SS	9   US   R                  SSS9  S S S 5        US S 2S4   S:H  R                  5       (       d   e[        UR                  R                  5      S
:X  d   e[         R                  " UR                  U5      (       d   eg ! , (       d  f       N= f! , (       d  f       N= f)N)(   2   F)copyr   Tr   zinplace methodmatchr   )r   fullr   r   r!   raises_chained_assignment_errorr#   isnanallassert_produces_warningFutureWarninglen_mgrarraysr%   values)r'   r(   arrr*   s       r-   test_fillna_on_column_view%TestFillNA.test_fillna_on_column_view4   s    ggh's'3351R. 688C1I&**,,,,++MAQR1R. S1IO((**** 277>>"a'''		3//// 65 SRs   D?4E?
E
Ec                    Un[         R                  UR                  UR                  S S S4'   [         R                  UR                  UR                  SS  S4'   UR	                  S5      nUR                  UR                  S S S4   S:H  R                  5       (       d   eSn[        R                  " [        US9   UR	                  SS9nS S S 5        [         R                  " WR                  UR                  S S S4   5      R                  5       (       d   eUR                  UR                  SS  S4   UR                  UR                  S   S4   :H  R                  5       (       d   eS	n[        R                  " [        US9   UR	                  5         S S S 5        S
n[        R                  " [        US9   UR	                  SSS9  S S S 5        g ! , (       d  f       GN= f! , (       d  f       NU= f! , (       d  f       g = f)N   r   r   ,DataFrame.fillna with 'method' is deprecatedr5   padmethodz'Must specify a fill 'value' or 'method'z(Cannot specify both 'value' and 'method'ffill)r   r   locindexr#   r:   r!   r;   r<   r9   pytestraises
ValueError)r'   datetime_frametfzero_filledmsgpaddeds         r-   test_fillna_datetimeTestFillNA.test_fillna_datetimeG   s   $&FFrxx|S !%'VVrxx}c!"$++A. 1 1"1 5s :;q@EEGGGG<''SA#**%*8F Bxx

6<<#3S#89:>>@@@@JJv||BC(#-.&**V\\"=Ms=R2SS
#% 	  8]]:S1!!# 28]]:S1!!!G!4 21 BA 21 21s$   =G	G)=G:
G&)
G7:
Hzcan't fill 0 in string)reasonc                 ^   Un[         R                  UR                  UR                  SS S4'   [         R                  UR                  UR                  SS  S4'   UR	                  SS9  Sn[
        R                  " [        US	9   UR	                  S
S9  S S S 5        g ! , (       d  f       g = f)NrE      r   r   r   valuerG   r5   rH   rI   )r   r   rL   rM   r#   r!   r;   r<   )r'   float_string_framemfrT   s       r-   test_fillna_mixed_type!TestFillNA.test_fillna_mixed_type^   s    (*rxx"~u$%&(ffrxx~s"#
			<''SAIIUI# BAAs   B
B,c                 T   UR                  / SQS9n[        R                  UR                  UR                  SS  S4'   UR                  SS9n[        USS 0S9  S	n[        R                  " [        US
9   UR                  SS9nS S S 5        [        USS 0S9  g ! , (       d  f       N= f)N)r   r   Dr    r[   r   r   r\   r   dtyperG   r5   rH   rI   )
reindexr   r   rL   rM   r#   r   r!   r;   r<   )r'   mixed_float_framer_   resultrT   s        r-   test_fillna_mixed_float"TestFillNA.test_fillna_mixed_floati   s    &&&?&(ffrxx~s"##6#t5<''SAYYeY,F B6#t5 BAs   4B
B'c                 6   U(       a  [         R                  " S5        [        S/S9nS HZ  nSn[        R                  " [
        US9   UR                  R                  USS9  UR                  R                  US	9  S S S 5        M\     g ! , (       d  f       Mn  = f)
Nz9condition is unnecessary complex and is deprecated anywayxrd   )rH   backfillz)Series.fillna with 'method' is deprecatedr5   TrJ   r   rI   )rN   skipr   r!   r;   r<   rm   r#   )r'   r(   r*   mrT   s        r-   test_fillna_emptyTestFillNA.test_fillna_emptyu   ss    KKSTu%$A=C++ME1d31% FE %EEs   4B		
B	c                    [        SS[        R                  S/SS[        R                  S/SS[        R                  S//5      nU(       a6  [        R                  " [
        SS9   UR                  SS05      nS S S 5        OUR                  SS05      n[        / SQ/ S	Q/ S
Q/5      n[        R                  " WU5        U(       a5  [        R                  " [
        SS9   UR                  SS0SS9nS S S 5        OUR                  SS0SS9n[        R                  " X$5        Wb   eg ! , (       d  f       N= f! , (       d  f       N;= f)NabcDowncastingr5   r   r   )ru   ru   r   ru   )rv   rv   r   rv   )rw   rw   r   rw   Tr   r   r   r   r!   r;   r<   r#   r$   )r'   using_infer_stringr*   ri   r,   return_values         r-   test_fillna_different_dtype&TestFillNA.test_fillna_different_dtype   s"   3$sC&=S"&&RU?VW
 ++MOAu:. PO YY5z*F#%;=ST
 	fh/++MO!yy!UTyB PO 99aZ9>L
b+### PO POs   %D* D;*
D8;
E	c                    [        [        R                  R                  S5      R	                  S5      5      n[        R
                  UR                  SS2S4'   [        R
                  UR                  SS2S4'   UR                  5       nSUR                  S'   SUR                  S	'   UR                  SS
S9n[        R                  " X25        g )Nr   )
   r      r   r   rE   i  )r   r   )r   r   r   limit)r   r   randomdefault_rngstandard_normalr   r&   r3   r#   r!   r$   r'   r*   r,   ri   s       r-   test_fillna_limit_and_value&TestFillNA.test_fillna_limit_and_value   s    ryy,,Q/??HI&&!Q&&!Q779!d!d3a(
f/    c                 6   [        [        [        S5      /[        S5      [        /S.5      nUR                  5       nUS   R	                  UR
                  UR                  S   S4   5      US'   UR	                  SUS   0S9n[        R                  " X25        g )Nz2014-1-1z2013-1-1)DateDate2r   r   r   r\   )	r   r   r   r3   r#   rL   rM   r!   r$   r   s       r-   test_fillna_datelikeTestFillNA.test_fillna_datelike   s     i
34#J/5
 779#F+22266"((1+w:N3OP&"W+!67
f/r   c                 b   [        S[        S5      [        /05      n[        S[        S5      [        S5      /05      nSn[        R                  " [
        US9   UR                  SS9nS S S 5        [        R                  " WU5        [        S[        [        S5      /05      n[        S[        S5      [        S5      /05      nSn[        R                  " [
        US9   UR                  SS9nS S S 5        [        R                  " XB5        g ! , (       d  f       N= f! , (       d  f       N6= f)Nr   z2012-11-11 00:00:00+01:00rG   r5   rH   rI   bfill)r   r   r   r!   r;   r<   r#   r$   )r'   r*   exprT   ress        r-   test_fillna_tzawareTestFillNA.test_fillna_tzaware   s    i(CDcJKL9:9:
 =''SA))5))C B
c3'c9-H#IJKL9:9:
 =''SA))7)+C B
c'! BA BAs   D D 
D 
D.c                 Z   [        [        SSSS9SS[        R                  [        R                  /S.5      nSn[        R
                  " [        US	9   UR                  S
S9nS S S 5        [        [        SSSS9/ SQS.5      n[        R                  " WU5        g ! , (       d  f       N?= f)N20130101   z
US/Eastern)periodstzr   r   r   r   rG   r5   rH   rI   )      ?r   r   r   )	r   r   r   r   r!   r;   r<   r#   r$   r'   r*   rT   ri   r,   s        r-   $test_fillna_tzaware_different_column/TestFillNA.test_fillna_tzaware_different_column   s     
A,GBFFBFF+
 =''SAYYeY,F B
A,G)
 	fh/ BAs   B
B*c                    [        SSS[        R                  // SQS9nSS[        R                  S/n[        XS	.5      n[        / S
Q/ SQS9n/ SQn[        XES	.5      n[        / SQ/ SQS9nSS[        R                  /n[        XxS	.5      n	[        SS// SQS9n
SS/n[        XS	.5      nUR	                  SSS	.S9n[
        R                  " X5        Sn[        R                  " [        US9   UR	                  SSS	.S9  S S S 5        Sn[
        R                  " [        US9   UR	                  SS9nS S S 5        [
        R                  " X5        UR                  S/S9n[
        R                  " X5        UR                  5       n[
        R                  " X5        [        [        R                  S[        R                  /SS/S9n[        U/ SQS	.5      n[        / SQSS/S9n[        U/ SQS	.5      nUR	                  S5      n[
        R                  " UU5        g ! , (       d  f       GN&= f! , (       d  f       GN= f)Nr   r   r   r   r   r   )
categoriesru   rv   dcatsvals)r   r   r   r   )ru   rv   rv   r   r\   z3Cannot setitem on a Categorical with a new categoryr5   r   rw   rG   rH   rI   r   )subset)ru   rv   ru   )r   r   r   r   r#   r!   r$   rN   rO   	TypeErrorr;   r<   dropna)r'   catr   r*   cat2vals2df_exp_fillcat3vals3df_exp_drop_catscat4vals4df_exp_drop_allr   rT   rw   cat_expdf_exps                     r-   test_na_actions_categorical&TestFillNA.test_na_actions_categorical   s   1aBFF+	BS"&&#&23<I>$ =>9;c266"$d%BCAq6i8c
#T$AB iiq#6i7
c/C]]9C0IIQ4I5 1 =''SA))5))C B
c/ iixi(
c4iik
c3 bff-3*E956o3*EGY?@iin
c6*/ 10 BAs   /H!%H3!
H03
Ic                 
   [        [        R                  S[        R                  /5      n[        [        R                  [        R                  [        R                  /5      n[        XS.5      n[	        S[        R                  S.5      nUR                  U5      n[        R                  [        R                  [        R                  /n[        / SQUS.SS9n[        R                  " XW5        UR                  R                  [        R                  5      n[        R                  " XR                  5        UR                  R                  [        R                  5      n[        R                  " XR                  5        [        SSS[        [        /5      n	[        S	[        U	5      05      n[        R                  " UR                  [        S
9U5        [        SSS[        [        /SS9n	[        S	[        U	5      05      n[        R                  " UR                  [        S
9U5        [        SSS[        [        /5      n	[        S	[        U	5      05      n[        R                  " UR                  [        S
9U5        g )Nr   r   r   )r   r   r   categoryre   z2011-01-01 09:00z2016-01-01 23:45ru   r\   z2011-01M)freqz1 daysz2 days)r   r   r   r   r	   r#   r!   r$   r   assert_series_equalr   r   r   r   r
   )
r'   r   valr*   medianr   v_expr   ri   idxs
             r-   test_fillna_categorical_nan&TestFillNA.test_fillna_categorical_nan  s    2661bff-.2662662662312 bff56ii(Iu=ZP
c*'
vww/'
vww/!35GcR
 [-./
biici2B79iCECP[-./
biici2B7h(CEF[-./
biici2B7r   c                 "   [        SS[        R                  /05      nSn[        R                  " [
        US9   UR                  SSS9nS S S 5        [        SSS/05      n[        R                  " WU5        [        SS[        R                  /05      n[        R                  " [
        US9   UR                  SS0SS9nS S S 5        [        SSS/05      n[        R                  " X45        g ! , (       d  f       N= f! , (       d  f       NE= f)	Nru   r   z.The 'downcast' keyword in fillna is deprecatedr5   r   inferdowncastr   ry   r   s        r-   test_fillna_downcastTestFillNA.test_fillna_downcast6  s     c266]+,>''SAYYq7Y3F BcAq6]+
fh/ c266]+,''SAYYQx'Y:F BcAq6]+
f/ BA BAs   C/.D /
C= 
Dc                     U" / SQSS9nSn[         R                  " [        US9   UR                  SSS9nS S S 5        [         R                  " WU5        g ! , (       d  f       N&= f)	Nr   objectre    The 'downcast' keyword in fillnar5    Fr   )r!   r;   r<   r#   assert_equal)r'   frame_or_seriesobjrT   ri   s        r-   test_fillna_downcast_false%TestFillNA.test_fillna_downcast_falseG  sS    ix80''SAZZUZ3F B
$ BAs   A
A$c                 \   U" / SQ[         R                  S9nSn[        R                  " [        US9   UR                  S[         R                  " [         R                  5      S9nS S S 5        UR                  [         R                  5      n[        R                  " WU5        UR                  [         R                  5      n[        R                  " [        US9   UR                  SSS9nS S S 5        Un[        R                  " WU5        [        R                  " [        US9   UR                  S[         R                  " [         R                  5      S9n	S S S 5        [        R                  " W	U5        g ! , (       d  f       GN= f! , (       d  f       N= f! , (       d  f       NI= f)Nr   re   r   r5   r   r   r   )r   int64r!   r;   r<   r#   rf   int32astyper   float64)
r'   r   r   rT   r   r,   obj2res2	expected2res3s
             r-   test_fillna_downcast_noop$TestFillNA.test_fillna_downcast_noopO  s     irxx80''SA**URXXbhh-?*@C B ::bhh'
X&zz"**%''SA;;uw;7D B	
i(''SA;;urxx/A;BD B 	h' BA BA
 BAs#   3E:F'3F:
F	
F
F+r    )r   r   r   r   c                    [        [        R                  SS/US9n[        R                  " S 5         UR                  SS05      nS S S 5        UR                  5       nSUS'   [        R                  " WU5        g ! , (       d  f       N;= f)Nr   r   rM   r    r           )r   r   r   r!   r;   r#   r3   r$   )r'   r    r*   ri   r,   s        r-   -test_fillna_dictlike_value_duplicate_colnames8TestFillNA.test_fillna_dictlike_value_duplicate_colnamesi  sn     rvvaVW=''-YYQx(F . 779
fh/ .-s   A;;
B	c                    [        / SQ/ SQS9nUR                  n[        [        R                  " S5      /S-  / SQS9n[
        R                  " X45        Sn[
        R                  " [        US9   UR                  S	5      nS S S 5        [        S	/ SQ/ SQS9n[
        R                  " X45        [        [        S
5      SS/SS9nU(       a4  [
        R                  " [        SS9   UR                  S5      nS S S 5        OUR                  S5      n[        S[        S
5      SS/S9n[
        R                  " X45        g ! , (       d  f       N= f! , (       d  f       NL= f)Nr   )r   r   r   r   rE   r   r   rE   rM   Downcasting object dtype arraysr5   r   r   r   r   r   )rM   r    rf   rx   r   )r   dtypesr	   r   rf   r!   r   r;   r<   r#   r$   range)r'   rz   r*   ri   r,   rT   s         r-   test_fillna_dtype_conversion'TestFillNA.test_fillna_dtype_conversiont  s   _oF288H-.2/J
v0/''SAYYq\F BQoO
f/ U1XSzK++MO5) PO YYu%FU%(S#JG
f/ BA POs   0D>%E>
E
Er   r   r   r   c                     [        S[        R                  /SS/S.5      nUR                  [        R                  U5      nUR	                  U5      n[
        R                  " XC5        g )Nr   r   r   r   )r   r   r   replacer#   r!   r$   )r'   r   r*   r,   ri   s        r-   *test_fillna_dtype_conversion_equiv_replace5TestFillNA.test_fillna_dtype_conversion_equiv_replace  sL    a[Sz:;::bffc*3
f/r   c                 @   [        SS[        R                  /[        SSS9/ SQ/ SQS.[        S	SS9S
9nUR	                  S5      n[        / SQ[        SSS9/ SQ/ SQS.[        S	SS9S
9n[
        R                  " X#5        [        SS[        R                  /[        S5      [        S5      [        // SQ/ SQS.[        S	SS9S
9nUR	                  S5      n[        / SQ[        S5      [        S5      S// SQ/ SQS.[        S	SS9S
9n[
        R                  " X#5        g )Nr4   r   r   )r   )r   barN)foo2bar2Nr   r   r   rc   20130110r   ?)r4   r   r   )r   r   r   )r   r   r   z
2013-01-01z
2013-01-02)	r   r   r   r   r#   r!   r$   r   r   r'   r*   ri   r,   s       r-   test_fillna_datetime_columns'TestFillNA.test_fillna_datetime_columns  s"   "bff%
A6)+	 Z3
 3"
A6(*	 Z3
 	f/"bff%-y/FL)+	 Z3
 3"-y/FL(*	 Z3
 	f/r   c                    [         R                  UR                  UR                  S S S4'   [         R                  UR                  UR                  SS  S4'   Sn[        R
                  " [        US9   UR                  SS9nS S S 5        [        R                  " UR                  5       W5        g ! , (       d  f       N4= f)NrE   r   rF   rG   r5   rK   rI   )
r   r   rL   rM   r!   r;   r<   r#   r$   rK   r'   rQ   rT   alts       r-   
test_ffillTestFillNA.test_ffill  s    <>FF>//3S89=?VV>//4c9:<''SA ''w'7C B
n224c: BA   4B22
C c                    [         R                  UR                  UR                  S S S4'   [         R                  UR                  UR                  SS  S4'   Sn[        R
                  " [        US9   UR                  SS9nS S S 5        [        R                  " UR                  5       W5        g ! , (       d  f       N4= f)NrE   r   rF   rG   r5   r   rI   )
r   r   rL   rM   r!   r;   r<   r#   r$   r   r   s       r-   
test_bfillTestFillNA.test_bfill  s    <>FF>//3S89=?VV>//4c9:<''SA ''w'7C B 	n224c: BAr   c                    [         R                  " S5      n[        [         R                  R	                  S5      R                  S5      US9nUS S R                  USSS9nSn[        R                  " [        US	9   US S R                  U5      R                  SS
9nS S S 5        [         R                  WR                  SS & [        R                  " X55        USS  R                  USSS9n[        R                  " [        US	9   USS  R                  U5      R                  SS
9nS S S 5        [         R                  UR                  S S& [        R                  " X55        g ! , (       d  f       N= f! , (       d  f       NS= f)Nr   r   r   r   r   rH   rE   rJ   r   rG   r5   rI   r   rn   r   r   aranger   r   r   r   rg   r!   r;   r<   r#   r   r&   r$   r'   rM   r*   ri   rT   r,   s         r-   test_frame_pad_backfill_limit(TestFillNA.test_frame_pad_backfill_limit  s7   		"ryy,,Q/??HPUVBQe1=<''SA"1v~~e,3353AH BVVbc
f/BCzC''SA"#wu-44J4GH BFFbq
f/ BA BAs   <"E$"E5$
E25
Fc                    [         R                  " S5      n[        [         R                  R	                  S5      R                  S5      US9nUS S R                  U5      nSn[        R                  " [        US9   UR                  SSS	9nS S S 5        [        R                  " [        US9   US S R                  U5      R                  SS
9nS S S 5        [         R                  WR                  SS & [        R                  " X55        USS  R                  U5      n[        R                  " [        US9   UR                  SSS	9nS S S 5        [        R                  " [        US9   USS  R                  U5      R                  SS
9nS S S 5        [         R                  UR                  S S& [        R                  " X55        g ! , (       d  f       GNB= f! , (       d  f       GN= f! , (       d  f       N= f! , (       d  f       Nw= f)Nr   r   r  r   rG   r5   rH   rE   r  rI   r  r   rn   r   r  r  s         r-   test_frame_fillna_limit"TestFillNA.test_frame_fillna_limit  s   		"ryy,,Q/??HPUVBQ&<''SA]]%q]9F B ''SA"1v~~e,3353AH BVVbc
f/BC'''SA]]*A]>F B ''SA"#wu-44J4GH BFFbq
f/ BA BA BA BAs0   <G."G8G,*"G=
G
G),
G:=
Hc                     [        [        R                  R                  S5      R	                  S5      R                  [        5      5      nUR                  [        R                  5        g )Nr   r  )	r   r   r   r   r   r   intr#   r   )r'   r*   s     r-   test_fillna_skip_certain_blocks*TestFillNA.test_fillna_skip_certain_blocks  sF     ryy,,Q/??HOOPSTU 			"&&r   typec                    [        [        R                  R                  S5      R	                  S5      5      R                  U5      nSn[        R                  " [        US9   UR                  SSS9  S S S 5        g ! , (       d  f       g = f)Nr   r  zLimit must be greater than 0r5   r   rF   r   
r   r   r   r   r   r   rN   rO   rP   r#   r'   r  r*   rT   s       r-   test_fillna_positive_limit%TestFillNA.test_fillna_positive_limit  sa    ryy,,Q/??HIPPQUV,]]:S1IIarI" 211   "A<<
B
c                    [        [        R                  R                  S5      R	                  S5      5      R                  U5      nSn[        R                  " [        US9   UR                  SSS9  S S S 5        g ! , (       d  f       g = f)Nr   r  zLimit must be an integerr5   r   g      ?r   r  r  s       r-   test_fillna_integer_limit$TestFillNA.test_fillna_integer_limit  sa    ryy,,Q/??HIPPQUV(]]:S1IIasI# 211r  c                 d   [        [        R                  R                  S5      R	                  S5      5      n[        R
                  UR                  S S2S4'   [        R
                  UR                  SS 2S4'   UR                  SS9nX!Ld   eUR                  SS	S
9  [        R                  " X5        UR                  SS0S	S
9nUb   e[        R
                  UR                  S S2S4'   [        R
                  UR                  SS 2S4'   Sn[        R                  " [        US9   UR                  SS9nS S S 5        X!Ld   e[        R                  " [        US9   UR                  S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   r\   Tr]   r   rG   r5   rK   rI   ro   )r   r   r   r   r   r   rL   r#   r!   r$   r;   r<   )r'   r*   r,   rT   s       r-   test_fillna_inplaceTestFillNA.test_fillna_inplace  sa   ryy,,Q/??HIrr1ursAv9919%!!!
		4	(
b+99Aq6498rr1ursAv<''SAyyy0H B!!!''SAIIWdI3 B
b+ BA BAs   )F F!
F!
F/c           	      J   [        [        R                  SS[        R                  [        R                  /SSS[        R                  [        R                  /[        R                  SSSS/S.5      nUR                  SSS.5      nUR	                  5       nUS	   R                  S5      US	'   US
   R                  S5      US
'   [
        R                  " X#5        UR                  SSSS.5      nUR                  UR                  5       5      nUR                  UR                  5       R                  5       5      n[
        R                  " X#5        [        R                  " [        SS9   UR                  UR                  S5      SS9  S S S 5        g ! , (       d  f       g = f)Nr   r   r   r   ru   rv   rw   r   rE   )ru   rv   ru   rv   r   )ru   rv   r   zcolumn by columnr5   )axis)r   r   r   r#   r3   r!   r$   maxto_dictrN   rO   NotImplementedErrorr   s       r-   test_fillna_dict_series"TestFillNA.test_fillna_dict_series,  s@   ffaBFFBFF3Arvvrvv.ffaAq)
 +,779 ,,Q/ ,,Q/
f/ 34 2668$99RVVX--/0
f/ ]].6HIIIbffQiaI( JIIs   + F
F"c           	      b   [        [        R                  SS[        R                  [        R                  /SSS[        R                  [        R                  /[        R                  SSSS/S.[        S5      S9n[        [        R                  SS	S
S// SQS/S-  S.[        S5      S9nUR	                  U5      n[        [        R                  SS[        R                  S/SSS[        R                  S/[        R                  SSSS/S.[        S5      S9n[
        R                  " X45        g )Nr   r   r   r   r   VWXYZr   r   rZ      r1   )r2   <   F   P   Z   r   rE   )ru   rv   r   VWXuZr-  r   r   r   listr#   r!   r$   )r'   r*   df2ri   r,   s        r-   test_fillna_dataframe TestFillNA.test_fillna_dataframeH  s   ffaBFFBFF3Arvvrvv.ffaAq)
 w-
 ffb"b"-)w{
 w-
 3 ffaBFFB/Arvvr*ffaAq)
 w-
 	f/r   c                    [         R                  R                  S5      R                  S5      n[         R                  US S 2S S S24'   [        U5      nSn[        R                  " [        US9   UR                  SSS9nS S S 5        [        R                  " [        US9   UR                  R                  SS	9R                  nS S S 5        [        R                  " WW5        UR                  S
SS5        [        R                  " [        US9   UR                  SSS9nS S S 5        [        R                  " [        US9   UR                  [        5      R                  SSS9nS S S 5        [        R                  " XE5        g ! , (       d  f       GN= f! , (       d  f       N= f! , (       d  f       N= f! , (       d  f       NY= f)Nr   )r   r   rG   r5   rK   r   )rJ   r!  rH   rI      r   rE   )r   r   r   r   r   r   r!   r;   r<   r#   Tr$   insertr   float)r'   rA   r*   rT   ri   r,   s         r-   test_fillna_columnsTestFillNA.test_fillna_columnsk  sH   ii##A&66x@ffAssFs^<''SAYYgAY6F B''SAtt{{%{022H B
fh/
		!UA''SAYYgAY6F B''SAyy'..gA.FH B
f/ BAAA
 BAAAs0   /F!$FF($F9
F
F%(
F69
Gc                     [         R                  " [        SS9   UR                  SS9  S S S 5        g ! , (       d  f       g = f)Nffilr5   rI   )rN   rO   rP   r#   )r'   float_frames     r-   test_fillna_invalid_method%TestFillNA.test_fillna_invalid_method~  s-    ]]:V4f- 544s	   3
Ac                    Sn[         R                  " [        UR                  S5      S9   UR	                  SS/5        S S S 5        [         R                  " [        UR                  S5      S9   UR	                  S5        S S S 5        Sn[         R                  " [        US9   UR
                  S S 2S	4   R	                  U5        S S S 5        g ! , (       d  f       N= f! , (       d  f       Nf= f! , (       d  f       g = f)
NzA"value" parameter must be a scalar or dict, but you passed a "{}"r0  r5   r   r   tuple)r   r   zP"value" parameter must be a scalar, dict or Series, but you passed a "DataFrame"r   )rN   rO   r   formatr#   r&   )r'   r=  rT   s      r-   test_fillna_invalid_value$TestFillNA.test_fillna_invalid_value  s    Q]]9CJJv,>?1v& @ ]]9CJJw,?@v& A# 	 ]]9C0QT"))+6 10 @? A@ 10s#   C/C!$#C2
C!
C/2
D c                    [        SSS5       Vs/ s H  nS[        U5      -   PM     nn[        R                  R	                  S5      R                  S5      n[        [        S5      X#S9nS	n[        R                  " [        US
9   UR                  SS9nS S S 5        UR                  R                  5       WR                  R                  5       :X  d   eg s  snf ! , (       d  f       NL= f)NrE   r   r4   zCOL.r   )rZ   rE   rZ   )rM   r    datarG   r5   rK   rI   )r   strr   r   r   r   r!   r;   r<   r#   r    tolist)r'   icolsrF  r*   rT   filleds          r-   test_fillna_col_reordering%TestFillNA.test_fillna_col_reordering  s    ).q!R9AQ9yy$$Q'..w7U2Y@<''SAYYgY.F Bzz  "fnn&;&;&==== : BAs   CC
C*c                    Un[         R                  UR                  UR                  SS S4'   [         R                  UR                  UR                  SS  S4'   UR	                  SS9nUR                  UR                  SS S4   S:H  R                  5       (       d   eUS	 UR                  / S9R	                  SS9  g )	NrE   rZ   r   r[   r   r   r\   rd   )r   r   rL   rM   r#   r:   rg   )r'   r=  r^   r_   rK  s        r-   test_fill_cornerTestFillNA.test_fill_corner  s    (*rxx"~u$%&(ffrxx~s"##***3

6<<"-u45:??AAAAu%B'..Q.7r   c                    [        SS[        R                  /05      nSn[        R                  " [
        US9   UR                  SS0SS0S9nS S S 5        [        SSS/05      n[        R                  " WU5        g ! , (       d  f       N5= f)Ncol1r   r   r5   r   r   r   ry   r   s        r-   test_fillna_downcast_dict$TestFillNA.test_fillna_downcast_dict  s|    BFF,-0''SAYY{fg5FYGF Bfq!f-.
fh/ BAs   A==
Bc           
         [        [        R                  S[        R                  S/SS[        R                  S/[        R                  [        R                  [        R                  S/[        R                  S[        R                  S//[        S5      S9nUR	                  SS	SS
9nUR	                  SS	SS
9n[        [        / SQSS9SS[        R                  S/[        R                  S	[        R                  [        R                  /[        / SQSS9S./ SQS9n[        [        / SQSS9[        / SQSS9S	S	[        R                  S	/[        / SQSS9S./ SQS9n[        R                  " X$5        [        R                  " X55        g )Nr   r   r   r   r   rE   ABCDrd   d   r!  r]   r   )rW  r   rW  rW  r   re   )r   r   rE   r   r   )r   r   r   r   r   )r   r   rW  r   )r   r   r   r0  r#   r	   r!   r$   )r'   r*   ri   result2r,   r   s         r-   "test_fillna_with_columns_and_limit-TestFillNA.test_fillna_with_columns_and_limit  sH   BFFA&Arvvq!+BFFA&	 L
 A6))#Q)7.i@BFFA&ffc2662662L	:	 
 .i@N)<3,L	:	 
	 	f/
g1r   c                     [        [        SS /5      [        SS /5      S.5      nUR                  5       nUR                  [        R
                  SS9  [        R                  " X5        g )Nz
2018-05-30z
2018-09-30)date1date2Tr   )r   r   r3   r#   r   r   r!   r$   r'   r*   r,   s      r-   test_fillna_datetime_inplace'TestFillNA.test_fillna_datetime_inplace  sZ    $lD%9:$lD%9:
 779
		"&&$	'
b+r   c           	         [        [        R                  S[        R                  S/SS[        R                  S/[        R                  [        R                  [        R                  S/[        R                  S[        R                  S//[        S5      S9nUR	                  SS	SS
9nX!Ld   eUR	                  SS	SSS9  [
        R                  " X5        g )Nr   r   r   r   r   rE   rV  rd   rW  rX  T)r!  r]   r   r   r/  r_  s      r-   0test_fillna_inplace_with_columns_limit_and_value;TestFillNA.test_fillna_inplace_with_columns_limit_and_value  s    BFFA&Arvvq!+BFFA&	 L
 99!3a98!!!
		q1d	;
b+r   r4   rm   yc                    [        [        R                  S/[        R                  S/S.5      nUR                  5       nUS S  n[        R
                  " U5         UR                  USS9  S S S 5        [        SS/SS/S.5      n[        R                  " XG5        U(       a  [        R                  " Xe5        g [        R                  " Xg5        g ! , (       d  f       Nk= f)Nr   re  Tr   r4   r         )r   r   r   r3   r!   r"   r#   r$   )r'   r   r(   r)   r*   df_origresult_viewr,   s           r-   test_inplace_dict_update_view(TestFillNA.test_inplace_dict_update_view  s     bffa[{;<'')e""#56IIc4I( 7B9D!9=>
b+!!+7!!+8 76s   C
Cc           
         [        SS[        R                  S[        R                  /S[        R                  [        R                  SS/S[        R                  SSS/[        R                  SS[        R                  S	/S
.5      nUR                  SSSS9n[        / SQSS[        R                  S/S[        R                  SS// SQ/ SQ// S
QS9n[        R
                  " X#5        g )NrE   r   r   r   r      r   r      )rR  col2col3col4r2   )r   r!  )      @      @g      (@      I@r   ru  r   )g      $@rs  r   ru  )ru        @r   g      2@rd   )r   r   r   r#   r!   r$   r   s       r-   )test_single_block_df_with_horizontal_axis4TestFillNA.test_single_block_df_with_horizontal_axis  s    Arvvr2662BFFBFFAq1RVVQ1-Arvvr2	
 2QQ/&dBFFC(rvvsC(&& 5	
 	f/r   c                    [        [        R                  SS/SS[        R                  /SS[        R                  /S.5      n[        / SQ/ SQSS[        R                  /S.5      n[        R                  " UR                  SS05      U5        [        R                  " UR                  SS	S
.5      U5        [        / SQ/ SQSS[        R                  /S.5      n[        R                  " UR                  S	SS.5      U5        g )Nr   rv  r   ))rm   ru   rm   rv   )rf  rw   )rh  r   rv  )r   r   rh  rm   r4   r   )rm   rz  )r   r   g       )rz  rm   )r   r   r   r!   r$   r#   )r'   pdfr,   s      r-   "test_fillna_with_multi_index_frame-TestFillNA.test_fillna_with_multi_index_frame  s    VVS#. #rvv. #rvv.
 ,, #rvv.
 	cjj#r3X>
cjjrr)BCXN,, #rvv.
 	cjjbr)BCXNr    N);__name__
__module____qualname____firstlineno__r.   td&skip_array_manager_not_yet_implementedrB   rV   rN   markxfailr   r`   rj   rr   r|   r   r   r   r   r   r   r   r   r   parametrizer   r   r   r   r   r   r   r   r  r
  r  r  r8  r  r  r  r%  r2  r9  r>  rC  rL  rO  rS  rZ  r`  rc  skip_array_manager_invalid_testrk  rw  r|  __static_attributes__r~  r   r-   r   r      s   D6 ..0 /0$5. [[13<TU$ V$
6	&$0
00(>0(*+X"8H0"%(4 [[Y3*(EF0 G00. [[URBFFC$890 :0*0X;;0&0. [[Vc5\2# 3# [[Vc5\2$ 3$,2)8!0F0&.7 > [[13<TU	8 V	80"2H
,,$ ''[[URr);$<=9 > (9 0.Or   r   c                      [        / SQ/ SQ/ SQ// SQS9n U R                  SSS9nUR                  S	5      nUR                  5       R	                  5       R	                  5       S	:X  d   eg )
N)r   r   r   r   )r   r   r   r   )r   r   r   rv  )i1i2i3f1rd   r  r  r   r   )r   pivotr#   isnasum)r*   df_nonconsolri   s      r-   !test_fillna_nonconsolidated_framer  9  si    		

 )
B 88$85L  #F;;=""$)))r   c                     [        S S /S S //SS/S9n Sn[        R                  " [        US9   U R	                  SSS.S	S
9  S S S 5        [        SS/SS//SS/S9n[        R
                  " X5        g ! , (       d  f       N7= f)Nr   r   rd   r   r5   r   r   r   Tr  )r   r!   r;   r<   r#   r$   )r*   rT   r,   s      r-   test_fillna_nones_inplacer  H  s    	
d|$c

B ,C		#	#M	=
		aa($	7 
> 1a&1a&)C:>H"'	 
>	=s   A33
BfuncrH   rn   c                     [        S/ SQ05      n[        R                  " [        5         [	        X5      " 5         S S S 5        g ! , (       d  f       g = f)Nru   r   )r   r!   r;   r<   getattr)r  r*   s     r-   test_pad_backfill_deprecatedr  V  s8     
C#	$B		#	#M	2 
3	2	2s   A
Az#data, expected_data, method, kwargsr   r   rv  rt  rK   
limit_areainsider   )r  r   outsiderE   r   c                 ~    [        U 5      n[        U5      n[        XB5      " S0 UD6n[        R                  " Xe5        g )Nr~  )r   r  r!   r$   )rF  expected_datarJ   kwargsr*   r,   ri   s          r-   test_ffill_bfill_limit_arear  ^  s8    F 
4B'HR *6*F&+r   )"numpyr   rN   pandas._configr   pandas.util._test_decoratorsutil_test_decoratorsr  pandasr   r   r   r   r   r	   r
   r   r   r   pandas._testing_testingr!   pandas.tests.frame.commonr   r   r  r  r  r  r  r   r   r  r~  r   r-   <module>r     s     5 ) )    8^O ^OB*( %!45 6 ) VVRVVQ266266JVVRVVS#sCbffbffE8$		
 VVRVVQ266266JVVRVVS#rvvrvvsBFFBFFK#a0		
 VVRVVQ266266JVVRVVS"&&"&&"&&#sCH9%		
 VVRVVQ266266JVVRVVS"&&"&&"&&#sBFFK$q1		
 VVRVVRVVRVVRVVRVVRVVDVVRVVRVVRVVRVVRVVRVVD$q1		
 !H!H$q1		
 VVRVVQ266266JVVRVVS#sCbffbffE8$		
 VVRVVQ266266JVVRVVS"&&"&&#sBFFBFFK#a0		
 VVRVVQ266266J#sBFFBFFBFFCH9%		
 VVRVVQ266266JVVS#rvvrvvrvvsBFFBFFK$q1		
o=@B,C@B,r   