
    A>iq                        S SK rS SKrS SK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\R0                  R3                  S	\R4                  \R4                  S
\R4                  \R4                  \R4                  S\R4                  \R4                  /	\R4                  \R4                  SSSSS\R4                  \R4                  /	SSS04\R4                  \R4                  S
\R4                  \R4                  \R4                  S\R4                  \R4                  /	\R4                  \R4                  SS\R4                  \R4                  S\R4                  \R4                  /	SSSS.4\R4                  \R4                  S
\R4                  \R4                  \R4                  S\R4                  \R4                  /	\R4                  \R4                  S\R4                  \R4                  \R4                  SSS/	SSS04\R4                  \R4                  S
\R4                  \R4                  \R4                  S\R4                  \R4                  /	\R4                  \R4                  S\R4                  \R4                  \R4                  SS\R4                  /	SSSS.4\R4                  \R4                  \R4                  \R4                  \R4                  \R4                  \R4                  /\R4                  \R4                  \R4                  \R4                  \R4                  \R4                  \R4                  /SSSS.4\" S5      \" S5      SSSS.4\R4                  \R4                  S
\R4                  \R4                  \R4                  S\R4                  \R4                  /	\R4                  \R4                  SSSSS\R4                  \R4                  /	SSS04\R4                  \R4                  S
\R4                  \R4                  \R4                  S\R4                  \R4                  /	\R4                  \R4                  S\R4                  \R4                  SS\R4                  \R4                  /	SSSS.4\R4                  \R4                  S
\R4                  \R4                  \R4                  S\R4                  \R4                  /	SSS\R4                  \R4                  \R4                  S\R4                  \R4                  /	SSS04\R4                  \R4                  S
\R4                  \R4                  \R4                  S\R4                  \R4                  /	\R4                  SS\R4                  \R4                  \R4                  S\R4                  \R4                  /	SSSS.44
5      S 5       r\R0                  R3                  SSS/5      \R0                  R3                  SSS/5      S 5       5       rS rg)    N)OutOfBoundsDatetime)
Categorical	DataFrameDatetimeIndexNaTPeriodIndexSeriesTimedeltaIndex	Timestamp
date_rangeto_datetime)_check_mixed_floatc                   z   \ 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S rS r\R&                  R)                  S/ SQSS//5      S 5       rS r\R&                  R)                  SSS\R0                  S/5      S 5       rS rS rS rS rS rS r\R&                  R)                  S \ \!/5      S! 5       r"\R&                  R)                  S \ \!/5      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/ r0\R&                  R)                  SS0S0S0S1./5      S2 5       r1S3 r2S4 r3S5r4g6)7
TestFillNA   c                    [        [        R                  /S-  [        [	        S5      [        /[        R                  SS/S.5      n/ SQUl        US S  nUR                  SS0SS	9  [        S
/S-  S[	        S5      S// SQS.5      n/ SQUl        [        R                  " X5        [        R                  " UR                  S S 2S4   UR                  S S 2S4   5      (       a   eg )N      foo   ABC)r   r   r   r   Tinplace       @)r   r   r   )r   npnanr   r   columnsfillnatmassert_frame_equalshares_memoryiloc)selfdforigexpecteds       e/var/www/html/land-tabula/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
		3(D	) %!)1ilA"6]K
 +
b+##BGGAqDM499QT?CCCCC    c                    [         R                  " S[         R                  5      n[        USS9n[        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[        UR                  R                  5      S:X  d   e[         R                  " UR                  U5      (       d   eg ! , (       d  f       N= f)	N)(   2   F)copyr   Tr   r   )r   fullr   r   r"   raises_chained_assignment_errorr!   isnanalllen_mgrblocksr$   values)r&   arrr'   s      r*   test_fillna_on_column_view%TestFillNA.test_fillna_on_column_view(   s    ggh's'//1qELLTL* 2xxAqD	"&&(((( 277>>"a'''		3//// 21s   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5      nUR                  UR                  S S S4   S:H  R                  5       (       d   eUR                  5       n[         R                  " UR                  UR                  S S S4   5      R                  5       (       d   eSn[        R                  " [        US9   UR	                  5         S S S 5        g ! , (       d  f       g = f)N   r   r   z/missing 1 required positional argument: 'value'match)r   r   locindexr!   r6   ffillr5   pytestraises	TypeError)r&   datetime_frametfzero_filledpaddedmsgs         r*   test_fillna_datetimeTestFillNA.test_fillna_datetime5   s    $&FFrxx|S !%'VVrxx}c!"$++A. 1 1"1 5s :;q@EEGGGG%%'xx

6<<#3S#89:>>@@@@@]]9C0!!# 100s   D..
D<c                    Un[         R                  UR                  UR                  SS S4'   [         R                  UR                  UR                  SS  S4'   UR	                  5       nUR                  UR                  SS  S4   UR                  UR                  S   S4   :H  R                  5       (       d   eUR                  UR                  SS S4   S:H  R                  5       (       d   eUR                  SS	9nUR                  UR                  SS  S4   S:H  R                  5       (       d   eUR                  UR                  SS S4   S:H  R                  5       (       d   eg )
Nr?      r   r   ibarr   value)r   r   rC   rD   rE   r6   r!   )r&   float_string_frameusing_infer_stringmfresults        r*   test_fillna_mixed_type!TestFillNA.test_fillna_mixed_typeD   sN   (*rxx"~u$%&(ffrxx~s"#JJv||CD)3./6::fll3>OQT>T3UU
#% 	  

6<<"-u45>CCEEEE#

6<<-s23q8==????

6<<"-u45:??AAAAr-   c                     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  UR                  5       n[        USS 0S9  g )	N)r   r   Dr    rR   r   r   rT   r   dtype)reindexr   r   rC   rD   r!   r   rE   )r&   mixed_float_framerX   rY   s       r*   test_fillna_mixed_float"TestFillNA.test_fillna_mixed_floatS   sm    &&&?&(ffrxx~s"##6#t56#t5r-   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X!L d   e[
        R                  " X5        g )Nabcr   r   )rf   rf   r   rf   )rg   rg   r   rg   )rh   rh   r   rh   objectTr   )r   r   r   r!   astyper"   r#   r&   r'   rY   r)   s       r*   test_fillna_different_dtype&TestFillNA.test_fillna_different_dtype\   s    3$sC&=S"&&RU?VW
 Au:&#%;=ST
 qk((2
f/Au:t4||
b+r-   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   r?   i  )r   r   )r   r   r   limit)r   r   randomdefault_rngstandard_normalr   r%   r1   r!   r"   r#   r&   r'   r)   rY   s       r*   test_fillna_limit_and_value&TestFillNA.test_fillna_limit_and_valuen   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Date2rz   r   r{   rT   )	r   r   r   r1   r!   rC   rD   r"   r#   rv   s       r*   test_fillna_datelikeTestFillNA.test_fillna_datelikez   s     i
34#J/5
 779#F+22266"((1+w:N3OP&"W+!67
f/r-   c                    [        S[        S5      [        /05      n[        S[        S5      [        S5      /05      nUR                  5       n[        R
                  " X25        [        S[        [        S5      /05      n[        S[        S5      [        S5      /05      nUR                  5       n[        R
                  " X25        g )Nr   z2012-11-11 00:00:00+01:00)r   r   r   rE   r"   r#   bfill)r&   r'   express       r*   test_fillna_tzawareTestFillNA.test_fillna_tzaware   s     i(CDcJKL9:9:
 hhj
c'c9-H#IJKL9:9:
 hhj
c'r-   c                     [        [        SSSS9SS[        R                  [        R                  /S.5      nUR	                  5       n[        [        SSSS9/ SQS.5      n[
        R                  " X#5        g )	N20130101   z
US/Eastern)periodstzr   r   r   r   )      ?r   r   r   )r   r   r   r   rE   r"   r#   rk   s       r*   $test_fillna_tzaware_different_column/TestFillNA.test_fillna_tzaware_different_column   sn     
A,GBFFBFF+
 
A,G)
 	f/r-   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        UR                  5       n[
        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)Nr   r   r   r   r   r   )
categoriesrf   rg   dcatsvals)r   r   r   r   )rf   rg   rg   r   rT   z3Cannot setitem on a Categorical with a new categoryrA   r   rh   r   )subset)rf   rg   rf   )r   r   r   r   r!   r"   r#   rF   rG   rH   rE   dropna)r&   catr   r'   cat2vals2df_exp_fillcat3vals3df_exp_drop_catscat4vals4df_exp_drop_allr   rM   rh   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 hhj
c/ iixi(
c4iik
c3 bff-3*E956o3*EGY?@iin
c6*+ 10s   /G>>
H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   categoryr_   z2011-01-01 09:00z2016-01-01 23:45rf   rT   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   rY   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Q5      SS[        R                  /S.5      n[	        [        / SQ5      5      nUR                  SU05      n[        [        / SQ5      / SQS.5      n[        R                  " X45        g )Nr   r   r   )r   ints)      $@g      4@      >@r   )r   r   r   )r   r   r   r   r	   r!   r"   r#   )r&   r'   fillerrY   r)   s        r*   #test_fillna_with_categorical_series.TestFillNA.test_fillna_with_categorical_series  sq     1Cbff;MN
 $678FF+, 1;KL
 	f/r-   c                 d    U" / SQSS9nUR                  S5      n[        R                  " X25        g )Nr   ri   r_    )r!   r"   assert_equal)r&   frame_or_seriesobjrY   s       r*   test_fillna_no_downcast"TestFillNA.test_fillna_no_downcast  s'    ix8B
$r-   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   rD   r    r           )r   r   r   r"   assert_produces_warningr!   r1   r#   )r&   r    r'   rY   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                    [        / SQ/ SQS9nUR                  n[        [        R                  " S5      /S-  / SQS9n[
        R                  " X#5        UR                  S5      n[        S/ SQ/ SQ[        S9n[
        R                  " X#5        [        [        S	5      S
S/SS9nUR                  S5      n[        SS[        S	5      S
S/S9n[
        R                  " X#5        g )Nr   )r   r   r   r   r?   r   ri   r?   rD   r   )rD   r    r`   r   r   r   float64r   )r`   rD   r    )r   dtypesr	   r   r`   r"   r   r!   ri   r#   rangerk   s       r*   test_fillna_dtype_conversion'TestFillNA.test_fillna_dtype_conversion#  s    _oF288H-.2/J
v01_oV
 	f/ U1XSzK5!U(%(SRUJW
f/r-   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)   rY   s        r*   *test_fillna_dtype_conversion_equiv_replace5TestFillNA.test_fillna_dtype_conversion_equiv_replace5  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 )Nr2   r   r   )r   )r   rS   N)foo2bar2Nr   r   r   r]   20130110r   ?)r2   r   r   )r   rS   r   )r   r   r   z
2013-01-01z
2013-01-02)	r   r   r   r   r!   r"   r#   r   r   rk   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'   UR	                  5       n[
        R                  " UR	                  5       U5        g Nr?   r   r@   )r   r   rC   rD   rE   r"   r#   r&   rI   alts      r*   
test_ffillTestFillNA.test_ffillh  u    <>FF>//3S89=?VV>//4c9:""$
n224c:r-   c                    [         R                  UR                  UR                  S S S4'   [         R                  UR                  UR                  SS  S4'   UR	                  5       n[
        R                  " UR	                  5       U5        g r   )r   r   rC   rD   r   r"   r#   r   s      r*   
test_bfillTestFillNA.test_bfillo  r   r-   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US S R                  U5      R                  5       n[         R                  UR                  SS & [        R                  " X45        US	S  R                  US
SS9nUS	S  R                  U5      R                  5       n[         R                  UR                  S S& [        R                  " X45        g )Nro   r   ro   r   r   padr?   )methodrr   r   backfillr   r   aranger   rs   rt   ru   ra   rE   r   r%   r"   r#   r   r&   rD   r'   rY   r)   s        r*   test_frame_pad_backfill_limit(TestFillNA.test_frame_pad_backfill_limitv  s    		"ryy,,Q/??HPUVBQe1=bq6>>%(..0VVbc
f/BCzCbc7??5)//1FFbq
f/r-   c                 |   [         R                  " S5      n[        [         R                  R	                  S5      R                  S5      US9nUS S R                  U5      nUR                  SS9nUS S R                  U5      R                  5       n[         R                  UR                  SS & [        R                  " X45        USS  R                  U5      nUR                  SS9nUSS  R                  U5      R                  5       n[         R                  UR                  S S	& [        R                  " X45        g )
Nro   r   r   r   r?   rq   r   r   r   r   r   s        r*   test_frame_fillna_limit"TestFillNA.test_frame_fillna_limit  s    		"ryy,,Q/??HPUVBQ&A&bq6>>%(..0VVbc
f/BC'A&bc7??5)//1FFbq
f/r-   c                     [        [        R                  R                  S5      R	                  S5      R                  [        5      5      nUR                  [        R                  5        g )Nr   r   )	r   r   rs   rt   ru   rj   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 0rA   r   r@   rq   
r   r   rs   rt   ru   rj   rF   rG   
ValueErrorr!   r&   r   r'   rM   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 integerrA   r   g      ?rq   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                    [        [        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nX1L d   e[        R                  " X5        UR                  SS0S	S
9nX1L d   e[        R
                  UR                  S S2S4'   [        R
                  UR                  SS 2S4'   UR                  5       nX!Ld   eUR                  S	S9  [        R                  " X5        g )Nr   r   r   r   r   r   rT   TrU   r   r   )r   r   rs   rt   ru   r   rC   r!   r"   r#   rE   rv   s       r*   test_fillna_inplaceTestFillNA.test_fillna_inplace  s   ryy,,Q/??HIrr1ursAv9919%!!!D1||
b+!Q6||rr1ursAv88:!!!

b+r-   c           	         [        [        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        g )Nr   r   r   r   rf   rg   rh   r   r?   )rf   rg   rf   rg   rp   )rf   rg   r   )	r   r   r   r!   r1   r"   r#   maxto_dictrk   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/r-   c           	         [        [        R                  SS[        R                  [        R                  /SSS[        R                  [        R                  /[        R                  SSSS/S.5      nUR                  UR	                  SS9SS9nUR                  UR	                  SS9SSS9nX!L d   e[        / S	Q/ S
Q/ S	QS.5      n[
        R                  " X#5        [
        R                  " X5        g )Nr   r   r   r   r  axisT)r  r   )r   r   r         @      @)r   r   r  r  r  )r   r   r   r!   r  r"   r#   rk   s       r*   test_fillna_dict_series_axis_1)TestFillNA.test_fillna_dict_series_axis_1  s    ffaBFFBFF3Arvvrvv.ffaAq)
 266q6>2266q6>4@||...
 	f/
b+r-   c           	      P   [        SS[        R                  SS/SSS[        R                  [        R                  /[        R                  SSSS/S	.5      n[        R                  " [
        S
S9   UR                  [        SSSS	.5      SS9  S S S 5        g ! , (       d  f       g = f)Nabcdefghijklr   r   r   r   r  z$All columns must have the same dtyperA   hijr  r   r   r   rF   rG   r   r!   r	   r   s     r*   ,test_fillna_dict_series_axis_1_mismatch_cols7TestFillNA.test_fillna_dict_series_axis_1_mismatch_cols  s    UBFFE59Arvvrvv.ffaAq)
 ]]:-STIIf5u5ABIK UTTs   0B
B%c           	         [        [        R                  SS[        R                  [        R                  /SSS[        R                  [        R                  /[        R                  SSSS/S.5      n[        R                  " [
        SS9   UR                  [        SS	S
S.5      SS9  S S S 5        g ! , (       d  f       g = f)Nr   r   r   r   r  z&.* not a suitable type to fill into .*rA   r  r  r  r  r  r   s     r*   7test_fillna_dict_series_axis_1_value_mismatch_with_colsBTestFillNA.test_fillna_dict_series_axis_1_value_mismatch_with_cols  s    ffaBFFBFF3Arvvrvv.ffaAq)
 ]]:-UVIIf5u5ABIK WVVs   B33
C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   ro   rQ      r/   )r0   <   F   P   Z   rS   r?   )rf   rg   r   VWXuZr#  r   r   r   listr!   r"   r#   )r&   r'   df2rY   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UR                  SS9nUR                  R                  5       R                  n[        R                  " X45        UR                  SSS5        UR                  SS9nUR                  [        5      R                  SS9n[        R                  " X45        g )Nr   )ro   ro   r   r     r   r?   )r   rs   rt   ru   r   r   rE   Tr"   r#   insertrj   float)r&   r;   r'   rY   r)   s        r*   test_fillna_columnsTestFillNA.test_fillna_columns-  s    ii##A&66x@ffAssFs^q!44::<>>
f/
		!UAq!99U#))q)1
f/r-   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&  rA   r   r   tuple)r   r   zP"value" parameter must be a scalar, dict or Series, but you passed a "DataFrame"r   )rF   rG   rH   formatr!   r%   )r&   float_framerM   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                 r   [        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UR                  5       nUR                  R                  5       UR                  R                  5       :X  d   eg s  snf )	Nr?   r   r2   zCOL.r   )rQ   r?   rQ   )rD   r    data)	r   strr   rs   rt   r   rE   r    tolist)r&   icolsr8  r'   filleds         r*   test_fillna_col_reordering%TestFillNA.test_fillna_col_reorderingK  s    ).q!R9AQ9yy$$Q'..w7U2Y@zz  "fnn&;&;&====	 :s   B4c                 l    UR                  / S9nUR                  SS9n[        R                  " X25        g )Nr^   r   rT   )ra   r!   r"   r#   )r&   r4  r'   rY   s       r*   test_fill_emptyTestFillNA.test_fill_emptyR  s3       ,#
f)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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   r?   ABCDr^   d   r  rU   rr   )rE  r   rE  rE  r   r_   )r   r   r?   r   r   )r   r   r   r   r   )r   r   rE  r   )r   r   r   r&  r!   r	   r"   r#   )r&   r'   rY   result2r)   	expected2s         r*   "test_fillna_with_columns_and_limit-TestFillNA.test_fillna_with_columns_and_limitW  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   r1   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nX1L d   e[
        R                  " X5        g )Nr   r   r   r   r   r?   rD  r^   rE  rF  T)r  rU   rr   r   r%  rv   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!!!AtD||
b+r-   r2   xyc                 &   [        [        R                  S/[        R                  S/S.5      nUR                  5       nUS S  nUR	                  USS9  [        SS/SS/S.5      n[
        R                  " X%5        [
        R                  " XC5        g )Nr   rS  Tr   r2   r         )r   r   r   r1   r!   r"   r#   )r&   r   r'   df_origresult_viewr)   s         r*   test_inplace_dict_update_view(TestFillNA.test_inplace_dict_update_view  sz     bffa[{;<'')e
		#t	$B9D!9=>
b+
k3r-   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 )Nr?   r   ro   rp   r      r   r      )col1col2col3col4r0   )rr   r  )      @      @g      (@      I@r   re  r   )r   rc  r   re  )re  r  r   g      2@r^   )r   r   r   r!   r"   r#   rk   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   r  r   ))rT  rf   rT  rg   )rU  rh   )rW  r   r  )r   r   rW  rT  r2   r   )rT  ri  )r   r   g       )ri  rT  )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)5__name__
__module____qualname____firstlineno__r+   r<   rN   rZ   rc   rl   rw   r|   r   r   r   r   r   r   rF   markparametrizer   r   r   r   r   r   r   r   r   r   r   r   r.  r   r   r  r  r  r  r  r(  r/  r5  r>  rA  rI  rN  rQ  rZ  rf  rk  __static_attributes__rm  r-   r*   r   r      s   D"0$B6,$
00(60$(+T"8H0% [[Y3*(EF0 G00$ [[URBFFC$890 :0*0X;;0 0$ [[Vc5\2# 3# [[Vc5\2$ 3$,.00,*	L	L!0F07 >*
"2H
,,& [[URr);$<=4 >4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   r  )i1i2i3f1r^   rv  rw  r   r   )r   pivotr!   isnasum)r'   df_nonconsolrY   s      r*   !test_fillna_nonconsolidated_framer~    si    		

 )
B 88$85L  #F;;=""$)))r-   c                      [        S S /S S //SS/S9n U R                  SSS.SS9nXL d   e[        SS/SS//SS/[        S	9n[        R                  " X5        g )
Nr   r   r^   r   r   r   Tr  )r    r`   )r   r!   ri   r"   r#   )r'   rY   r)   s      r*   test_fillna_nones_inplacer    ss    	
d|$c

B YY11-tY<F<<1a&1a&)C:VLH"'r-   z#data, expected_data, method, kwargsr   rp   r  rd  rE   
limit_areainsider   )r  rr   outsider?   r   c                 ~    [        U 5      n[        U5      n[        XB5      " S0 UD6n[        R                  " Xe5        g )Nrm  )r   getattrr"   r#   )r8  expected_datar   kwargsr'   r)   rY   s          r*   test_ffill_bfill_limit_arear    s8    F 
4B'HR *6*F&+r-   
test_frameTFr`   r.  ri   c                     [        S[        R                  S/US9nU (       a  UR                  5       nUR	                  S S9n[        / SQUS9nU (       a  UR                  5       n[
        R                  " X45        g )Nr   r   r_   rT   )r   Nr   )r	   r   r   to_framer!   r"   r   )r  r`   r   rY   r)   s        r*   test_fillna_with_none_objectr  >  sa     !RVVQu
-CllnZZdZ#Fl%0H$$&OOF%r-   c            	          [        [        SSSSS9/ SQS.5      n S U R                  S'   S	n[        R                  " [
        US
9   U R                  [        S5      5        S S S 5        g ! , (       d  f       g = f)Nz1/1/2011r   hns)r   r   unitr   )datetimerU   )r   r   z=Cannot cast 0001-01-01 00:00:00 to unit='ns' without overflowrA   z
0001-01-01)r   r   r%   rF   rG   r   r!   r   )r'   rM   s     r*   "test_fillna_out_of_bounds_datetimer  L  sb    	":qsN	

B BGGDM
IC	*#	6
		)L)* 
7	6	6s   A))
A7)numpyr   rF   pandas.errorsr   pandasr   r   r   r   r   r	   r
   r   r   r   pandas._testing_testingr"   pandas.tests.frame.commonr   r   r~  r  rr  rs  r   r   r  r  r  rm  r-   r*   <module>r     s     -    8@O @OF*
( ) 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, e}57H"56	& 7 6	&+r-   