o
    dz                     @   s   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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, d.d, d/d, gd0d1 Z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(ejdHdIdJgdKdL Z)dMdN Z*dOdP Z+dQdR Z,dSdT Z-dUdV Z.ejdWdIdJgdXdY Z/dZd[ Z0d\d] Z1d^d_ Z2d`da Z3dbdc Z4ddde Z5dfdg Z6dhdi Z7djdk Z8dldm Z9dndo Z:dpdq Z;ejdre < e <  e < = gdsdt Z>dudv Z?ejdwdJdIgdxdy Z@dzd{ ZAejd|eBed}eCd d~ejDdd~ddeEg dgdd ZFejddd, d dgdd~ggfdd, d dhdd~hgfdd, ddgfdd, d dddd~dgfdd, d d iddigd didd~iggfgdd ZGdd ZHejddd, dd, gdd ZIdd ZJejddd, dd, gejdHdIdJgdd ZKdd ZLdd ZMdd ZNdd ZOdd ZPejddIdJgdd ZQejddJe	g dg dge
g deRdd!gdIeddgejEddgddgddggdd ZSdd ZTdd ZUdd ZVejddIdJgdd ZWdd ZXejdg dg dgddÄ ZYejdg dg dŢgg dg dƢgg dǢg dȢggddʄ ZZejddIgi fg ddIifgdd΄ Z[ejdddgdd҄ Z\ejdddd, fddd, fdddgddۄ Z]dS )    )datedatetime)StringION)	DataFrameIndex
MultiIndexSeriesbdate_range)get_groupby_method_argsc                  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namesparse_dates	date_timec                 S      |   S Nidxmaxx r   d/var/www/html/visualizacion-main/env/lib/python3.10/site-packages/pandas/tests/groupby/test_apply.py<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:00r   indexF
group_keysc                 S   s   | d | d    S )Nr   r   r   r   r   r   r   r   :       )pdread_csvr   	set_indexgroupbyr    r   r   applytmassert_frame_equalr   objectr   assert_series_equal)sdfexpectedresultexp_idxr   r   r   test_apply_issues   s(   

r2   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
}  jdd  jD dd fdd}t||  d S )Nar4   br5   r4         ?       @      @      @g      @keydatar<   r=   columns   float64r+   axiskeysc                 S      g | ]}t |qS r   str.0r   r   r   r   
<listcomp>G   r#   z&test_apply_trivial.<locals>.<listcomp>rC   c                    s    j dd  S Nr@   ilocr   r.   r   r   r   H       z$test_apply_trivial.<locals>.<lambda>)	r   r$   concatrN   r'   dtypesr(   r)   r*   r/   r0   r   rO   r   test_apply_trivial?   s   ,
rT   c                     sp   t g dg ddddgd tj  gddd	gd
}  jdd  jD ddd fdd}t||  d S )Nr3   r6   r;   r<   r=   r>   r@   rA   r+   rB   c                 S   rE   r   rF   rH   r   r   r   rJ   U   r#   z+test_apply_trivial_fail.<locals>.<listcomp>T)rC   r"   c                    s    S r   r   r   rO   r   r   r   V       z)test_apply_trivial_fail.<locals>.<lambda>)r   r$   rQ   r'   rR   r(   r)   r*   rS   r   rO   r   test_apply_trivial_failN   s   
rV   zdf, group_names)r@   r@   r@         )r4   r4   r4   r5   cr4   r5   r@   rW   rX   r   r   r@   r@   )r   r@   r   r@   r@   r4   )r@   r@   r@   rW   rW   r@   r@   rW      rW   r@   rW   rX   r@   rW   rX   )            r]   	   )r4   two
aaabbbcccc)
rX   r_   rX   ra   r`   rW   r@   rc   r`   r_   )
r_   r   rW   rW   rW   rb   r]   ra   rW   r]   )r4   BCr4   r5   rY   )rW   rW   rX   r>   )GH2936zGH7739 & GH10519GH10519GH2656GH12155GH20084GH21417)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   )appendr   copygroupr   r   r   f_copy   s   z/test_group_apply_once_per_group.<locals>.f_copyc                    s     | j | S r   rp   r   rr   rt   r   r   f_nocopy      z1test_group_apply_once_per_group.<locals>.f_nocopyc                    s     | j dS Nr   rv   rr   rt   r   r   f_scalar   rx   z1test_group_apply_once_per_group.<locals>.f_scalarc                    s     | j d S r   rv   rr   rt   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@   rZ   )rp   r   r   rr   rt   r   r   f_constant_df   s   z6test_group_apply_once_per_group.<locals>.f_constant_dfr4   Fr!   )r'   r(   )r.   group_namesru   rw   rz   r{   r|   funcr   rt   r   test_group_apply_once_per_group\   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 )NrW   )r   r   r   r   r@   r@   r@   r@   )02468101214)group_by_columntest_columnr   r   Fr!   c                 S   s   t dS )Nfunction_called)printrO   r   r   r   r      r   z2test_group_apply_once_per_group2.<locals>.<lambda>r   )r   r'   r(   
readouterroutcount)capsysr/   r.   r0   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@   rX   )Ar5   c                 S      | S r   r   rr   r   r   r   slow      z,test_apply_fast_slow_identical.<locals>.slowc                 S   r   r   rq   rr   r   r   r   fast   s   z,test_apply_fast_slow_identical.<locals>.fastr   Fr!   )r   ranger'   r(   r)   r*   )r.   r   r   fast_dfslow_dfr   r   r   test_apply_fast_slow_identical   s   r   r~   c                 C   r   r   r   r   r   r   r   r      rU   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@   rW   rW   rW   r@   rW   rX   r_   )r`   ra   rb   r]   )gr4   r5   r   Fr!   r   r'   r(   r)   r*   )r~   r.   r0   r   r   r   5test_groupby_apply_identity_maybecopy_index_identical   s   r   c                  C   s   t tj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 )Nra   onerd   rd   threer   rd   foo1foo2c                 S   r   r   r   r   r   r   r   r      rU   z-test_apply_with_mixed_dtype.<locals>.<lambda>r@   rK   c1)r@   rW   ra   ra   r]   r8   c2Fas_index)r   nprandomrandnr(   rR   r)   r,   r   r'   meanreset_indexr   )r.   r0   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)r5   r5   r4   rY   r4   r5   )r@   rW   r@   r@   rX   r@   ra   )item_iduser_idr   r   Tr   FrW   )r   r@   rW   r_   c                 S   
   |  dS NrW   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   rW   r@   r@   rW   r_   )r@   r   r@   rW   )rW   r@   )rX   r_   rt   abcder@   rX   r_   r`   r   r   )r   r"   c                 S   r   r   r   r   r   r   r   r     rU   )r   r   r'   r   r    r   r)   assert_index_equalr(   r   from_tupleslist)r.   g_asg_not_asres_as
res_not_asexpres_as_applyres_not_as_applyexp_not_as_applytp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   rf   c                 S   s   |   }d|j_|S Nstat)describer    r   rs   r0   r   r   r   desc!  s   z.test_apply_concat_preserve_names.<locals>.descc                 S   s$   |   }d|j_|d t|  }|S r   )r   r    r   lenr   r   r   r   desc2&  s   z/test_apply_concat_preserve_names.<locals>.desc2c                 S   s0   |   }dt| d|j_|d t|  }|S )Nstat_d)r   r   r    r   r   r   r   r   desc3-  s   z/test_apply_concat_preserve_names.<locals>.desc3)r   rf   r   )r   rf   N)r'   r(   r    r   )three_groupgroupedr   r   r   r0   r   result3r   r   r    test_apply_concat_preserve_names  s   



r   c                  C   st   dd } t ddd}ttjd|d}|jdd d	d
}|| }t|ts)J t	|dr0J 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   demeanedlogged)r   errstatelogr   r   )piecer   r   r   r   fB  s   z%test_apply_series_to_frame.<locals>.fz1/1/2000d   )periodsr   c                 S      | j S r   monthr   r   r   r   r   L      z,test_apply_series_to_frame.<locals>.<lambda>Fr!   r   )r	   r   r   r   r   r'   r(   
isinstancer   hasattrr)   r   r    )r   drtsr   r0   r   r   r   test_apply_series_to_frameA  s   
r   c                 C   s4   |  ddgd t}|jjd d dksJ d S )Nr   rf   rg   rW   r   rf   )r'   r(   r   r    r   r.   r0   r   r   r    test_apply_series_yield_constantT  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   rf   rg   D)r'   r(   r   r   r   r   r   r   r   r   test_apply_frame_yield_constantY  s   r   c                 C   sH   |  ddg}|t}| d }t|j|j t|j|j d S )Nr   rf   rg   )	r'   r(   r   r   r)   r   r    assert_numpy_array_equalvaluesr.   r   r0   r/   r   r   r   test_apply_frame_to_seriesd  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   rf   Fr   rg   r>   r   )r'   r(   r   r   renamer   nandropr)   r   r    r   r   r   r   r   r   )test_apply_frame_not_as_index_column_namel  s
   
r   c                     s   dd }  fdd}t tjdddtjdddtjdd  d	| } d	d
 |}tj||dd |j	d
ksCJ d S )Nc                 S   s    |  dd   jd d S )Nrf   rg   rW   )r'   sumsort_valuesrN   rr   r   r   r   transw  s    z-test_apply_frame_concat_series.<locals>.transc                    s,   |   | jd }|  jd d S )Nrf   rW   )r'   reindexr    r   r  rN   )rs   r   rO   r   r   trans2z  s   z.test_apply_frame_concat_series.<locals>.trans2r   r`     r   rf   rg   r   rg   F)check_names)
r   r   r   randintr   r'   r(   r)   r,   r   )r  r  r0   r   r   rO   r   test_apply_frame_concat_seriesv  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>Fr!   c                 S      | d S r   r   r   r   r   r   r     r   c                 S   r
  r   r   r   r   r   r   r     r   )r'   r(   	transformr)   r,   )r   r   r0   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  rr   r   r   r   r     s   z%test_apply_multikey_corner.<locals>.f)r'   r(   r)   r*   loc)tsframer   r   r0   r<   rs   r   r   r   test_apply_multikey_corner  s   
r  r"   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@   rW   rW   rW   rX   rX   rX   rc   )r<   r   r<   r!   c                 S   s   | j d d S r   rM   r   r   r   r   r     rP   z'test_apply_chunk_view.<locals>.<lambda>)r   r@   rX   r_   ra   rb   )r@   r@   rW   rW   rX   rX   rt   )
r   r   r'   r(   taker   from_arraysr    r)   r*   )r"   r.   r0   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@   rW   rW   rW   rW   )
r   r   r   r@   r@   r@   r   r   r@   r@   rc   )r   name2r   r   r  c                 S      | j dddS )Nr   Tinplacer  r   r   r   r   r     rP   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r7   r7   r7   r8   r8   r8   rh   rW   r7         @r   rY   vc                 S   ,   | d }||   | |    | d< | S Nr   v2minmaxrs   r   r   r   r   r         z#test_apply_typecast_fail.<locals>.fr   Fr!           g      ?r@   r#  )	r   r   tilearanger'   r(   rq   r)   r*   )r.   r   r0   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@   r^   r  rh   rW   r7   r  r  r   c                 S   r!  r"  r$  r'  r   r   r   r     r(  z%test_apply_multiindex_fail.<locals>.fr   Fr!   r)  r#  )r   r  r   r   r+  r,  r'   r(   rq   r)   r*   )r    r.   r   r0   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>Fr!   c                 S   r
  r   r   r   r   r   r   r     r   rW   )r'   r(   r)   r*   )r  r0   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,  )r4   r5   rY   rY   r   )id_fieldcategoryr   c                 S   s$   | j d dkr|  S | | jdk S Nr   r@   rY   )shaperq   r2  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 r3  )r4  r2  r   r   r   r   filt2  s   z&test_apply_without_copy.<locals>.filt2r1  r   )r=   r5  r6  r/   r0   r   r   r   test_apply_without_copy  s   r7  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@   rW   rW   r?   r    r   F)levelr"   c                 S   r   r   r   r   r   r   r   r     rU   z<test_apply_with_duplicated_non_sorted_axis.<locals>.<lambda>r!   c                 S   r   r   r   r   r   r   r   r     rU   )	r   r&   r'   r(   
sort_indexr)   r,   r  r*   )r8  r.   serr0   r/   r   r   r   *test_apply_with_duplicated_non_sorted_axis  s    

rA  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@   rW   rW   Group1Group2rW   rs   r   r   r   r    r   c                 S   s"   |  t| j | j d S rL   )r  r   r,  r    r%  r&  r   r   r   r   reindex_helper-  s   "z1test_apply_reindex_values.<locals>.reindex_helperrs   Fr!   )r   r   r'   r   r(   r)   r,   )r   indicesr.   r/   rG  r0   r   r   r   test_apply_reindex_values#  s   rI  c                  C   sj   d} t jjdd| d}t|t j| g d| d  d}|jdd	d
}dd }||}d|v s3J d S )Nr  r   r   )size)foobarbazquxr_   )r<   value1value2r<   Fr!   c                 S   s   | d d | d< | S )NrO  rW   value3r   r   r   r   r   r   D  s   z"test_apply_corner_cases.<locals>.frQ  )r   r   r  r   r   r'   r(   )Nlabelsr.   r   r   r0   r   r   r   test_apply_corner_cases5  s   

rU  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@   rW   z
2017-03-02rK  inf)NumberDateStrrW  c                 S   
   | j d S ry   rM   r   r   r   r   r   V  r   z;test_apply_numeric_coercion_when_datetime.<locals>.<lambda>c                 S   rZ  ry   rM   r   r   r   r   r   X  r   rY  )
         )rK  3r   z12:31:22rX   )r   rf   Tc                 S   s   | j d dg S )Nr   rf   rM   rR  r   r   r   get_B`  s   z8test_apply_numeric_coercion_when_datetime.<locals>.get_Br   rf   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    r   step1r   ra  step2rb  rc  )r   r+   r   StaterG   Machiner   oTime)toolr   r   r   r   predictionsi  s   z>test_apply_numeric_coercion_when_datetime.<locals>.predictions)rf   rf   r   r   )rd  re  rd  re  ) z2016-09-19 05:24:33rk  z2016-09-19 23:59:04)2336L36Rrn  )Keyrf  rh  rg  ro  )r   r'   r(   r$   to_datetimerX  r)   r,   	Timestamprf   r   r    rq   rh  ra  )r.   r/   r0   r`  rj  df1df2r   r   r   )test_apply_numeric_coercion_when_datetimeL  s8   	rt  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:00rX   )clientidr   time_delta_zeroru  c                 S   s   t | j | j dS )N)clientid_ager   )r   rv  r%  r   )ddfr   r   r   r     s    z?test_apply_aggregating_timedelta_and_datetime.<locals>.<lambda>r   r   )ru  rw  r   )
r   r   
datetime64r   r'   r(   timedelta64r&   r)   r*   r.   r0   r/   r   r   r   -test_apply_aggregating_timedelta_and_datetime  s$   
r|  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[  rf   r\  r]  rg   (   2   NameValuez
2020-09-01z
2020-09-05r=  r  )r[  r~  Z   )r  r  Tr  )r   r$   
date_ranger'   r   r&   r)   r*   )r=   r.   r0   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gd}d
|j_t|| t|| d S )Nr@   c                 S   s   g | ]}t  qS r   )r   now)rI   nnr   r   r   rJ     r#   z'test_time_field_bug.<locals>.<listcomp>r[  rZ   c                 S   s   t ddiS )NrY   rW   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@   rW   r5   rY   )r   r   r  r   r   r   func_with_date     z+test_time_field_bug.<locals>.func_with_dater4   byrY   rW   r   r  r  )	r   r   r'   r(   r    r   r   r)   r*   )r.   r  r  dfg_no_conversiondfg_no_conversion_expecteddfg_conversiondfg_conversion_expectedr   r   r   test_time_field_bug  s   r  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)r4   r4   r4   r5   r5   r5   r4   r4   r4   r5   r5   r5   )rY   rY   r   r   r   erY   rY   r   r   r   r  )g?rW   rX   r_   r`   ra   rW   r_   ra   r]   r@   rW   )gffffff@r]   rc   r[        r]   rb   ra   r`   r_   rX   )group1group2weightr   r  r  T)r>  sortc                 S   s   t | | d}|S )NrX   )r   arrayrepeat)r   r  r   r   r   r   noddy  s   z7test_gb_apply_list_of_unequal_len_arrays.<locals>.noddyc                    s    | j | jS r   )r   r  r   r  r   r   r     rP   z:test_gb_apply_list_of_unequal_len_arrays.<locals>.<lambda>)r   r&   r'   r(   )r.   
df_groupedr   r  r   (test_gb_apply_list_of_unequal_len_arrays  s   
r  c                  C   sD   t g dg dd} dd }| d|}t  }t|| d S )Nr\   )r]   rb   r_   r`   )groups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   )test_dfr  r0   r/   r   r   r   test_groupby_apply_all_none  s
   r  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@   rW   )r   r@   rW   rX   )r  varsr   c                 S   s    | j d dk r	d S | jddg S )Nr   rW   r  )r4  rN   r   r   r   r   r    s   z0test_groupby_apply_none_first.<locals>.test_funcr  r@   r   rW   rt   rX   r   )r   r'   r(   r   r  r)   r*   )	test_df1test_df2r  r   r   index1index2	expected1	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@   filledempty)r   rs   rs   c                 S   s   | | j dk d S )Nr@   r   )r   rr   r   r   r   r         z7test_groupby_apply_return_empty_chunk.<locals>.<lambda>r   rt   )r   r    )	r   r'   r(   r   r   from_productr   r)   r,   )r.   r  r0   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 br[   r_   ra   r`   r  r   Fr!   c                 S      | |    S r   r   r   r   r   r   r     r   z-test_apply_with_mixed_types.<locals>.<lambda>)gUUUUUU?gUUUUUU?r@   )皙?g333333?r7   rf   rg   c                 S   r  r   r  r   r   r   r   r     r   )r   splitr'   r  r)   r*   r(   )r.   r   r0   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 )Nr4   r@   rW   r   c                 S   r   r   r   rR  r   r   r   r   !  r   z*test_func_returns_object.<locals>.<lambda>r   )r   r   r'   r(   r   r)   r,   r{  r   r   r   test_func_returns_object  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 )NrK  rZ   r4   c                 S   s   t dgdgdS )Nspam*   r   r  r   r   r   r   r   2      z+test_apply_datetime_issue.<locals>.<lambda>r  r+   r   r  r>   r   r'   r(   r   r)   r*   )r  r.   r0   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@   rW   rX   r_   zsome UA stringzanother UA string17661101)day	userAgentuserIdc                 S   s   t dd |  D S )Nc                 S   s    i | ]\}}||  jd  qS )r   )value_countsr    )rI   rY   r-   r   r   r   
<dictcomp>W  s     zYtest_apply_series_return_dataframe_groups.<locals>.most_common_values.<locals>.<dictcomp>)r   itemsrO   r   r   r   most_common_valuesV  r  zEtest_apply_series_return_dataframe_groups.<locals>.most_common_valuesr  r  z
2015-02-24r  rF  )	r   r$   rq  r'   r(   r   DatetimeIndexr)   r,   )tdfr  r0   r/   r   r   r   )test_apply_series_return_dataframe_groups:  s6   r  r2  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}|
ddd }t|| |jjddgksjJ d S )Nr@   rW   r`   r[   )
categoriesrf   )r  r   )g      4@g      9@r*  r  r\     )rg   r   r   r[  )r   rf   rg   r   r   c                 S   r   r   r  r   r   r   r   r   s  r   z-test_apply_multi_level_name.<locals>.<lambda>)r$   CategoricalCategoricalIndexr   r   r   r,  r   r   r&   r'   r(   r)   r*   r    r   )r2  r5   expected_indexexpected_valuesr/   r.   r0   r   r   r   test_apply_multi_level_name`  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@   reddarkr   r  greenstormyrW   9i  bluebrightrX   r   i  calmr_   potato)observationcolormood	intensityscorer>   r  c                 S   rZ  ry   rM   rR  r   r   r   r     r   z;test_groupby_apply_datetime_result_dtypes.<locals>.<lambda>zdatetime64[ns]r   )r   from_recordsr$   rq  r'   r(   rR   r   r   r   r+   int64r)   r,   )r=   r0   r/   r   r   r   )test_groupby_apply_datetime_result_dtypesx  s   	r  r    abcrX   2020r   )r   freq))r4   r   )r4   r@   )r5   r   c                 C   sB   t g dg dd| d}|jddddd	 }t|| d S )
N)r@   r@   rW   )r   r@   r   rE  r   rs   Fr!   c                 S   r   r   r   r   r   r   r   r     rU   z8test_apply_index_has_complex_internals.<locals>.<lambda>r   )r    r.   r0   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     rP   c                 C   r  r   )tupler    r  r   r   r   r   r     rP   )r   r@   rW   rX   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   )rI   nir   r   r   rJ         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   rf   rf   r  r>   r   rf   r  r   r   r'   r(   r   r   r)   r,   )functionr  r.   r0   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 )Nrf   )r   flattenrr   r   r   r   fct  s   z4test_apply_function_returns_numpy_array.<locals>.fct)r4   r4   r5   noner@   rW   rX   r   r   r7   r8   r9   )r4   r5   r  r  r   )	r   r   r   r'   r(   r   r   r)   r,   )r  r.   r0   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 rL   r   r  r   r   r   r     rP   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@   rW   rW   rW   r@   rW   rX   r@   rX   r@   idr>   )r   r_   rb   rc   )r@   rW   rX   r`   ra   r]   r[   r  r   r  )r  r.   r0   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@   rW   r_   r_   r`   ra   r   r   Fr   c                 S   r   r   )r   r   r   r   r   r     r   zAtest_apply_function_with_indexing_return_column.<locals>.<lambda>)r   r   rd   )r9   r:   r:   r   r{  r   r   r   /test_apply_function_with_indexing_return_column  s   r   udfc                 C   r   r   r   r   r   r   r   r     r   c                 C   s   |   dd S )Nc                 S   s   | d S rL   r   )yr   r   r   r     r   z<lambda>.<locals>.<lambda>)rq   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 )Nr4   r5   r@   rW   r   r   r!   )r   r'   r(   rf   r   r    nlevels)r"   r  r.   	df_result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)rW   r@   rW   r[   r   r   Fr!   c                 S   r   r   r   r   r   r   r   r     rU   z4test_result_order_group_keys_false.<locals>.<lambda>c                 S   r   r   r   r   r   r   r   r     r   r   r{  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-01rW   z
2001-01-02z
2001-01-03UTC)tzrX   ra   )r   r  tr   Fr!   c                 S      | ddg   S Nr   r  r   rO   r   r   r   r     r  z1test_apply_with_timezones_aware.<locals>.<lambda>c                 S   r  r  r   rO   r   r   r   r     r  )	r$   r  r   r   r   r'   r(   r)   r*   )datesindex_no_tzindex_tzrr  rs  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}|t}t|| |jdd}t| |}t|| | }|t}t|| d S )N)c   r  r  X   r  r  )r@   rW   rX   r_   r`   ra   )r[  r\  r]  r}  r~  <   rh   i  i)     ra      r  r  r  r4   r  r   r  )	r   r   r'   r(   r   r)   r*   r
   getattr)reduction_funcr.   r/   grpr0   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)r4   r4   r4   r5   i  r@   r[  rW   r   r  )r   e   f   g   idxr  r   r   rf   c                 S   r   rL   r   r   r   r   r   r   :  r   zRtest_apply_with_date_in_multiindex_does_not_convert_to_timestamp.<locals>.<lambda>)r   rW   rX   )r   rf   r  r>   )r   r   r   r'   r(   rN   r   r   
from_framer    r   r)   r*   levelstype)r.   r  r0   r/   valr   r   r   @test_apply_with_date_in_multiindex_does_not_convert_to_timestamp(  s*   




r$  c                  C   sz   t tjddgtddgddggd} | jjddd	d
d }| jddd	dd }t	||j t	||  d S )Nra   r_   r   rf   r@   rW   r>   r   rC   r>  c                 S   s   | j dddS )Nr   r%  	droplevelr   r   r   r   r   R  rP   zDtest_apply_by_cols_equals_apply_by_rows_transposed.<locals>.<lambda>c                 S   r  )Nr@   r   r%  r&  r   r   r   r   r   T  rP   )
r   r   r   r   r  r_  r'   r(   r)   r*   )r.   by_rowsby_colsr   r   r   2test_apply_by_cols_equals_apply_by_rows_transposedF  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@   rW   rX   r_   r`   r4   r5   )colrs   xxyxzr   rs   F)r+  r"   c                 S   r   r   r   r   r   r   r   r   e  rU   z5test_apply_dropna_with_indexed_same.<locals>.<lambda>)r   rX   r@   rW   r_   )
r   r   r   r   r'   r(   r+  rN   r)   r*   )r+  r.   r0   r/   r   r   r   #test_apply_dropna_with_indexed_sameZ  s   r/  zas_index, expected)r@   r@   r@   )rW   rW   r@   )r4   r5   N)r   r   )rW   rW   r5   rt   r   c                 C   sH   t g dg dg dd}|jddg| ddd }t|| d S )	NrB  )r@   r@   r@   r@   rh   r4   r5   r   c                 S   s   dS rL   r   r   r   r   r   r   ~  rU   z5test_apply_as_index_constant_lambda.<locals>.<lambda>)r   r'   r(   r)   assert_equal)r   r/   r.   r0   r   r   r   #test_apply_as_index_constant_lambdaj  s   r1  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,  )ra   rb   r]   rc   r   )r@   r@   r@   rW   rW   r  r`   r   rg   c                 S   r  r   )r   r?  r   r   r   r   r     r   z(test_sort_index_groups.<locals>.<lambda>r@   ra   )r   r   r   r  r   rt   r   rF  )	r   r   r'   r(   r   r   r   r)   r,   r{  r   r   r   test_sort_index_groups  s   r2  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-0112Hr`   )r  r   r   )r   valsletFr!   c                 S   s   | j dd  S ry   rM   r   r   r   r   r     rP   z;test_positional_slice_groups_datetimelike.<locals>.<lambda>)r   r$   r  r   r   r'   r5  r   dtr(   r)   r*   rS   r   r   r   )test_positional_slice_groups_datetimelike  s   
r7  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)r4   r4   r5   r[   r  r  r   rf   rg   c                 S   s   |  t |   S r   )astypefloatr&  r%  r   r   r   r   r     s    z7test_groupby_apply_shape_cache_safety.<locals>.<lambda>r7   r*  r8   r  r4   r5   r  r   r  )r.   gbr0   r/   r   r   r   %test_groupby_apply_shape_cache_safety  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 )NrB  )r@   r   rW   r`   r@   rW   )r  r  zr  )r+  c                 S   s   |  ddS )Nr@   r<  )nlargest)grp_dfr   r   r   r     r   ztest_apply_na.<locals>.<lambda>c                 S   s   | j ddddS )Nr<  F)	ascendingr@   )r  r   r   r   r   r   r     r#   )r   r   r   r'   r(   r)   r*   )r+  r.   dfgrpr0   r/   r   r   r   test_apply_na  s   rA  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 )NrB  )rk  rk  rk  rk  r   r-   )unitrh   r4   r5   c                 S   rZ  Nr  rM   rO   r   r   r   r     r   z8test_apply_empty_string_nan_coerce_bug.<locals>.<lambda>r@   rk  rW   r_   )r@   rk  )rW   rk  rt   r=  )	r   r$   rp  r'   r(   r   r   r)   r*   )r0   r/   r   r   r   &test_apply_empty_string_nan_coerce_bug  s   

&rD  index_values)r7   r8   r9   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)aaa2a3r[   rZ   r   b_mean)r8   r9   r7   )rG  rH  rF  r4   r  c                 S   s   t | d  gdgdS )Nr5   rI  r   )r   r   rO   r   r   r   r     r  z0test_apply_index_key_error_bug.<locals>.<lambda>)r   r   r'   r(   r)   r*   )rE  r0   r/   r   r   r   test_apply_index_key_error_bug  s   
rJ  zarg,idx)皙?333333?皙?)rK  rM  rL  )r@   r_   rX   )rK  r  rM  c                 C   s8   t d| i|d}|jddddd }t|| d S )Nr-  r   Fr!   c                 S   r   r   r   r   r   r   r   r     rU   z5test_apply_nonmonotonic_float_index.<locals>.<lambda>r   )argr  r/   r0   r   r   r   #test_apply_nonmonotonic_float_index  s   +rO  zargs, kwargsnumeric_onlyc                 C   s>   |  d}|jdg|R i |}|jdd}t|| d S )Nr   r   T)rP  )r'   r(   r   r)   r*   )r.   r  kwargsr:  r0   r/   r   r   r   test_apply_str_with_args  s   
rR  r   	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@   rW   r  r4   Fr!   c                 S   r   r   r   r   r   r   r   r   "  rU   z1test_result_name_when_one_group.<locals>.<lambda>)r   r'   r(   r)   r,   )r   r@  r0   r/   r   r   r   test_result_name_when_one_group  s   rT  z
method, opr(   c                 C   rZ  rC  )r   r:  r   r   r   r   +  r   c                 C   s   | d j d S )Nr5   r   rM   rU  r   r   r   r   ,  rP   )aggskew)rV  prod)rV  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 )	NrZ   r4   Tr!   r5   rA   r   )r   r   r    )r   r'   r  r   r   r)   r,   )methodopempty_dfr:  rs   r0   r/   r   r   r   test_empty_df(  s   
r\  )^r   r   ior   numpyr   pytestpandasr$   r   r   r   r   r	   pandas._testing_testingr)   pandas.tests.groupbyr
   r2   rT   rV   markparametrizer   r   r   r   r   r   r   r   r   r   r   r   r   r   r	  r  r  r  r  r-  r.  r/  r7  rA  rI  rU  rt  r|  r  r  r  r  r  r  r  r  todayr   r  r  r  r  r  interval_rangeperiod_ranger   r  r  r  r  r   r  r  r  r  r$  r*  r/  r+   r1  r2  r7  r;  rA  rD  rJ  rO  rR  rT  r\  r   r   r   r   <module>   s\   )"

,
	%#


5	
&


	

	




)

	


