U
    f/e/                     @   s   d 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 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S )zG test where we are determining what we are grouping, or getting groups     N)CategoricalIndex	DataFrame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   sn   t ddggddgd}|d}tjtdd |dg  W 5 Q R X tjtd	d |ddg  W 5 Q R X d S )
N      ABcolumnsz"Columns not found: 'C'"matchCz^[^A]+$)r   groupbypytestraisesKeyError)selfdfg r   F/tmp/pip-unpacked-wheel-tiezk1ph/pandas/tests/groupby/test_grouping.pytest_select_bad_cols   s    
z"TestSelection.test_select_bad_colsc              	   C   s   t ddddgtdtddtdddgd	}d
}tjt|d |d W 5 Q R X tjt|d |ddg W 5 Q R X |d}| }|jjdkst	|jj
dkst	d S )Nr   r   r      r      r      )r   dataz!Grouper for 'A' not 1-dimensionalr   r      )r   ranger   r   
ValueErrorr   countr   ZnlevelsAssertionErrorsize)r   r   msggroupedcr   r   r   'test_groupby_duplicated_column_errormsg#   s    
 
z5TestSelection.test_groupby_duplicated_column_errormsgc                 C   sf   | dj }| dd  }t|| d|d< | d }| dtj}t|| d S )Nr   r   g      ?mean)	r   r   sumtmassert_series_equalr,   aggnpassert_frame_equalr   r   resultexpectedr   r   r   test_column_select_via_attr4   s    z)TestSelection.test_column_select_via_attrc              
   C   s   t ddddddddgddddddddgtjdtjdtjdd}|dd	d
g  }|d|jdd   }|jd d dd	d
gf d }t	|| t	|| d S )Nfoobaronetwothreer    r   r   r   DEr   r   r=   r   r   )
r   r1   randomrandnr   r,   r   locr.   r2   r   r   r4   result2r5   r   r   r   test_getitem_list_of_columns>   s    



"z*TestSelection.test_getitem_list_of_columnsc              	   C   s   t tdd tjdtjdtjdd}|d|jdd   }|dddg  }|jd d dddgf d }t	
|| t	
|| t	t |dd	   W 5 Q R X d S )
Nabcdr   r    )r   r   r   r   r   r   r"   r   )r   r   )r   listr1   r?   r@   r   r   r,   rA   r.   r2   assert_produces_warningFutureWarningrB   r   r   r   !test_getitem_numeric_column_namesQ   s    



"z/TestSelection.test_getitem_numeric_column_namesc              	   C   s,   t t |dd   W 5 Q R X d S )Nr   )r   r=   )r.   rG   rH   r   r,   r   r   r   r   r   #test_getitem_single_list_of_columnsg   s    z1TestSelection.test_getitem_single_list_of_columnsc              
   C   s   t ddddddddgddddddddgtjdtjdtjdd}|dd	  }|jd d dd	gf d }|jd d d
f }|}t	|| d S )Nr7   r8   r9   r:   r;   r    r<   r   r   r   )
r   r1   r?   r@   r   r,   rA   ilocr.   r/   )r   r   r4   Zas_frameZ	as_seriesr5   r   r   r   test_getitem_single_columnl   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   s,   | ]$}t jd ddD ]}||fV  qqdS r"      Nr1   r?   randint.0xyr   r   r   	<genexpr>   s       zJTestSelection.test_indices_grouped_by_tuple_with_lambda.<locals>.<genexpr>r   r   c                    s    j | df S Nr   rL   rU   r   r   r   <lambda>       zITestSelection.test_indices_grouped_by_tuple_with_lambda.<locals>.<lambda>)r   r   indicesr.   assert_dict_equalr   gbZ	gb_lambdar5   r4   r   r\   r   )test_indices_grouped_by_tuple_with_lambda   s    
z7TestSelection.test_indices_grouped_by_tuple_with_lambdaN)__name__
__module____qualname__r   r+   r6   rD   rI   rK   rM   rc   r   r   r   r   r
      s   
r
   c                   @   s  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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%d&d'gd(d) Zd*d+ Zejd%d&d'gd,d- Zd.d/ Zejd0d&d1d1d1d2d2d3d3d4d4d4g
gd'd2d2d2d3d3d1d1d4d4d4g
ggd5d6 Zd7d8 Zd9d: Zejd;d<ed1e j!e"g d=fd>ed1e j!e#j$g d3d?d=fd@ed1e j!e#j$g d3d?d=fgdAdB Z%dCdD Z&dEdF Z'dGdH Z(dIS )JTestGroupingc                 C   s   t tdddtdd}tjtjtjtj	tj
tjfD ]V}|t||_|tddd  tt|j |_|tdd	d  q:d S )
N
   rP   r   ZABr   Zabcdec                 S   s   | S Nr   r[   r   r   r   r]      r^   z7TestGrouping.test_grouper_index_types.<locals>.<lambda>c                 S   s   | S ri   r   r[   r   r   r   r]      r^   )r   r1   arangereshaperF   r.   ZmakeFloatIndexZmakeStringIndexZmakeUnicodeIndexZmakeIntIndexZmakeDateIndexZmakePeriodIndexlenindexr   applyreversedtolist)r   r   rm   r   r   r   test_grouper_index_types   s    	z%TestGrouping.test_grouper_index_typesc           	      C   s   ddl m}m} | |dd }t|| }tj||gddgd}ttj	
ddd	|d
}| tjdddtjdddg }tdgdd|_|tjdddtjdddg }t|| |tjdddtjdddg }t|| d S )Nr   )date	timedelta   )daysr7   r8   namesd      rm   Wkeyfreqint64dtypelevelr~   r   )datetimerr   rs   todayr   r   from_productr   r1   r?   rR   reset_indexr   pdGrouperr-   r   r   r.   r2   )	r   rr   rs   Zd0datesZ
date_indexr   r5   r4   r   r   r   test_grouper_multilevel_freq   s$    z)TestGrouping.test_grouper_multilevel_freqc              	   C   s|  t ddddddgddddddgd}|d	}| }|tjd	d
}| }t|| |tjd	dd}| }t|| |dd }dddg|d	< |jd d d	dgf }t|| t ddddddgddddddgddddddgd}|d	 }|tjd	d
g}| }t|| |d	dg }|tjd	d
tjdd
g}| }t|| |d	tjdd
g}| }t|| |tjd	d
dg}| }t|| t	t
jdddtjtdtdtdddgdddgdd}|tjddd }t	dgtjtdgdddd}t|| |tjdd  }|jdd  }t|| d S )!Nr   r   r   r"   r   rP   r   r   r   r   r}   )r}   axisc                 S   s   |   S ri   )r-   r[   r   r   r   r]      r^   z8TestGrouping.test_grouper_creation_bug.<locals>.<lambda>r   )r   r   r   r    r   r   ab20130101periodsr9   r:   r;   rv   rz   Mr      z
2013-01-31)r~   namer   )r   r   r-   r   r   r.   r2   rn   rA   r   r1   rj   r   r   rF   r#   r   DatetimeIndexr   r/   )r   r   r   r5   r4   sr   r   r   test_grouper_creation_bug   s\    &
.z&TestGrouping.test_grouper_creation_bugc                 C   sB  t ddddddg}ddg|_ttd	d
d
ddd
d
gd|d}|dtjddg	 }|
 ddg	 }t|| |tjdddg	 }|
 ddg	 }t|| |
d}|dtjddg	 }|
 ddg	 }t|| |tjdddg	 }|
 ddg	 }t|| d S )N)ar   )r   r   )r   r"   br   )r   r   )r   r"   outerinnerr   r9   r:   r   rz   r   r   )r   from_tuplesrw   r   r1   rj   r   r   r   r,   r   r.   r2   )r   idxZdf_multir4   r5   Z	df_singler   r   r   test_grouper_column_and_index  s*    

z*TestGrouping.test_grouper_column_and_indexc                 C   sz   ddg}t jddddg|d}ttdd	d
|d}|j|d }| | }|j	
tj|_	t|| d S )NrU   rV   r   r   r   r   )r"   r   )rP   r   rv      r"   rz   r   )r   r   r   r1   rj   rk   r   r,   r   r   Zastyper   r.   r2   )r   Z	idx_namesr   r   Z	by_levelsZ
by_columnsr   r   r   test_groupby_levels_and_columns0  s    z,TestGrouping.test_groupby_levels_and_columnsc              
   C   s  ddddg}ddg}t ddddgddddgddddgddddgddddggt}t||dd}t||d}|jdd|d	 }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}|jdd|d	 }t|j	|	d}
t||
 d S )Nr   r   r   r   T)
categoriesZordered)r!   r   r   )r   r   observedr   rz   )r!   rm   )
r1   arrayintr   r   r   r-   r.   r2   T)r   r   r   r   r!   Zcat_columnsr   r4   Zexpected_dataZexpected_columnsr5   r   r   r   *test_groupby_categorical_index_and_columns>  s*    4 *  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jddtjdddg }t dddddddg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   r9   r:   rv   rz   r   r   r      r      r"   )r~   r   )r   r   r   rF   r   r   r   r   r-   r.   r2   r3   r   r   r   #test_grouper_getting_correct_binnerU  s$     z0TestGrouping.test_grouper_getting_correct_binnerc                 C   s    t |djddgkstd S )Nr   r8   r7   )sortedr   grouperr&   rJ   r   r   r   test_grouper_iterl  s    zTestGrouping.test_grouper_iterc              	   C   s(   t jtdd |g  W 5 Q R X d S )NzNo group keys passed!r   )r   r   r$   r   rJ   r   r   r   test_empty_groupso  s    zTestGrouping.test_empty_groupsc                 C   s2   | d}| |j }| }t|| d S )Nr   )r   r   r,   r.   r2   )r   r   r)   r4   r5   r   r   r   test_groupby_groupert  s    
z!TestGrouping.test_groupby_grouperc                 C   s   ddl m} |ddi}|ddit}|dgt}t|| |dddd	gtd
d}ddddd}|| }||t	j}|ddddg }|ddddg }t|| t|| t|| d S )Nr   )r   ZT1rP   ZT2      ?       @g      @g      @rE   rz   r   )r   r   r*   d)
pandasr   r   r0   r-   r.   r/   rF   r,   r1   )r   r   r   r4   r5   mappingrC   Z	expected2r   r   r   test_groupby_dict_mapping{  s    z&TestGrouping.test_groupby_dict_mappingc              	   C   sR   t dddd}ttjd|d}d}tjt|d |dd	  W 5 Q R X d S )
Nz01-Jan-2013r   ZMSr   r~   rz   z4Grouper result violates len\(labels\) == len\(data\)r   c                 S   s   | dd S )Nr   r   r   r   r   r   r   r]     r^   zDTestGrouping.test_groupby_grouper_f_sanity_checked.<locals>.<lambda>)	r   r   r1   r?   r@   r   r   r&   r   )r   r   tsr(   r   r   r   %test_groupby_grouper_f_sanity_checked  s
    z2TestGrouping.test_groupby_grouper_f_sanity_checkedc              	   C   s6   d}t jt|d t|j|ddg  W 5 Q R X d S )NzEGrouper for '<class 'pandas.core.frame.DataFrame'>' not 1-dimensionalr   r   )r   r   r$   r	   rm   )r   r   r(   r   r   r   %test_grouping_error_on_multidim_input  s    z2TestGrouping.test_grouping_error_on_multidim_inputc                 C   sX   t dddgdddgddd	gg}td
ddg|_|jdddgd }t|| d S )Nr   r   r"   r   rP   r      r    	   rX   r   )r   r   r   r   r   )r   r   r   r   r   firstr.   r2   )r   r   r4   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   r-   r.   r2   )r   mframer4   r5   r   r   r   test_multiindex_negative_level  s    z+TestGrouping.test_multiindex_negative_levelc                 C   s4   t t|j|_|jdddd dt ji d S )Nr   F)Zas_indexr   Q)r1   rj   rl   r   r   r0   r,   rJ   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sJt|d	gj}|d dgksjttddgd
dgg|d}|dj}|d	gj}||kst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   groupsr&   r.   r`   )r   lstZmidxr   r)   r5   r4   r   r   r   #test_multiindex_columns_empty_level  s    
z0TestGrouping.test_multiindex_columns_empty_levelc              	   C   s   t ddddgddddgddddggtdddd	gddddggd
}|dgj}|dj}t|| t |jtdddd	gddddggd
}|dgj}|dj}t|| t |jdddd	gd
}|dgj}|dj}t|| d S )Nr   r   r"   r   rP   r   r   r   r*   r   r   r   e)r   r   )r   r   )r   r   )r   r   from_arraysr   r   r.   r`   r   )r   r   r5   r4   Zdf2Zdf3r   r   r   test_groupby_multiindex_tuple  s(     z*TestGrouping.test_groupby_multiindex_tuple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st|jjdkstt|| t||	 |jj|jj	d kst|jj|jj	d kst|jd|d }|jd|d }t|| t||	 |j
jdd|d }|j
jdd|d }t||j
 t||	j
 d}
tjt|
d	 |jdd
 W 5 Q R X d S )Nr   r   r   r   r   )r   r   )r   r   r   z2level > 0 or level < -1 only valid with MultiIndexr   r   )r   r   r-   r   rm   r   r&   r.   r2   rw   r   r   r   r$   )r   r   r   r   frameZ	deleveledZresult0result1Z	expected0Z	expected1r(   r   r   r   test_groupby_level  s2    zTestGrouping.test_groupby_levelc              	   C   s   t dgd dgd  tddd}|dkr6|j}|jd|d d	|| }tjt|d
 |jd|d W 5 Q R X d S )Nr   r"   r   r   )expZvar1r   )r   r   )r   r   z&level name foo is not the name of the r   r7   )	r   r#   	set_indexr   r   Z_get_axis_namer   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ddddggddddddddgddddddddggd}ttd|d}|jd|d }td	d
gddgd}t|| t ddgddddggddddddddgddddddddggd}ttd|d}|jd|d }td	dgddgd}t|| d S )Nr   r   r   r"   )levelscodesg       @rz   r   g      @g      6@r   g      2@g        r   )r   r   r1   rj   r   r-   r.   r/   )r   r   rm   r   r4   r5   r   r   r   test_groupby_level_with_nas-  s     &&z(TestGrouping.test_groupby_level_with_nasc              	   C   sZ   |}d}t jt|d |  W 5 Q R X d}t jt|d |jd d d W 5 Q R X d S )Nz*You have to supply one of 'by' and 'level'r   )Zbyr   )r   r   	TypeErrorr   )r   r   r   r(   r   r   r   test_groupby_argsF  s    zTestGrouping.test_groupby_argszsort,labelsr   r   r   r"   c                 C   s4   |j d|d}t|tj}t|jjd | d S )Nr   r   )r   r1   r   intpr.   assert_almost_equalr   r   )r   r   labelsr   r)   
exp_labelsr   r   r   test_level_preserve_orderR  s    	z&TestGrouping.test_level_preserve_orderc                 C   sN   | |jd}tjddddddddddg
tjd}t|jj	d | d S )Nr   r   r   r"   r   )
r   rm   Zget_level_valuesr1   r   r   r.   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jddd}||g}td	tt	t
d
i}t|j| ||}td	di}t|j| d S )Nrr   z1/1/2011im  r=   r   r   ZASr|   z
2011-01-01il  )r   r   r   ZNaTrL   r   r   r   r   rF   r#   r.   r`   r   )r   r   r   r4   r5   r   r   r   test_list_grouper_with_natd  s    
z'TestGrouping.test_list_grouper_with_natzfunc,expectedZ	transform)r   r   rm   r0   r   rn   c                 C   s>   t g g d}|d}t|d |dd }t|| d S )Nr   r   r   c                 S   s   | S ri   r   r[   r   r   r   r]     r^   z>TestGrouping.test_evaluate_with_empty_groups.<locals>.<lambda>)r   r   getattrr.   r/   )r   funcr5   r   r   r4   r   r   r   test_evaluate_with_empty_groupst  s    
z,TestGrouping.test_evaluate_with_empty_groupsc                 C   s   t g ddd}|g }| }t|| t|jjdks@tt	|jj
d tjg ttjd t	|jj
d tjg tdd |jj
d dkst||jjdgkstd S )	Nr   float64)r   r   r   r   r   r   r   )r   r   r,   r.   r/   rl   r   	groupingsr&   Zassert_numpy_array_equalZ
group_infor1   r   r   r   rw   )r   r   grr4   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dddg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 )NrU   rh      r   r   r   r   r   objectr   r   )r   r   rw   r   )r!   rm   r   r   )
r   r1   nanr   r   r-   r   r   r.   r2   r3   r   r   r   %test_groupby_level_index_value_all_na  s$     
z2TestGrouping.test_groupby_level_index_value_all_nac                 C   sv   t dddgdddggdddgd	}|ddg}||jd
k  }|d }t ddgtjg ddd}t|| d S )N{   r   r   r   r   idcategoryvaluer   r   r   r   )r   r   rm   )	r   r   r   r   r-   r   Z
Int64Indexr.   r2   )r   r   emptyr4   r5   r   r   r   #test_groupby_multiindex_level_empty  s       z0TestGrouping.test_groupby_multiindex_level_emptyN))rd   re   rf   rq   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   markZparametrizer   r   r   r   r   r   r   r   r1   r   r   r   ZFloat64Indexr   r   r   r   r   r   r   r   rg      sd   "F"

(



rg   c                   @   sD   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ddddddgddddddgddddd	d
gd}|d}t|jd }||}|t| }|t	t|}t
|| t
|| |ddg}t|jd }||}|t|d  |d f}|t	t|d |d f}t
|| t
|| d}tjt|d |d W 5 Q R X tjt|d |d W 5 Q R X d}tjt|d |d W 5 Q R X d S )Nz10-Oct-2013z11-Oct-2013r7   r8   r   r   r"   r   rP   r   )DATElabelZVALr   r   r   z<must supply a tuple to get_group with multiple grouping keysr   zHmust supply a same-length tuple to get_group with multiple grouping keys)r7   r8   baz)r   r   to_datetimer   rF   r   	get_groupr   Zto_pydatetimestrr.   r2   r   r   r$   )r   r   r   r}   r   rC   Zresult3r(   r   r   r   test_get_group  sH    



zTestGetGroup.test_get_groupc              	   C   s   t ddddg}ddddg}|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 5 Q R X d S )Nr"   r   r   r   r   rP   rh      )r   rz   z"Interval\(10, 15, closed='right'\)r   )r   r   r   Zcutr   ZIntervalr.   r2   r   r   r   )r   r   r   Zbinsr   r4   r5   r(   r   r   r   test_get_group_empty_bins  s    z&TestGetGroup.test_get_group_empty_binsc                 C   s   t ddddggdgdj}|d}t dddgiddgd}|d}t|| tddddg}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   idsrz   r   r   
2010-01-01z
2010-01-02c                 S   s   g | ]
}|fqS r   r   )rT   rU   r   r   r   
<listcomp>  s     z@TestGetGroup.test_get_group_grouped_by_tuple.<locals>.<listcomp>)r  )r   r   r   r   r.   r2   r   r   )r   r   r   r5   r4   dtr   r   r   test_get_group_grouped_by_tuple
  s    



$z,TestGetGroup.test_get_group_grouped_by_tuplec                    sr   t ddd dD i  d}  fdd}|t|j d }|t|j d }t|| d S )NrN   c                 s   s,   | ]$}t jd ddD ]}||fV  qqdS rO   rQ   rS   r   r   r   rW     s       zKTestGetGroup.test_get_group_grouped_by_tuple_with_lambda.<locals>.<genexpr>rX   c                    s    j | df S rY   rZ   r[   r\   r   r   r]      r^   zJTestGetGroup.test_get_group_grouped_by_tuple_with_lambda.<locals>.<lambda>r   )r   r   r   rF   r   keysr.   r2   ra   r   r\   r   +test_get_group_grouped_by_tuple_with_lambda  s    
z8TestGetGroup.test_get_group_grouped_by_tuple_with_lambdac                 C   sL   t d}d}t||td}t jdd}||}tt|d d ksHtd S )Nr   r   r=   r~   )	r   r   r   r   r   r   nextiterr&   )r   rm   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dddgddd}t|d | t|d	 | t|d
d	| d S )
Nr   Zabssbabr   rP   r   r   r   rz   r   )r   rF   r.   r2   r   r   rL   r   r%   r-   Znth)r   r   r   r   r   r   test_groupby_with_single_column/  s    "z,TestGetGroup.test_groupby_with_single_columnc                 C   s|   t ddddgddddgddddggd	d
ddgd}|d	d
g}|d	d
dg }|jd dksft|jd dksxtd S )Nr7   r8   r   r   r   r   r   r"   r   r   thirdr9   r   )r7   r8   r   )r7   r   r   )r   r   r   r'   rA   r&   rJ   r   r   r   test_gb_key_len_equal_axis_len8  s     
z+TestGetGroup.test_gb_key_len_equal_axis_lenN)
rd   re   rf   r  r  r	  r  r  r  r  r   r   r   r   r     s   /	r   c                   @   sD   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 )TestIterationc                 C   s   | dg}|j}||jks t|j D ]"\}}|j| d |k s*tq*| ddg}|j}||jkspt|j D ]D\}}|j| d |d k st|j| d |d k sztqzd S )Nr   r   r   r   )r   r   r&   itemsrA   all)r   r   r)   r   kvr   r   r   test_groupsK  s    zTestIteration.test_groupsc                 C   s,   | dd dd g}|jjd D ]}q"d S )Nc                 S   s   |   S ri   )weekdayr[   r   r   r   r]   ^  r^   z9TestIteration.test_grouping_is_iterable.<locals>.<lambda>c                 S   s   | j S ri   )yearr[   r   r   r   r]   ^  r^   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ddddddg}tddddddg}|||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 ]B\}\\}}	}
|| \}}}||kst||	kstt	|
| qd S )Nr   r   r   12r   r   r   r   r"   rP   )
r   r1   rj   r   r   rF   	enumerater&   r.   r/   )r   r   k1k2r)   iteratedr5   ir9   r:   r;   e1e2e3r   r   r   test_multi_iterd  s    zTestIteration.test_multi_iterc                 C   s  t ddddddg}t ddddddg}tt jdt jd||dddd	d
ddg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 ]F\}	\\}
}}||	 \}}}||
kst
||kst
t|| qt ddddddg|d< t ddddddg|d< |ddg}dd |D }t|dkst
|dddg }|jjddd}|D ]
\}}qd S )Nr   r   r  r  r   )Zv1Zv2r  r   r9   r:   r;   ZfourZfivesixrz   r  r   r   r"   rP   r   r   r   c                 S   s   i | ]\}}||qS r   r   )rT   r}   Zgpr   r   r   
<dictcomp>  s      z7TestIteration.test_multi_iter_frame.<locals>.<dictcomp>r   r   r   r   r   )r1   r   r   r?   r@   r   rF   rm   rA   r  r&   r.   r2   rl   r,   r   )r   Zthree_groupr  r   r   r)   r!  r   r5   r"  r9   r:   r;   r#  r$  r%  r   Zthree_levelsr}   groupr   r   r   test_multi_iter_framex  s8    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   )dictr  r   rJ   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jdd	d
g}t|jdksLt|jdksZtt	ddf|jksptt	ddf|jkst|
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dgdddgdtdddgd}|tjdd	d
g}t|jdks6t|jdksFtt	ddf|jks^tt	ddf|jksvt|
t	ddf}t||jddgd d f  |
t	ddf}t||jdgd d f  t dddgdddgdtdddgd}|tjdd	d
g}t|jdks(t|jdks8tt	ddf|jksPtt	ddf|jkshtt	ddf|jkst|
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starti  i.  )eventZchangez
2014-09-10z
2013-10-10rz   r   r  r.  r   z
2014-09-30z
2013-10-31r   r   i#  z
2014-09-15z
2014-08-05r"   z
2014-08-31)r   r   r   r   r   rl   r   r&   Zngroupsr   r   r.   r2   rL   )r   r   r)   resr   r   r   test_groupby_with_small_elem  sT    z*TestIteration.test_groupby_with_small_elemc                 C   s\   t tdtdg}tdddgg|d}||d }|jjd  }d	}||ksXtd S )
NZAABZabar   r   r"   r   )r   r   r   zGrouping(('A', 'a')))	r   r   rF   r   r   r   r   __repr__r&   )r   mir   r   r4   r5   r   r   r   test_grouping_string_repr  s    z'TestIteration.test_grouping_string_reprN)
rd   re   rf   r  r  r&  r*  r,  r0  r3  r   r   r   r   r  J  s   	&4r  )__doc__Znumpyr1   r   r   r   r   r   r   r   r   r   r   Zpandas._testingZ_testingr.   Zpandas.core.groupby.grouperr	   r
   rg   r   r  r   r   r   r   <module>   s   $	{    < 