
    Piָ                         d dl m Z mZ d dlZd dlZd dlZd dlmZ d dl	m
Z
mZ d dlmZ d dlmZ d dlZd dlmZmZmZmZmZmZmZmZ d dlmZ d dlmZ  G d	 d
          Z G d d          Z dS )    )datetime	timedeltaN)dateutil_gettz)IS64is_platform_windows)np_version_gt2)Pandas4Warning)CategoricalCategoricalIndex	DataFrameIndex
MultiIndexSeries
date_rangeisna)CategoricalDtypec                   z    e Zd Zd Zd Zd Zd Zej        	                    dg dg dg          d             Z
d	S )
TestReindexSetIndexc                    t          t          j                            d                              d                    }t	          dddd          }t	          dddd	          }|                    |          }t          j        |j        |           |	                    |          }t          j        |j        |           d S )
N      z
2011/01/01ME
US/Easternperiodsfreqtz2013YEz
Asia/Tokyo)
r   nprandomdefault_rngr   	set_indextmassert_index_equalindexreindex)selfdfidx1idx2s       {/home/jaya/work/projects/VOICE-AGENT/VIET/agent-env/lib/python3.11/site-packages/pandas/tests/frame/methods/test_reindex.py(test_dti_set_index_reindex_datetimeindexz<TestReindexSetIndex.test_dti_set_index_reindex_datetimeindex$   s    ry,,Q//66q99::,NNN&!$<HHH\\$
bh---ZZ
bh-----    c           	         t          t          ddd          t          dddd          dd          }t          t          j                            d                              d	          d
g|          }t          t          ddd          t          dddd          dd          }|                    |          }|j        j	        |j	        k    sJ d S )Ni  
         hr   )r   r   r   )   r1   acolumnsr&   )
r   r   r   r    r!   r"   standard_normalr#   r&   r   )r(   r&   r)   	new_indexresults        r,   'test_dti_set_index_reindex_freq_with_tzz;TestReindexSetIndex.test_dti_set_index_reindex_freq_with_tz/   s    T2q!!8D"a#<#<3<
 
 
 I!!!$$44W==E
 
 

 T2q!!8D"a#<#<3<
 
 
	 i((| EJ......r.   c                     t          dt          d          i          }t          j        |j        d          }||d<   |                    d          }|                                }d S )NAr0      B)r   rangepdcutr=   r#   reset_index)r(   r)   sers      r,   "test_set_reset_index_intervalindexz6TestReindexSetIndex.test_set_reset_index_intervalindex@   sX    U2YY'((fRT1oo3\\#^^r.   c                 >   t          g d                              dt          j        t          j        d          }|                    dg          }g |d<   |                                }t          g dt          d                                        dt          j        t          j        t          j        d          }t          j	        ||           |                    dd	g          }g |d<   |                                }t          j	        ||           d S )
Nr5   bcr7   zdatetime64[ns]r5   dr5   rH   rI   rK   r   r6   rH   )
r   astyper    int64float64r#   rC   r@   r$   assert_frame_equal)r(   r)   df1r:   expecteddf2s         r,   test_setitem_reset_index_dtypesz3TestReindexSetIndex.test_setitem_reset_index_dtypesH   s   ///66"
CC
 
 llC5!!C""%9%9%9qJJJQQ"
TT
 
 	fh///llC:&&C""
fh/////r.   z timezone, year, month, day, hour)zAmerica/Chicagoi        r1   )zAmerica/Santiagoi     rV   r2   c           	         t          |          }t          j        ||||dd|          }t          j        ||||dd|          }t          ||gddgd                              d                              dd	g          }	t          dd	gt          j        t          j        gd                              d          }
|
                    |	j	        j
                  }
t          j        |	|
           d S )
Nr   )yearmonthdayhourminutefoldtzinfor1   r5   rH   )r&   valsr&   12)gettzrA   	Timestampr   r#   r'   r    nanrM   r`   dtyper$   rP   )r(   timezonerY   rZ   r[   r\   test_timezonetransition_1transition_2r)   exps              r,    test_reindex_timestamp_with_foldz4TestReindexSetIndex.test_reindex_timestamp_with_foldZ   s    h| 
 
 
 | 
 
 
 | <sCjQQRRYwWc3Z   	
 3*rvrv6FGGHHRR
 
 jj''
	
 	
 	
 	
 	
r.   N)__name__
__module____qualname__r-   r;   rE   rT   pytestmarkparametrizerl    r.   r,   r   r   !   s        	. 	. 	./ / /"  0 0 0$ [*	,	,	,.R.R.RS !
 !
	 !
 !
 !
r.   r   c                   p   e Zd Zej                            e p e            oe d          d             Z	d Z
d Zej                            ddg dfd	ej        d
ddgfdg dfg          d             Zd Zd Zd Zd Zej                            ddg dfddddej        gfg          d             Zd Zej                            dg ddgg ddgd gdgg d!dgg d"dgd#d$gdgd#d gdgd d$gdgg d%dgd&d'gd(gg d)d(gg          d*             Zej                            d+g d,          d-             Zej                            d.g d/g d0gg d1g d2gd3d4gg d5gd4d6gg d7gg          d8             Zej                            d9 ed:          g d;dg ed<          g d=dg ed>          g d?dg ed@          g dAdg edB          g dCdg edD          g dEdg edF          g dGdg edH          g d(gg          dI             ZdJ ZdK ZdL ZdM ZdN ZdO Z dP Z!dQ Z"dR Z#dS Z$dT Z%dU Z&dV Z'dW Z(dX Z)dY Z*dZ Z+d[ Z,d\ Z-d] Z.d^ Z/d_ Z0d` Z1da Z2db Z3dc Z4dd Z5de Z6df Z7ej                            dgd	 e8dhi          djd e8dhi          djdkdidkdlig          dm             Z9ej                            dne:e;g          ej                            do e:g            e;g            e:d d$g           e;d d$g           e:d d g           e;d d g          g          dp                         Z<ej                            dqdrdsg          dt             Z=ej                            due:e;g          ej                            dvd d$g          dw                         Z>dx Z?dy Z@dz ZAdlS ){TestDataFrameSelectReindexzTPasses int32 values to DatetimeArray in make_na_array on windows, 32bit linux builds)reasonc                 :   t          dgg          }t          j        dd                              d          }|                    ddgd|          }|j        d         t          j        dd          k    sJ t          dg|gd	          }|d                             |j        d                   |d<   t          j	        ||           |
                    d                               d          }|                    ddgd|          }|j        d         t          j        d          k    sJ t          dg|gd	          }t          j	        ||           t          j        ||t          j        d
          z             }|                    ddgd|          }|j        d         t          j        dd          k    sJ t          dg|gd	          }|d                             |j        d                   |d<   t          j	        ||           d S )Nr1   z2023-04-10 17:32z
US/Pacific)r   sr   )axis
fill_value)unitr   )r   r1   secondszdatetime64[s, US/Pacific]right)r   rA   rd   as_unitr'   dtypesDatetimeTZDtyperM   r$   rP   tz_localize	to_periodPeriodDtypeInterval	TimedeltaIntervalDtype)r(   r)   tsresrR   perintervals          r,   test_reindex_tzaware_fill_valuez:TestDataFrameSelectReindex.test_reindex_tzaware_fill_value   s    u\,>>>FFsKKjj!QaBj77z!} 2 M M MMMMM!"..//qk((A77
c8,,,nnT"",,S11jj!QaCj88z!}s 3 33333!#//00
c8,,,;r2Q(?(?(?#?@@jj!QaHj==z!} 01Lg V VVVVV!(4455qk((A77
c8,,,,,r.   c                    t          ddd          j                            dd          }t          |ddgt	          d          	          }|j        d
         }|                                }|                    t	          d          g d|          }t          g |d                                         |g |d                                         ||gdz  dt                    }t          j        ||           |                    t	          d          |          }t          j        ||ddg                    |                    t	          d          g dd          }t          g |d                                         |g |d                                         ||gdz  d          }t          j        ||           d S )N
2016-01-01r   ns)r   r{   rV   r   r=   r?   r6   r   r   rW   r=   r?   Cr&   r7   rz   rf   )r&   rz   )r   valuesreshaper   r@   ilocdater'   tolistobjectr$   rP   )r(   arrr)   r   fvr   rR   s          r,   test_reindex_date_fill_valuez7TestDataFrameSelectReindex.test_reindex_date_fill_value   s   qt<<<CKKAqQQsS#JeAhh???WT]WWYYjjuQxxRjPP)BsGNN$$)b)0G"S'..2B2B0GB0GrdUVhWW
 
 
 	c8,,, jjuQxxBj77
c8S#J#7888 jj((OOO  
 
 )BsGNN$$)b)0G"S'..2B2B0GB0GrdUVhWW
 
 	c8,,,,,r.   c                    t          dgdz  dgdz  z   dgdz  z   t          t          d                    dz  g ddz  d                              dd	g          }g d
}t	          j        dg|gdd	g          }|                    |          }t          dgdz  |t          j        ddt          j        gd                              dd	g          }t          j
        ||           t          dgdz  |g dd                              dd	g          }|                    |d          }t          j
        ||           |                    |d          }t          j
        ||           t          dgdz  |g dd                              dd	g          }|                    |d          }t          j
        ||           |                    |d          }t          j
        ||           d S )N   r   r1   rV   )r=   r?   r   DEFGrG   r5   rH   )      ?       @g      @g333333@namesrW   r   r   )r?   r   r   r   bfillmethodbackfill)r=   r   r   r   padffill)r   listr@   r#   r   from_productr'   r    re   r$   rP   )r(   r)   r9   new_multi_index	reindexedrR   reindexed_with_backfillingreindexed_with_paddings           r,   test_reindex_with_multi_indexz8TestDataFrameSelectReindex.test_reindex_with_multi_index   s>   L TAXa'1#'1%((^^a'8881< 
 
 )S#J

 	 )((	$1A3	2B3PS*UUU JJ//	#'	c260JKK
 

)S#J

 	 	h	222 #'	0D0D0DEE
 

)S#J

 	 &(ZZZ%P%P"
h(BCCC%'ZZ
Z%S%S"
h(BCCC #'	0D0D0DEE
 

)S#J

 	 "$OE!J!J
h(>???!#OG!L!L
h(>?????r.   zmethod,expected_valuesnearest)r   r1   r1   r   r   r   r1   r   )r   r1   r   r   c                 R   t          dt          t          d                    i          }t          j        g d          }t          d|i|          }|                    ||          }t          j        ||           |                    ||d          }t          j        ||           |                    ||g d          }t          j        ||           |d d d	         }|                    |d d d	         |          }t          j        ||           g d
}|j        |         }|                    ||         |          }t          j        ||           |dk    rdn	|dk    rdn|}	|d d d	                             ||	          }t          j        ||           d S )Nxr>   gg?g?g      ?r&   r   r1   r   	tolerance)r1   r1   r1   r1   r   )rV   r   r   r1   r   r   )	r   r   r@   r    arrayr'   r$   rP   r   )
r(   r   expected_valuesr)   targetrR   actuale2	new_orderswitched_methods
             r,   test_reindex_methodsz/TestDataFrameSelectReindex.test_reindex_methods  s    T%((^^,--///00c?36BBBF622
h///F6Q??
h///F6\\\JJ
h///ddd^F44R4L88
b&))) LL	]9%F9-f==
b&))) z))EEVu__zzRX 	 DDbD!!&!AA
h/////r.   c                    t          dt          t          d                    i          }t          j        g d          }t          ddddt          j        gi|          }|                    |dd	          }t          j        ||           t          ddt          j        dt          j        gi|          }|                    |dg d
	          }t          j        ||           d S )Nr   r>   r   r   r1   r   r   g?r   )r   g{Gz?g?g?)	r   r   r@   r    r   re   r'   r$   rP   )r(   r)   r   rR   r   s        r,   $test_reindex_methods_nearest_specialz?TestDataFrameSelectReindex.test_reindex_methods_nearest_special/  s    T%((^^,--///00cAq!RV#45VDDDF9DD
h///cArvq"&#9:&IIIF9@U@U@UVV
h/////r.   c                    |}t          dd|          }t          dt          t          d                    i|          }|                    d          }|                    |d d         d          }t          j        ||           d S )	Nz
2019-01-01r>   )r   r   r   r   rV   r   r   )r   r   r   r@   headr'   r$   rP   )r(   tz_aware_fixturer   idxr)   rR   r   s          r,   test_reindex_nearest_tzz2TestDataFrameSelectReindex.test_reindex_nearest_tz;  s    qR888T%((^^,C888771::CGI66
h/////r.   c                     t          j        dg          }t          t          j        dg                    }t          |          }|                    |d          }t	          j        ||           d S )Nz2016-06-26 14:27:26+00:00z2016-07-04 14:00:59+00:00r   r   r   )rA   DatetimeIndexr   r'   r$   rP   )r(   dtir)   rR   r:   s        r,   #test_reindex_nearest_tz_empty_framez>TestDataFrameSelectReindex.test_reindex_nearest_tz_empty_frameE  ss     ;<==R-/J.KLLMMM3'''C	22
fh/////r.   c                    t          ddd          }t          t          j                            d                              t          |                    |d          }|                    t          d                    }t          j	        |d         j
        t          j
        d	                    sJ t          |          d         }|d
d                                          sJ |d d
                                         rJ d S )Nz1/1/2000 00:00:00r0   10sr   r   r   r=   r?      r?   M8[ns])r   r   r    r!   r"   r8   lenr'   r@   
issubdtyperf   r   allany)r(   rngr)   r:   masks        r,   test_reindex_frame_add_natz5TestDataFrameSelectReindex.test_reindex_frame_add_natM  s    ,buEEE)''**::3s88DD3OO
 
 E"II&&}VC[.0B0BCCCCCF||C BCCy}}9==??"""""r.   zmethod, exp_valuesr   r   r1   r   rV   r   g      ?r   g      @c           	          |g dt          dddd                    }t          dddd          }|                    ||t          j        d	          
          } |||          }t	          j        ||           d S )Nr   z2020-01-01 00:00:00rW   r3   UTCr   r   z2020-01-01 00:01:00z1 hourr   )r   r'   rA   r   r$   assert_equal)r(   frame_or_seriesr   
exp_valuesobjr9   r:   rR   s           r,   !test_reindex_frame_tz_ffill_bfillz<TestDataFrameSelectReindex.test_reindex_frame_tz_ffill_bfillZ  s     oLL2ACERRR
 
 
 4aceTTT	YvhAWAWXX"?:Y???
)))))r.   c                 "   g dg dg dg dg}g dg dg dg dg dt           j        t           j        t           j        gg}t          |          }|                    g ddd          }t          |          }t	          j        ||           d S )	N)r=   r=   r=   )r?   r?   r?   )r   r   r   )r   r   r   )r   r1   r   rV   rW   r>   r   r1   )r   limit)r    re   r   r'   r$   rP   )r(   dataexp_datar)   r:   rR   s         r,   test_reindex_limitz-TestDataFrameSelectReindex.test_reindex_limiti  s    ///???SOOOOOOOOOOVRVRV$
 t__...waHHX&&
fh/////r.   zidx, check_index_type)r   r?   r=   T)r   r   r=   r   r=   r   )r   r=   r?   r   r?   )r?   r=   r   r   r   F)r=   r   r?   c           
         t          t          d          t          d          d d d         g ddz  t          j                            d                              ddd	          d
          g d}fd}t          j        t          t          ||                              }                    |          	                    |d          }j
        |                             |          }t          j        |||           d S )N	BBBBAACCC	abcdeabcdr   r0         rV   r   r     	   jimjoejoliejoliner   r   r   c                 p    t          j        d         | k                                              d         S Nr   r   r    nonzeroto_numpyvalr)   s    r,   fzKTestDataFrameSelectReindex.test_reindex_level_verify_first_level.<locals>.f  -    :r%yC/99;;<<Q??r.   r   levelcheck_index_type)r   r   r    r!   r"   integersconcatenatemapr#   r'   r   r$   rP   )	r(   r   r  icolr   ileftr~   r)   s	           @r,   %test_reindex_level_verify_first_levelz@TestDataFrameSelectReindex.test_reindex_level_verify_first_levely  s   $ 788K((2.%))//22;;AtQGG	 
 
 '&&	@ 	@ 	@ 	@ 	@ N4As,,--||D!!))#U);;
$$T**
dE<LMMMMMMr.   r   ))mid)r  btm)r  r  top)r  r  )r  r  r  )r  )r  r  )r  r  r  )r  r  )r  r  r  )r  )r  r  )r  r  r  )r  r  )r  r  r  c                    t          dgdz  dgdz  z   dgdz  z   dgdz  d	gd
z  z   dgd
z  z   d	gdz  z   dgd
z  z   d	gdz  z   dgd
z  z   dgdz  z   t          j        d dD                       t          j                            d                              d                              d
          dz  d          g d}fd}t          j        t          t          ||                              }	                    |          
                    |d          }j        |         	                    |          }t          j        ||           d S )Nr  r>   r     r  r   3rdr   1strV   2ndc                 x    g | ]7}t           j                            d                               d|d          8S r   r   F)replacer    r!   r"   choice.0r   s     r,   
<listcomp>z\TestDataFrameSelectReindex.test_reindex_level_verify_first_level_repeats.<locals>.<listcomp>  M        	--a0077a7OO  r.   r   rV   rV   r   rV   r   rV   r   r   r0   r   r   c                 p    t          j        d         | k                                              d         S r   r   r   s    r,   r   zSTestDataFrameSelectReindex.test_reindex_level_verify_first_level_repeats.<locals>.f  r  r.   r   r  )r   r    r  r!   r"   r8   roundr   r  r#   r'   r   r$   rP   )r(   r   r	  r   r
  r  r~   r)   s          @r,   -test_reindex_level_verify_first_level_repeatszHTestDataFrameSelectReindex.test_reindex_level_verify_first_level_repeats  s   * w{eWq[0E7Q;>w{'A+'A+ 'A+ 'A+	
 'A+ 'A+ 'A+  !9    )//22BB2FFLLQOORTT' 
 
. '&&	@ 	@ 	@ 	@ 	@ N4As,,--||D!!))#U);;
$$T**
dE*****r.   zidx, indexer)r  r  r  )r   rV   rW   r   r1   r  r   r>   r   r   r0   rU                  r         )r  r  r  )r   r1   r   rV   rW   r0   rU   r"  r>   r   r   r  r   r   r'  r(  r%  r&  r#  r$  r  r  )r   r1   r>   r   r   r0   rU   r"  r%  r&  r   r'  r(  r  )r   r1   r   rV   rW   r0   rU   r"  r  r   r   r'  r(  r#  r$  c                 F   t          dgdz  dgdz  z   dgdz  z   dgdz  d	gd
z  z   dgd
z  z   d	gdz  z   dgd
z  z   d	gdz  z   dgd
z  z   dgdz  z   t          j        d dD                       t          j                            d                              d                              d
          dz  d          }g d}|                    |                              |d          }|j	        |                             |          }t          j        ||           d S )Nr  r>   r  r  r  r   r  r   r  rV   r  c                 x    g | ]7}t           j                            d                               d|d          8S r  r  r  s     r,   r  zPTestDataFrameSelectReindex.test_reindex_level_verify_repeats.<locals>.<listcomp>  r  r.   r  r   r0   r   r   r   r  )r   r    r  r!   r"   r8   r   r#   r'   r   r$   rP   )r(   r   indexerr)   r	  r  r~   s          r,   !test_reindex_level_verify_repeatsz<TestDataFrameSelectReindex.test_reindex_level_verify_repeats  sy     w{eWq[0E7Q;>w{'A+'A+ 'A+ 'A+	
 'A+ 'A+ 'A+  !9    )//22BB2FFLLQOORTT' 
 
. '&&||D!!))#U);; **400
dE*****r.   zidx, indexer, check_index_typeabcde)	rV   r   r1   r   r>   rW   r  r   r   abcd)rV   r   r1   r   r>   r  r   r   abc)rV   r   r1   r  r   r   eca)r1   rV   rW   r   r  edc)r   r1   rW   r>   r   eadbc)	rV   r   r   r1   rW   r>   r  r   r   edwq)r   rW   r>   wqc           
         t          t          d          t          d          d d d         g ddz  t          j                            d                              ddd	          d
          }g d}|                    |                              |d          }|j        |                             |          }t          j
        |||           d S )Nr   r   r   r   rV   r   r   r   r   r   r   r   r  r  )r   r   r    r!   r"   r  r#   r'   r   r$   rP   )r(   r   r+  r  r)   r	  r  r~   s           r,   test_reindex_level_verifyz4TestDataFrameSelectReindex.test_reindex_level_verify  s     788K((2.%))//22;;AtQGG	 
 
 '&&||D!!))#U);; **400
dE<LMMMMMMr.   c                    t          ddd          }t          j                            d                              d          }t          ||t          d                    }t          ||g d	         t          d                    }d
}t          j        t          |          5  |
                    |j        d           d d d            n# 1 swxY w Y   t          j        t          |          5  |
                    |j        d           d d d            n# 1 swxY w Y   t          j        t          |          5  |
                    |j        d           d d d            n# 1 swxY w Y   t          j        t          |          5  |
                    |j        d           d d d            d S # 1 swxY w Y   d S )Nz
2013-08-01r   r?   r   r   )r   r1   r=   r&   r7   )rV   rW   r>   r   r1   r   z0index must be monotonic increasing or decreasingmatchr   r   r   r   r   )r   r    r!   r"   r8   r   r   rp   raises
ValueErrorr'   r&   )r(   drr   r)   df_revmsgs         r,   "test_non_monotonic_reindex_methodsz=TestDataFrameSelectReindex.test_non_monotonic_reindex_methods  s   ac:::y$$Q''77??t2tCyy9994r*<*<*<'=tCyyQQQ@]:S111 	3 	3NN28EN222	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3]:S111 	5 	5NN28GN444	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5]:S111 	5 	5NN28GN444	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5]:S111 	7 	7NN28IN666	7 	7 	7 	7 	7 	7 	7 	7 	7 	7 	7 	7 	7 	7 	7 	7 	7 	7sH   (CCC7D  D$'D$E//E36E3F??GGc           
         t          ddgt          j        ddgt          j        dd                    d          }|                    ddg          }t          dt
          j        gt          j        dt
          j        gt          j        dd                    dddg	          }t          j        ||           d S )
Nr   r1   rN   r   r   r           rO   r   )	r   rA   r   SparseDtyper'   r    re   r$   rP   r(   r)   r:   rR   s       r,   test_reindex_sparsez.TestDataFrameSelectReindex.test_reindex_sparse*  s    a&rxAbnWa6P6PQQQRR
 
 QF##26]XsBFm2>)S3Q3QRRR  a&
 
 
 	fh/////r.   c                    t          t          j        dt          j                  t	          dd                    }|                    |j                  }|j        D ]}||                                         D ]p\  }}||j        v rLt          j	        |          r#t          j	        ||         |                   sJ E|||         |         k    sJ Zt          j	        |          sJ q|                                D ]$\  }}t          j        |j        |j                   %|                    t          g                     }t          |j                  dk    sJ |                    |j        d d d                   }	|	j        D ]}|	|                                         D ]p\  }}||j        v rLt          j	        |          r#t          j	        ||         |                   sJ E|||         |         k    sJ Zt          j	        |          sJ q|	                                D ]$\  }}t          j        |j        |	j                   %|                    |j                  }|j                            |j                  sJ |                    g           }|j        sJ t          |j                  t          |j                  k    sJ |                    g           }|                    |j                  }t          |j                  t          |j                  k    sJ t          |j                  t          |j                  k    sJ |                    t!          |j                            }|j                            d           }
t          j        |j        |
           |                                }t          j        ||           ||usJ d S )Nr   r   z
2020-01-01r   r   r   r   )r   r    arangerO   r   r'   r&   r7   itemsisnanr$   r%   r   r   is_emptyr   
_with_freqrP   )r(   float_framedatetime_seriesnewFramecolr   r   series
emptyFramenonContigFramerR   r:   s               r,   test_reindexz'TestDataFrameSelectReindex.test_reindex9  s    Ib
+++:lTV3W3W3W
 
 
 &&'<==# 	) 	)C$SM//11 ) )S++++x}} <!xC(8(=>>>>>>"k#&6s&;;;;;;8C==((=() $>>++ 	@ 	@KC!&,???? ((r33
:#$$)))) %,,_-B33Q3-GHH!) 	) 	)C*3/5577 ) )S++++x}} <!xC(8(=>>>>>>"k#&6s&;;;;;;8C==((=() *//11 	F 	FKC!&,0DEEEE &&{'899~!!+"344444 &&r**~~8#$$K,?(@(@@@@@ &&r**##K$5668>""c+*;&<&<<<<<8#$$K,?(@(@@@@@ &&tO,A'B'BCC"(33D99
hnh777 $$&&
fk222[((((((r.   c                    t          ddgddgddgddggdt          j        ddgd	d
g          }t          j        ddt          j        ddt          j        gg d}}t          j        |                    |          |j        |                    |j                            d          |_        t          j        |                    |          |j        |         d           t          ddt          j        dgdt          j        dt          j        gg dd          }t          j
        |j                  |d<   t          j
        d          |d         z
                      d          |d<   |                    g d                                          }|                    g d          }t          j        ||           d S )Nr1   r   rV   r>   r   rU   r   r2   r   r   r8  )r1   rV   rV   r1   r   r   r1   r   Fr  r5   rH   rI   z
2015-03-22z
2012-01-08)r   rV   rW   r>   )otherr   amountr   z
2015-06-18delta)rY  rW  r   )rY  rW  r   rX  rJ   )r   r    re   r$   rP   r'   r   r&   rM   rA   to_datetimer   shiftr#   rC   )r(   r)   r
  jr  r~   s         r,   test_reindex_nanz+TestDataFrameSelectReindex.test_reindex_nanx  s   VaVaWq"g.bfa#EN
 
 
 1bfaBF35J5J5J1
bjjmmRWQZ8888??8,,
bjjmmRWQZ%PPPP sBFC0%rv|RVD&,, 
 
 ^BG,,6
~l33bj@GGJJ7||66677CCEE

#G#G#G
HH
dE*****r.   c                    t          t          j                            d                              d                    }t	          |t          j        t          |                              }t          t          j        d          d          }|                    |          }|j        j	        dk    sJ |                    t          t          j        d          d                    }|j        j	        dk    sJ t          t          j                            d                              d                    }t	          |j        t          j        t          |                              }t          t          j        d          d          }|                    |          }|j        j	        dk    sJ d S )Nr   r0   r   inamenametmpnamerJ   )r   r    r!   r"   r   rH  r   r'   r&   ra  r   Tr7   )r(   rx   r)   r
  s       r,   test_reindex_name_remainsz4TestDataFrameSelectReindex.test_reindex_name_remains  s_   29((++2226677q	#a&& 1 122229R==w///ZZ]]x}''''ZZbimm)<<<==x}	))))29((++2226677qs")CFF"3"344429R==w///ZZZ""z'))))))r.   c                 ^   |                     |j        d d d                   }|d         j        t          j        k    sJ |                     |j                  }|d         j        t          j        k    sJ |                     ddg          }|d         j        t          j        k    sJ d S )Nr   r=   r?   rJ   )r'   r&   rf   r    rN   rO   )r(   	int_framesmallerbiggers       r,   test_reindex_intz+TestDataFrameSelectReindex.test_reindex_int  s    ##IOCCaC$899s|!RX----11c{ BJ....##S#J#77s|!RX------r.   c                    |                     g d          }t          j        |d         |d                    t          j        |d                                                   sJ d|vsJ |                     g           }|j        sJ d S )Nr=   r?   r   rJ   r?   r   r   )r'   r$   assert_series_equalr    rJ  r   rL  )r(   rN  	new_frames      r,   test_reindex_columnsz/TestDataFrameSelectReindex.test_reindex_columns  s    '''@@	
y~{3/?@@@x	#''++-----)####  '''33	r.   c           
      8   t          g dg dg dgg dg dt                    }|                    t          d                    }t          t          j        dd	t          j        d
t          j        gt          j        ddt          j        dt          j        gt          j        ddt          j        dt          j        ggg dt          d          t                    }t          j        ||           |                    t          d          d          }t          t          j        dd	d	d
d
gt          j        dddddgt          j        dddddggg dt          d          t                    }t          j        ||           |                    t          d          d          }t          ddd	d
d
t          j        gdddddt          j        gdddddt          j        ggg dt          d          t                    }t          j        ||           d S )N)rU   r"  r#  )      r2   )       !   )r1   r   rW   )r   r&   r7   rf   r   rJ   rU   r"  r#  rp  rq  r2   rr  rs  rt  r   )r7   r   r   )r   floatr'   r@   r    re   r$   rP   rD  s       r,   test_reindex_columns_methodz6TestDataFrameSelectReindex.test_reindex_columns_method  s   ,,lll;))II	
 
 
 E!HH--RRV4RRV4RRV4
 ))!HH	
 	
 	
 	fh/// E!HHW==RR,RR,RR,
 ))!HH	
 	
 	
 	fh/// E!HHW==RRRV,RRRV,RRRV,
 ))!HH	
 	
 	
 	fh/////r.   c           
      R   t          t          j        d          t          ddd          t          ddd          t          ddd          gg d          }d}t	          j        t          |	          5  t          d
dd          }d d d            n# 1 swxY w Y   ddg}|                    |          j	        j
        }|                    ||          j	        j
        }|                    |                              |          j	        j
        }||k    sJ ||k    sJ d S )NrV   rV   i  r1   r   rV   rG   r8  z:'d' is deprecated and will be removed in a future version.r9  
2012-01-01z
2012-01-03rK   )r   r5   rH   r   rJ   )r   r    onesr   r$   assert_produces_warningr	   r   r'   r&   r   )r(   r)   r?  	time_freq	some_cols
index_freq	both_freqseq_freqs           r,   test_reindex_axesz,TestDataFrameSelectReindex.test_reindex_axes  s~   GFOOD!Q''$1)=)=xaQR?S?ST#OO
 
 
 K'cBBB 	I 	I"<CHHHI	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I 	I#J	ZZiZ006;
JJY	JBBHM	::I:..66y6IIOTY&&&&X%%%%%%s   4BBBc                    t          t          j                            d                              d                    }|                    t          t          d                              }t          j        |j	        dd                    
                                sJ |                    t          d          d          }|                    t          d                                        d          }t          j        ||           |                    t          d          d	          }|                                }d|d
<   t          j        ||           |                    t          d          d	          }|                                }d|d
<   t          j        ||           |                    t          d          d	          }|                                }d|d
<   t          j        ||           d|d<   |                    t          d          d          }|                    t          d                                        d          }t          j        ||           d S )Nr   )r0   rW   r   r   r   )rz   r>   rB  )r7   rz   rW   foo0)r   r    r!   r"   r8   r'   r   r@   rJ  r   r   fillnar$   rP   copyrD  s       r,   test_reindex_fill_valuez2TestDataFrameSelectReindex.test_reindex_fill_value  s   ry,,Q//??HHII DrOO,,xbcc*++//11111E"II!44::eBii((//22
fh/// E!HH==7799
fh///E!HH;;7799
fh///E!HH??7799
fh/// 5	E"II#66::eBii((//44
fh/////r.   c                     t          ddgddgd|          }|                    t          d          g dd          }t          g d	g d	ddd
|          }t          j        ||           d S )Nr1   r   r5   rH   r   r.  r   r0   r7   r&   rz   )r1   r   r0   r0   rL   )r   r'   r   r$   rP   )r(   any_unsigned_int_numpy_dtyper)   r:   rR   s        r,   #test_reindex_uint_dtypes_fill_valuez>TestDataFrameSelectReindex.test_reindex_uint_dtypes_fill_value#  s    aV1a&119UVVVDLLQSTT ..~~~BRHH.
 
 
 	fh/////r.   c                     t          dddgi|          }|                    t          d          g dd          }t          t          g d	|          dd
          }t	          j        ||           d S )Nr5   r1   r   r   ab)r   r1   r   r0   r  )r1   r   r0   r  )r   r'   r   r   r$   rP   )r(   any_numeric_ea_dtyper)   r:   rR   s        r,   /test_reindex_single_column_ea_index_and_columnszJTestDataFrameSelectReindex.test_reindex_single_column_ea_index_and_columns-  s    aV},@AAADJJiiiBOO+?@@@rJJ
 
 	fh/////r.   c           
         t           j                            d                              d          }t	          |g d          }|                                }t          t          t          |                              |_	        t	          |t          t          t          |                                        }t          j        ||           d}t          j        t          |          5  |                    t          t          t          |                                         d d d            d S # 1 swxY w Y   d S )Nr   r0   )
r1   r   rV   rW   r>   r1   r   rV   rW   r>   r   /cannot reindex on an axis with duplicate labelsr9  )r    r!   r"   r8   r   r  r   r@   r   r&   r$   rP   rp   r;  r<  r'   )r(   r   r)   r:   rR   r?  s         r,   test_reindex_dupsz,TestDataFrameSelectReindex.test_reindex_dups6  sJ   i##A&&66r::s"@"@"@AAA E#b''NN++SU3r77^^(<(<===
fh/// @]:S111 	3 	3JJT%B..11J222	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3s   2>D==EEc                 n   t          g dg dg dgg d          }d}t          j        t          |          5  |                    dg           d d d            n# 1 swxY w Y   t          j        t          |          5  |                    ddg           d d d            d S # 1 swxY w Y   d S )N)r1   r>   g      @)barr5   r5   rJ   r  r9  r  r  )r   rp   r;  r<  r'   r(   r)   r?  s      r,   #test_reindex_with_duplicate_columnsz>TestDataFrameSelectReindex.test_reindex_with_duplicate_columnsF  sN   [[+++{{{3=N=N=N
 
 
 @]:S111 	( 	(JJwJ'''	( 	( 	( 	( 	( 	( 	( 	( 	( 	( 	( 	( 	( 	( 	(]:S111 	/ 	/JJu~J...	/ 	/ 	/ 	/ 	/ 	/ 	/ 	/ 	/ 	/ 	/ 	/ 	/ 	/ 	/ 	/ 	/ 	/s#   AA"%A"B**B.1B.c                    t          g dg dd          }t          ddt          j        gddt          j        gdg d	          }|                    g d          }t	          j        ||           |                    g dd
          }t	          j        ||           |                    g dd          }t	          j        ||           d S )Nr1   r   rV   rW   r>   r   r   r1   r   rW   r>   )r   r1   rV   r   r   ry   r&   )r   r    re   r'   r$   rP   )r(   r)   rR   r:   s       r,   test_reindex_axis_stylez2TestDataFrameSelectReindex.test_reindex_axis_styleQ  s    YYYYYY7788a.1bf~66iii
 
 
 III&&
fh///IIIA..
fh///IIIG44
fh/////r.   c                     t          g dg dd          }d}t          j        t          |          5  |                    ddgg d           d d d            d S # 1 swxY w Y   d S )	Nr  r  r   zCreindex\(\) takes from 1 to 2 positional arguments but 3 were givenr9  r   r1   r   r   rp   r;  	TypeErrorr'   r  s      r,   test_reindex_positional_raisesz9TestDataFrameSelectReindex.test_reindex_positional_raises`  s     YYYYYY7788T]9C000 	0 	0JJ1v///	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0s   AA #A c                 <   t          g dg dd          }t          j        t          d          5  |                    ddgdgd	           d d d            n# 1 swxY w Y   t          j        t          d          5  |                    ddgdgd
	           d d d            n# 1 swxY w Y   t          j        t          d          5  |                    ddgd
           d d d            n# 1 swxY w Y   t          j        t          d          5  |                    ddgd           d d d            n# 1 swxY w Y   t          j        t          d          5  |                    ddgd	           d d d            n# 1 swxY w Y   t          j        t          d          5  |                    ddgddgd           d d d            n# 1 swxY w Y   t          j        t          d          5  |                    ddgdgdg           d d d            n# 1 swxY w Y   t          j        t          d          5  |                    ddgd
           d d d            n# 1 swxY w Y   t          j        t          d          5  |                    ddgd           d d d            n# 1 swxY w Y   t          j        t          d          5  |                    ddgddg           d d d            d S # 1 swxY w Y   d S )Nr  r  r   zCannot specify both 'axis'r9  r   r1   r=   )r7   ry   r&   )r&   ry   r7   )r&   r7   ry   zCannot specify all)labelsr&   r7   zmultiple valuesr  r  )r(   r)   s     r,   test_reindex_axis_style_raisesz9TestDataFrameSelectReindex.test_reindex_axis_style_raisesh  s   YYYYYY7788]9,HIII 	6 	6JJ1vu1J555	6 	6 	6 	6 	6 	6 	6 	6 	6 	6 	6 	6 	6 	6 	6 ]9,HIII 	< 	<JJ1vu7J;;;	< 	< 	< 	< 	< 	< 	< 	< 	< 	< 	< 	< 	< 	< 	< ]9,HIII 	3 	3JJaV'J222	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 ]9,HIII 	5 	5JJaV)J444	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 ]9,HIII 	7 	7JJ1vIJ666	7 	7 	7 	7 	7 	7 	7 	7 	7 	7 	7 	7 	7 	7 	7 ]9,HIII 	E 	EJJaVaV)JDDD	E 	E 	E 	E 	E 	E 	E 	E 	E 	E 	E 	E 	E 	E 	E ]9,@AAA 	@ 	@JJq!fQC#J???	@ 	@ 	@ 	@ 	@ 	@ 	@ 	@ 	@ 	@ 	@ 	@ 	@ 	@ 	@ ]9,HIII 	3 	3JJaV'J222	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 ]9,HIII 	5 	5JJaV)J444	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 ]9,=>>> 	. 	.JJ1vq!fJ---	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	.s   AA!A B((B,/B,C44C8;C8E  EE&FFF2GG"GH**H.1H.I66I:=I:KK	K(LLLc                     t          g dg dd          }|                    ddgdg          }t          dddgi          }t          j        ||           d S )Nr  r   r   r1   r=   rJ   r   r   r'   r$   rP   rD  s       r,   !test_reindex_single_named_indexerz<TestDataFrameSelectReindex.test_reindex_single_named_indexer  sh    YYYYYY7788QFSE22cAq6]++
fh/////r.   c                 B   t          g dg dg dgg dg d          }|                    ddg          }|                    ddg	          }|                    ddg
          }|                    ddgd          }|                    ddgd          }||||fD ]}t          j        ||           |                    ddg          }|                    ddgd          }|                    ddgd          }||fD ]}t          j        ||           |                    ddgddg          }|                    ddgddg          }|                    ddgd                              ddgd          }||fD ]}t          j        ||           d S )Nr  )rV   rW   r>   )r>   r   r   rG   )rK   er   r8  rH   r5   r   r  r   )r  ry   r  r  rK   rJ   r1   r6   r  )r(   r)   res1res2res3res4res5r   s           r,   test_reindex_api_equivalencez7TestDataFrameSelectReindex.test_reindex_api_equivalence  s    YY			999-!//#OO
 
 
 zz3*%%zzc
z++zz#sz,,zz#s!z44zz3*1z--$d+ 	- 	-C!$,,,,zz3*z--zz3*1z--zz#s!z44$< 	- 	-C!$,,,,zzc
S#Jz??zz3*S#Jz??zz#s!z44<<S#JUV<WW$< 	- 	-C!$,,,,	- 	-r.   c                    t          t          j        dt                    t          j        ddd          ddg          }|                    t          j        d                    }|j        j        t          j        k    sJ t          |d         d                   sJ |                    t          d	          
          }|j        j        t          j        k    sJ t          |d                                                   sJ d S )N)r0   r   r   r   r   r   r8  r0   r1   rV   rJ   )r   r    rz  boolrH  r'   r   rf   object_r   r@   r   )r(   framer   s      r,   test_reindex_booleanz/TestDataFrameSelectReindex.test_reindex_boolean  s    GG4(((	!R0C0CaQRV
 
 
 MM")B--00	%3333IaLO$$$$$MM%((M33	%3333IaL!!%%'''''''r.   c                 ~    |                     g d          }d|v sJ |                     ddg          }d|vsJ d S )N)r  r=   r?   rJ   r  r=   r?   )r'   )r(   float_string_framer   s      r,   test_reindex_objectsz/TestDataFrameSelectReindex.test_reindex_objects  sa    &..7H7H7H.II		!!!!&..Sz.BB	I%%%%%%r.   c                 <   t          g d          }t          i                               g d          }|                    |          }t          j        |j        |           |                    g d          }|d         j        t          j        k    sJ d S )NrG   r  r   rJ   rk  r   )	r   r   r'   r$   r%   r7   rf   r    rO   )r(   rf  r&   dmr   rg  s         r,   test_reindex_cornerz.TestDataFrameSelectReindex.test_reindex_corner  s    ooo&&r]]"""33JJuJ--	
i/777 ##OOO#<<s|!RZ//////r.   c           	         t          ddgddgt          j        t          j        gddgddggd	d
gddt          j        ddg          }|                    g d          }|j        g d         }t          j        ||           |                    dg          }|j        dg         }t          j        ||           |                    dg          }|j        dg         }t          j        ||           d S )Nr1   r   rV   rW   r   r  r   r0   r5   rH   g      Y@     @Y@     Y@     Y@r6   )r  r  r  r   )r1   rV   rW   )r   r    re   r'   r   r$   rP   rD  s       r,   test_reindex_with_nansz1TestDataFrameSelectReindex.test_reindex_with_nans  s   VaVbfbf-1v2w?#J%6
 
 
 "7"7"7887999%
fh///5'**7A3<
fh///5'**7A3<
fh/////r.   c                 "   t          t          j        dt          j                            }|                    t          j        dd                    }|j                            t          j                                                  sJ d S )N)r0   r0   r   r>   r   rJ   )	r   r    zerosfloat32r'   rH  r   eqr   )r(   r)   r:   s      r,   test_reindex_without_upcastingz9TestDataFrameSelectReindex.test_reindex_without_upcasting  so    rx
;;;<<BIa$4$455}
++//1111111r.   c                 8   t          t          j                            d                              d                    }|                    t          d          t          d                    }|                    t          t          d                                                  t          d                    }t          j	        ||           t          t          j                            d          
                    ddd                    }|                    t          d          t          d                    }|                    t          t          d                                                  t          d                    }t          j	        ||           t          t          j                            d          
                    ddd                    }|                    t          d          t          d                    }|                    t          d                                        t          d                    }t          j	        ||           t          t          j                            d                              d          d	z   g d
          }|                    ddgddg          }|                    ddg                              ddg          }t          j	        ||           d S )Nr   rx  rW   r8  rJ   r   r0   )r>   rV   y              ?rG   r1   r5   rH   )r   r    r!   r"   r8   r'   r@   r   r$   rP   r  rD  s       r,   test_reindex_multiz-TestDataFrameSelectReindex.test_reindex_multi  s`   ry,,Q//??GGHH%((E!HH==::d588nn--55eAhh5GG
fh///ry,,Q//88BGGHH%((E!HH==::d588nn--55eAhh5GG
fh///ry,,Q//88BGGHH%((E!HH==::eAhh''//a/AA
fh///I!!!$$44V<<rA#OO
 
 

 1a&3*==::q!f%%--sCj-AA
fh/////r.   c                    t          j        t          g d          t          t          ddd                    g          }t	          dt          t          |                    i|          }|j        g d         }|                    |          }t	          dd	d
dddddt          j
        dg	i|          }t          j        ||           d S )NrG   ry  rV   r3   r   r5   r   )r   r1   r   rV   rW   r>   r   r  r   r1   r   rW   r>   r   r  )r   r   r
   r   r   r@   r   r   r'   r    re   r$   rP   )r(   midxr)   rS   r:   rR   s         r,   #test_reindex_multi_categorical_timez>TestDataFrameSelectReindex.test_reindex_multi_categorical_time  s    &OOO,,J|QSIIIJJ
 
 U3t99--.d;;;g.../T""cAq!Q1a#CDDQQQ
fh/////r.   c                    t          dt          j        dd          it          t	          d          t          t	          d                    d          	          }|                    g d
          }t          ddt          j        gt          t	          d                    d          	                    d          }t          j        ||d           |                    ddg          }t          ddgt          t	          d                    d          	                    d          }t          j        ||d           |                    dg          }t          t          j        gt          dg          d          	                    d          }t          j        ||d           |                    dg          }t          t          j        gt          dg          d          	                    d          }t          j        ||d           t	          d          }|                    t          ddg|                    }t          dt          j        gt          t	          d                                        t          |                    d          	                    d          }t          j        ||d           |                    t          dg|                    }t          dgt          t	          d                                        t          |                    d          	                    d          }t          j        ||d           |                    g d
          }t          ddt          j        gt          t	          d                    d          	                    d          }t          j        ||d           |                    ddg          }t          ddgt          t	          d                    d          	                    d          }t          j        ||d           |                    dg          }t          t          j        gt          dg          d          	                    d          }t          j        ||d           |                    t          ddg|d                    }t          dt          j        gt          t	          d                                        t          |d                    d          	                    d          }t          j        ||d           |                    t          ddgddg                    }t          dt          j        gt          t	          d                                        t          ddg                    d          	                    d          }t          j        ||d           t          dt          j        dd          it          t	          d          t          t	          d                    d          	          }d}t          j        t           |          5  |                    ddg           d d d            n# 1 swxY w Y   d}t          j        t"          |                    d                     5  |                    dgd!"           d d d            n# 1 swxY w Y   t          j        t"          |                    d#                    5  |                    dgd$           d d d            n# 1 swxY w Y   t          j        t"          |                    d%                    5  |                    dgd&'           d d d            d S # 1 swxY w Y   d S )(Nr=   rV   rN   r   r/  caber?   )rf   ra  r   )r5   rH   r  r   r1   aber   Tr  r5   rH   r  r  rK   
categoriesae)r  ordered)r  adr   aabbcar  r9  z<argument {} is not implemented for CategoricalIndex\.reindexr   r   r   r  r  r   r   )r   )r   r    rH  r   r   r   r'   re   r   r#   r$   rP   r
   rM   rp   r;  r<  NotImplementedErrorformat)r(   r)   r:   rR   catsrS   r?  s          r,   "test_reindex_with_categoricalindexz=TestDataFrameSelectReindex.test_reindex_with_categoricalindex  s   RYq000 #U#3DLL#A#A  	
 
 
 OOO,,Aq"&>tE{{8K8KLLMMWW
 
 	fhFFFFS#J''Aq6tDzz0B0BCCDDNNsSS
fhFFFFSE""BF8&#--@@AAKKCPP
fhFFFFSE""BF8&#--@@AAKKCPP
fhFFFF F||Kc
tDDDEEbf+F4::$6$6$=$=>Nt>T>T$U$UVV
 

)C.. 	 	fhFFFFK$???@@#F499--445Ed5K5KLLMM
 

)C.. 	 	fhFFFFOOO,,Aq"&>tE{{8K8KLLMMWW
 
 	fhFFFFS#J''Aq6tDzz0B0BCCDDNNsSS
fhFFFFSE""BF8&#--@@AAKKCPP
fhFFFF Kc
tTRRRSS[DJJ''../?d/S/S/STT 
 

 )C.. 	 	fhFFFFKc
SzJJJKK[DJJ''../?c
/K/KLL 
 

 )C.. 	 	fhFFFFRYq000 #X&6tF||&D&D3  	
 
 
 @]:S111 	$ 	$KKc
###	$ 	$ 	$ 	$ 	$ 	$ 	$ 	$ 	$ 	$ 	$ 	$ 	$ 	$ 	$ N].cjj6J6JKKK 	. 	.JJuWJ---	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	. 	.].cjj6I6IJJJ 	' 	'JJuAJ&&&	' 	' 	' 	' 	' 	' 	' 	' 	' 	' 	' 	' 	' 	' 	'].cjj6I6IJJJ 	' 	'JJuAJ&&&	' 	' 	' 	' 	' 	' 	' 	' 	' 	' 	' 	' 	' 	' 	' 	' 	' 	'sH   Z;;Z?Z?6\\"\]99]= ]=2___c                 ~    t          j        t          j                  }t	          |j                  }|h dk    sJ d S )N>   ry   r  r(   r&   r  r   r  r   r7   r   rz   )inspect	signaturer   r'   set
parameters)r(   sigr  s      r,   test_reindex_signaturez1TestDataFrameSelectReindex.test_reindex_signaturez  sT    	 122((
 
 
 
 
 
 
 
 
 
r.   c                 &   t          j        ddg          }t          ddgddgg|ddg	          }t          j        g d
          }|                    |dd          }t          ddgddgddgg|ddg	          }t	          j        ||           d S )Nr  rK   r  r   r   rV   rW   r   yr8  )r  r  )r3   r
  r   )ry   r   )r   from_tuplesr   r'   r$   rP   )r(   mir)   mi2r:   rR   s         r,   (test_reindex_multiindex_ffill_added_rowszCTestDataFrameSelectReindex.test_reindex_multiindex_ffill_added_rows  s     #Z$<==AA'rC:FFF$%I%I%IJJCa88q!fq!fq!f5S3PS*UUU
fh/////r.   kwargsr   r|   r   r   Nc                    t          ddd          }t          g t          g d          dg          } |j        |fi |}t          dt          j        gdz  i|t          	          }t          j        ||           d S )
N202030srV   )startr   r   timer`  r5   r8  )r&   rf   )	r   r   r   r'   r    re   r   r$   rP   )r(   r  r   r)   r:   rR   s         r,   test_reindex_empty_framez3TestDataFrameSelectReindex.test_reindex_empty_frame  s     vE1===rr!7!7!7#GGGC**6**cBF8a<06JJJ
fh/////r.   src_idxcat_idxc                     t           |g           dgd          }|                    |          }t          dg|d          }t          j        ||           d S )NKf8)r7   r&   rf   rJ   )r&   r7   rf   r  )r(   r  r  r)   r:   rR   s         r,   test_reindex_emptyz-TestDataFrameSelectReindex.test_reindex_empty  sd     wwr{{3%tDDDG,,C5'FFF
fh/////r.   rf   m8[ns]r   c                    t          j        t          d          t          d          g          }t	          dd          }t          j        dd          }|dk    r ||d	         z
  }t          j        dd          }t          ||
          }t          j
        |d d d<   |                                }|j                            t          dg                    }|j                            t          dg                    }|                    |||          }	t#          g |d	                                         |g |d                                         |t          j        dgdz  |j                  d|
          }
|	j        d	dg         t,          k                                    sJ |	j        d         t          j
        u sJ |	j        d         |u sJ |	j        d         |u sJ t3          j        |	|
           d S )NABCDEr   r   r0   rG  NaTr   r  r   r   rV   r1   r  r   r   r   )r   r1   r  r   )r   r   )r   r1   )r   r   r   r@   r   r    timedelta64
datetime64r   rA   r  unstackr&   appendr   r7   r'   r   r   r   rf   r   r   r   r   r$   rP   )r(   rf   r  r   r   rD   r)   r&   r7   r   rR   s              r,   #test_reindex_datetimelike_to_objectz>TestDataFrameSelectReindex.test_reindex_datetimelike_to_object  s    $d7mmU1XX%>??r222^E4((HA,Cud++BS###6CCaC[[]]qc

++*##E5'NN33jjug"jEE(RU\\^^(R((RU\\^^(R(x!28<<< 
 
 
 
 
Aq6"f,1133333x~''''x"$$$$x"$$$$
c8,,,,,r.   klassr   c                     t          t          g dg                    } ||g          }|                    |          }t          |          }t          j        ||           d S )Nr=   r  r   )r   r   r'   r$   rP   )r(   r  r   r)   r   r:   rR   s          r,   test_reindex_not_categoryz4TestDataFrameSelectReindex.test_reindex_not_category  so     -bcUCCCDDDeTFmm#&&3'''
fh/////r.   c                     t          ddt          j        dgi          }d}t          j        t
          |          5  |                    g dd           d d d            d S # 1 swxY w Y   d S )	Nr=   r1   r   zInvalid fill methodr9  )r1   r   r   asfreqr   )r   r    re   rp   r;  r<  r'   r  s      r,   test_invalid_methodz.TestDataFrameSelectReindex.test_invalid_method  s    a^,--#]:S111 	3 	3JJyyyJ222	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3s   A##A'*A'c                 R   t          ddgddgdt          ddgd	          
          }t          j        ddgddggddg          }|                    |
          }t          g dg ddt          j        ddgddggddg                    }t          j        ||           d S )Nr1   r   r=   r?   )valuerW  r0   r   r5   r`  r   r   r  rH   r   )r1   r1   r   r   )r=   r=   r?   r?   r   r&   )r   r   r   r   r'   r$   rP   r(   r)   r   r:   rR   s        r,   0test_reindex_index_name_matches_multiindex_levelzKTestDataFrameSelectReindex.test_reindex_index_name_matches_multiindex_level  s    !fSz22Rs+++
 
 
 ("XSz"*
 
 

 &))'<<2F2F2FGG)B8c3Z*@c
SSS
 
 
 	fh/////r.   c                 ^   t          dddgit          ddgd                    }t          j        ddgd	d
ggddg          }|                    |          }t          dt
          j        gdz  it          j        ddgd	d
ggddg                    }t          j        ||           d S )Nr  r1   r   r0   r   different_namer`  r   r   r  r5   rH   r   rW   r  )	r   r   r   r   r'   r    re   r$   rP   r  s        r,   1test_reindex_index_name_no_match_multiindex_levelzLTestDataFrameSelectReindex.test_reindex_index_name_no_match_multiindex_level   s    !Q(r2hEU0V0V0VWWW(2r(S#J)?SzRRR&))BF8a<()B8c3Z*@c
SSS
 
 
 	fh/////r.   )Brm   rn   ro   rp   rq   xfailr   r   r   r   r   r   rr   r    re   r   r   r   r   r   r   r   r  r!  r,  r   r6  r@  rE  rU  r]  rd  ri  rn  rv  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r   r  r   r   r  r  r  r   r  r  rs   r.   r,   ru   ru      s        [B((**A>/A&   
- - 
-0- - -:I@ I@ I@V [ %RVQ1%&&	
 0 0 08
0 
0 
00 0 00 0 0# # # [
<<<	 7S#sBF,C"DE 	* 	*	 	*0 0 0  [__d#!!!4(UDM__d#__d#3Z3Z3Z__d#3Z__e$	
 "N N# "N& [	
 	
 	
 ( +  +) ( +D [ &%%VVV
 &%%VVV U^LLLMU^RRRS	
 + + +: [(T']]777>T&\\333T:T%[[,,,d3T%[[///40T%[[///40T']]777>T&\\999d+T$ZZU#		
 N N N7 7 7 0 0 0=) =) =)~+ + +:* * *"	. 	. 	.	 	 	10 10 10f& & &&0 0 0B0 0 00 0 03 3 3 	/ 	/ 	/0 0 00 0 0!. !. !.F0 0 0- - -:( ( (& & &0 0 00 0 0&2 2 20 0 0@0 0 0c' c' c'J
 
 
"0 0 0 [99Q+?+?+?@@!		!0D0D0DEEy!t		
 0 0 0 [Y0@(ABB[ E"IIR  E3*c3Z((E3*c3Z((		
 0 0  CB0 [Wx&:;; -  - <; -D [Wu.>&?@@[Vc3Z000 0 10 A@03 3 30 0 0"	0 	0 	0 	0 	0r.   ru   )!r   r   r  numpyr    rp   pandas._libs.tslibs.timezonesr   rc   pandas.compatr   r   pandas.compat.numpyr   pandas.errorsr	   pandasrA   r
   r   r   r   r   r   r   r   pandas._testing_testingr$   pandas.api.typesr   r   ru   rs   r.   r,   <module>r     s                A A A A A A        / . . . . . ( ( ( ( ( (    	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	       - - - - - -^
 ^
 ^
 ^
 ^
 ^
 ^
 ^
BG0 G0 G0 G0 G0 G0 G0 G0 G0 G0r.   