o
    Ti                     @   s   d Z ddlmZ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mZmZmZ ddlmZ ddlmZ G dd dZG dd	 d	ZG d
d dZG dd dZdd Zdd ZdS )zG
test where we are determining what we are grouping, or getting groups
    )date	timedeltaN)CategoricalIndex	DataFrameGrouperIndex
MultiIndexSeries	Timestamp
date_range)Groupingc                   @   sL   e Zd Zdd Zdd Zdd Zdd Zd	d
 Zdd Zdd Z	dd Z
dS )TestSelectionc                 C   s   t ddggddgd}|d}tjtdd |dg  W d    n1 s'w   Y  tjtd	d |ddg  W d    d S 1 sEw   Y  d S )
N      ABcolumnsz"Columns not found: 'C'"matchCz^[^A]+$)r   groupbypytestraisesKeyError)selfdfg r   b/var/www/html/evchargy.com/venv/lib/python3.10/site-packages/pandas/tests/groupby/test_grouping.pytest_select_bad_cols   s   
"z"TestSelection.test_select_bad_colsc                 C   s   t g dtdtddtdddgd}d}tjt|d	 |d
 W d    n1 s-w   Y  tjt|d	 |d
dg W d    n1 sKw   Y  |d}| }|jjdksaJ |jj	dksiJ d S )N)r   r   r   r      r      r      )r   dataz!Grouper for 'A' not 1-dimensionalr   r   r   r      )
r   ranger   r   
ValueErrorr   countr   Znlevelssize)r   r   msggroupedcr   r   r   'test_groupby_duplicated_column_errormsg*   s    
z5TestSelection.test_groupby_duplicated_column_errormsgc                 C   sp   | dj }| dd  }t|| d|d< | djdd}| dg d d}t|| d S )Nr   r   g      ?meanTZnumeric_only)r   Dr.   )r   r   sumtmassert_series_equalr.   aggassert_frame_equalr   r   resultexpectedr   r   r   test_column_select_via_attr;   s   z)TestSelection.test_column_select_via_attrc                 C   s   t g dg dtjddtjddtjddd}|dddg  }|d|jdd	   }|jd d g d
f d }t	
|| t	
|| d S )Nfoobarr;   r<   r;   r<   r;   r;   oner>   twothreer?   r?   r>   r@   r   r#   r   r   r   r0   Er   r   r0   r!   )r   r   r0   )r   nprandomdefault_rngstandard_normalr   r.   r   locr2   r5   r   r   r7   result2r8   r   r   r   test_getitem_list_of_columnsE   s   
 z*TestSelection.test_getitem_list_of_columnsc                 C   s   t tdd tjddtjddtjddd}|d|jdd   }|dddg  }|j	d d g d	f d }t
|| t
|| tjtd
d |dd   W d    d S 1 ssw   Y  d S )Nabcdr   r#   )r   r   r!   r"   r   r   r%   r!   r   r   r!   "Cannot subset columns with a tupler   )r   r!   )r   listrC   rD   rE   rF   r   r   r.   rG   r2   r5   r   r   r'   rH   r   r   r   !test_getitem_numeric_column_namesX   s   
 "z/TestSelection.test_getitem_numeric_column_namesc                 C   sF   t jtdd |dd   W d    d S 1 sw   Y  d S )NrM   r   r   )r   r0   )r   r   r'   r   r.   r   r   r   r   r   +test_getitem_single_tuple_of_columns_raisesn   s   "z9TestSelection.test_getitem_single_tuple_of_columns_raisesc                 C   s   t g dg dtjddtjddtjddd}|dd  }|jd d ddgf d }|jd d df }|}t	
|| d S )	Nr:   r=   r   r#   rA   r   r   r   )r   rC   rD   rE   rF   r   r.   rG   ilocr2   r3   )r   r   r7   Zas_frameZ	as_seriesr8   r   r   r   test_getitem_single_columns   s   
 z(TestSelection.test_getitem_single_columnc                    sN   t ddd dD i  d}  fdd}|j}|j}t|| d S )NTuplesc                 s   4    | ]}t jd dddD ]}||fV  qqdS r   r%      NrC   rD   rE   integers.0xyr   r   r   	<genexpr>       zJTestSelection.test_indices_grouped_by_tuple_with_lambda.<locals>.<genexpr>r   r   c                        j | df S Nr   rR   r\   r   r   r   <lambda>       zITestSelection.test_indices_grouped_by_tuple_with_lambda.<locals>.<lambda>)r   r   indicesr2   assert_dict_equalr   gbZ	gb_lambdar8   r7   r   re   r   )test_indices_grouped_by_tuple_with_lambda   s   

z7TestSelection.test_indices_grouped_by_tuple_with_lambdaN)__name__
__module____qualname__r    r-   r9   rJ   rO   rQ   rS   rl   r   r   r   r   r      s    
r   c                   @   s  e Zd Zejdejejej	ej
ejgejddd Zdd Zdd Zd	d
 Zdd Zdd Zdd Zdd Zdd Zdd Zdd Zejdg dg ddd edD gdd Zd d! Zd"d# Zd$d% Zd&d' Zd(d) Zd*d+ Zd,d- Z d.d/ Z!d0d1 Z"ejd2d3d4gd5d6 Z#d7d8 Z$ejd2d3d4gd9d: Z%d;d< Z&ejd=d3g d>gd4g d?ggd@dA Z'dBdC Z(dDdE Z)ejdFdGe*dHe+j,dIfdJe*dHe+j,e-g e+j,dKdLdMfdNe*dHe+j,e-g e+j,dKdLdMfgdOdP Z.dQdR Z/dSdT Z0dUdV Z1dWS )XTestGroupingindexz3ignore:PeriodDtype\[B\] is deprecated:FutureWarningc                 C   s|   t tdddtdd}|t||_|jtdddd	d
  tt	|j
 |_|jtddddd
  d S )N
   rW   r   ZABr   ZabcdeFZ
group_keysc                 S      | S Nr   rd   r   r   r   rf          z7TestGrouping.test_grouper_index_types.<locals>.<lambda>c                 S   rt   ru   r   rd   r   r   r   rf      rv   )r   rC   arangereshaperN   lenrq   r   applyreversedtolist)r   rq   r   r   r   r   test_grouper_index_types   s
    z%TestGrouping.test_grouper_index_typesc                 C   s   t  tdd }t|t  }tj||gddgd}ttj	d
ddd	|d
}| tdddtdddg }tdgdd|_|tdddtdddg }t|| |tdddtdddg }t|| d S )N   )daysr;   r<   namesr   r   d      rq   Wkeyfreqint64dtypelevelr   r   )r   todayr   r   r   from_productr   rC   rD   rE   rY   reset_indexr   r   r1   r   r   r2   r5   )r   Zd0datesZ
date_indexr   r8   r7   r   r   r   test_grouper_multilevel_freq   s*   z)TestGrouping.test_grouper_multilevel_freqc              	   C   st  t g dg dd}|d}| }|tdd}| }t|| d}tjt|d tddd	}W d    n1 s@w   Y  ||}| }t|| |d
d }g d|d< |j	d d ddgf }t|| t g dg dg dd}|d }|tddg}| }t|| |ddg }|tddtddg}| }t|| |dtddg}| }t|| |tdddg}| }t|| t
tjdddtjtdtdtdddgg ddd}|tddd }t
dgtjtdgddd d}t|| |td!d" }|jd!d" }t|| d S )#N)r   r   r   r   r   r   r   r   r%   r!   rW   r"   r   r   r   r   z6Grouper axis keyword is deprecated and will be removedr   r   )r   axisc                 S      |   S ru   )r1   rd   r   r   r   rf          z8TestGrouping.test_grouper_creation_bug.<locals>.<lambda>rL   r   )r   r   r   r   r   r   )r   r   r   r   r%   r%   r   r   r   r#   r   r   abr   20130101periods)r>   r?   r@   r   r   r@   Mr      z
2013-01-31)r   namer>   r   )r   r   r1   r   r2   r5   assert_produces_warningFutureWarningrz   rG   r	   rC   rw   r   r   rN   r&   r   pdDatetimeIndexr
   r3   )r   r   r   r8   r7   r*   Zgprsr   r   r   test_grouper_creation_bug   sd   

z&TestGrouping.test_grouper_creation_bugc                 C   sJ  t g d}ddg|_ttdg dd|d}|dtdd	gjd
d}|	 ddgjd
d}t
|| |tdd	dgjd
d}|	 ddgjd
d}t
|| |	d}|dtdd	gjd
d}|	 ddgjd
d}t
|| |tdd	dgjd
d}|	 ddgjd
d}t
|| d S )N)ar   )r   r   )r   r%   br   r   r   )r   r%   outerinnerr"   )r>   r>   r?   r?   r>   r>   r   r   r   r   Tr/   )r   from_tuplesr   r   rC   rw   r   r   r.   r   r2   r5   )r   idxZdf_multir7   r8   Z	df_singler   r   r   test_grouper_column_and_index  s:   

z*TestGrouping.test_grouper_column_and_indexc                 C   sv   ddg}t jg d|d}ttddd|d}|j|d	 }| | }|j	
tj|_	t|| d S )
Nr\   r]   )r   r   r   r   )r%   r!   )rW   r"   r      r%   r   r   )r   r   r   rC   rw   rx   r   r.   r   r   Zastyper   r2   r5   )r   Z	idx_namesr   r   Z	by_levelsZ
by_columnsr   r   r   test_groupby_levels_and_columnsH  s   z,TestGrouping.test_groupby_levels_and_columnsc                 C   s\  g d}ddg}t g dg dg dg dg dgt}t||dd}t||d}d}tjt|d	 |jd
d|d	 }W d    n1 sHw   Y  t ddgddgddgddgddggt}	t||dd}
t|	|
d}t
|| t|j|d}d}tjt|d	 |jdd|d	 }W d    n1 sw   Y  t|	j|
d}t
|| d S )N)r   r   r   r   r   r   )r   r   r   r   T)
categoriesordered)r$   r   +DataFrame.groupby with axis=1 is deprecatedr   r   r   )r   r   observedr!   r   r   5The 'axis' keyword in DataFrame.groupby is deprecated)r$   rq   )rC   arrayintr   r   r2   r   r   r   r1   r5   T)r   r   r   r   r$   Zcat_columnsr   depr_msgr7   Zexpected_dataZexpected_columnsr8   r*   r   r   r   *test_groupby_categorical_index_and_columnsV  s0   "*z7TestGrouping.test_groupby_categorical_index_and_columnsc              	   C   s   t dditjtdtdddgddgd	d
}|tddtdddg }t dg ditjtdtddddgddgd	d
}t	|| d S )Nr   r   r   r   P   r   r>   r?   r   r   r   r   r   )   r      r   r   r   r%   )r   r   )
r   r   r   rN   r   r   r   r1   r2   r5   r6   r   r   r   #test_grouper_getting_correct_binnerq  s&   
z0TestGrouping.test_grouper_getting_correct_binnerc                 C   s    t |djddgksJ d S )Nr   r<   r;   )sortedr   grouperrP   r   r   r   test_grouper_iter  s    zTestGrouping.test_grouper_iterc                 C   s>   t jtdd |g  W d    d S 1 sw   Y  d S )NzNo group keys passed!r   )r   r   r'   r   rP   r   r   r   test_empty_groups  s   "zTestGrouping.test_empty_groupsc                 C   s:   | d}| |jjdd}|jdd}t|| d S )Nr   Tr/   )r   r   r.   r2   r5   )r   r   r+   r7   r8   r   r   r   test_groupby_grouper  s   
z!TestGrouping.test_groupby_grouperc                 C   s   t ddi}|ddid}|dgd}t|| t g dtdd}ddd	d	d
}|| }||d}tjg dtj	d}|| }|| }t|| t|| t|| d S )NZT1rW   ZT2r1   )      ?       @g      @g      @rK   r   r   r   r   r   r,   dr.   )r   r   r   r   r   )
r	   r   r4   r2   r3   rN   r.   rC   r   r   )r   r   r7   r8   mappingrI   Zexp_keyZ	expected2r   r   r   test_groupby_dict_mapping  s   z&TestGrouping.test_groupby_dict_mappingr   r   r   r%   r   c                 C   s   g | ]
}t d dd| qS )i     r   )r
   )r[   ir   r   r   
<listcomp>  s    zTestGrouping.<listcomp>r!   c                 C   sT   |g d|d}t g d|dd}|| }|ddg}d|j_t|| d S )Nr   r   r%   r!   r   )r   r   r   r   )r   r   )rq   r   r!   r%   )r	   r   lastrq   r   r2   Zassert_equal)r   Zframe_or_seriesrq   objgroupsr7   r8   r   r   r   $test_groupby_series_named_with_tuple  s   
z1TestGrouping.test_groupby_series_named_with_tuplec                 C   s   t dddd}ttjdd|d}d}tjt|d |	d	d
  W d    n1 s/w   Y  |	dd
 
 }|	|j
 }d |j_t|| d S )Nz01-Jan-2013r   ZMSr   r   r   r   z''Timestamp' object is not subscriptabler   c                 S   s   | dd S )Nr   r"   r   r   r   r   r   rf     s    zDTestGrouping.test_groupby_grouper_f_sanity_checked.<locals>.<lambda>c                 S   rt   ru   r   rd   r   r   r   rf     rv   )r   r	   rC   rD   rE   rF   r   r   	TypeErrorr   r1   rq   r   r2   r3   )r   r   tsr*   r7   r8   r   r   r   %test_groupby_grouper_f_sanity_checked  s   z2TestGrouping.test_groupby_grouper_f_sanity_checkedc              	   C   s   t ddgd tddddd}tdd	d
}||dg}tddfddgtddfdgtddfdgtddfddgi}t|j| t|j	 dksOJ d S )Nr   r   r%   z
2000-01-01z
2000-01-03Z9Hr   )idr   r0   r   r   r   r   r   z
2000-01-02r!   rW   )
r   r   r   r   r
   r2   ri   r   ry   keys)r   r   r   rk   r8   r   r   r   test_groupby_with_datetime_key  s   
z+TestGrouping.test_groupby_with_datetime_keyc                 C   sL   d}t jt|d t|j|ddg  W d    d S 1 sw   Y  d S )NzEGrouper for '<class 'pandas.core.frame.DataFrame'>' not 1-dimensionalr   r   )r   r   r'   r   rq   r   r   r*   r   r   r   %test_grouping_error_on_multidim_input  s   "z2TestGrouping.test_grouping_error_on_multidim_inputc                 C   s   t g dg dg dg}tg d|_d}tjt|d |jdddgd	}W d    n1 s2w   Y  | }t	|| d S )
Nr   r   r%   )r!   rW   r"   )r   r#   	   )r`   r   )r   r   r   r   r   r   r   r   )
r   r   r   r   r2   r   r   r   firstr5   )r   r   r   rk   r7   r   r   r   test_multiindex_passthru  s   z%TestGrouping.test_multiindex_passthruc                 C   s   |j dd }|j dd }t|| |j dd }|j dd }t|| |j ddgd }| }t|| |j ddgd }|j ddgd }t|| d S )Nr   r   secondr   )r   r1   r2   r5   Z
sort_index)r   mframer7   r8   r   r   r   test_multiindex_negative_level  s   z+TestGrouping.test_multiindex_negative_levelc                 C   sh   t t|j|_d}tjt|d |jdddd dt j	i W d    d S 1 s-w   Y  d S )Nz7Passing a dictionary to SeriesGroupBy.agg is deprecatedr   r   FZas_indexr   Q)
rC   rw   ry   r   r2   r   r   r   r4   r.   r   r   r   r   &test_multifunc_select_col_integer_cols  s
    "z3TestGrouping.test_multifunc_select_col_integer_colsc                 C   s   ddgddgg}t |}tddgg|d}|dj}|d dgks%J |d	gj}|d dgks5J tddgd
dgg|d}|dj}|d	gj}||ksTJ tddgd
dgg|d}|dj}|d	gj}t|| d S )Nr(   values	to filter r   r   r   r   )r   r   r   r   )r   r   r   r   r   r2   ri   )r   lstZmidxr   r+   r8   r7   r   r   r   #test_multiindex_columns_empty_level  s   
z0TestGrouping.test_multiindex_columns_empty_levelc                 C   s   t g dg dg dgtg dg dgd}|dgj}|dj}t|| t |jtg dg dgd}|d	gj}|dj}t|| t |jg d
d}|d	gj}|dj}t|| d S )Nr   r%   r!   rW   r"   r   r!   r   r%   r   r   r   r,   r   r   r   r   r   r   )r   r   er   r   r   ))r   r   r   )r   r   r,   )r   r   from_arraysr   r   r2   ri   r   )r   r   r8   r7   Zdf2Zdf3r   r   r   test_groupby_multiindex_tuple#  s(   z*TestGrouping.test_groupby_multiindex_tuplec                 C   s  t g dg dg dgtg dg dgd}|dgdd	g  }|dgd
  }t|| |dgdd	g  }|dgd
  }t|| |dgdd	g  }|dgd
  }t|| |dgdd	g 	 }|dgd
 	 }	t||	 |dgdd	g 
 }
|dgd
 
 }t|
| |dgdd	g j}|dgd
 j}t|| d S )Nr   r   r   r   r   r   r   r   r   r   )r   r   r   r   r.   r2   r5   r1   r(   minmaxr   ri   )r   r   Zexpected_meanZresult_meanZexpected_sumZ
result_sumZexpected_countZresult_countZexpected_minZ
result_minZexpected_maxZ
result_maxZexpected_groupsZresult_groupsr   r   r   4test_groupby_multiindex_partial_indexing_equivalence<  s,   zATestGrouping.test_groupby_multiindex_partial_indexing_equivalencesortTFc                 C   s  |}|  }|jd|d }|jd|d }|j|d j|d }|j|d j|d }	d|j_d|	j_|jjdks@J |jjdksHJ t|| t||	 |jj|jjd ks`J |jj|jjd kslJ |jd|d }|jd|d }t|| t||	 d}
tj	t
|
d |jjdd|d	 }|jjdd|d	 }W d    n1 sw   Y  t||j t||	j d
}
tjt|
d |jdd W d    d S 1 sw   Y  d S )Nr   r   r   r   r   )r   r   r   r   )r   r   r   z2level > 0 or level < -1 only valid with MultiIndexr   )r   r   r1   r   rq   r   r2   r5   r   r   r   r   r   r   r'   )r   r   r   r   frameZ	deleveledZresult0result1Z	expected0Z	expected1r*   r   r   r   test_groupby_level[  s:   "zTestGrouping.test_groupby_levelc              	   C   s  t dgd dgd  tddd}|dv r|j}d}nd	}tjt|d
 |jd|d W d    n1 s9w   Y  d|| }t	j
t|d
/ tjt|d
 |jd|d W d    n1 sgw   Y  W d    d S W d    d S 1 sw   Y  d S )Nr   r%   r   r"   )expZvar1r  )r   r   r   r   r   )r   r   z&level name foo is not the name of the r;   )r   r&   	set_indexr   r2   r   r   r   Z_get_axis_namer   r   r'   )r   r   r   r   r*   r   r   r   test_groupby_level_index_names  s$   ""z+TestGrouping.test_groupby_level_index_namesc                 C   s   t ddgg dgg dg dgd}ttd|d}|jd|d	 }td
dgddgd}t|| t ddgg dgg dg dgd}ttd|d}|jd|d	 }td
dgddgd}t|| d S )Nr   r   r   )r   r   r   r   r   r   r   r   )r   r   r   r%   r   r   r   r%   )levelscodesg       @r   r   g      @g      6@)r   r   r   r   r   r   r   r   g      2@g        r   )r   r	   rC   rw   r   r1   r2   r3   )r   r   rq   r   r7   r8   r   r   r   test_groupby_level_with_nas  s    z(TestGrouping.test_groupby_level_with_nasc                 C   s   |}d}t jt|d |  W d    n1 sw   Y  d}t jt|d |jd d d W d    d S 1 s;w   Y  d S )Nz*You have to supply one of 'by' and 'level'r   )Zbyr   )r   r   r   r   )r   r   r  r*   r   r   r   test_groupby_args  s   
"zTestGrouping.test_groupby_argszsort,labels
r   r   r   r   r   r   r   r%   r%   r%   )
r   r   r   r   r   r   r   r%   r%   r%   c                 C   s4   |j d|d}t|tj}t|jjd | d S )Nr   r   )r   rC   r   intpr2   assert_almost_equalr   r  )r   r   labelsr   r+   
exp_labelsr   r   r   test_level_preserve_order  s   	z&TestGrouping.test_level_preserve_orderc                 C   s>   | |jd}tjg dtjd}t|jj	d | d S )Nr   r  r   )
r   rq   Zget_level_valuesrC   r   r  r2   r  r   r  )r   r   r+   r  r   r   r   test_grouping_labels  s   z!TestGrouping.test_grouping_labelsc                 C   s   t dtddddi}tj|jd< tddd}||g}td	tt	t
d
i}t|j| ||}td	di}t|j| d S )Nr   z1/1/2011im  r0   r   r   ZASr   z
2011-01-01il  )r   r   r   ZNaTrR   r   r   r
   r   rN   r&   r2   ri   r   )r   r   r   r7   r8   r   r   r   test_list_grouper_with_nat  s   
z'TestGrouping.test_list_grouper_with_natzfunc,expected	transformr   r   r   r4   r   r   r   )r   r   rq   rz   c                 C   sB   t g g d}|jddd}t|d |dd }t|| d S )Nr   r   Frs   r   c                 S   rt   ru   r   rd   r   r   r   rf     rv   z>TestGrouping.test_evaluate_with_empty_groups.<locals>.<lambda>)r   r   getattrr2   r3   )r   funcr8   r   r   r7   r   r   r   test_evaluate_with_empty_groups  s   z,TestGrouping.test_evaluate_with_empty_groupsc                 C   s   t g ddd}|g }| }|tg tjd}t|| t	|j
jdks*J t|j
jd tjg ttjd t|j
jd tjg ttjd |j
jd dksZJ ||j
jdgksfJ d S )Nr   float64r  r   r   r   r   )r	   r   r.   Zset_axisr   rC   r  r2   r3   ry   r   	groupingsZassert_numpy_array_equalZ
group_infor   r   r   )r   r   grr7   r8   r   r   r   test_groupby_empty  s   
zTestGrouping.test_groupby_emptyc                 C   s   t dtjdgd tjdggg ddddg}|jddgd }t g ttdgd	d
tg dd
gg g gddgddgdd}t	|| d S )Nr\   rr      r   r   r   r   r   objectr   r  )r  r  r   r   r   )r$   rq   r   r   )
r   rC   nanr  r   r1   r   r   r2   r5   r6   r   r   r   %test_groupby_level_index_value_all_na  s"   

z2TestGrouping.test_groupby_level_index_value_all_nac                 C   sr   t g dg dgg dd}|ddg}||jdk  }|d }t dd	gtg tjdd
d}t	|| d S )N){   r   r   )r!  r   r   )r   categoryvaluer   r   r"  r   r  r#  r  )r   r   rq   )
r   r  r#  r   r1   r   rC   r   r2   r5   )r   r   emptyr7   r8   r   r   r   #test_groupby_multiindex_level_empty&  s   z0TestGrouping.test_groupby_multiindex_level_emptyN)2rm   rn   ro   r   markZparametrizer2   ZmakeFloatIndexZmakeStringIndexZmakeIntIndexZmakeDateIndexZmakePeriodIndexfilterwarningsr}   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	   rC   r  r   r  r  r   r%  r   r   r   r   rp      s    

H.
	
)





rp   c                   @   D   e Zd Zdd Zdd Zdd Zdd Zd	d
 Zdd Zdd Z	dS )TestGetGroupc                 C   s  t tg dg dg dd}|d}tt|j}||}|t|	 }|t
t|}t|| t|| |ddg}tt|j}||}|t|d 	 |d f}|t
t|d |d f}t|| t|| d	}tjt|d
 |d W d    n1 sw   Y  tjt|d
 |d W d    n1 sw   Y  d}tjt|d
 |d W d    d S 1 sw   Y  d S )N)10-Oct-2013r*  r*  11-Oct-2013r+  r+  )r;   r;   r<   r;   r;   r<   r   )DATElabelZVALr,  r-  r   r   z<must supply a tuple to get_group with multiple grouping keysr   r;   zHmust supply a same-length tuple to get_group with multiple grouping keys)r;   r<   baz)r   r   to_datetimer   nextiterr   	get_groupr
   Zto_pydatetimestrr2   r5   r   r   r'   )r   r   r   r   r  rI   Zresult3r*   r   r   r   test_get_group;  sB   



"zTestGetGroup.test_get_groupc                 C   s   t g d}g d}|jt|d ||d}|tdd}t ddgddgd}t|| d	}tj	t
|d
 |tdd W d    d S 1 sNw   Y  d S )N)r%   r   r   r"   )r   rW   rr      r   )r   rW   r%   r   r   z"Interval\(10, 15, closed='right'\)r   rr   r5  )r   r   r   cutr2  ZIntervalr2   r5   r   r   r   )r   r   r   Zbinsr   r7   r8   r*   r   r   r   test_get_group_empty_binsj  s   "z&TestGetGroup.test_get_group_empty_binsc                 C   s   t g dgdgdj}|d}t dddgiddgd}|d}t|| tg d}t ddd	 |D i}|d}|d
}t d|d f|d fgiddgd}t|| d S )N)r   r   r8  r   Zidsr   r8  r   r   )
2010-01-01
2010-01-02r9  r:  c                 S   s   g | ]}|fqS r   r   )r[   r\   r   r   r   r     s    z@TestGetGroup.test_get_group_grouped_by_tuple.<locals>.<listcomp>)r9  )r   r   r   r2  r2   r5   r   r/  )r   r   r  r8   r7   dtr   r   r   test_get_group_grouped_by_tupley  s   



$z,TestGetGroup.test_get_group_grouped_by_tuplec                    sr   t ddd dD i  d}  fdd}|tt|j }|tt|j }t|| d S )NrT   c                 s   rU   rV   rX   rZ   r   r   r   r^     r_   zKTestGetGroup.test_get_group_grouped_by_tuple_with_lambda.<locals>.<genexpr>r`   c                    ra   rb   rc   rd   re   r   r   rf     rg   zJTestGetGroup.test_get_group_grouped_by_tuple_with_lambda.<locals>.<lambda>)	r   r   r2  r0  r1  r   r   r2   r5   rj   r   re   r   +test_get_group_grouped_by_tuple_with_lambda  s   

z8TestGetGroup.test_get_group_grouped_by_tuple_with_lambdac                 C   sJ   t d}d}t||td}tdd}||}tt|d d u s#J d S )Nr   r   r0   r   )r   r   r	   r  r   r   r0  r1  )r   rq   r$   Zseriesr   r+   r   r   r   test_groupby_with_empty  s   


z$TestGetGroup.test_groupby_with_emptyc                 C   s   t dtdi}t|dd|jddg  t tg dddg d}t|d | t|d	 | |jg d }t|d
d	| d S )
Nr   Zabssbabr   rW   )r   r   r   )r   )rq   r   r%   r!   rW   r   )r   rN   r2   r5   r   r2  rR   r   r(   r1   Znth)r   r   r  r   r   r   test_groupby_with_single_column  s   "z,TestGetGroup.test_groupby_with_single_columnc                 C   sj   t g dg dg dgg dd}|ddg}|g d }|jd	 d
ks*J |jd dks3J d S )N)r;   r<   r   r   )r;   r<   r   r   )r;   r.  r   r%   )r   r   thirdr>   r   r   r   )r   r   rA  )r;   r<   r   r   )r;   r.  r   r   )r   r  r   r)   rG   rP   r   r   r   test_gb_key_len_equal_axis_len  s   z+TestGetGroup.test_gb_key_len_equal_axis_lenN)
rm   rn   ro   r4  r7  r<  r=  r>  r@  rB  r   r   r   r   r)  :  s    /r)  c                   @   r(  )TestIterationc                 C   s   | dg}|j}||ju sJ |j D ]\}}|j| d |k s&J q| ddg}|j}||ju s8J |j D ]"\}}|j| d |d k sPJ |j| d |d k s_J q=d S )Nr   r   r   r   )r   r   itemsrG   all)r   r   r+   r   kvr   r   r   test_groups  s    zTestIteration.test_groupsc                 C   s,   | dd dd g}|jjd D ]}qd S )Nc                 S   r   ru   )weekdayrd   r   r   r   rf     r   z9TestIteration.test_grouping_is_iterable.<locals>.<lambda>c                 S   s   | j S ru   )yearrd   r   r   r   rf     s    r   )r   r   r  )r   Ztsframer+   r   r   r   r   test_grouping_is_iterable  s   z'TestIteration.test_grouping_is_iterablec                 C   s   t td}tg d}tg d}|||g}t|}dd|ddg fdd|d	g fd
d|dg fd
d|ddg fg}t|D ]!\}\\}}	}
|| \}}}||ksYJ ||	ks_J t|
| qDd S )Nr"   )r   r   r   r   r   r   12rM  rN  rM  rN  r   rM  r   r   rN  r   r   r!   r%   rW   )	r	   rC   rw   r   r   rN   	enumerater2   r3   )r   r   k1k2r+   iteratedr8   r   r>   r?   r@   e1e2e3r   r   r   test_multi_iter  s    zTestIteration.test_multi_iterc                 C   s  t g d}t g d}tt jddt jdd||dg dd}|dd	g}t|}|j}d
d|j	|dg  fd
d|j	|ddg  fdd|j	|ddg  fdd|j	|dg  fg}t
|D ]!\}	\\}
}}||	 \}}}||
ks|J ||ksJ t|| qgt g d|d< t g d|d	< |dd	g}dd |D }t|dksJ |g d }d}tjt|d |jjddd}W d    n1 sw   Y  |D ]\}}qd S )N)r   r   r   r   r   r   rL  r   r"   )Zv1Zv2rP  rQ  )r>   r?   r@   fourfivesixr   rP  rQ  r   rM  r!   rN  r%   rW   r   r   r   )rM  rM  rM  rN  rN  rN  c                 S   s   i | ]\}}||qS r   r   )r[   r   gpr   r   r   
<dictcomp>  s    z7TestIteration.test_multi_iter_frame.<locals>.<dictcomp>r   r   r   r   r   )rC   r   r   rD   rE   rF   r   rN   rq   rG   rO  r2   r5   ry   r.   r   r   r   )r   Zthree_grouprP  rQ  r   r+   rR  r   r8   r   r>   r?   r@   rS  rT  rU  r   Zthree_levelsr   r   groupr   r   r   test_multi_iter_frame  sH   
z#TestIteration.test_multi_iter_framec                 C   s   t t|d t t|ddg t t|d |d  t t|d |d |d g t t|dd  t t|ddgd  d S )Nr   r   r   )dictr1  r   rP   r   r   r   test_dictify  s   "zTestIteration.test_dictifyc                 C   s  t ddgddgdtddgd}|tdd	d
g}t|jdks%J |jdks,J tddf|jv s7J tddf|jv sBJ |	tddf}t
||jdgd d f  |	tddf}t
||jdgd d f  t g dg ddtg dd}|tdd	d
g}t|jdksJ |jdksJ tddf|jv sJ tddf|jv sJ |	tddf}t
||jddgd d f  |	tddf}t
||jdgd d f  t g dg ddtg dd}|tdd	d
g}t|jdksJ |jdksJ tddf|jv sJ tddf|jv s'J tddf|jv s3J |	tddf}t
||jdgd d f  |	tddf}t
||jdgd d f  |	tddf}t
||jdgd d f  d S )Nstart  .  )eventZchange
2014-09-10
2013-10-10r   r   r   rc  r   z
2014-09-30z
2013-10-31r   r   )r`  r`  r`  )ra  rb  i#  )rd  re  z
2014-09-15)rd  re  z
2014-08-05r%   z
2014-08-31)r   r   r   r   r   ry   r   Zngroupsr
   r2  r2   r5   rR   )r   r   r+   resr   r   r   test_groupby_with_small_elem'  sT    z*TestIteration.test_groupby_with_small_elemc                 C   sZ   t tdtdg}tg dg|d}||d }|jjd  }d}||ks+J d S )NZAABZabar   r   )r   r   r   zGrouping(('A', 'a')))r   r   rN   r   r   r   r  __repr__)r   mir   r  r7   r8   r   r   r   test_grouping_string_repr[  s   z'TestIteration.test_grouping_string_reprN)
rm   rn   ro   rH  rK  rV  r]  r_  rg  rj  r   r   r   r   rC    s    	04rC  c                  C   s   t g dg dg ddd} | jtddtddgdd	}|jjd
 jr)J |jjd js2J d}tjt	|d |
 }W d    n1 sJw   Y  t ddgddgd}t|| d S )N)r   r   r   r?  )r   r   r,   r   r   r   r   Fr   r   r   z*A grouping .* was excluded from the resultr   r   r   rW   )r   r,   )r   r  r   r   r   r  Zin_axisr2   r   r   r1   r5   )r   rk   r*   r7   r8   r   r   r   test_grouping_by_key_is_in_axisf  s   "
rk  c                  C   sn  t g ddd} tdd}| |}d}tjt|d |j}W d    n1 s*w   Y  ||ju s6J d}tjt|d |j}W d    n1 sMw   Y  ||ju sYJ d	}tjt|d |j}W d    n1 spw   Y  ||ju s|J d
}tjt|d |j	 W d    n1 sw   Y  d}tjt|d |j
 W d    d S 1 sw   Y  d S )Nr   r   )r   r   r   r   zUse GroupBy.groups insteadr   zUse GroupBy.grouper insteadz-Grouper.obj is deprecated and will be removedzUse Resampler.ax insteadzGrouper.indexer is deprecated)r   r   r   r2   r   r   r   r   r   axZindexer)r   Zgrperrk   r*   rf  r   r   r   test_grouper_groupsv  s4   

"rm  )__doc__datetimer   r   numpyrC   r   Zpandasr   r   r   r   r   r   r	   r
   r   Zpandas._testingZ_testingr2   Zpandas.core.groupby.grouperr   r   rp   r)  rC  rk  rm  r   r   r   r   <module>   s,    (
         &