
    h                        S SK rS SK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\R4                  R7                  SS	S
/5      S 5       r\R4                  R7                  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)
Categorical	DataFrameDatetimeIndexNaTPeriodIndexSeriesTimedeltaIndex	Timestamp
date_rangeto_datetime)_check_mixed_floatc                      \ rS rSrS r\R                  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S rS r\R.                  R1                  S/ SQSS//5      S 5       rS r\R.                  R1                  SSS\R8                  S/5      S 5       rS rS rS r S r!S  r"S! r#\R.                  R1                  S"\$\%/5      S# 5       r&\R.                  R1                  S"\$\%/5      S$ 5       r'S% r(S& r)S' r*S( r+S) r,S* r-S+ r.S, r/S- r0S. r1S/ r2S0 r3\Rh                  \R.                  R1                  SS1S1S1S2./5      S3 5       5       r5S4 r6S5 r7S6r8g7)8
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         ^/var/www/html/shao/venv/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_view2   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 deprecatedr4   padmethodz'Must specify a fill 'value' or 'method'z(Cannot specify both 'value' and 'method'ffill)r   r   locindexr"   r9   r    r:   r;   r8   pytestraises
ValueError)r&   datetime_frametfzero_filledmsgpaddeds         r,   test_fillna_datetimeTestFillNA.test_fillna_datetimeE   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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  Sn[
        R                  " [        US	9   UR	                  S
S9  S S S 5        g ! , (       d  f       g = f)NrD      r   r   r   valuerF   r4   rG   rH   )r   r   rK   rL   r"   r    r:   r;   )r&   float_string_framemfrS   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   rY   r   r   rZ   r   dtyperF   r4   rG   rH   )
reindexr   r   rK   rL   r"   r   r    r:   r;   )r&   mixed_float_framer]   resultrS   s        r,   test_fillna_mixed_float"TestFillNA.test_fillna_mixed_floatf   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xrb   )rG   backfillz)Series.fillna with 'method' is deprecatedr4   TrI   r   rH   )rM   skipr   r    r:   r;   rk   r"   )r&   r'   r)   mrS   s        r,   test_fillna_emptyTestFillNA.test_fillna_emptyr   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R                  SS05      n[        / SQ/ SQ/ SQ/5      nUS   R	                  S	5      US'   [
        R                  " X#5        UR                  SS0S
S9n[
        R                  " X5        Ub   eg )Nabcr   r   )rs   rs   r   rs   )rt   rt   r   rt   )ru   ru   r   ru   objectTr   )r   r   r   r"   astyper    r#   )r&   r)   rg   r+   return_values        r,   test_fillna_different_dtype&TestFillNA.test_fillna_different_dtype}   s    3$sC&=S"&&RU?VW
 Au:&#%;=ST
 qk((2
f/yy!UTy:
b+###    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   rD   i  )r   r   )r   r   r   limit)r   r   randomdefault_rngstandard_normalr   r%   r2   r"   r    r#   r&   r)   r+   rg   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/r{   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   rZ   )	r   r   r
   r2   r"   rK   rL   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:00rF   r4   rG   rH   bfill)r   r
   r   r    r:   r;   r"   r#   )r&   r)   exprS   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   rF   r4   rG   rH   )      ?r   r   r   )	r   r   r   r   r    r:   r;   r"   r#   r&   r)   rS   rg   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   )
categoriesrs   rt   dcatsvals)r   r   r   r   )rs   rt   rt   r   rZ   z3Cannot setitem on a Categorical with a new categoryr4   r   ru   rF   rG   rH   r   )subset)rs   rt   rs   )r   r   r   r   r"   r    r#   rM   rN   	TypeErrorr:   r;   dropna)r&   catr   r)   cat2vals2df_exp_fillcat3vals3df_exp_drop_catscat4vals4df_exp_drop_allr   rS   ru   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   categoryrc   z2011-01-01 09:00z2016-01-01 23:45rs   rZ   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   rg   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)	Nrs   r   z.The 'downcast' keyword in fillna is deprecatedr4   r   inferdowncastr   r   r   r   r    r:   r;   r"   r#   r   s        r,   test_fillna_downcastTestFillNA.test_fillna_downcast-  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   rv   rc    The 'downcast' keyword in fillnar4    Fr   )r    r:   r;   r"   assert_equal)r&   frame_or_seriesobjrS   rg   s        r,   test_fillna_downcast_false%TestFillNA.test_fillna_downcast_false>  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   rc   r   r4   r   r   r   )r   int64r    r:   r;   r"   rd   int32rw   r   float64)
r&   r   r   rS   r   r+   obj2res2	expected2res3s
             r,   test_fillna_downcast_noop$TestFillNA.test_fillna_downcast_noopF  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   rL   r   r           )r   r   r   r    r:   r"   r2   r#   )r&   r   r)   rg   r+   s        r,   -test_fillna_dictlike_value_duplicate_colnames8TestFillNA.test_fillna_dictlike_value_duplicate_colnames`  sn     rvvaVW=''-YYQx(F . 779
fh/ .-s   A;;
B	c                 2   [        / 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R                  S5      n[        S[        S
5      SS/[        S9n[
        R                  " X45        g ! , (       d  f       N= f)Nr   )r   r   r   r   rD   r   rv   rD   rL   Downcasting object dtype arraysr4   r   r   r   r   r   )rL   r   rd   r   )r   dtypesr   r   rd   r    r   r:   r;   r"   r#   rangerv   )r&   using_infer_stringr)   rg   r+   rS   s         r,   test_fillna_dtype_conversion'TestFillNA.test_fillna_dtype_conversionk  s    _oF288H-.2/J
v0/''SAYYq\F BQoO
f/ U1XSzK5!U%(S#JfU
f/ BAs   0D
D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+   rg   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 )Nr3   r   r   )r   )r   barN)foo2bar2Nr   r   r   ra   20130110r   ?)r3   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)   rg   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)NrD   r   rE   rF   r4   rJ   rH   )
r   r   rK   rL   r    r:   r;   r"   r#   rJ   r&   rP   rS   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)NrD   r   rE   rF   r4   r   rH   )
r   r   rK   rL   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   rG   rD   rI   r   rF   r4   rH   r   rl   r   r   aranger   r   r   r   re   r    r:   r;   r"   r   r%   r#   r&   rL   r)   rg   rS   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   rF   r4   rG   rD   r   rH   r   r   rl   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   rw   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 0r4   r   rE   r   
r   r   r   r   r   rw   rM   rN   rO   r"   r&   r  r)   rS   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 integerr4   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   rZ   Tr[   r   rF   r4   rJ   rH   rm   )r   r   r   r   r   r   rK   r"   r    r#   r:   r;   )r&   r)   r+   rS   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   rs   rt   ru   r   rD   )rs   rt   rs   rt   r~   )rs   rt   r   zcolumn by columnr4   )axis)r   r   r   r"   r2   r    r#   maxto_dictrM   rN   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}   rX      r0   )r1   <   F   P   Z   r   rD   )rs   rt   r   VWXuZr*  r   r   r   listr"   r    r#   )r&   r)   df2rg   r+   s        r,   test_fillna_dataframe TestFillNA.test_fillna_dataframe;  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}   rF   r4   rJ   r   )rI   r  rG   rH      r   rD   )r   r   r   r   r   r   r    r:   r;   r"   Tr#   insertrw   float)r&   r@   r)   rS   rg   r+   s         r,   test_fillna_columnsTestFillNA.test_fillna_columns^  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ffilr4   rH   )rM   rN   rO   r"   )r&   float_frames     r,   test_fillna_invalid_method%TestFillNA.test_fillna_invalid_methodq  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 "{}"r-  r4   r   r   tuple)r   r   zP"value" parameter must be a scalar, dict or Series, but you passed a "DataFrame"r   )rM   rN   r   formatr"   r%   )r&   r:  rS   s      r,   test_fillna_invalid_value$TestFillNA.test_fillna_invalid_valueu  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)NrD   r   r3   zCOL.r   )rX   rD   rX   )rL   r   datarF   r4   rJ   rH   )r   strr   r   r   r   r    r:   r;   r"   r   tolist)r&   icolsrC  r)   rS   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                 l    UR                  / S9nUR                  SS9n[        R                  " X25        g )Nrb   r   rZ   )re   r"   r    r#   )r&   r:  r)   rg   s       r,   test_fill_emptyTestFillNA.test_fill_empty  s3       ,#
f)r{   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   r4   r   r   r   r   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   rD   ABCDrb   d   r  r[   r   )rT  r   rT  rT  r   rc   )r   r   rD   r   r   )r   r   r   r   r   )r   r   rT  r   )r   r   r   r-  r"   r   r    r#   )r&   r)   rg   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   r2   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   rD   rS  rb   rT  rU  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{   r3   rk   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   rb  Tr   r3   r         )r   r   r   r2   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 )NrD   r   r}   r~   r      r   r      )rO  col2col3col4r1   )r   r  )      @      @g      (@      I@r   rr  r   )g      $@rp  r   rr  )rr        @r   g      2@rb   )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   rs  r   ))rk   rs   rk   rt   )rc  ru   )re  r   rs  )r   r   re  rk   r3   r   )rk   rw  )r   r   g       )rw  rk   )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)9__name__
__module____qualname____firstlineno__r-   td&skip_array_manager_not_yet_implementedrA   rU   r^   rh   rp   ry   r   r   r   r   r   r   r   r   r   rM   markparametrizer   r   r   r   r   r   r   r   r  r  r  r
  r5  r  r  r  r"  r/  r6  r;  r@  rI  rL  rP  rW  r]  r`  skip_array_manager_invalid_testrh  rt  ry  __static_attributes__r{  r{   r,   r   r      s   D6 ..0 /0$5.$
6	&$$
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 >*
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   rs  )i1i2i3f1rb   r  r  r   r   )r   pivotr"   isnasum)r)   df_nonconsolrg   s      r,   !test_fillna_nonconsolidated_framer  %  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   rb   r   r4   r   r   r   Tr  )r   r    r:   r;   r"   r#   )r)   rS   r+   s      r,   test_fillna_nones_inplacer  4  s    	
d|$c

B ,C		#	#M	=
		aa($	7 
> 1a&1a&)C:>H"'	 
>	=s   A33
BfuncrG   rl   c                     [        S/ SQ05      n[        R                  " [        5         [	        X5      " 5         S S S 5        g ! , (       d  f       g = f)Nrs   r   )r   r    r:   r;   getattr)r  r)   s     r,   test_pad_backfill_deprecatedr  B  s8     
C#	$B		#	#M	2 
3	2	2s   A
Az#data, expected_data, method, kwargsr   r~   rs  rq  rJ   
limit_areainsider   )r  r   outsiderD   r   c                 ~    [        U 5      n[        U5      n[        XB5      " S0 UD6n[        R                  " Xe5        g )Nr{  )r   r  r    r#   )rC  expected_datarI   kwargsr)   r+   rg   s          r,   test_ffill_bfill_limit_arear  J  s8    F 
4B'HR *6*F&+r{   ) numpyr   rM   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     ) )    8LO LO^*( %!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{   