o
    _~#gN                     @  s   d dl mZ d dlmZ d dlZd dlZd dlZd dlmZ d dl	Z
d dl	mZmZmZmZmZ d dlmZ ejddd	ZejdddZG dd dZG dd dZdS )    )annotations)datetimeN)using_pyarrow_string_dtype)	DataFrameIndexSeries	Timestamp
date_rangereturndict[str, list[int | str]]c                   C  s   t tdt ddS )N   ab..ab)listrange r   r   /var/www/static.ux5.de/https/Moving-Object-Detection-with-OpenCV/env/lib/python3.10/site-packages/pandas/tests/frame/methods/test_replace.pymix_ab   s   r   dict[str, list[float | str]]c                   C  s"   t tdt dddtjdgdS )Nr   r   r   r   dr   r   c)r   r   npnanr   r   r   r   mix_abc   s   "r   c                   @  s
  e Zd Zejje dddd Zejdddge	j
dgd	d
e	j
e	j
gdgd dg g ddfddgddgg dg dg ddfddgddgg dg dg ddfgejdddgejdddgdd Zdd Zd d! Zd"d# Zd$d% Zd&d' Zejje ddd(d) Zejje ddd*d+ Zejje ddd,d- Zejje ddd.d/ Zd0d1 Zd2d3 Zejd4e	j
d5d6d5e	j
d7gd8d9 Zejd:g d;d<d= Zejd>d?d@gdAdBdCdDdEgfg dFdGejidBejejgfgdHdI ZdJdK ZdLdM ZdNdO ZdPdQ Zejje dddRdS Z ejje dddTdU Z!dVdW Z"dXdY Z#dZd[ Z$d\d] Z%d^d_ Z&ejd`g dadbdc Z'ddde Z(dfdg Z)dhdi Z*djdk Z+dldm Z,dndo Z-dpdq Z.ejdre/dsg dtidudve/dsg dwife/dsg dtie	j0dxdudve/dsg dwie	j0dxfe/dsg dtie	j1dxdudve/dsg dwie	j1dxfe/dyg dzidde/dyg d{ife/d|g d}id~dve/d|g dife/de2e3ddde3ddde3dddgie3ddde3ddde/de2e3dddgd ife/e3dddgdgddde/e3dddgdgdfe/de3dddugie3dddue3dddue/de3dddugife/e4dddddve	j
dgde5ddde5ddde/e6e5ddde5ddde5dddg7ddve	j
dgdfe/dudgddggdde/ddgddggfe/dudgddggdude/ddgddggfe/dudgddggdde/ddgddggfe/dudgddggdude/ddgddggfgdd Z8dd Z9ejje dddd Z:dd Z;ejje dddd Z<ejje dddd Z=dd Z>dd Z?dd Z@dd ZAdd ZBdd ZCdd ZDdd ZEdd ZFdd ZGejje dddd ZHejje dddd ZIejje dddd ZJddÄ ZKddń ZLejddvdg dȢde	j
dgg ddɜfe	j
dg dʢg dˢg ddɜfdBdg dʢde	j
dgg ddɜfdvdgdg dȢde	j
dgg ddɜfdudgdg d΢de	j
dgg ddɜfddg dТde	j
dgg ddɜfd
dAgdg dʢde	j
dgg dѢdɜfgddӄ ZMejddududCddgddggfduddCddugddggfgddք ZNejdg dtg dآdٜdddd؜g dtg dۢdٜfg dtg dܢdٜddddܜg dtg ddٜfgdd ZOejje ddejde5de	Pdue	1due	Qdue	Rdugdd ZSdd ZTdd ZUejd`g dejde	j
ejgdd ZVejde	j
dgdd ZWejdeXdeYdvdgdd ZZdd Z[dd Z\dd Z]dd Z^dd Z_dd  Z`ejddugdgdvgdvgfdugdugdvgdvgfdgdgdvgdgfdgdugdvgdgfgejdeaebe	jcgdd Zdejdde	j
dgdd Zed	d
 ZfdS (  TestDataFrameReplacecan't set float into stringreasonc                 C  s  t j|j|jd d df< t j|j|jdd  df< | }|jt jddd}|d u s-J t||d |}t j|j	dd|j
df< t j|j	d	d |j
df< |t jd}|jdd
}t|| | }|jt jgdgdd}|d u s|J t||d d S )N   Ar   Tinplace   foovalue)r   r   locindexcopyreplacetmassert_frame_equalfillnailoccolumnsget_loc)selfdatetime_framefloat_string_frametsframereturn_valuemfresultexpectedr   r   r   test_replace_inplace!   s    z)TestDataFrameReplace.test_replace_inplacezto_replace,values,expected\s*\.\s*ze|f|gcrapr   r      hrA   r?   lor   
\s*(\.)\s*z(e|f|g)\1\1\1_crapr   r   ..rI   )e_crapf_crapg_craprA   )rA   rJ   rC   rD   er?   fgrA   r%   TFuse_value_regex_argsc                 C  sp   t tdtdtdd}|r|j|||d}n	|j||d|d}|r,|d u s*J |}t |}t|| d S )Nr   efghhelor   )r*   regexr%   TrT   r%   )r   r   r.   r/   r0   )r5   
to_replacevaluesr<   r%   rQ   dfr;   r   r   r   test_regex_replace_list_obj;   s   *z0TestDataFrameReplace.test_regex_replace_list_objc           	      C  sF  t |}ddg}tjdg}ttdtdtdd}t |}|j||dd	}t |d dd
tjtjgg dd}t|| ddg}ddg}|j||dd	}t |d g dd}t|| g d}g d}|j||dd	}t |d g dd}t|| g d}g d}|j||d}t |d g dd}t|| d S )Nr>   r   r?   r   r   halor   TrT   r   rB   rE   (a|b)rF   rG   a_crapb_craprI   rI   r   rE   r   z(b)rF   r?   rG   r?   r_   rI   rI   rT   r*   )r   r   r   r   r   r.   r/   r0   )	r5   r   dfmixto_replace_resrW   mix2dfmix2resexpecr   r   r   test_regex_replace_list_mixeds   s8   
z2TestDataFrameReplace.test_regex_replace_list_mixedc                 C  st  t |}ddg}tjdg}| }|j||ddd}|d u s J t |d ddtjtjgd}t|| dd	g}d
dg}| }|j||ddd}|d u sPJ t |d g dd}t|| g d}g d}| }|j||ddd}|d u s|J t |d g dd}t|| g d}g d}| }|j||dd}|d u sJ t |d g dd}t|| d S )Nr>   r   r?   Tr%   rT   r   r   rE   r\   rF   rG   r]   r`   ra   rb   rT   r*   r%   )r   r   r   r-   r.   r/   r0   )r5   r   rd   re   rW   rh   r9   ri   r   r   r   %test_regex_replace_list_mixed_inplace   s:   
z:TestDataFrameReplace.test_regex_replace_list_mixed_inplacec                 C  sz  t |}|jddidtjidd}| }|jddidtjiddd}|d u s)J t |d ddtjtjg|d d}t|| t|| |jdd	idd
idd}| }|jdd	idd
iddd}|d u sjJ t |d g d|d d}t|| t|| |jdd	idd
id}| }|jdd	idd
idd}|d u sJ t |d g d|d d}t|| t|| t |d tjdddg|d d}|jddtjidd}| }|jddtjiddd}|d u sJ t|| t|| |jddtjidd}| }|jddtjidd}|d u sJ t |d tjdddg|d d}t|| t|| d S )Nr   r>   Tr[   rk   r   r   r   rE   z\1ty)r   r   .tyrn   rc   rl   .rU   r   r.   r   r   r-   r/   r0   )r5   r   rd   rh   res2r9   ri   r   r   r   test_regex_replace_dict_mixed   sh   z2TestDataFrameReplace.test_regex_replace_dict_mixedc           	      C  s   t |}|jddtjiidd}| }| }|jddtjiiddd}|d u s+J |jddtjiid}|jddtjiidd}|d u sHJ t |d ddtjtjg|d d	}t|| t|| t|| t|| d S )
Nr   r>   Tr[   rk   rU   r   r   r   rp   )	r5   r   rd   rh   rq   res4r9   res3ri   r   r   r   test_regex_replace_dict_nested	  s$   z3TestDataFrameReplace.test_regex_replace_dict_nestedc                 C  s   |}t dg di|d}|r;|dkr;tjtdd |jddid	d
}W d    n1 s-w   Y  t dg di}n|jddid	d
}t dg di|d}t|| d S )Nfirst)abcbcacabdtypeobjectDowncastingmatchr   ro   Tr[   )z.bczbc.zc.br   r/   assert_produces_warningFutureWarningr.   r0   )r5   any_string_dtypeusing_infer_stringr{   rX   r;   r<   r   r   r   2test_regex_replace_dict_nested_non_first_character  s   zGTestDataFrameReplace.test_regex_replace_dict_nested_non_first_characterc                 C  sz   t g ddd}t g ddd}d}tjt|d |ddd	d
i}W d    n1 s0w   Y  t|| d S )N)QTr   r   r      )Typetmp)r      r   r   r   !Downcasting behavior in `replace`r~   r   r   r   )r   r   r   r5   rX   r<   msgr;   r   r   r   %test_regex_replace_dict_nested_gh4115.  s   z:TestDataFrameReplace.test_regex_replace_dict_nested_gh4115c           	      C  sZ  t |}t |d ttjgd tjtjtjdgd}d}tjt|d |jddgtjd	d
}W d    n1 s;w   Y  | }| }tjt|d |jddgtjd	d	d}W d    n1 sfw   Y  |d u sqJ tjt|d |jddgtjd	d}W d    n1 sw   Y  |d u sJ t	|| t	|| t	|| d S )Nr   r   r   r   r   r~   r>   za|bTr[   rU   rl   )
r   r   arrayr   r/   r   r   r.   r-   r0   )	r5   r   rX   ri   r   rh   rq   rt   r9   r   r   r   !test_regex_replace_list_to_scalar9  s8   z6TestDataFrameReplace.test_regex_replace_list_to_scalarc                 C  s   t |}|jdddd}| }|jddddd}|d u sJ | }|jdddd}|d u s1J t |d g d|d	 d
}t|| t|| t|| d S )Nr>   r   Tr[   rk   rl   r   )r   r   r   r   r   r   )r   r.   r-   r/   r0   r5   r   rX   rh   rq   r9   rt   ri   r   r   r   !test_regex_replace_str_to_numericX  s   z6TestDataFrameReplace.test_regex_replace_str_to_numericc                 C  s   t |}|jddgddd}| }|jddgdddd}|d u s#J | }|jddgddd}|d u s7J t |d g d	ddtjd
gd}t|| t|| t|| d S )Nr>   r   r   Tr[   rU   rl   r   )r   r   r   r   r   r   )r   r.   r-   r   r   r/   r0   r   r   r   r   (test_regex_replace_regex_list_to_numericj  s   z=TestDataFrameReplace.test_regex_replace_regex_list_to_numericc           
      C  s   t |}tddi}tdtji}|j||dd}| }|j||ddd}|d u s,J | }|j||dd}|d u s>J t |d ddtjtjg|d d	}	t||	 t||	 t||	 d S )
Nr   r>   Tr[   rk   rl   r   r   r   )r   r   r   r   r.   r-   r/   r0   )
r5   r   rX   s1s2rh   rq   r9   rt   ri   r   r   r   $test_regex_replace_series_of_regexes}  s    z9TestDataFrameReplace.test_regex_replace_series_of_regexesc                 C  sR   t |}t g d|d |d d}|dd}t|| |jjtjks'J d S )N)r   r   r   r@   r   r   r   r   r   )r   r.   r/   r0   r   r{   r   object_)r5   r   rX   ri   rh   r   r   r   /test_regex_replace_numeric_to_object_conversion  s
   zDTestDataFrameReplace.test_regex_replace_numeric_to_object_conversionrV    )r   ,)r   r   c                 C  sX   t g dg dg dd}|j|d}t g ddtjdgg dd}t|| d S )	N)z1,000r   3)r   r   r   r   col1col2col3r[   )1000r   r   r   r   r   r.   r   r   r/   r0   )r5   rV   rX   r;   r<   r   r   r   +test_joint_simple_replace_and_regex_replace  s   
z@TestDataFrameReplace.test_joint_simple_replace_and_regex_replacemetachar)z[]z()z\dz\wz\sc                 C  sB   t d|dgi}|d|dii}t dddgi}t|| d S )Nr   elseparenr   r.   r/   r0   )r5   r   rX   r;   r<   r   r   r   test_replace_regex_metachar  s   z0TestDataFrameReplace.test_replace_regex_metacharzdata,to_replace,expectedxaxxbxr   r   r   xcxxdx)r   r   r   ^\s*$c                 C  s   |}|||d}	|rE|dkrEt |dkr$t|	tr$|jtjjdd tj	t
dd |	j|dd	}
d
}W d    n1 s?w   Y  n|	j|dd	}
|||d}t|
| d S )Nrz   r|   r   z=object input array that gets downcasted raises on second passr   r}   r~   Tr[   zstring[pyarrow_numpy])len
isinstancer   node
add_markerpytestmarkxfailr/   r   r   r.   assert_equal)r5   datarV   r<   frame_or_seriesr   r   requestr{   objr;   r   r   r   test_regex_replace_string_types  s"   z4TestDataFrameReplace.test_regex_replace_string_typesc                 C  s8  t j|j|jd d df< t j|j|jdd  df< |t jd}t||d t|dt j| t j|j|jd d df< t j|j|jdd  df< d|j|jd d df< tddgd}t||dd	 td
t	
dfdt	
dfg}|d
t j}tt jt	
dfdt	
dfg}t|| d S )Nr!   r"   r#       חBr   r   r,      -2015010120150102)r   r   r+   r,   r.   r/   r0   r1   r   pdto_datetime)r5   r6   zero_filledrX   df1expected_dfr   r   r   test_replace  s$   z!TestDataFrameReplace.test_replacec                 C  s   t dt dt dd}t|}ddg}tjdg}|||}tdd	tjtjgg d
g dd}t|| ddg}ddg}|||}tg dg dg dd}t|| d S )Nr   rR   rS   r   ro   rM   r?   r   r   rN   rB   rO   rI   rH   )rM   r?   rP   rA   )rA   rM   rC   rD   )r   r   r   r   r.   r/   r0   )r5   r   dfobjre   rW   rh   ri   r   r   r   test_replace_list  s,   
z&TestDataFrameReplace.test_replace_listc                 C  s   t ddgg tjdgg}td|i}t||}|}|g tj}t|| d}tj	t
|jddd |tjg i W d    n1 sGw   Y  tj	t
|jd	dd |tjd
dgi W d    d S 1 smw   Y  d S )Nr   r   r   colzwNumPy boolean array indexing assignment cannot assign {size} input values to the 1 output values where the mask is truer   )sizer~   r   dummyalt)r   r   r   r   r/   get_objr.   r   r   raises
ValueErrorformat)r5   r   serr   r<   r;   r   r   r   r   test_replace_with_empty_list  s   "z1TestDataFrameReplace.test_replace_with_empty_listc                 C  s   t ddddddd}|dddd}t ddddddd}t|| |d| }t|| t ddddddd}tddd}||ddd}t ddddddd}t|| ||| }t|| d S )	N        r   r          @r   )zeroone      ?      ?)r   r.   r/   r0   meanr   )r5   rX   r;   r<   sr   r   r   test_replace_series_dict%  s   z-TestDataFrameReplace.test_replace_series_dictc                 C  s   t g dg dg}dddd}d}tjt|d ||}W d    n1 s)w   Y  ttjgd }|j}t	|| d S )N)r'   barbah)r   r'   r   r   r   r@   "Downcasting behavior in `replace` r~   )
r   r/   r   r   r.   r   r   int64dtypesassert_series_equal)r5   rX   mr   repri   rh   r   r   r   test_replace_convert9  s   z)TestDataFrameReplace.test_replace_convertc                 C  s   |}t j|jdd|jdf< t j|jdd |jdf< |t jd}|jdd}t|| t|dt j| |t jd}|jdd}t|| t|dt j| d S )	Nr!   r&   r'   r(   r"   ir)   r   )	r   r   r2   r3   r4   r.   r1   r/   r0   )r5   r7   r:   r;   r<   r   r   r   test_replace_mixedG  s   z'TestDataFrameReplace.test_replace_mixedc                 C  s   t tddgddtddgddd}t tddgddtd	dgddd}|dd	}t|| |jdd	d
d}|d u s@J t|| d S )Nr   r   float64rz   r   r   r   r"   r   r   Tr$   r   r   r.   r/   r0   )r5   rX   r<   r;   r9   r   r   r   &test_replace_mixed_int_block_upcastingY  s   z;TestDataFrameReplace.test_replace_mixed_int_block_upcastingc                 C  s   t tddgddtddgddtddgddd	}t tddgddtd
dgddtddgddd	}|dd
}t|| d S )Nr   r   r   rz   r   r   r   r   r"   r   Cr   r   r5   rX   r<   r;   r   r   r   &test_replace_mixed_int_block_splittingn  s   z;TestDataFrameReplace.test_replace_mixed_int_block_splittingc                 C  s   t tddgddtddgddd}t tdd	gd
dtddgddd}|dd	}t|| t td	dgtdd	gd
dd}|rgtjtdd |ddgd	dg}W d    n1 saw   Y  n
|ddgd	dg}t|| d S )Nr   r   r   rz   r   r   r   r   r'   r|   r   r   r}   r~   )r   r   r.   r/   r0   r   r   )r5   r   rX   r<   r;   r   r   r   test_replace_mixed2  s0   
z(TestDataFrameReplace.test_replace_mixed2c                 C  s   t tddgddtddgddd}|d|  }| d}| }|jd |jd< |jd |jd	< t	|| d S )
Nr@   r   r   rz   r   r   r   r   r   )r   r   )
r   r   r.   r   to_dictr-   astyper2   r/   r0   )r5   rX   r;   r<   r   r   r   r   test_replace_mixed3  s    z(TestDataFrameReplace.test_replace_mixed3c                 C  sT   t dddtjgg dd}|d d|d< |dtj}t|d |d  d S )	Nr   r   r@   )somestringshereher   r   Int64r   )r   r   r   r   r.   r/   r   r5   rX   rh   r   r   r   1test_replace_nullable_int_with_string_doesnt_cast  s   zFTestDataFrameReplace.test_replace_nullable_int_with_string_doesnt_castr{   )booleanr   Float64c                 C  sP   t g d|d}tg d|d}|dd}tg d|d}t|| d S )N)r   r   r   rz   )r"   r   xr   r   X)r"   r   r   r   r   r.   r/   r0   )r5   r{   nullable_serrX   r;   r<   r   r   r   !test_replace_with_nullable_column  s
   z6TestDataFrameReplace.test_replace_with_nullable_columnc                 C  sb   t dtddi}t dg di}|ddddi}t|| |ddd}t|| d S )Nr   r   r!   r   r   r@   r   r   r   )r   r   r   r   r.   r/   r0   r   r   r   r   test_replace_simple_nested_dict  s   z4TestDataFrameReplace.test_replace_simple_nested_dictc                 C  sf   t dtddi}t dg di}|dddd}t|| |dddddi}t|| d S )	Nr   r   r!   r  r   r   r   )r   r   r  r   r   r   r   6test_replace_simple_nested_dict_with_nonexistent_value  s   zKTestDataFrameReplace.test_replace_simple_nested_dict_with_nonexistent_valuec                 C  sN   t ddd giddi}|tjd i}t ddd gitd}t|| d S )Nr*   *   r   rz   )r   r   r.   r   NAr|   r/   r0   r5   rX   r;   r<   r   r   r   test_replace_NA_with_None  s   z.TestDataFrameReplace.test_replace_NA_with_Nonec                 C  sB   t tjtjg}|tjd tjd i}t d d g}t|| d S N)r   r   NaTr.   r   r   r/   r0   r	  r   r   r   test_replace_NAT_with_None  s   z/TestDataFrameReplace.test_replace_NAT_with_Nonec                 C  sb   t g ddd}tt g ddd|d}|dd i}tt g dd	d|d}t|| d S )
N)r   r   r   r   categoryrz   )r!   r   r@   r   r   )idr   r@   )      @g      @Nr   r|   r   )r5   
cat_seriesrX   r;   r<   r   r   r   (test_replace_with_None_keeps_categorical  s   z=TestDataFrameReplace.test_replace_with_None_keeps_categoricalc                 C  s   |j d }|j d }tj|j d< d|j d< |jtjdid}|jjtjdidj}t|| |jtjdddid}| }d|j d< d|j d< |}t|| ||j d< ||j d< d S )Nr   r   r   r   r   rV   r   )r2   r   r   r.   r   r/   r0   r-   )r5   r6   
orig_valueorig2r;   r<   r8   r   r   r   test_replace_value_is_none  s   





z/TestDataFrameReplace.test_replace_value_is_nonec                 C  s   |  tj}tj|j|jd d df< tj|j|jdd  df< |tjd}t	||
d t	|dtj| tj|j|jd d df< tj|j|jdd  df< tj|j|jd d df< d}tjt|d |j
dd	}t	||j
dd	 W d    d S 1 sw   Y  d S )
Nr!   r"   r#   r   r   z,DataFrame.fillna with 'method' is deprecatedr~   bfill)method)r-   r   r   float32r   r+   r,   r.   r/   r0   r1   r   r   )r5   r6   r8   r   r   r;   r   r   r   test_replace_for_new_dtypes  s   "z0TestDataFrameReplace.test_replace_for_new_dtypesz"frame, to_replace, value, expectedintsr   r   r@   r   r   )r   r   r@   rz   boolsTFT)TTTcomplex)              ?               @              @r!  )y                r"  r#  
datetime64i  r!      r   i     r&   r'   )dtstrr   r'  h  
   i  20130101
US/Easternperiodstzr   r   20130102r/  2013010420130103nsr   r   r  c                 C  sj   d }t |tr|jdkrt}d}tj||d |||}W d    n1 s(w   Y  t|| d S )Nr)  r   r~   )r   r   yearr   r/   r   r.   r0   )r5   framerV   r*   r<   warnr   r;   r   r   r   test_replace_dtypes  s   lz(TestDataFrameReplace.test_replace_dtypesc           	        s  t jddd ddddtt jdt jgg dg dd}| } fdd	| D }t|t| |g dg d
}tt jdt jgg d
g dd}t|| ddddtt jdt jgg dg dd}|t j}fdd	| D }t|t| t jddg g d| }| }t	 D ]\}}|j||dd}|d u sJ qt|| d}t
jt|d | dd   W d    d S 1 sw   Y  d S )Nr   r   r   r  missingr   r   r!   r   asdffdc                   s&   i | ]\}}||  | | qS r   r.   .0kvto_reprW   r   r   
<dictcomp>  s   & zLTestDataFrameReplace.test_replace_input_formats_listlike.<locals>.<dictcomp>)r!   r   r   r!   c                   s$   i | ]\}}|| tj | qS r   )r.   r   r   r?  )rW   r   r   rE    s   $ )r  r9  Tr$   z:Replacement lists must match in length\. Expecting 3 got 2r~   r   )r   r   r   infr.   itemsr/   r0   r-   zipr   r   r   )	r5   rX   filledr<   r;   r   r*   r9   r   r   rC  r   #test_replace_input_formats_listlike  s@   "z8TestDataFrameReplace.test_replace_input_formats_listlikec                   s   t tjdtjgg dg dd}tjddd | d} fdd| D }t|t | d}tj	t
|d	 | tjddg W d    n1 sOw   Y  tjddg | d
}| } D ]}|j|d
dd}|d u svJ qft|| d S )Nr   r:  r;  r   r   c                   s"   i | ]\}}||  | d qS )r   r>  r?  rD  r   r   rE    s   " zJTestDataFrameReplace.test_replace_input_formats_scalar.<locals>.<dictcomp>z.value argument must be scalar, dict, or Seriesr~   r  Tr$   )r   r   r   rG  r.   rH  r/   r0   r   r   	TypeErrorr-   )r5   rX   rJ  r<   r   r;   r   r9   r   rL  r   !test_replace_input_formats_scalar  s$   z6TestDataFrameReplace.test_replace_input_formats_scalarc                 C  s   d S r  r   )r5   r   r   r   test_replace_limit  s   z'TestDataFrameReplace.test_replace_limitc                 C  s   t dddddd}ddd	d
dd}t d
dd	ddd}d}tjt|d ||}W d    n1 s5w   Y  t|| d S NStrongly AgreeAgreeNeutralDisagreeStrongly Disagree)r   r   r   r@   r   r   r   r@   r!   r   )rR  rT  rS  rQ  rU  r   r~   r   r/   r   r   r.   r   r5   answerweightsr<   r   r;   r   r   r   test_replace_dict_no_regex  s(   
z/TestDataFrameReplace.test_replace_dict_no_regexc                 C  s   t dddddd}t ddd	d
dd}t d
dd	ddd}d}tjt|d ||}W d    n1 s7w   Y  t|| d S rP  rV  rW  r   r   r   test_replace_series_no_regex  s,   		z1TestDataFrameReplace.test_replace_series_no_regexc                 C  s   t dtjdgi}|jtjdddid}|jdtjfddgd}|jdtjgddgd}t dddgi}t|| t|| t|| d S )Nr"   r   r   r   r  rV   r*   )r   r   r   r.   r/   r0   )r5   rX   res1rq   rt   r<   r   r   r   6test_replace_dict_tuple_list_ordering_remains_the_same
  s   zKTestDataFrameReplace.test_replace_dict_tuple_list_ordering_remains_the_samec                 C  s@   t g dg dg dg dd}|ddi}t|| d S )N)r   r   r   r@   )0vrr_  r_  )r_  r_  r_  bt)vor_  r_  r_  )folT_oppT_DirT_Enhz\Dr   r   r   r   r   r   )test_replace_doesnt_replace_without_regex  s   z>TestDataFrameReplace.test_replace_doesnt_replace_without_regexc                 C  sF   t ddgtdd}|dd}t ddg|jd}t|| d S )NTFabr   r   )r   r   r.   r   r/   r0   r	  r   r   r   test_replace_bool_with_string!  s   z2TestDataFrameReplace.test_replace_bool_with_stringc                 C  s6   t tjdddk}|dd}t|| d S )Nr   r   r   r   r<  fdsa)r   r   randomdefault_rngr.   r/   r0   r5   rX   r;   r   r   r   (test_replace_pure_bool_with_string_no_op'  s   z=TestDataFrameReplace.test_replace_pure_bool_with_string_no_opc                 C  sH   t tjdddk}|dd}t tjdtd}t|| d S )Nr   rj  r   FTrz   )	r   r   rl  rm  r.   onesboolr/   r0   r	  r   r   r   test_replace_bool_with_bool,  s   z0TestDataFrameReplace.test_replace_bool_with_boolc                 C  sL   t ddgddgd}|ddd}t ddgddgd}t|| d S )NTFr   r   asdbyes)r<  Tr   r	  r   r   r   %test_replace_with_dict_with_bool_keys2  s   z:TestDataFrameReplace.test_replace_with_dict_with_bool_keysc                 C  sV   t ddgddgd}|ddi}t|| |d ddi}t||d  d S )	Nr   r   r@   r   )Y0Y1replace_stringtestrw  )r   r.   r/   r0   r   rn  r   r   r   !test_replace_dict_strings_vs_ints8  s
   z6TestDataFrameReplace.test_replace_dict_strings_vs_intsc                 C  s<   t dddgi}|tjtj gtj}|}t|| d S )Nr   T)r   r.   r   rG  r   r/   r0   )r5   rX   rrM   r   r   r   test_replace_truthyB  s   z(TestDataFrameReplace.test_replace_truthyc              	   C  sj   t dttddi}|dtttddtddi}|tttddtdd}t|| d S )Nr   r   r!   r      )r   r   r   r.   dictrI  r/   r0   r	  r   r   r   -test_nested_dict_overlapping_keys_replace_intH  s   $ zBTestDataFrameReplace.test_nested_dict_overlapping_keys_replace_intc                 C  sp   t dd}|t}t ddt}td|i}|tt||}|dtt||i}t	|| d S )Nr   r!   r   r~  r   )
r   aranger   r(  r   r.   r  rI  r/   r0   )r5   r   astrbstrrX   r;   r<   r   r   r   -test_nested_dict_overlapping_keys_replace_strQ  s   
zBTestDataFrameReplace.test_nested_dict_overlapping_keys_replace_strc                 C  s   t dg di}|ddddi}t dg di}t|| t dg di}|ddddi}t dg di}t|| d S )	Nr   r  YN)TF)r  r  r  )r   r   r   rs  r   )r5   r   rX   rh   expectr   r   r   test_replace_swapping_bug[  s   z.TestDataFrameReplace.test_replace_swapping_bugc                   s  dt jddddt jddddt jddddt jdd	ddt jddddt jddddt jd
ddddi tg ddgd}t|jjt d  ksOJ td fdd|jjD i}|jjd dkshJ d}t	j
t|d | }W d    n1 sw   Y  t	|| d S )Nfnamei     M)r5  monthfreqr   i  r!   r   i  	   out_augmented_AUG_2011.jsonout_augmented_JAN_2011.jsonout_augmented_MAY_2012.jsonout_augmented_SUBSIDY_WEEK.jsonout_augmented_AUG_2012.jsonout_augmented_MAY_2011.jsonout_augmented_SEP_2013.jsonr  r  r  r  r  r  r  r3   c                      g | ]} d  | qS r  r   r@  rA  r   r   r   
<listcomp>      z<TestDataFrameReplace.test_replace_period.<locals>.<listcomp>r   z	Period[M]r   r~   )r   Periodr   setr  rW   keysr   r2   r/   r   r   r.   r0   r   r   r  r   test_replace_periodi  s0   	 z(TestDataFrameReplace.test_replace_periodc              	     s   dt dt dt dt dt dt dt dd	i tg d
dgd}t|jjt d  ks3J td fdd|jjD i}d}tjt|d |	 }W d    n1 s[w   Y  t
|| d S )Nr  z2011-08z2011-01z2012-05z2011-04z2012-08z2011-05z2013-09r  r  r  c                   r  r  r   r  r  r   r   r    r  z>TestDataFrameReplace.test_replace_datetime.<locals>.<listcomp>r   r~   )r   r   r  r  rW   r  r/   r   r   r.   r0   r   r   r  r   test_replace_datetime  s*   	 z*TestDataFrameReplace.test_replace_datetimec                 C  sL  t tdddddtjdgd}|tjd}t tddddtg d	d
dd}t|| |d}t|| |dtj}t tddddtjtjdgd}t|| |t	dddt	ddd}t t	dddt	dddt	dddgdtjdgd}|d j
d|d< t|| | }tj|jd< |dtjit	ddd}t|| | }tj|jd< |dtjit	ddd}t t	dddt	ddddt	dddgdtjdgd}|d j
d|d< t|| | }tj|jd< |dtjit	d}t t	dddt	dt	dddgdtjdgd}t|| d S )Nr+  r@   r,  r-  r   r   r   r   r   r   r   r   rz   r0  r1  r2  r3  r"   r4  r  z
US/Pacific)r   r	   r   r   r.   r   r/   r0   r1   r   r'  as_unitr-   r2   r   r  
tz_convertr	  r   r   r   test_replace_datetimetz  s   
















z,TestDataFrameReplace.test_replace_datetimetzc              	   C  sh   t |}t||i  t||tg td t||di i t||tdi i d S )Nrz   r   )r   r/   r0   r.   r   r|   )r5   r   rX   r   r   r    test_replace_with_empty_dictlike  s
   z5TestDataFrameReplace.test_replace_with_empty_dictlikezto_replace, method, expectedr  )r   r   r   r   r  )r        @r  ffillpad)r   r   r   )r   r   )r   r   r   )r   r   r   c                 C  sz   t g ddtjdgg dd}d}tjt|d |j|d |d}W d    n1 s,w   Y  t |}t|| d S )	Nr  r!   r   r   r   z7The 'method' keyword in DataFrame.replace is deprecatedr~   )rV   r*   r  )r   r   r   r/   r   r   r.   r0   )r5   rV   r  r<   rX   r   r;   r   r   r   test_replace_method  s    "z(TestDataFrameReplace.test_replace_methodzreplace_dict, final_datac                 C  sl  t ddgddggddgdd}t|}tj|d d df ddgd	}|d dkr-ddgnddg}tj|d d df |d	}t ||d
}d}tjt|d ||d}	W d    n1 s_w   Y  t	|	| d}
t
jt|
d t	|| W d    n1 sw   Y  tjt|d |j|ddd}W d    n1 sw   Y  |d u sJ t	|| d S )Nr   r   r   r   r  )r3   r{   r   r@   )
categoriesr   z#with CategoricalDtype is deprecatedr~   zHAttributes of DataFrame.iloc\[:, 0\] \(column name=\"a\"\) are differentTr$   )r   r   r   r   Categoricalr/   r   r   r.   r0   r   r   AssertionError)r5   replace_dict
final_datarX   r   ex_catr   r<   msg2r;   r   r9   r   r   r   "test_categorical_replace_with_dict:  s*   
z7TestDataFrameReplace.test_categorical_replace_with_dictzdf, to_replace, expr   r!   r~  )r   r   r~  )r!   r~  r   )456r  r  7)r  r  r  c                 C  s*   t |}t |}||}t|| d S r  r   )r5   rX   rV   expr<   r;   r   r   r   test_replace_commutativeZ  s   
z-TestDataFrameReplace.test_replace_commutativereplacer20170827c                 C  sf   t dg}d}tjt|d |||d}W d    n1 s!w   Y  t |g}t|| d S )Nr   r   r~   r   r   )r5   r  rX   r   r;   r<   r   r   r   test_replace_replacer_dtypet  s   

z0TestDataFrameReplace.test_replace_replacer_dtypec                 C  sD   t dg didd}|dd}t dg didd}t|| d S )Ngrp)r   r   r@   r   r!   r   rz   r   r*  )r*  r   r@   r   r!   r   r	  r   r   r   !test_replace_after_convert_dtypes  s   z6TestDataFrameReplace.test_replace_after_convert_dtypesc              	   C  s   t g dg dd}d}d}tjt|d/ tjt|d |dd  W d    n1 s0w   Y  W d    d S W d    d S 1 sHw   Y  d S )	N)r   zb r   )zd ze zf )r   twozZExpecting 'to_replace' to be either a scalar, array-like, dict or None, got invalid type.*zSDataFrame.replace without 'value' and with non-dict-like 'to_replace' is deprecatedr~   c                 S  s   |   S r  )strip)r   r   r   r   <lambda>  s    zFTestDataFrameReplace.test_replace_invalid_to_replace.<locals>.<lambda>)r   r   r   rM  r/   r   r   r.   )r5   rX   r   r  r   r   r   test_replace_invalid_to_replace  s   "z4TestDataFrameReplace.test_replace_invalid_to_replace)floatr   r   r   r   r*   c                 C  s<   t td|d}|jd tj tjg|d}t|| d S )Nr   rz   r\  )r   r   eyer.   rG  r/   r0   )r5   r{   r*   rX   r;   r   r   r   "test_replace_no_replacement_dtypes  s   z7TestDataFrameReplace.test_replace_no_replacement_dtypesreplacementc                 C  sr   t g dg dg dd}td|_t g dg d|ddgd}td|_|d d	||d< t|| d S )
Nr  r  )r   r  r  )r"   A1r   AABr  r  r   r   )r   r   r3   r.   r/   r0   )r5   r  r;   r<   r   r   r   #test_replace_with_duplicate_columns  s   

z8TestDataFrameReplace.test_replace_with_duplicate_columnsz2020-01c                 C  sB   t d|gd i}t||}| }|dd}t|| d S )NPerr@   r   r   )r   r/   r   r-   r.   r   )r5   r   r*   r   r<   r;   r   r   r   test_replace_ea_ignore_float  s
   z1TestDataFrameReplace.test_replace_ea_ignore_floatc                 C  sJ  g dg dg dg dg dd}t |dddd	}|d
 jjg ddd|d
< |d jjg ddd|d< g dg dg dg dg dd}t |dddd	}|d
 jjg ddd|d
< |d jjg ddd|d< d}tjt|d |dd}|dd}|dd}W d   n1 sw   Y  t|| dS )zt
        Test for #23305: to ensure category dtypes are maintained
        after replace with direct values
        )r   r   r@   r   )r   r   r   r   )g      ?g      @g      @g      @)cat1cat2cat3cat4)obj1obj2obj3obj4)r   r   r   col4col5r   r  )r   r  r   T)orderedr  )r   r   r   z)r  catXr  r  )obj9r  r  r  OThe behavior of Series\.replace \(and DataFrame.replace\) with CategoricalDtyper~   r   r  r  r  r  r  N)	r   r   catreorder_categoriesr/   r   r   r.   r0   r5   
input_dictinput_dfexpected_dictr<   r   r;   r   r   r    test_replace_value_category_type  sL   









z5TestDataFrameReplace.test_replace_value_category_typec                 C  s   dgdgdgd}t |ddddd}dgdgd	gd}t |ddddd}d
}tjt|d |ddd	d}W d   n1 sGw   Y  t|| dS )zf
        Test to ensure category dtypes are maintained
        after replace with dict values
        r   r  r  r   r  r  r  r  r  r  r~   )r   r  r  N)r   r   r/   r   r   r.   r0   r  r   r   r   test_replace_dict_category_type  s   



z4TestDataFrameReplace.test_replace_dict_category_typec                 C  sD   t g d}td}|j|didd}t g d}t|| d S )Nr   z^a$r  Tr[   )r  r   r   )r   recompiler.   r/   r0   )r5   rX   rT   r;   r<   r   r   r    test_replace_with_compiled_regex  s
   
z5TestDataFrameReplace.test_replace_with_compiled_regexc                 C  s   t dtddtddgi}|rtnd }tj|dd |dtdddii}W d    n1 s5w   Y  t dddgi}t|| d S )Nr   r   r   r}   r~   r   )r   r   Intervalr   r/   r   r.   r0   )r5   r   rX   warningr;   r<   r   r   r   test_replace_intervals!  s    z+TestDataFrameReplace.test_replace_intervalsc                 C  sN   dddddi}t dtdi}||}t dtdi}t|| d S )Npositiver   r   )u   正面u   中立u   负面r@   )r   r   rp  r.   r/   r0   )r5   columns_values_mapr   r;   r<   r   r   r   test_replace_unicode*  s
   
z)TestDataFrameReplace.test_replace_unicodec                 C  s8   |dg d}| }|d tji}t|| d S )NrD   z|S)r   r-   r.   r   r   r/   r   )r5   r   r   r<   r   r   r   test_replace_bytes2  s   z'TestDataFrameReplace.test_replace_bytesz!data, to_replace, value, expectedr   boxc           	      C  s0   ||}||}| |||}t|| d S r  )r.   r/   r   )	r5   r   rV   r*   r<   r  r   r   r;   r   r   r   !test_replace_list_with_mixed_type9  s   z6TestDataFrameReplace.test_replace_list_with_mixed_typevalc                 C  sj   t dd|gi}||d }t ddd gitd}t|| t dd|gi}||d i}t|| d S )Nr   r   rz   )r   r.   r|   r/   r0   )r5   r  rX   r;   r<   r   r   r   %test_replace_value_none_dtype_numericL  s   z:TestDataFrameReplace.test_replace_value_none_dtype_numericc                 C  sH   t ddtjgi}t ddtjgiddgd}|dd}t|| d S )Nr   nilzanything elser   r   r   )r   r   r  r.   r/   r0   )r5   r   r<   r;   r   r   r   test_replace_with_nil_naX  s   z-TestDataFrameReplace.test_replace_with_nil_naN)g__name__
__module____qualname__r   r   r   r   r=   parametrizer   r   rY   rj   rm   rr   ru   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  r   int32int16r   r   r	   r   DatetimeIndexr  r8  rK  rN  rO  rZ  r[  r^  rg  ri  ro  rr  rv  r{  r}  r  r  r  r  r  r  r  r  r  r  int8r  r   r  r  r  r  r  r  r  r  r  r  r  r  r  r  r   tupler   r  r  r  r   r   r   r   r       sf   
%)(E










"














k	(



	


$
 T	  
 
2




	

	8	
		r   c                	   @  s   e Zd Zejdededdedeeddgejddej	fdgejd	d
dgejdd
dgejdd
dgdd Z
ejje ddejddd
gdd Zdd Zdd Zdd ZdS )TestDataFrameReplaceRegexr   r   rR   r   r   zto_replace,valuer>   )rE   z\1\1\1compile_regexTFregex_kwargr%   c                 C  s   t |}| }|rt|}|r|}	d }nd}	|j||||	d}
|r+|
d u s)J |}
|tju r4tj}nd}||j|d dkdf< t	|
| d S )NTrk   z...r   ro   )
r   r-   r  r  r.   r   r   r+   r/   r0   )r5   r   rV   r*   r   r  r%   rX   r<   rT   r;   expected_replace_valr   r   r   test_regex_replace_scalara  s"   

z3TestDataFrameReplaceRegex.test_regex_replace_scalarr   r   rT   c           	      C  s   t dgdgd}t dgdgd}d}tjt|d |jdd|d}W d    n1 s.w   Y  t|| t dgdgd}t dgdgd}tjt|d |jdd|d}W d    n1 sew   Y  t|| d S )Nr_  r   r   r   r~   )rV   r*   rT   1r   )	r5   rT   r   expected_df1r   
result_df1df2expected_df2
result_df2r   r   r   test_replace_regex_dtype_frame  s   z8TestDataFrameReplaceRegex.test_replace_regex_dtype_framec                 C  sV   t g dg dd}|dtjd}t dtjdgtjddgd}t|| d S )Nr  )r   r   r   r   r   rs  r   r   r	  r   r   r   +test_replace_with_value_also_being_replaced  s   zETestDataFrameReplaceRegex.test_replace_with_value_also_being_replacedc                 C  sH   t g dg dddd}| }|jddgdd gd	}t|| d S )
N)r   r  Nthree)r   Nr  r  r   r  rz   ro   def_r\  )r   r-   r.   r/   r0   r   r   r   r   'test_replace_categorical_no_replacement  s   zATestDataFrameReplaceRegex.test_replace_categorical_no_replacementc                 C  s   t dgdd}|rt|jjdksJ n
t|jjdksJ |jddddd	 |r6t|jjdks4J d S t|jjdks@J d S )
Nr   r   r   r   r   r   r   T)rV   r*   r%   rT   )r   r   _mgrblocksr.   )r5   r   rX   r   r   r   test_replace_object_splitting  s   z7TestDataFrameReplaceRegex.test_replace_object_splittingN)r  r  r  r   r   r  r   r   r   r   r  r   r   r
  r  r  r  r   r   r   r   r  `  s,    r  )r
   r   )r
   r   )
__future__r   r   r  numpyr   r   pandas._configr   pandasr   r   r   r   r   r	   pandas._testing_testingr/   fixturer   r   r   r  r   r   r   r   <module>   s6                L