
    .i                         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 y)    )datetime	timedeltaN)dateutil_gettz)IS64is_platform_windows)np_version_gt2)Pandas4Warning)CategoricalCategoricalIndex	DataFrameIndex
MultiIndexSeries
date_rangeisna)CategoricalDtypec                   t    e Zd Zd Zd Zd Zd Zej                  j                  dg dg dg      d        Z
y	)
TestReindexSetIndexc                 r   t        t        j                  j                  d      j                  d            }t	        dddd      }t	        dddd	      }|j                  |      }t        j                  |j                  |       |j                  |      }t        j                  |j                  |       y )
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       e/var/www/app/trading-bot/venv/lib/python3.12/site-packages/pandas/tests/frame/methods/test_reindex.py(test_dti_set_index_reindex_datetimeindexz<TestReindexSetIndex.test_dti_set_index_reindex_datetimeindex$   s    ryy,,Q/66q9:,N&!$<H\\$
bhh-ZZ
bhh-    c           	      ~   t        t        ddd      t        dddd      dd      }t        t        j                  j                  d      j                  d	      d
g|      }t        t        ddd      t        dddd      dd      }|j                  |      }|j                  j                  |j                  k(  sJ y )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<
 II!!!$44W=E

 T2q!8D"a#<3<
	 i(||  EJJ...r.   c                     t        dt        d      i      }t        j                  |j                  d      }||d<   |j                  d      }|j                         }y )NAr0      B)r   rangepdcutr=   r#   reset_index)r(   r)   sers      r,   "test_set_reset_index_intervalindexz6TestReindexSetIndex.test_set_reset_index_intervalindex@   sK    U2Y'(ffRTT1o3\\#^^r.   c                     t        g d      j                  dt        j                  t        j                  d      }|j                  dg      }g |d<   |j                         }t        g dt        d            j                  dt        j                  t        j                  t        j                  d      }t        j                  ||       |j                  dd	g      }g |d<   |j                         }t        j                  ||       y )
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
 llC5!C"%9qJQQ"

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      j	                  d      j                  dd	g      }	t        dd	gt        j                  t        j                  gd      j	                  d      }
|
j                  |	j                  j                        }
t        j                  |	|
       y )
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RYwWc3Z  	
 3*rvvrvv6FGHRR
 jj'
	
r.   N)__name__
__module____qualname__r-   r;   rE   rT   pytestmarkparametrizerl    r.   r,   r   r   !   sE    	./"0$ [[*	,.RS!
	!
r.   r   c                      e Zd Zej                  j                  e xs  e       xr e d      d        Z	d Z
d Zej                  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                  j                  ddg dfddddej                  gfg      d        Zd Zej                  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                  j                  d+g d,      d-        Zej                  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                  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 Z7dg Z8ej                  j                  dhd	 e9dij      dkd e9dij      dkdldidldmig      dn        Z:ej                  j                  doe;e<g      ej                  j                  dp e;g        e<g        e;d d$g       e<d d$g       e;d d g       e<d d g      g      dq               Z=ej                  j                  drdsdtg      du        Z>ej                  j                  dve;e<g      ej                  j                  dwd d$g      dx               Z?dy Z@dz ZAd{ ZBym)|TestDataFrameSelectReindexzTPasses int32 values to DatetimeArray in make_na_array on windows, 32bit linux builds)reasonc                    t        dgg      }t        j                  dd      j                  d      }|j	                  ddgd|      }|j
                  d   t        j                  dd      k(  sJ t        dg|gd	      }|d   j                  |j
                  d         |d<   t        j                  ||       |j                  d       j                  d      }|j	                  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         }|j	                  ddgd|      }|j
                  d   t        j                  dd      k(  sJ t        dg|gd	      }|d   j                  |j
                  d         |d<   t        j                  ||       y )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jj!QaBj7zz!} 2 2 MMMM!"./qk((A7
c8,nnT",,S1jj!QaCj8zz!}s 3333!#/0
c8,;;r2Q(?#?@jj!QaHj=zz!} 0 01Lg VVVV!(45qk((A7
c8,r.   c                    t        ddd      j                  j                  dd      }t        |ddgt	        d      	      }|j
                  d
   }|j                         }|j                  t	        d      g d|      }t        g |d   j                         |g |d   j                         ||gdz  dt              }t        j                  ||       |j                  t	        d      |      }t        j                  ||ddg          |j                  t	        d      g dd      }t        g |d   j                         |g |d   j                         ||gdz  d      }t        j                  ||       y )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   so   qt<CCKKAqQsS#JeAh?WWT]WWYjjuQxRjP)BsGNN$)b)0G"S'..2B0GB0GrdUVhW
 	c8, jjuQxBj7
c8S#J#78 jj(O  
 )BsGNN$)b)0G"S'..2B0GB0GrdUVh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      j                  dd	g      }g d
}t	        j
                  dg|gdd	g      }|j                  |      }t        dgdz  |t        j                  ddt        j                  gd      j                  dd	g      }t        j                  ||       t        dgdz  |g dd      j                  dd	g      }|j                  |d      }t        j                  ||       |j                  |d      }t        j                  ||       t        dgdz  |g dd      j                  dd	g      }|j                  |d      }t        j                  ||       |j                  |d      }t        j                  ||       y )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'81<
 )S#J
 	 )	$11A3	2B3PS*U JJ/	#'	c2660JK

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

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

)S#J
 	 "$OE!J
h(>?!#OG!L
h(>?r.   zmethod,expected_valuesnearest)r   r1   r1   r   r   r   r1   r   )r   r1   r   r   c                    t        dt        t        d            i      }t        j                  g d      }t        d|i|      }|j                  ||      }t        j                  ||       |j                  ||d      }t        j                  ||       |j                  ||g d      }t        j                  ||       |d d d	   }|j                  |d d d	   |      }t        j                  ||       g d
}|j                  |   }|j                  ||   |      }t        j                  ||       |dk(  rdn|dk(  rdn|}	|d d d	   j                  ||	      }t        j                  ||       y )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  sa    T%(^,-/0c?36BF62
h/F6Q?
h/F6\J
h/dd^F4R4L8
b&) 	]]9%F9-f=
b&) z)EVu_zRX 	 DbD!!&!A
h/r.   c                    t        dt        t        d            i      }t        j                  g d      }t        ddddt        j
                  gi|      }|j                  |dd	      }t        j                  ||       t        ddt        j
                  dt        j
                  gi|      }|j                  |dg d
	      }t        j                  ||       y )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cAq!RVV#45VDF9D
h/cArvvq"&&#9:&IF9@UV
h/r.   c                     |}t        dd|      }t        dt        t        d            i|      }|j	                  d      }|j                  |d d d      }t        j                  ||       y )	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;  sc    qR8T%(^,C8771:CGI6
h/r.   c                     t        j                  dg      }t        t        j                  dg            }t        |      }|j                  |d      }t	        j
                  ||       y )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  s[     ;<=R--/J.KLM3'C	2
fh/r.   c                    t        ddd      }t        t        j                  j	                  d      j                  t        |            |d      }|j                  t        d            }t        j                  |d   j                  t        j                  d	            sJ t        |      d   }|d
d  j                         sJ |d d
 j                         rJ y )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))''*::3s8D3O
 E"I&}}VC[..0BCCCF|C BCy}}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      }|j                  ||t        j                  d	      
      } |||      }t	        j
                  ||       y )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  sj     2ACER
 4aceT	YvhAW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        |      }|j                  g ddd      }t        |      }t	        j
                  ||       y )	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  sv    /?SVVRVVRVV$
 t_.wa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                  j	                  d      j                  ddd	      d
      g d}fd}t        j                  t        t        ||                  }j                  |      j                  |d      }j                  |   j                  |      }t        j                  |||       y )N	BBBBAACCC	abcdeabcdr   r0         rV   r   r     	   jimjoejoliejoliner   r   r   c                 \    t        j                  d   | k(  j                               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K(2.%)))//2;;AtQG	
 '	@ NN4As,-||D!))#U);
$$T*
dE<L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 cg c]3  }t        j                  j	                  d      j                  d|d      5 c}      t        j                  j	                  d      j                  d      j                  d
      dz  d      g d}fd}t        j                  t        t        ||                  }j                  |      j                  |d      }j                  |   j                  |      }t        j                  ||       y c c}w )Nr  r>   r     r  r   3rdr   1strV   2ndr   rV   rV   r   rV   r   rV   r   r   Freplacer   r0   r   r   c                 \    t        j                  d   | k(  j                               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"   choicer8   roundr   r  r#   r'   r   r$   rP   )	r(   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+  ": 		--a077a7O ))//2BB2FLLQORTT'
. '	@ NN4As,-||D!))#U);
$$T*
dE*!s   #8E/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                    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 cg c]3  }t        j                  j	                  d      j                  d|d      5 c}      t        j                  j	                  d      j                  d      j                  d
      dz  d      }g d}|j                  |      j                  |d      }|j                  |   j                  |      }t        j                  ||       y c c}w )Nr  r>   r  r  r  r   r  r   r  rV   r  r  r   Fr  r   r0   r   r   r   r  )r   r    r  r!   r"   r  r8   r  r#   r'   r   r$   rP   )r(   r   indexerr   r)   r	  r  r~   s           r,   !test_reindex_level_verify_repeatsz<TestDataFrameSelectReindex.test_reindex_level_verify_repeats  sq     w{eWq[0E7Q;>w{'A+'A+ 'A+ 'A+	
 'A+ 'A+ 'A+  ": 		--a077a7O ))//2BB2FLLQORTT'
. '||D!))#U); **40
dE*s   "8E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           
      r   t        t        d      t        d      d d d   g ddz  t        j                  j	                  d      j                  ddd	      d
      }g d}|j                  |      j                  |d      }|j                  |   j                  |      }t        j                  |||       y )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K(2.%)))//2;;AtQG	
 '||D!))#U); **40
dE<LMr.   c                 N   t        ddd      }t        j                  j                  d      j	                  d      }t        ||t        d            }t        ||g d	   t        d            }d
}t        j                  t        |      5  |j                  |j                  d       d d d        t        j                  t        |      5  |j                  |j                  d       d d d        t        j                  t        |      5  |j                  |j                  d       d d d        t        j                  t        |      5  |j                  |j                  d       d d d        y # 1 sw Y   xY w# 1 sw Y   xY w# 1 sw Y   cxY w# 1 sw Y   y xY w)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:yy$$Q'77?t2tCy94r*<'=tCyQ@]]:S1 	3NN288EN2	3]]:S1 	5NN288GN4	5]]:S1 	5NN288GN4	5]]:S1 	7NN288IN6	7 	7	3 	3	5 	5	5 	5	7 	7s0   E7FFF7F FFF$c           
         t        ddgt        j                  ddgt        j                  dd            d      }|j	                  ddg      }t        dt
        j                  gt        j                  dt
        j                  gt        j                  dd            dddg	      }t        j                  ||       y )
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&rxxAbnnWa6PQR
 QF#266]XXsBFFm2>>)S3QR a&
 	fh/r.   c                    t        t        j                  dt        j                        t	        dd            }|j                  |j                        }|j                  D ]  }||   j                         D ]k  \  }}||j                  v rAt        j                  |      rt        j                  ||   |         rEJ |||   |   k(  rSJ t        j                  |      rkJ   |j                         D ]/  \  }}t        j                  |j                  |j                         1 |j                  t        g             }t        |j                        dk(  sJ |j                  |j                  d d d         }	|	j                  D ]  }|	|   j                         D ]k  \  }}||j                  v rAt        j                  |      rt        j                  ||   |         rEJ |||   |   k(  rSJ t        j                  |      rkJ   |	j                         D ]/  \  }}t        j                  |j                  |	j                         1 |j                  |j                        }|j                  j                  |j                        sJ |j                  g       }|j                  sJ t        |j                        t        |j                        k(  sJ |j                  g       }|j                  |j                        }t        |j                        t        |j                        k(  sJ t        |j                        t        |j                        k(  sJ |j                  t!        |j                              }|j                  j#                  d       }
t        j                  |j                  |
       |j                         }t        j$                  ||       ||usJ y )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~    IIb

+:lTV3W
 &&'<'<=## 	)C$SM//1 )S++++xx}!xxC(8(=>>>"k#&6s&;;;;88C=(=)	) $>>+ 	@KC!!&,,?	@ ((r3
:##$))) %,,_-B-B3Q3-GH!)) 	)C*3/557 )S++++xx}!xxC(8(=>>>"k#&6s&;;;;88C=(=)	) *//1 	FKC!!&,,0D0DE	F &&{'8'89~~!!+"3"3444 &&r*~~~8##$K,?,?(@@@@ &&r*##K$5$568>>"c+*;*;&<<<<8##$K,?,?(@@@@ &&tO,A,A'BC"((33D9
hnnh7 $$&
fk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                  |          |j                  j                  d      |_        t        j                  |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
  j                  d      |d<   |j                  g d      j                         }|j                  g d      }t        j                  ||       y )Nr1   r   rV   r>   r   rU   r   r2   r   r   r1  )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)rR  rP  r   )rR  rP  r   rQ  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  sk   VaVaWq"g.bffa#EN
 1bffaBFF35J1
bjjmRWWQZ888??8,
bjjmRWWQZ%P sBFFC0%rvv|RVVD&
 ^^BGG,6
~~l3bj@GGJ7||67CCE

#G
H
dE*r.   c                 ^   t        t        j                  j                  d      j                  d            }t	        |t        j
                  t        |                  }t        t        j
                  d      d      }|j                  |      }|j                  j                  dk(  sJ |j                  t        t        j
                  d      d            }|j                  j                  dk(  sJ t        t        j                  j                  d      j                  d            }t	        |j                  t        j
                  t        |                  }t        t        j
                  d      d      }|j                  |      }|j                  j                  dk(  sJ y )Nr   r0   r   inamenametmpnamerJ   )r   r    r!   r"   r   rA  r   r'   r&   rZ  r   Tr7   )r(   rx   r)   r
  s       r,   test_reindex_name_remainsz4TestDataFrameSelectReindex.test_reindex_name_remains  s$   299((+22267q		#a& 12299R=w/ZZ]xx}}'''ZZbiim)<=xx}}	)))299((+22267qss"))CF"34299R=w/ZZZ"zz')))r.   c                 p   |j                  |j                  d d d         }|d   j                  t        j                  k(  sJ |j                  |j                        }|d   j                  t        j
                  k(  sJ |j                  ddg      }|d   j                  t        j                  k(  sJ y )Nr   r=   r?   rJ   )r'   r&   rf   r    rN   rO   )r(   	int_framesmallerbiggers       r,   test_reindex_intz+TestDataFrameSelectReindex.test_reindex_int  s    ##IOOCaC$89s|!!RXX---1c{  BJJ...##S#J#7s|!!RXX---r.   c                     |j                  g d      }t        j                  |d   |d          t        j                  |d         j                         sJ d|vsJ |j                  g       }|j                  sJ y )Nr=   r?   r   rJ   r?   r   r   )r'   r$   assert_series_equalr    rC  r   rE  )r(   rG  	new_frames      r,   test_reindex_columnsz/TestDataFrameSelectReindex.test_reindex_columns  s|    '''@	
y~{3/?@xx	#'++---)###  '''3	r.   c           
      D   t        g dg dg dgg dg dt              }|j                  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                  ||       |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                  ||       |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                  ||       y )N)rU   r  r  )      r2   )       !   )r1   r   rW   )r   r&   r7   rf   r   rJ   rU   r  r  ri  rj  r2   rk  rl  rm  r   )r7   r   r   )r   floatr'   r@   r    re   r$   rP   r=  s       r,   test_reindex_columns_methodz6TestDataFrameSelectReindex.test_reindex_columns_method  s   l;	
 E!H-RRVV4RRVV4RRVV4
 !H	
 	fh/ E!HW=RR,RR,RR,
 !H	
 	fh/ E!HW=RRRVV,RRRVV,RRRVV,
 !H	
 	fh/r.   c           
      <   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        ddg}|j                        j                  j                  }|j                  ||      j                  j                  }|j                  |      j                  |      j                  j                  }||k(  sJ ||k(  sJ y # 1 sw Y   xY w)NrV   rV   i  r1   r   rV   rG   r1  z:'d' is deprecated and will be removed in a future version.r2  
2012-01-01z
2012-01-03rK   )r   r5   rH   r   rJ   )r   r    onesr   r$   assert_produces_warningr	   r   r'   r&   r   )r(   r)   r8  	time_freq	some_cols
index_freq	both_freqseq_freqs           r,   test_reindex_axesz,TestDataFrameSelectReindex.test_reindex_axes  s   GGFOD!Q'$1)=xaQR?ST#
 K''cB 	I"<CHI	I#J	ZZiZ066;;
JJY	JBHHMM	::I:.66y6IOOTTY&&&X%%%	I 	Is   %DDc                 <   t        t        j                  j                  d      j	                  d            }|j                  t        t        d                  }t        j                  |j                  dd        j                         sJ |j                  t        d      d      }|j                  t        d            j                  d      }t        j                  ||       |j                  t        d      d	      }|j                         }d|d
<   t        j                  ||       |j                  t        d      d	      }|j                         }d|d
<   t        j                  ||       |j                  t        d      d	      }|j                         }d|d
<   t        j                  ||       d|d<   |j                  t        d      d      }|j                  t        d            j                  d      }t        j                  ||       y )Nr   )r0   rW   r   r   r   )rz   r>   r;  r7   rz   rW   foo0)r   r    r!   r"   r8   r'   r   r@   rC  r   r   fillnar$   rP   copyr=  s       r,   test_reindex_fill_valuez2TestDataFrameSelectReindex.test_reindex_fill_value  s   ryy,,Q/??HI DrO,xxbc*+//111E"I!4::eBi(//2
fh/ E!H=779
fh/E!H;779
fh/E!H?779
fh/ 5	E"I#6::eBi(//4
fh/r.   c                     t        ddgddgd|      }|j                  t        d      g dd      }t        g d	g d	ddd
|      }t        j                  ||       y )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&19UVDLQST ~BRH.
 	fh/r.   c                     t        dddgi|      }|j                  t        d      g dd      }t        t        g d	|      dd
      }t	        j
                  ||       y )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DJiBO+?@rJ
 	fh/r.   c                     t        ddgi      }|j                  g dd      }t        dgdgdgd      }t        j                  ||       y )Nr5   r   rG   missingr|  r   r'   r$   rP   r=  s       r,   #test_reindex_with_string_fill_valuez>TestDataFrameSelectReindex.test_reindex_with_string_fill_value6  sK    aSz"O	JA3i[	{KL
fh/r.   c           
         t         j                  j                  d      j                  d      }t	        |g d      }|j                         }t        t        t        |                  |_	        t	        |t        t        t        |                        }t        j                  ||       d}t        j                  t        |      5  |j                  t        t        t        |                         d d d        y # 1 sw Y   y xY w)Nr   r0   )
r1   r   rV   rW   r>   r1   r   rV   rW   r>   r   /cannot reindex on an axis with duplicate labelsr2  )r    r!   r"   r8   r   r  r   r@   r   r&   r$   rP   rp   r4  r5  r'   )r(   r   r)   r:   rR   r8  s         r,   test_reindex_dupsz,TestDataFrameSelectReindex.test_reindex_dups=  s    ii##A&66r:s"@A E#b'N+SU3r7^(<=
fh/ @]]:S1 	3JJT%B.1J2	3 	3 	3s   .DDc                 F   t        g dg dg dgg d      }d}t        j                  t        |      5  |j	                  dg       d d d        t        j                  t        |      5  |j	                  ddg       d d d        y # 1 sw Y   BxY w# 1 sw Y   y xY w)N)r1   r>   g      @)barr5   r5   rJ   r  r2  r  r}  )r   rp   r4  r5  r'   r(   r)   r8  s      r,   #test_reindex_with_duplicate_columnsz>TestDataFrameSelectReindex.test_reindex_with_duplicate_columnsM  s    +{3=N
 @]]:S1 	(JJwJ'	(]]:S1 	/JJu~J.	/ 	/	( 	(	/ 	/s   B-BBB c                    t        g dg dd      }t        ddt        j                  gddt        j                  gdg d	      }|j                  g d      }t	        j
                  ||       |j                  g dd
      }t	        j
                  ||       |j                  g dd      }t	        j
                  ||       y )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_styleX  s    YY78a.1bff~6i
 I&
fh/IA.
fh/IG4
fh/r.   c                     t        g dg dd      }d}t        j                  t        |      5  |j	                  ddgg d       d d d        y # 1 sw Y   y xY w)	Nr  r  r   zCreindex\(\) takes from 1 to 2 positional arguments but 3 were givenr2  r   r1   r   r   rp   r4  	TypeErrorr'   r  s      r,   test_reindex_positional_raisesz9TestDataFrameSelectReindex.test_reindex_positional_raisesg  sM     YY78T]]9C0 	0JJ1v/	0 	0 	0s   AAc                    t        g dg dd      }t        j                  t        d      5  |j	                  ddgdgd	       d d d        t        j                  t        d      5  |j	                  ddgdgd
	       d d d        t        j                  t        d      5  |j	                  ddgd
       d d d        t        j                  t        d      5  |j	                  ddgd       d d d        t        j                  t        d      5  |j	                  ddgd	       d d d        t        j                  t        d      5  |j	                  ddgddgd       d d d        t        j                  t        d      5  |j	                  ddgdgdg       d d d        t        j                  t        d      5  |j	                  ddgd
       d d d        t        j                  t        d      5  |j	                  ddgd       d d d        t        j                  t        d      5  |j	                  ddgddg       d d d        y # 1 sw Y   xY w# 1 sw Y   xY w# 1 sw Y   xY w# 1 sw Y   xY w# 1 sw Y   dxY w# 1 sw Y   5xY w# 1 sw Y   xY w# 1 sw Y   xY w# 1 sw Y   xY w# 1 sw Y   y xY w)Nr  r  r   zCannot specify both 'axis'r2  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_raiseso  sx   YY78]]9,HI 	6JJ1vu1J5	6 ]]9,HI 	<JJ1vu7J;	< ]]9,HI 	3JJaV'J2	3 ]]9,HI 	5JJaV)J4	5 ]]9,HI 	7JJ1vIJ6	7 ]]9,HI 	EJJaVaV)JD	E ]]9,@A 	@JJq!fQC#J?	@ ]]9,HI 	3JJaV'J2	3 ]]9,HI 	5JJaV)J4	5 ]]9,=> 	.JJ1vq!fJ-	. 	.;	6 	6	< 	<	3 	3	5 	5	7 	7	E 	E	@ 	@	3 	3	5 	5	. 	.sw   I)I'$I4JJJJ(J5 K9KI$'I14I>JJJ%(J25J>K
Kc                     t        g dg dd      }|j                  ddgdg      }t        dddgi      }t        j                  ||       y )Nr  r   r   r1   r=   rJ   r   r  r=  s       r,   !test_reindex_single_named_indexerz<TestDataFrameSelectReindex.test_reindex_single_named_indexer  sK    YY78QFSE2cAq6]+
fh/r.   c                    t        g dg dg dgg dg d      }|j                  ddg      }|j                  ddg	      }|j                  ddg
      }|j                  ddgd      }|j                  ddgd      }||||fD ]  }t        j                  ||        |j                  ddg      }|j                  ddgd      }|j                  ddgd      }||fD ]  }t        j                  ||        |j                  ddgddg      }|j                  ddgddg      }|j                  ddgd      j                  ddgd      }||fD ]  }t        j                  ||        y )Nr  )rV   rW   r>   )r>   r   r   rG   )rK   er   r1  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    	9-!#
 zz3*%zzc
z+zz#sz,zz#s!z4zz3*1z-$d+ 	-C!!$,	- zz3*z-zz3*1z-zz#s!z4$< 	-C!!$,	- zzc
S#Jz?zz3*S#Jz?zz#s!z4<<S#JUV<W$< 	-C!!$,	-r.   c                    t        t        j                  dt              t        j                  ddd      ddg      }|j                  t        j                  d            }|j                  j                  t        j                  k(  sJ t        |d   d         sJ |j                  t        d	      
      }|j                  j                  t        j                  k(  sJ t        |d         j                         sJ y )N)r0   r   r   r   r   r   r1  r0   r1   rV   rJ   )r   r    rs  boolrA  r'   r   rf   object_r   r@   r   )r(   framer   s      r,   test_reindex_booleanz/TestDataFrameSelectReindex.test_reindex_boolean  s    GGG4(		!R0CaQRV
 MM"))B-0	%%333IaLO$$$MM%(M3	%%333IaL!%%'''r.   c                 l    |j                  g d      }d|v sJ |j                  ddg      }d|vsJ y )N)r}  r=   r?   rJ   r}  r=   r?   )r'   )r(   float_string_framer   s      r,   test_reindex_objectsz/TestDataFrameSelectReindex.test_reindex_objects  sI    &..7H.I		!!!&..Sz.B	I%%%r.   c                 (   t        g d      }t        i       j                  g d      }|j                  |      }t        j                  |j
                  |       |j                  g d      }|d   j                  t        j                  k(  sJ y )NrG   r  r   rJ   rd  r   )	r   r   r'   r$   r%   r7   rf   r    rO   )r(   r_  r&   dmr   r`  s         r,   test_reindex_cornerz.TestDataFrameSelectReindex.test_reindex_corner  sz    o&r]"""3JJuJ-	
i//7 ##O#<s|!!RZZ///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      }|j                  g d      }|j                  g d   }t        j                  ||       |j                  dg      }|j                  dg   }t        j                  ||       |j                  dg      }|j                  dg   }t        j                  ||       y )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   r=  s       r,   test_reindex_with_nansz1TestDataFrameSelectReindex.test_reindex_with_nans  s    VaVbffbff-1v2w?#J%6
 "78779%
fh/5'*77A3<
fh/5'*77A3<
fh/r.   c                    t        t        j                  dt        j                              }|j	                  t        j
                  dd            }|j                  j                  t        j                        j                         sJ y )N)r0   r0   r   r>   r   rJ   )	r   r    zerosfloat32r'   rA  r   eqr   )r(   r)   r:   s      r,   test_reindex_without_upcastingz9TestDataFrameSelectReindex.test_reindex_without_upcasting  s[    rxx

;<BIIa$45}}

+//111r.   c                 .   t        t        j                  j                  d      j	                  d            }|j                  t        d      t        d            }|j                  t        t        d                  j                  t        d            }t        j                  ||       t        t        j                  j                  d      j                  ddd            }|j                  t        d      t        d            }|j                  t        t        d                  j                  t        d            }t        j                  ||       t        t        j                  j                  d      j                  ddd            }|j                  t        d      t        d            }|j                  t        d            j                  t        d            }t        j                  ||       t        t        j                  j                  d      j	                  d      d	z   g d
      }|j                  ddgddg      }|j                  ddg      j                  ddg      }t        j                  ||       y )Nr   rq  rW   r1  rJ   r   r0   )r>   rV   y              ?rG   r1   r5   rH   )r   r    r!   r"   r8   r'   r@   r   r$   rP   r  r=  s       r,   test_reindex_multiz-TestDataFrameSelectReindex.test_reindex_multi  s   ryy,,Q/??GH%(E!H=::d58n-55eAh5G
fh/ryy,,Q/88BGH%(E!H=::d58n-55eAh5G
fh/ryy,,Q/88BGH%(E!H=::eAh'//a/A
fh/II!!!$44V<rA#

 1a&3*=::q!f%--sCj-A
fh/r.   c                 p   t        j                  t        g d      t        t        ddd            g      }t	        dt        t        |            i|      }|j                  g d   }|j                  |      }t	        dd	d
dddddt        j                  dg	i|      }t        j                  ||       y )NrG   rr  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    &&O,J|QSIJ
 U3t9-.d;gg./T"cAq!Q1a#CDDQ
fh/r.   c                 x   t        dt        j                  dd      it        t	        d      t        t	        d            d      	      }|j                  g d
      }t        ddt        j                  gt        t	        d            d      j                  d      }t        j                  ||d       |j                  ddg      }t        ddgt        t	        d            d      j                  d      }t        j                  ||d       |j                  dg      }t        t        j                  gt        dg      d      j                  d      }t        j                  ||d       |j                  dg      }t        t        j                  gt        dg      d      j                  d      }t        j                  ||d       t	        d      }|j                  t        ddg|            }t        dt        j                  gt        t	        d            j                  t        |            d      j                  d      }t        j                  ||d       |j                  t        dg|            }t        dgt        t	        d            j                  t        |            d      j                  d      }t        j                  ||d       |j                  g d
      }t        ddt        j                  gt        t	        d            d      j                  d      }t        j                  ||d       |j                  ddg      }t        ddgt        t	        d            d      j                  d      }t        j                  ||d       |j                  dg      }t        t        j                  gt        dg      d      j                  d      }t        j                  ||d       |j                  t        ddg|d            }t        dt        j                  gt        t	        d            j                  t        |d            d      j                  d      }t        j                  ||d       |j                  t        ddgddg            }t        dt        j                  gt        t	        d            j                  t        ddg            d      j                  d      }t        j                  ||d       t        dt        j                  dd      it        t	        d      t        t	        d            d      	      }d}t        j                  t         |      5  |j                  ddg       d d d        d}t        j                  t"        |j%                  d             5  |j                  dgd!"       d d d        t        j                  t"        |j%                  d#            5  |j                  dgd$       d d d        t        j                  t"        |j%                  d%            5  |j                  dgd&'       d d d        y # 1 sw Y   xY w# 1 sw Y   xY w# 1 sw Y   ixY w# 1 sw Y   y xY w)(Nr=   rV   rN   r   r(  caber?   )rf   rZ  r   )r5   rH   r  r   r1   aber   Tr  r5   rH   r  r  rK   
categoriesae)r  ordered)r  adr   aabbcar  r2  z<argument {} is not implemented for CategoricalIndex\.reindexr   r   r   r  r  r   r   )r   )r   r    rA  r   r   r   r'   re   r   r#   r$   rP   r
   rM   rp   r4  r5  NotImplementedErrorformat)r(   r)   r:   rR   catsrS   r8  s          r,   "test_reindex_with_categoricalindexz=TestDataFrameSelectReindex.test_reindex_with_categoricalindex  sf   RYYq0 #U#3DL#A	
 O,Aq"&&>tE{8KLMWW
 	fhFS#J'Aq6tDz0BCDNNsS
fhFSE"BFF8&#-@AKKCP
fhFSE"BFF8&#-@AKKCP
fhF F|Kc
tDEbff+F4:$6$=$=>Nt>T$UV

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

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

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

 )C. 	 	fhFRYYq0 #X&6tF|&D3	
 @]]:S1 	$KKc
#	$ N]].cjj6JK 	.JJuWJ-	.]].cjj6IJ 	'JJuAJ&	']].cjj6IJ 	'JJuAJ&	' 	'	$ 	$
	. 	.	' 	'	' 	's0   Z Z'Z$.Z0ZZ!$Z-0Z9c                     t        j                  t        j                        }t	        |j
                        }|h dk(  sJ y )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_signature  s=    	 1 12(
 
 
 	
 
r.   c                    t        j                  ddg      }t        ddgddgg|ddg	      }t        j                  g d
      }|j                  |dd      }t        ddgddgddgg|ddg	      }t	        j
                  ||       y )Nr  rK   r  r   r   rV   rW   r   yr1  )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$$%IJCa8q!fq!fq!f5S3PS*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                  ||       y )
N202030srV   )startr   r   timerY  r5   r1  )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  sk     vE1=rr!7#GC*6*cBFF8a<06J
fh/r.   src_idxcat_idxc                     t         |g       dgd      }|j                  |      }t        dg|d      }t        j                  ||       y )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  sH     wr{3%tDG,C5'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                         }|j                  j                  t        dg            }|j                  j                  t        dg            }|j!                  |||      }	t#        g |d	   j%                         |g |d   j%                         |t        j&                  dgdz  |j(                        d|
      }
|	j*                  d	dg   t,        k(  j/                         sJ |	j0                  d   t        j                  u sJ |	j0                  d   |u sJ |	j0                  d   |u sJ t3        j4                  |	|
       y )NABCDEr   r   r0   r@  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    $$d7mU1X%>?r2^^E4(HA,Cud+BS#66CaC[[]qc
+**##E5'N3jjug"jE(RU\\^(R((RU\\^(R(xx!288<
 
 

Aq6"f,11333xx~'''xx"$$$xx"$$$
c8,r.   klassr   c                     t        t        g dg            } ||g      }|j                  |      }t        |      }t        j                  ||       y )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  sM     -bcUCDTFm#&3'
fh/r.   c                     t        ddt        j                  dgi      }d}t        j                  t
        |      5  |j                  g dd       d d d        y # 1 sw Y   y xY w)	Nr=   r1   r   zInvalid fill methodr2  )r1   r   r   asfreqr   )r   r    re   rp   r4  r5  r'   r  s      r,   test_invalid_methodz.TestDataFrameSelectReindex.test_invalid_method  sS    a^,-#]]:S1 	3JJyJ2	3 	3 	3s   AA$c                 6   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      }|j	                  |
      }t        g dg ddt        j                  ddgddggddg            }t        j                  ||       y )Nr1   r   r=   r?   )valuerP  r0   r   r5   rY  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Rs+
 (("XSz"*

 &)'2FG))B8c3Z*@c
S
 	fh/r.   c                 J   t        dddgit        ddgd            }t        j                  ddgd	d
ggddg      }|j	                  |      }t        dt
        j                  gdz  it        j                  ddgd	d
ggddg            }t        j                  ||       y )Nr  r1   r   r0   r   different_namerY  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(r2hEU0VW((2r(S#J)?SzR&)BFF8a<())B8c3Z*@c
S
 	fh/r.   )Crm   rn   ro   rp   rq   xfailr   r   r   r   r   r   rr   r    re   r   r   r   r   r   r   r   r  r  r%  r   r/  r9  r>  rN  rV  r]  rb  rg  ro  rz  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@V [[ %RVVQ1%&&	
008
000# [[
<	 7S#sBFF,C"DE	*		*0  [[d#!4(UDMd#d#3Z3Z3Zd#3Ze$	
"N#"N& [[	
( +)( +D [[ &V
 &V U^LMU^RS	
++: [[(']7>&\3T:%[,d3%[/40%[/40']7>&\9d+$ZU#		
NN7 0=)~+:*"	.	10f&&0B0003 	/00!.F0-:(&00&20@0c'J
"0 [[9Q+?@!	!0DEy!t		
00 [[Y0@(AB[[ "IR 3*c3Z(3*c3Z(		
0 C0 [[Wx&:; - < -D [[Wu.>&?@[[Vc3Z00 1 A03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     sX       A / ( 	 	 	  -^
 ^
BN0 N0r.   