o
    Ti                     @   sR  d dl mZm Z  d dlmZ d dlZd dlZd dlZd dlm	Z	m
Z
mZmZmZ d dlmZ d dlmZ dd Zdd	 Zd
d Zdd Zejjde	g dg ddg dfe	g dg ddd dgfe	ddgidgfe	g deddddgfe	g dg ddg dfe	edg dg dd g d!fe	g dg d"gg d!d#ddgfgg d$d%d&d' Zd(d) Zd*d+ Zejd,d-d. d/d. d0d. d1d. gd2d3 Zd4d5 Zd6d7 Z d8d9 Z!d:d; Z"d<d= Z#d>d? Z$d@dA Z%dBdC Z&dDdE Z'dFdG Z(dHdI Z)ejdJdKdLgdMdN Z*dOdP Z+dQdR Z,dSdT Z-dUdV Z.dWdX Z/ejdYdKdLgdZd[ Z0d\d] Z1d^d_ Z2d`da Z3dbdc Z4ddde Z5dfdg Z6dhdi Z7djdk Z8dldm Z9dndo Z:dpdq Z;drds Z<ejdte = e =  e = > gdudv Z?dwdx Z@ejdydLdKgdzd{ ZAd|d} ZBejd~eCedeDd dejEddddeFg dgdd ZGejddd. d dgddggfdd. d dhddhgfdd. ddgfdd. d dddddgfdd. d d iddigd diddiggfgdd ZHdd ZIejddd. dd. gdd ZJdd ZKejddd. dd. gejdJdKdLgdd ZLdd ZMdd ZNdd ZOdd ZPdd ZQejddKdLgdd ZRejddLe	g dg dge
g deSdd#gdKeddgejFddgddgddggdd ZTdd ZUdd ZVdd ZWdd ZXejddKdLgdd ZYddÄ ZZejdg dg dŢgddǄ Z[ejdg dg dɢgg dg dʢgg dˢg d̢ggdd΄ Z\ejddKgi fg ddKifgdd҄ Z]ejdddgddք Z^ejdddd. fddd. fdddgdd߄ Z_ejddej`ddgej`dddgd ddej`ggdd Zadd ZbdS )    )datedatetime)StringION)	DataFrameIndex
MultiIndexSeriesbdate_range)get_groupby_method_argsc                     s|   t dttdd dgd } g   fdd}| d| t dgd dgd dtdd	dd
}t	 d | d S )N   
   r   )indexcolumnsc                    s     |  d S N)appendgroupgroups _/var/www/html/evchargy.com/venv/lib/python3.10/site-packages/pandas/tests/groupby/test_apply.pystore      zFtest_apply_func_that_appends_group_to_list_without_copy.<locals>.storer   )r   r   d   r   )
r   listrangereset_indexgroupbyapplypdZ
RangeIndextmassert_frame_equal)dfr   Zexpected_valuer   r   r   7test_apply_func_that_appends_group_to_list_without_copy   s     r$   c                  C   s   d} t jt| d g dddggd}|d}||jj }||jjdd }t	
|| t jt| d g dd	}tg d
tdd}tg d|d}|jddddd }t	|| d S )Na+  2011.05.16,00:00,1.40893
2011.05.16,01:00,1.40760
2011.05.16,02:00,1.40750
2011.05.16,03:00,1.40649
2011.05.17,02:00,1.40893
2011.05.17,03:00,1.40760
2011.05.17,04:00,1.40750
2011.05.17,05:00,1.40649
2011.05.18,02:00,1.40893
2011.05.18,03:00,1.40760
2011.05.18,04:00,1.40750
2011.05.18,05:00,1.40649)r   timevaluer   r%   )headernamesZparse_dates	date_timec                 S      |   S r   idxmaxxr   r   r   <lambda>@       z#test_apply_issues.<locals>.<lambda>)r'   r(   )z
2011.05.16z
2011.05.17z
2011.05.18dtypename)z00:0002:00r4   r   F
group_keysc                 S   s   | d | d    S )Nr%   r&   r+   r-   r   r   r   r/   K       )r    Zread_csvr   	set_indexr   r   r   r,   r   r!   r"   r   objectr   assert_series_equal)sr#   expectedresultZexp_idxr   r   r   test_apply_issues'   s(   

r>   c                     s   t g dg ddddgd tj jdd   jdd  gddd	gd
} d}tjt|d  jdd  jD dd}W d    n1 sFw   Y  |	 fdd}t
||  d S )Nar@   brA   r@         ?       @      @      @g      @keydatarH   rI   r   r   float64r9   axiskeys+DataFrame.groupby with axis=1 is deprecatedmatchc                 S      g | ]}t |qS r   str.0r.   r   r   r   
<listcomp>[   r7   z&test_apply_trivial.<locals>.<listcomp>rM   c                    s    j dd  S Nr   ilocr-   r#   r   r   r/   \       z$test_apply_trivial.<locals>.<lambda>)r   r    concatr[   r!   assert_produces_warningFutureWarningr   dtypesr   r"   r<   msggbr=   r   r\   r   test_apply_trivialP   s   ,re   c                     s   t g dg ddddgd tj  gddd	gd
} d}tjt|d  jdd  jD ddd}W d    n1 s=w   Y  | fdd}t	||  d S )Nr?   rB   rG   rH   rI   rJ   r   rK   r9   rL   rO   rP   c                 S   rR   r   rS   rU   r   r   r   rW   j   r7   z+test_apply_trivial_fail.<locals>.<listcomp>T)rM   r6   c                    s    S r   r   r-   r\   r   r   r/   k       z)test_apply_trivial_fail.<locals>.<lambda>)
r   r    r^   r!   r_   r`   r   ra   r   r"   rb   r   r\   r   test_apply_trivial_faila   s   rg   zdf, group_names)r   r   r         )r@   r@   r@   rA   cr@   rA   r   rh   ri   r   r   r   r   )r   r   r   r   r   r@   )r   r   r   rh   rh   r   r   rh      rh   r   rh   ri   r   rh   ri   )            rn   	   )r@   twoZ
aaabbbcccc)
ri   rp   ri   rr   rq   rh   r   rt   rq   rp   )
rp   r   rh   rh   rh   rs   rn   rr   rh   rn   )r@   BCr@   rA   rj   )rh   rh   ri   rJ   )ZGH2936zGH7739 & GH10519ZGH10519ZGH2656ZGH12155ZGH20084ZGH21417)Zidsc                    s   g   fdd} fdd} fdd} fdd} fd	d
}|||||fD ]} d d = | j ddd|  |ks>J q'd S )Nc                    s     | j |  S r   )r   r3   copyr   r(   r   r   f_copy   s   z/test_group_apply_once_per_group.<locals>.f_copyc                    s     | j | S r   r   r3   r   rz   r   r   f_nocopy      z1test_group_apply_once_per_group.<locals>.f_nocopyc                    s     | j dS Nr   r|   r   rz   r   r   f_scalar   r~   z1test_group_apply_once_per_group.<locals>.f_scalarc                    s     | j d S r   r|   r   rz   r   r   f_none   s   z/test_group_apply_once_per_group.<locals>.f_nonec                    s     | j tdgdgdS )Nr   rk   )r   r3   r   r   rz   r   r   f_constant_df   s   z6test_group_apply_once_per_group.<locals>.f_constant_dfr@   Fr5   )r   r   )r#   Zgroup_namesr{   r}   r   r   r   funcr   rz   r   test_group_apply_once_per_groupp   s   '
r   c                 C   sZ   d}t g dg ddg dd}|jdddd	d
  |  jd}||ks+J d S )Nrh   )r   r   r   r   r   r   r   r   )0246810Z12Z14)group_by_columnZtest_columnr   r   Fr5   c                 S   s   t dS )Nfunction_called)printr\   r   r   r   r/      r0   z2test_group_apply_once_per_group2.<locals>.<lambda>r   )r   r   r   Z
readouterroutcount)Zcapsysr<   r#   r=   r   r   r    test_group_apply_once_per_group2   s   r   c                  C   s^   t g dtdd} dd }dd }| jdd	d
|}| jdd	d
|}t|| d S )N)r   r   r   ri   )ArA   c                 S      | S r   r   r   r   r   r   slow      z,test_apply_fast_slow_identical.<locals>.slowc                 S   r*   r   ry   r   r   r   r   fast   s   z,test_apply_fast_slow_identical.<locals>.fastr   Fr5   )r   r   r   r   r!   r"   )r#   r   r   Zfast_dfZslow_dfr   r   r   test_apply_fast_slow_identical   s   r   r   c                 C   r   r   r   r-   r   r   r   r/      rf   r/   c                 C   s   | d d  S r   r   r-   r   r   r   r/          c                 C      | j ddS )NFdeepr   r-   r   r   r   r/      r   c                 C   r   )NTr   r   r-   r   r   r   r/      r   c                 C   s@   t g dg dg dd}|jddd| }t|| d S )Nr   rh   rh   rh   r   rh   ri   rp   )rq   rr   rs   rn   )gr@   rA   r   Fr5   r   r   r   r!   r"   )r   r#   r=   r   r   r   5test_groupby_apply_identity_maybecopy_index_identical   s   r   c                  C   s   t tjddg dd} | jdd ddj}| j}t|| t d	g d
i} | j	d | d< | 
d  j}| j
ddd j}t|| d S )Nrh   rr   oneru   ru   threer   ru   foo1Zfoo2c                 S   r   r   r   r-   r   r   r   r/     rf   z-test_apply_with_mixed_dtype.<locals>.<lambda>r   rX   c1)r   rh   rr   rr   rn   rD   c2Fas_index)r   nprandomdefault_rngstandard_normalr   ra   r!   r:   r   r   meanr   r   )r#   r=   r<   result1result2r   r   r   test_apply_with_mixed_dtype   s   r   c                  C   s6  t g dg dtdd} | jddd}| jddd}|d	j}|d	j}tg d
}t|| t|| |dd j}|dd j}t	
g d}g d}	t	j
|	dd gd}
t||
 t|| ttd}t dd	gd	dgddgddgd	dgg|d} | jdddddd j}t|| d S )N)rA   rA   r@   rj   r@   rA   )r   rh   r   r   ri   r   rr   )Zitem_iduser_idr%   r   Tr   Frh   )r   r   rh   rp   c                 S   
   |  dS Nrh   headr-   r   r   r   r/         
 z-test_groupby_as_index_apply.<locals>.<lambda>c                 S   r   r   r   r-   r   r   r   r/   !  r   ))r   r   )r   rh   r   r   rh   rp   )r   r   r   rh   )rh   r   )ri   rp   rz   abcder   ri   rp   rq   r   r   )r   r6   c                 S   r   r   r   r-   r   r   r   r/   .  rf   )r   r   r   r   r   r   r!   assert_index_equalr   r   from_tuplesr   )r#   Zg_asZg_not_asZres_asZ
res_not_asexpZres_as_applyZres_not_as_applyZexp_not_as_applytpZexp_as_applyindresr   r   r   test_groupby_as_index_apply  s0   *r   c                 C   sx   |  ddg}dd }dd }dd }||}|jjd	ks J ||}|jjd	ks-J ||}|jjd
ks:J d S )Nr   rv   c                 S   s   |   }d|j_|S Nstat)describer   r3   r   r=   r   r   r   desc5  s   z.test_apply_concat_preserve_names.<locals>.descc                 S   s$   |   }d|j_|d t|  }|S r   )r   r   r3   lenr   r   r   r   desc2:  s   z/test_apply_concat_preserve_names.<locals>.desc2c                 S   s0   |   }dt| d|j_|d t|  }|S )NZstat_d)r   r   r   r3   r   r   r   r   desc3A  s   z/test_apply_concat_preserve_names.<locals>.desc3)r   rv   r   )r   rv   N)r   r   r   r(   )Zthree_groupgroupedr   r   r   r=   r   Zresult3r   r   r    test_apply_concat_preserve_names2  s   



r   c                  C   sz   dd } t ddd}ttjdd|d}|jdd	 d
d}|| }t|t	s,J t
|dr3J t|j|j d S )Nc                 S   sN   t jdd t | }W d    n1 sw   Y  t| | |   |dS )Nignore)invalid)r&   Zdemeanedlogged)r   Zerrstatelogr   r   )Zpiecer   r   r   r   fV  s   z%test_apply_series_to_frame.<locals>.fz1/1/2000r   )periodsrh   r   c                 S      | j S r   monthr-   r   r   r   r/   `      z,test_apply_series_to_frame.<locals>.<lambda>Fr5   r3   )r	   r   r   r   r   r   r   r   
isinstancer   hasattrr!   r   r   )r   Zdrtsr   r=   r   r   r   test_apply_series_to_frameU  s   
r   c                 C   s4   |  ddgd t}|jjd d dksJ d S )Nr   rv   rw   rh   r   rv   )r   r   r   r   r(   r#   r=   r   r   r    test_apply_series_yield_constanth  s   r   c                 C   sl   |  ddgt}t|tsJ |jd u sJ |  ddgddg t}t|ts-J |jd u s4J d S )Nr   rv   rw   D)r   r   r   r   r   r3   r   r   r   r   test_apply_frame_yield_constantm  s   r   c                 C   sH   |  ddg}|t}| d }t|j|j t|j|j d S )Nr   rv   rw   )	r   r   r   r   r!   r   r   assert_numpy_array_equalvaluesr#   r   r=   r<   r   r   r   test_apply_frame_to_seriesx  s
   
r   c                 C   s^   | j ddgdd}|t}| jdtjidjdd}t	|j
|j
 t|j|j d S )Nr   rv   Fr   rw   rJ   r   )r   r   r   r   renamer   nandropr!   r   r   r   r   r   r   r   r   )test_apply_frame_not_as_index_column_name  s
   
r   c                     s   dd }  fdd}t tjddddtjddddtjddd	  d
| } d
d |}tj	||dd |j
dksLJ d S )Nc                 S   s    |  dd   jd d S )Nrv   rw   rh   )r   sumsort_valuesr[   r   r   r   r   trans  s    z-test_apply_frame_concat_series.<locals>.transc                    s,   |   | jd }|  jd d S )Nrv   rh   )r   reindexr   r   r   r[   )r   r   r\   r   r   trans2  s   z.test_apply_frame_concat_series.<locals>.trans2rh   r   rq     r   rv   rw   r   rw   F)Zcheck_names)r   r   r   r   integersr   r   r   r!   r:   r3   )r   r   r=   r   r   r\   r   test_apply_frame_concat_series  s   r   c                 C   s>   | j dd dd}|dd }|dd }t|| d S )Nc                 S   r   r   r   r-   r   r   r   r/     r   z&test_apply_transform.<locals>.<lambda>Fr5   c                 S      | d S r   r   r-   r   r   r   r/     r0   c                 S   r   r   r   r-   r   r   r   r/     r0   )r   r   	transformr!   r:   )r   r   r=   r<   r   r   r   test_apply_transform  s   r   c                 C   sP   |  dd dd g}dd }||}|D ]\}}t|j| || qd S )Nc                 S   r   r   yearr-   r   r   r   r/     r   z,test_apply_multikey_corner.<locals>.<lambda>c                 S   r   r   r   r-   r   r   r   r/     r   c                 S   s   |  ddd  S )Nr   r   r   r   r   r   r     s   z%test_apply_multikey_corner.<locals>.f)r   r   r!   r"   loc)tsframer   r   r=   rH   r   r   r   r   test_apply_multikey_corner  s   
r   r6   TFc                 C   sn   t g dtdd}|jd| ddd }|g d}| r/tjg d	|jgdd gd
|_t	|| d S )N)	r   r   r   rh   rh   rh   ri   ri   ri   rt   )rH   r&   rH   r5   c                 S   s   | j d d S r   rZ   r-   r   r   r   r/     r]   z'test_apply_chunk_view.<locals>.<lambda>)r   r   ri   rp   rr   rs   )r   r   rh   rh   ri   ri   rz   )
r   r   r   r   Ztaker   from_arraysr   r!   r"   )r6   r#   r=   r<   r   r   r   test_apply_chunk_view  s   r   c                  C   s@   t g dg dtdddd} | ddg}|dd	  d S )
N)
r   r   r   r   r   r   rh   rh   rh   rh   )
r   r   r   r   r   r   r   r   r   r   rt   )r3   name2r&   r3   r   c                 S      | j dddS )Nr&   TZinplacer   r-   r   r   r   r/     r]   z4test_apply_no_name_column_conflict.<locals>.<lambda>)r   r   r   r   )r#   r   r   r   r   "test_apply_no_name_column_conflict  s   
	r  c                  C   sp   t g dtg ddtddd} dd }| jd	d
d|}|  }tg dd|d< t|| d S )NrC   rC   rC   rD   rD   rD   rx   rh   rC         @r   rj   vc                 S   ,   | d }||   | |    | d< | S Nr  v2minmaxr   r  r   r   r   r         z#test_apply_typecast_fail.<locals>.fr   Fr5           g      ?r   r
  )	r   r   tilearanger   r   ry   r!   r"   )r#   r   r=   r<   r   r   r   test_apply_typecast_fail  s   
r  c                  C   s   t g dg dg} tg dtg ddtddd| d	}d
d }|jddd|}| }tg dd|d< t	
|| d S )N)r   r   r   r   r   r   ro   r  rx   rh   rC   r  r  r   c                 S   r  r	  r  r  r   r   r   r     r  z%test_apply_multiindex_fail.<locals>.fr   Fr5   r  r
  )r   r   r   r   r  r  r   r   ry   r!   r"   )r   r#   r   r=   r<   r   r   r   test_apply_multiindex_fail  s   
	r  c                 C   s4   | j dd dddd }| d }t|| d S )Nc                 S   r   r   r   r-   r   r   r   r/     r   z#test_apply_corner.<locals>.<lambda>Fr5   c                 S   r   r   r   r-   r   r   r   r/     r0   rh   )r   r   r!   r"   )r   r=   r<   r   r   r   test_apply_corner  s   r  c                  C   s\   t g dg dg dd} dd }dd }| d	|}| d	|}t|| d S )
N)r   r      i,  )r@   rA   rj   rj   r   )id_fieldcategoryr&   c                 S   s$   | j d dkr|  S | | jdk S Nr   r   rj   )shapery   r  r-   r   r   r   filt1  s   z&test_apply_without_copy.<locals>.filt1c                 S   s    | j d dkr	| S | | jdk S r  )r  r  r-   r   r   r   filt2  s   z&test_apply_without_copy.<locals>.filt2r  r   )rI   r  r  r<   r=   r   r   r   test_apply_without_copy  s   r  test_seriesc                 C   s   t ddgddgddggddgg dd}| r9|dd }|jdd	d
dd }| }| }t|| d S |jdd	ddd }|d}|d}t|| d S )Nr.   poXY)r   rh   rh   r   r   r   F)levelr6   c                 S   r   r   r   r-   r   r   r   r/   (  rf   z<test_apply_with_duplicated_non_sorted_axis.<locals>.<lambda>r5   c                 S   r   r   r   r-   r   r   r   r/   /  rf   )	r   r8   r   r   
sort_indexr!   r:   r   r"   )r  r#   serr=   r<   r   r   r   *test_apply_with_duplicated_non_sorted_axis   s    

r(  c                  C   sf   g d} g d}t ddgd | d|d}t| |dd	}d
d }|jdddj|}t|| d S )Nr   r   r   rh   rh   ZGroup1ZGroup2rh   r   r&   r   r&   r   r3   c                 S   s"   |  t| j | j d S rY   )r   r   r  r   r  r  r-   r   r   r   reindex_helperA  s   "z1test_apply_reindex_values.<locals>.reindex_helperr   Fr5   )r   r   r   r&   r   r!   r:   )r   indicesr#   r<   r,  r=   r   r   r   test_apply_reindex_values7  s   r.  c                  C   sv   d} t jdjdd| d}t|t jd| g d| d  d}|jd	d
d}dd }||}d|v s9J d S )Nr   rh   r   r   )size)foobarZbazZquxrp   )rH   value1Zvalue2rH   Fr5   c                 S   s   | d d | d< | S )Nr2  rh   value3r   r   r   r   r   r   X  s   z"test_apply_corner_cases.<locals>.fr3  )r   r   r   r   r   r   r   r   )Nlabelsr#   r   r   r=   r   r   r   test_apply_corner_casesI  s   
r7  c                  C   s:  t ddgdgd ddgd} | dgdd	 }t| j| _| dgd
d	 }t|d |d  t g dg dtdgd d} dd }| d|d }| j	}| j
|_t|| dd }t g dg dg dg dd}| }t|j|_|d|j}|d|j}t|| d S )Nr   rh   z
2017-03-02r0  inf)NumberDateStrr9  c                 S   
   | j d S r   rZ   r-   r   r   r   r/   j  r   z;test_apply_numeric_coercion_when_datetime.<locals>.<lambda>c                 S   r<  r   rZ   r-   r   r   r   r/   l  r   r;  )r         )r0  3r   z12:31:22ri   )r   rv   Tc                 S   s   | j d dg S )Nr   rv   rZ   r4  r   r   r   get_Bt  s   z8test_apply_numeric_coercion_when_datetime.<locals>.get_Br   rv   c                 S   s   t g dtd}dt| jv rt| | jdk jjd |d< dt| jv rCt| | jdk jjd |d< t| | jdk jjd |d< |S )	N)p1p2useTime)r   r2   step1r   rB  step2rC  rD  )r   r9   r   StaterT   Machiner   oTime)Ztoolr   r   r   r   predictions}  s   z>test_apply_numeric_coercion_when_datetime.<locals>.predictions)rv   rv   r   r   )rE  rF  rE  rF  ) z2016-09-19 05:24:33rK  z2016-09-19 23:59:04)Z23Z36L36RrL  )KeyrG  rI  rH  rM  )r   r   r   r    to_datetimer:  r!   r:   	Timestamprv   r   r   ry   rI  rB  )r#   r<   r=   rA  rJ  df1df2r   r   r   )test_apply_numeric_coercion_when_datetime`  s8   	rR  c                  C   s   t g dtdgd d} | j| j | d< | ddd }t g dtd	d
gd tdgd dd}t	|| d S )Nr   z2017-02-01 00:00:00ri   )clientidr   time_delta_zerorS  c                 S   s   t | j | j dS )N)clientid_ager   )r   rT  r  r   )Zddfr   r   r   r/     s    z?test_apply_aggregating_timedelta_and_datetime.<locals>.<lambda>r   r   )rS  rU  r   )
r   r   Z
datetime64r   r   r   Ztimedelta64r8   r!   r"   r#   r=   r<   r   r   r   -test_apply_aggregating_timedelta_and_datetime  s$   
rW  c                  C   s~   ddgddgddgddgddgg} t | d	d
gtddd}|d	 }t g dg dd}|jd	dd t|| d S )Nr   r   rv   r=  r>  rw   (   2   NameValuez
2020-09-01z
2020-09-05r$  r   )r   rY  Z   )rZ  r[  Tr  )r   r    
date_ranger   r   r8   r!   r"   )rI   r#   r=   r<   r   r   r    test_apply_groupby_datetimeindex  s   "r^  c                  C   s   t ddd tdD d} dd }dd	 }| jd
gd|}t ddidgd}d
|j_| jd
gd|}t tdddddddgd}d
|j_t	
|| t	
|| d S )Nr   c                 S   s   g | ]}t  qS r   )r   now)rV   nnr   r   r   rW     r7   z'test_time_field_bug.<locals>.<listcomp>r   rk   c                 S   s   t ddiS )Nrj   rh   r   batchr   r   r   func_with_no_date  s   z.test_time_field_bug.<locals>.func_with_no_datec                 S   s   t tdddddS )N  r   rh   rA   rj   )r   r   rb  r   r   r   func_with_date     z+test_time_field_bug.<locals>.func_with_dater@   Zbyrj   rh   r   re  nsrf  )r   r   r   r   r   r3   r    rO  Zas_unitr!   r"   )r#   rd  rg  Zdfg_no_conversionZdfg_no_conversion_expectedZdfg_conversionZdfg_conversion_expectedr   r   r   test_time_field_bug  s   rk  c                     s`   t g dg dg dg dd} | ddg} | jddgdd	}d
d  | fdd d S )N)r@   r@   r@   rA   rA   rA   r@   r@   r@   rA   rA   rA   )rj   rj   r   r   r   erj   rj   r   r   r   rl  )g?rh   ri   rp   rq   rr   rh   rp   rr   rn   r   rh   )gffffff@rn   rt   r         rn   rs   rr   rq   rp   ri   )group1group2weightr&   ro  rp  T)r%  sortc                 S   s   t | | d}|S )Nri   )r   arrayrepeat)r&   rq  r   r   r   r   noddy  s   z7test_gb_apply_list_of_unequal_len_arrays.<locals>.noddyc                    s    | j | jS r   )r&   rq  r-   ru  r   r   r/     r]   z:test_gb_apply_list_of_unequal_len_arrays.<locals>.<lambda>)r   r8   r   r   )r#   Z
df_groupedr   rv  r   (test_gb_apply_list_of_unequal_len_arrays  s   
rw  c                  C   sD   t g dg dd} dd }| d|}t  }t|| d S )Nrm   )rn   rs   rp   rq   )r   Zrandom_varsc                 S   s   d S r   r   r-   r   r   r   	test_func  r   z.test_groupby_apply_all_none.<locals>.test_funcr   r   )Ztest_dfrx  r=   r<   r   r   r   test_groupby_apply_all_none  s
   ry  c            	      C   s   t g dg dd} t g dg dd}dd }| d|}|d|}tjddgd	d
ggdd gd}tjd
d
gddggdd gd}t ddgd	d
gd|d}t d
d
gddgd|d}t|| t|| d S )N)r   r   r   rh   )r   r   rh   ri   )r   varsr   c                 S   s    | j d dk r	d S | jddg S )Nr   rh   r   )r  r[   r-   r   r   r   rx  	  s   z0test_groupby_apply_none_first.<locals>.test_funcr   r   r   rh   rz   ri   r   )r   r   r   r   r   r!   r"   )	Ztest_df1Ztest_df2rx  r   r   Zindex1index2Z	expected1Z	expected2r   r   r   test_groupby_apply_none_first  s   r|  c                  C   sl   t ddgddgd} | d}|dd }tdgd	tjddgdggdd gd
dd}t|| d S )Nr   r   Zfilledempty)r&   r   r   c                 S   s   | | j dk d S )Nr   r&   )r&   r   r   r   r   r/         z7test_groupby_apply_return_empty_chunk.<locals>.<lambda>r&   rz   r3   r   )	r   r   r   r   r   from_productr   r!   r:   )r#   r   r=   r<   r   r   r   %test_groupby_apply_return_empty_chunk  s   
r  c                  C   sx   t d g dg dd} | jddd}|dd	 }t g d
g dd}t|| |dd	 }t|| d S )Nza a brl   rp   rr   rq   r   r   Fr5   c                 S      | |    S r   r   r-   r   r   r   r/   ,  r   z-test_apply_with_mixed_types.<locals>.<lambda>)gUUUUUU?gUUUUUU?r   )皙?g333333?rC   rv   rw   c                 S   r  r   r  r-   r   r   r   r/   0  r   )r   splitr   r   r!   r"   r   )r#   r   r=   r<   r   r   r   test_apply_with_mixed_types'  s   r  c                  C   sh   t dddgitddgd} | ddd }ttdgtdggtddgddd}t|| d S )Nr@   r   rh   r   c                 S   r   r   r   r4  r   r   r   r/   7  r   z*test_func_returns_object.<locals>.<lambda>r3   )r   r   r   r   r   r!   r:   rV  r   r   r   test_func_returns_object4  s   (r  group_column_dtlikec                 C   sT   t dg| gd}|ddd }t dgtdgdddd	gd
}t|| d S )Nr0  rk   r@   c                 S   s   t dgdgdS )Nspam*   r   ra  r-   r   r   r   r/   H      z+test_apply_datetime_issue.<locals>.<lambda>r  r9   r1   r  rJ   r   r   r   r   r!   r"   )r  r#   r=   r<   r   r   r   test_apply_datetime_issue=  s   
r  c               	   C   s   t tdtdtdtdtddddddddddddddd} dd }| d	|d
 }tdgtjdgd	dd
d}t|| d S )Nz2015-02-24 00:00:00)r   r   rh   ri   rp   zsome UA stringzanother UA stringZ17661101)dayZ	userAgentuserIdc                 S   s   t dd |  D S )Nc                 S   s    i | ]\}}||  jd  qS )r   )value_countsr   )rV   rj   r;   r   r   r   
<dictcomp>m  s     zYtest_apply_series_return_dataframe_groups.<locals>.most_common_values.<locals>.<dictcomp>)r   itemsr\   r   r   r   most_common_valuesl  rh  zEtest_apply_series_return_dataframe_groups.<locals>.most_common_valuesr  r  z
2015-02-24r  r+  )	r   r    rO  r   r   r   DatetimeIndexr!   r:   )Ztdfr  r=   r<   r   r   r   )test_apply_series_return_dataframe_groupsP  s6   r  r  c                 C   s   ddgd }| r"t j|g dd}t jg dg ddd}g d}ntddgdd	}d
dg}t||d|d}ttd|ttdttdd	ddg}|j
ddddd }t|| |jjddgkslJ d S )Nr   rh   rq   rl   )
categoriesrv   )r  r3   )r=     r   r  r=  r  )rw   r   r   r   )r   rv   rw   r   r   F)Zobservedc                 S   r*   r   r  r-   r   r   r   r/     r0   z-test_apply_multi_level_name.<locals>.<lambda>)r    ZCategoricalCategoricalIndexr   r   r   r  r   r   r8   r   r   r!   r"   r   r(   )r  rA   Zexpected_indexexpected_valuesr<   r#   r=   r   r   r   test_apply_multi_level_namev  s$   

"
r  c               	   C   s   t jtdddddddftdddddd	d
ftdddddddftdddddddfgg dd} | ddd j}tt	dt
t
tjt
gg dd}t|| d S )Ni  r   redZdarkr   re  greenZstormyrh   9i  bluebrightri   r   i  Zcalmrp   potato)ZobservationcolorZmoodZ	intensityZscorerJ   r  c                 S   r<  r   rZ   r4  r   r   r   r/     r   z;test_groupby_apply_datetime_result_dtypes.<locals>.<lambda>zdatetime64[ns]r   )r   Zfrom_recordsr    rO  r   r   ra   r   r   r2   r9   Zint64r!   r:   )rI   r=   r<   r   r   r   )test_groupby_apply_datetime_result_dtypes  s   	r  r   abcri   Z2020r   )r   freq))r@   r   )r@   r   )rA   r   c                 C   sB   t g dg dd| d}|jddddd	 }t|| d S )
N)r   r   rh   )r   r   r   r*  r   r   Fr5   c                 S   r   r   r   r-   r   r   r   r/     rf   z8test_apply_index_has_complex_internals.<locals>.<lambda>r   )r   r#   r=   r   r   r   &test_apply_index_has_complex_internals  s   r  zfunction, expected_valuesc                 C   
   | j  S r   )r   to_listr-   r   r   r   r/     r   c                 C      t | j S r   )setr   r  r-   r   r   r   r/     r]   c                 C   r  r   )tupler   r  r-   r   r   r   r/     r]   )r   r   rh   ri   c                 C   s   t t| j S r   )dict	enumerater   r  r-   r   r   r   r/     r~  c                 C   s   dd t | j D S )Nc                 S   s   g | ]\}}||iqS r   r   )rV   nir   r   r   rW         z<lambda>.<locals>.<listcomp>)r  r   r  r-   r   r   r   r/     r  c                 C   sJ   t g ddgd}|d| }t|tddgddd}t|| d S )N)r   r   rv   rv   r   rJ   r   rv   r  r   r   r   r   r   r   r!   r:   )functionr  r#   r=   r<   r   r   r   1test_apply_function_returns_non_pandas_non_scalar  s   r  c                  C   sl   dd } t g ddddtjgd}|d| }td	d
gdgtjggtg dddd}t|| d S )Nc                 S   s   | d j  S )Nrv   )r   flattenr   r   r   r   fct  r   z4test_apply_function_returns_numpy_array.<locals>.fct)r@   r@   rA   noner   rh   ri   r   r   rC   rD   rE   )r@   rA   r  r  r   )	r   r   r   r   r   r   r   r!   r:   )r  r#   r=   r<   r   r   r   'test_apply_function_returns_numpy_array  s    r  r  c                 C   r   r   r   grr   r   r   r/     r   c                 C   s   | j d d S rY   r   r  r   r   r   r/     r]   c                 C   sh   t g ddgd}|d| }ttg dtg dtddggtg ddd	d
}t|| d S )N)
r   rh   rh   rh   r   rh   ri   r   ri   r   idrJ   )r   rp   rs   rt   )r   rh   ri   rq   rr   rn   rl   r  r   r  )r  r#   r=   r<   r   r   r    test_apply_function_index_return  s    r  c                  C   sT   t g dg dd} | jddddd }t g d	g d
d}t|| d S )Nr   )r   rh   rp   rp   rq   rr   r   r   Fr   c                 S   r*   r   )r   r-   r   r   r   r/     r0   zAtest_apply_function_with_indexing_return_column.<locals>.<lambda>)r   r   ru   )rE   rF   rF   r   rV  r   r   r   /test_apply_function_with_indexing_return_column  s   r  udfc                 C   r*   r   r   r-   r   r   r   r/     r0   c                 C   s   |   dd S )Nc                 S   s   | d S rY   r   )yr   r   r   r/     r0   z<lambda>.<locals>.<lambda>)ry   r   r-   r   r   r   r/     r~  c                 C   s   t ddgddgd}|jd| d|}|jj|j| d|}| r5|jjdks+J |jjdks3J d S |jjdks=J |jjdksEJ d S )Nr@   rA   r   rh   r   r   r5   )r   r   r   rv   r   r   Znlevels)r6   r  r#   Z	df_resultZseries_resultr   r   r   test_apply_result_type  s   	r  c                  C   sV   t g dg dd} | jddddd }| jdddd	d }t|| d S )
N)rh   r   rh   rl   r   r   Fr5   c                 S   r   r   r   r-   r   r   r   r/     rf   z4test_result_order_group_keys_false.<locals>.<lambda>c                 S   r*   r   r   r-   r   r   r   r/     r0   r   rV  r   r   r   "test_result_order_group_keys_false	  s   r  c                  C   s   dgd dgd  dgd  } t | }t j| dd}tttdd td|d	}tttdd td|d	}|jd
dddd }|jd
dddd }t|| d S )Nz
2001-01-01rh   z
2001-01-02z
2001-01-03UTC)tzri   rr   )r.   r  tr.   Fr5   c                 S      | ddg   S Nr.   r  r   r\   r   r   r   r/     r  z1test_apply_with_timezones_aware.<locals>.<lambda>c                 S   r  r  r   r\   r   r   r   r/     r  )	r    r  r   r   r   r   r   r!   r"   )datesZindex_no_tzZindex_tzrP  rQ  r   r   r   r   r   test_apply_with_timezones_aware  s   
  r  c                 C   s  t g dg dg dd}t ddgddgd	d
gdtddgddd}|jdd}d}tjt|dd |t}W d    n1 sDw   Y  t|| |jdd}t	| |}t
|| | }tjt|dd |t}W d    n1 syw   Y  t|| d S )N)c   r  r  X   r  r  )r   rh   ri   rp   rq   rr   )r   r=  r>  rX  rY  <   rx   i  i)     rr      r  r  r  r@   r  r   ri  z:The behavior of DataFrame.sum with axis=None is deprecatedF)rQ   Zcheck_stacklevel)r   r   r   r!   r_   r`   r   r   r"   r
   getattr)Zreduction_funcr#   r<   grprc   r=   args_r   r   r   ;test_apply_is_unchanged_when_other_methods_are_called_first   s.   
r  c               	   C   s   t g dtdddtdddtdddtdddgg ddtg dd	d
d} | ddg}|dd }| jg d }| }t|g d |_	|j
d	d}t|| |j	jd D ]
}t|tu sgJ q]d S )N)r@   r@   r@   rA   i  r   r   rh   r   r   )r   e   f   g   idxr  r   r   rv   c                 S   r   rY   r   r-   r   r   r   r/   R  r   zRtest_apply_with_date_in_multiindex_does_not_convert_to_timestamp.<locals>.<lambda>)r   rh   ri   )r   rv   r  rJ   )r   r   r   r   r   r[   r   r   Z
from_framer   r   r!   r"   Zlevelstype)r#   r  r=   r<   valr   r   r   @test_apply_with_date_in_multiindex_does_not_convert_to_timestamp@  s*   




r  c                  C   s   t tjdddgtddgddggd} d}tjt|d	 | j	j
d
d
d}W d    n1 s4w   Y  |dd }d}tjt|d	 | j
dd
d}W d    n1 s[w   Y  |dd }t||j	 t||  d S )Nrh   rr   rp   r   rv   r   rJ   z5The 'axis' keyword in DataFrame.groupby is deprecatedrP   r   rM   r%  c                 S   s   | j dddS )Nr   r  Z	droplevelr-   r   r   r   r/   l  r]   zDtest_apply_by_cols_equals_apply_by_rows_transposed.<locals>.<lambda>rO   c                 S   r  )Nr   r   r  r  r-   r   r   r   r/   q  r]   )r   r   r   r   r   r  r!   r_   r`   r@  r   r   r"   )r#   rc   rd   Zby_rowsZgb2Zby_colsr   r   r   2test_apply_by_cols_equals_apply_by_rows_transposed^  s    r  dropnac                 C   sl   t g ddtjtjddgdtdd}|jd| dd	d
d }| r'| n|jg d }t	|| d S )Nr   rh   ri   rp   rq   r@   rA   )colr   Zxxyxzr   r   F)r  r6   c                 S   r   r   r   r-   r   r   r   r/     rf   z5test_apply_dropna_with_indexed_same.<locals>.<lambda>)r   ri   r   rh   rp   )
r   r   r   r   r   r   r  r[   r!   r"   )r  r#   r=   r<   r   r   r   #test_apply_dropna_with_indexed_samew  s   r  zas_index, expected)r   r   r   )rh   rh   r   )r@   rA   N)r2   r   )rh   rh   rA   rz   r   c                 C   sH   t g dg dg dd}|jddg| ddd }t|| d S )	Nr)  )r   r   r   r   rx   r@   rA   r   c                 S   s   dS rY   r   r-   r   r   r   r/     rf   z5test_apply_as_index_constant_lambda.<locals>.<lambda>)r   r   r   r!   Zassert_equal)r   r<   r#   r=   r   r   r   #test_apply_as_index_constant_lambda  s   r  c                  C   sn   t g dg dg ddtdd} | ddd	 }ttd
dtjg ddd gddd}t|| d S )Nr  )rr   rs   rn   rt   r   )r   r   r   rh   rh   r   rq   r   rw   c                 S   r  r   )r   r&  r-   r   r   r   r/     r   z(test_sort_index_groups.<locals>.<lambda>r   rr   )r   r   r   r  r   rz   r   r+  )	r   r   r   r   r   r   r   r!   r:   rV  r   r   r   test_sort_index_groups  s   r  c                  C   sX   t tjddddtdtdd} | j| j| jjjgdd	d	d
 }t
||  d S )Nz
2010-01-01Z12Hrq   )r  r   r   )r   valsletFr5   c                 S   s   | j dd  S r   rZ   r-   r   r   r   r/     r]   z;test_positional_slice_groups_datetimelike.<locals>.<lambda>)r   r    r]  r   r   r   r  r   dtr   r!   r"   )r<   r=   r   r   r   )test_positional_slice_groups_datetimelike  s   
r  c                  C   sr   t g dg dg dd} | d}|ddg dd	 }t d
dgddgdtddgddd}t|| d S )N)r@   r@   rA   rl   r  r   r   rv   rw   c                 S   s   |  t |   S r   )Zastypefloatr  r  r-   r   r   r   r/     s    z7test_groupby_apply_shape_cache_safety.<locals>.<lambda>rC   r  rD   r  r@   rA   r  r   r  )r#   rd   r=   r<   r   r   r   %test_groupby_apply_shape_cache_safety  s   
r  c                  C   s~   t g dg dg dd} | dddg }|dd	 }tjg d
g dgdd gd}tg d|dd}t|| d S )N)r@   rA   r@   rA   )aaacr  ad)r  r  r  r  )r@   b1b2r@   r  r  c                 S   s   |    S r   )Zunstackr  r-   r   r   r   r/     r   z3test_groupby_apply_to_series_name.<locals>.<lambda>)r@   r@   rA   rA   rA   )r  r  r  r  r  )Zarraysr(   )ri   r   rh   r   r   r   r+  )	r   	from_dictr   r   r   r   r   r!   r:   )r#   r  r=   Zexpected_idxr<   r   r   r   !test_groupby_apply_to_series_name  s   r  c                 C   s^   t g dg dddtjtjgd}|jd| d}|dd	 }|d
d	 }t|| d S )Nr)  )r   r   rh   rq   r   rh   )r  r  zr  )r  c                 S   s   |  ddS )Nr   r  )nlargest)Zgrp_dfr   r   r   r/     r   ztest_apply_na.<locals>.<lambda>c                 S   s   | j ddddS )Nr  F)Z	ascendingr   )r   r   r-   r   r   r   r/     r7   )r   r   r   r   r   r!   r"   )r  r#   Zdfgrpr=   r<   r   r   r   test_apply_na  s   r  c                  C   s   t g dg dtjg ddddddgd	d
 } t ddtjdddgddtjdddggg dtjddgddgdd}t| | d S )Nr)  )rK  rK  rK  rK  r   r;   )unitrx   r@   rA   c                 S   r<  Nr   rZ   r\   r   r   r   r/     r   z8test_apply_empty_string_nan_coerce_bug.<locals>.<lambda>r   rK  rh   rp   )r   rK  )rh   rK  rz   r$  )	r   r    rN  r   r   r   r   r!   r"   )r=   r<   r   r   r   &test_apply_empty_string_nan_coerce_bug  s   

&r  index_values)rC   rD   rE   c                 C   sb   t g dg ddt| d}t dg ditg ddd	d}|dd
d }t|| d S )N)r  a2a3rl   rk   r   b_mean)rD   rE   rC   )r  r  r  r@   r  c                 S   s   t | d  gdgdS )NrA   r  r   )r   r   r\   r   r   r   r/     r  z0test_apply_index_key_error_bug.<locals>.<lambda>)r   r   r   r   r!   r"   )r  r=   r<   r   r   r   test_apply_index_key_error_bug   s   
r  zarg,idx)皙?333333?皙?)r  r  r  )r   rp   ri   )r  r  r  c                 C   s8   t d| i|d}|jddddd }t|| d S )Nr  r   Fr5   c                 S   r   r   r   r-   r   r   r   r/   B  rf   z5test_apply_nonmonotonic_float_index.<locals>.<lambda>r   )argr  r<   r=   r   r   r   #test_apply_nonmonotonic_float_index  s   +r  zargs, kwargsnumeric_onlyc                 C   s>   |  d}|jdg|R i |}|jdd}t|| d S )Nr   r   T)r  )r   r   r   r!   r"   )r#   r  kwargsrd   r=   r<   r   r   r   test_apply_str_with_argsF  s   
r  r3   Z	some_namec                 C   sL   t ddg| d}|jddgdddd }t ddg| d}t|| d S )	Nr   rh   r  r@   Fr5   c                 S   r   r   r   r-   r   r   r   r/   S  rf   z1test_result_name_when_one_group.<locals>.<lambda>)r   r   r   r!   r:   )r3   r'  r=   r<   r   r   r   test_result_name_when_one_groupO  s   r  z
method, opr   c                 C   r<  r  )r   rd   r   r   r   r/   \  r   c                 C   s   | d j d S )NrA   r   rZ   r  r   r   r   r/   ]  r]   )aggZskew)r  prod)r  r   c              	   C   s^   t g g d}|jddd}t|d}t|| |}tg ddtg dddd}t|| d S )	Nrk   r@   Tr5   rA   rK   r1   )r3   r2   r   )r   r   r  r   r   r!   r:   )methodopZempty_dfrd   r   r=   r<   r   r   r   test_empty_dfY  s   
r  	group_colr  c                 C   sh   t | g dd}|djdd }ttjdtjgdtjdgg d	gddgd
d}t	
|| d S )N)rh   rh   rh   rh   )r  	value_colr  c                 S   s   |   jg ddS )Nrl   r   )r  r   r-   r   r   r   r/   z  r7   z0test_apply_inconsistent_output.<locals>.<lambda>rE   r  r  rl   rz   r  )r   r   r  r   r   r   r   r   r  r!   r:   )r  r#   r=   r<   r   r   r   test_apply_inconsistent_outputq  s   r  c                  C   sv   t dddddddddd} | dddg dd	 }ttd
ggd tddgdddd}t|| d S )Nr   rh   rk   r   r   rv   rw   c                 S   s   t dgS r   )r   rs  r-   r   r   r   r/     r   z7test_apply_array_output_multi_getitem.<locals>.<lambda>r   r  r  r+  )	r   r   r   r   r   rs  r   r!   r:   rV  r   r   r   %test_apply_array_output_multi_getitem  s    r  )cr   r   ior   numpyr   ZpytestZpandasr    r   r   r   r   r	   Zpandas._testingZ_testingr!   Zpandas.tests.groupbyr
   r$   r>   re   rg   markZparametrizer   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r  r  r  r  r  r(  r.  r7  rR  rW  r^  rk  rw  ry  r|  r  r  r  todayr%   r  r  r  r  r  Zinterval_rangeZperiod_ranger   r  r  r  r  r  r  r  r  r  r  r  r  r9   r  r  r  r  r  r  r  r  r  r  r  r  r   r  r  r   r   r   r   <module>   sl   )"

,
	%#


5	
&


	

	 




)

	



&
