o թZhV@sddlZddlZddlZddlZddlmZmZmZm Z ddl m Z ddl mZejddgddgeddddgd egd eeed gd e gd e gd e gd gg d ddZejddgd ddZejddZejddZejddZejddZd>ddZejdgd d!d"Zejdd#d$gd%d&Zejdd#d$gejd'ejej gd(d)Z!ejdgd d*d+Z"ejdd#d$gd,d-Z#ejdd#d$gejd'ejej gd.d/Z$ejd0gd1d2d3Z%ejdgd d4d5Z&ejdd#d$gd6d7Z'ejdd#d$gejd'ejej gd8d9Z(ejdgd d:d;Z)dsr) rrrr r r r rrrrrr r r r rrrrrrrr)paramscC|jSNparamrequestr r rbysrTFcCrrrrr r rgroupby_series'srcCs&tgdgdtdtdd}|S)NrrrZ xyzwtyuiorrcd)rrangelistdfr r rdf_with_string_col,sr&c Cs4tgdgdtdtddddddd d }|S) Nrrrir i`=r)rr"datetimer$r r rdf_with_datetime_col9sr+cCs*tgdgdtdtjddd}|S)Nrrrr)daysr)rr"r* timedeltar$r r rdf_with_timedelta_colFs r.c Cs4tgdgdtdtgdgdddd}|S)Nrrr rrrrrrrrr rT categoriesZordered)rr"rr$r r rdf_with_cat_colSs r2c CsH|dkrdnt}tj||d|dur8|dkr t|||nb|dkr.|j|g|Rn\|j|g|RnBtj||d+|dkrLt|||n|dkrZ|j|g|Rn |j|g|RWdn(1smwYWddSWddSWddSWddSWddS1swYdS)Nr3matchmethodagg) FutureWarningtmassert_produces_warninggetattrr7 transformpytestraises)klassmsghowgb groupby_funcargswarn_msgZ warn_klassr r r_call_and_checkds2 "rFrA)r6r7r<c Cs|}t||}|j|d}|r |d}|dkr t|drJdSidddddddtdfd dd dd ttfd fd ttfdfdttfdfdttfdfdtdfddddddddddddidddttdfdttdfd dd!dd"dd#tdfd$ttd%fd&td'fd(dd)td*fd+dd,dd-td*fd.td*fd/dd0ttd1f|\}} |dkr|rd2nd3} | d4} nd5} t|| ||||| dS)6Nrr!corrwithallNr3anybfillzCould not convertcountcumcountcummaxzH(function|cummax) is not (implemented|supported) for (this|object) dtypecumminzH(function|cummin) is not (implemented|supported) for (this|object) dtypecumprodzI(function|cumprod) is not (implemented|supported) for (this|object) dtypecumsumzH(function|cumsum) is not (implemented|supported) for (this|object) dtypediffunsupported operand typeffillfillnafirstidxmaxidxminlastmaxmean-agg function failed [how->mean,dtype->object]medianz/agg function failed [how->median,dtype->object]minngroupnunique pct_changeprodz-agg function failed [how->prod,dtype->object]quantilez,cannot be performed against 'object' dtypes!ranksemz!could not convert string to floatshiftsizeskewstdsumvarz%agg function failed [how->var,dtype->rrGroupBy.fillna is deprecatedr3) rgroupbyhasattr TypeErrorNotImplementedErrorreescape ValueErrorrF) rArrrCr&r%rDrBr?r@kindrEr r rtest_groupby_raises_stringxs   #'()*+/01234567;=  rvr7r<cCf|}|j|d}|r|d}dd}tjtddt|||WddS1s,wYdS)NrGr!cStdNTest error messagerpr r r rfuncz,test_groupby_raises_string_udf..funcrzr4rnr=r>rpr;)rArrr&r%rBr|r r rtest_groupby_raises_string_udf "rgroupby_func_npc Csf|}|j|d}|r|d}tjdtjttdfi|\}}|r$d} nd} t|||||d| ddS) NrGr!rJr]using SeriesGroupBy.[sum|mean]!using DataFrameGroupBy.[sum|mean]r rE)rnnprkr\rprrrsrF) rArrrr&r%rBr?r@rEr r rtest_groupby_raises_string_nps  rc Cs|}t||}|j|d}|r |d}|dkr t|drJdSidddddddtdfd dd dd dd dd tdfdtdfddddddddddddddidddddddddddddtdfd td!fd"dd#dd$dd%dd&dd'td(d)d*gfd+dd,td-fd.td/f|\}} |d0vrd1|d2} n|dkr|rd3nd4} | d5} nd6} t|| ||||| d7dS)8NrGr!rHrIrJrKrLz+cannot perform __mul__ with this index typerMrNrOrPrQz3datetime64 type does not support cumprod operationsrRz2datetime64 type does not support cumsum operationsrSrUrVrWrXrYrZr[r\r^r_r`rarbz/cannot perform __truediv__ with this index typercz%datetime64 type does not support prodrdrerfrgrhri|z1dtype datetime64\[ns\] does not support reductionz0datetime64 type does not support skew operationsrjrk/datetime64 type does not support sum operationsrlz/datetime64 type does not support var operations)rKrI'z&' with datetime64 dtypes is deprecatedrrrmr3r)rrnrorpjoinrF) rArrrCr+r%rDrBr?r@rErur r rtest_groupby_raises_datetimes       ()*+-  rcCrw)NrGr!cSrxryr{r r r rr|Dr}z.test_groupby_raises_datetime_udf..funcrzr4r~)rArrr+r%rBr|r r r test_groupby_raises_datetime_udf<rrc Cs`|}|j|d}|r|d}tjtdftjdi|\}}|r!d} nd} t|||||d| ddS) NrGr!rrJrrr rrnrrkrpr\rF) rArrrr+r%rBr?r@rEr r rtest_groupby_raises_datetime_npKs  rr|)rcrQrirlcCs&|}|jdd}ttdd||gdS)NrrGz/timedelta64 type does not support .* operationsr6)rnrFrp)r|r.r%rBr r rtest_groupby_raises_timedeltacs rc Cs|}t||}|j|d}|r |d}|dkr t|drJdSidddddddtdfd dd dd ttfd fd ttfdfdttfdfdttfdfdtdfddd|s`tdfndddddddddidddtddd gfd!tdd"d#gfd$dd%dd&dd'td(fd)td*fd+td,fd-dd.tdd/d0gfd1dd2dd3tdd4d5gfd6tdd7d8gfd9td:fd;tddnd?} | d@} ndA} t| | ||||| dS)BNrGr!rHrIrJrKrL=unsupported operand type\(s\) for \*: 'Categorical' and 'int'rMrNrOzz(category type does not support cummax operations|category dtype not supported|cummax is not supported for category dtype)rPzz(category type does not support cummin operations|category dtype not supported|cummin is not supported for category dtype)rQz|(category type does not support cumprod operations|category dtype not supported|cumprod is not supported for category dtype)rRzz(category type does not support cumsum operations|category dtype not supported|cumsum is not supported for category dtype)rSzDunsupported operand type\(s\) for -: 'Categorical' and 'Categorical'rUrVSCannot setitem on a Categorical with a new category \(0\), set the categories firstrWrXrYrZr[r\rz2'Categorical' .* does not support reduction 'mean'2category dtype does not support aggregation 'mean'r^z4'Categorical' .* does not support reduction 'median'4category dtype does not support aggregation 'median'r_r`rarbzDunsupported operand type\(s\) for /: 'Categorical' and 'Categorical'rc.category type does not support prod operationsrdzNo matching signature foundrerf1'Categorical' .* does not support reduction 'sem'1category dtype does not support aggregation 'sem'rgrhri0dtype category does not support reduction 'skew'.category type does not support skew operationsrj1'Categorical' .* does not support reduction 'std'1category dtype does not support aggregation 'std'rk-category type does not support sum operationsrl1'Categorical' .* does not support reduction 'var'1category dtype does not support aggregation 'var'rrrmr3)rrnrorprqrrF) rArrrCusing_copy_on_writer2r%rDrBr?r@rurEr r rtest_groupby_raises_categoryrs2    "&'./0123<EFGHLMNOXYZclmvx  rcCrw)NrGr!cSrxryr{r r r rr| r}z.test_groupby_raises_category_udf..funcrzr4r~)rArrr2r%rBr|r r r test_groupby_raises_category_udfs "rc Csd|}|j|d}|r|d}tjtdftjtdfi|\}}|r#d} nd} t|||||d| ddS) NrGr!rrrrr rr) rArrrr2r%rBr?r@rEr r rtest_groupby_raises_category_nps   rcCsz|}tgdgddd|d<t||}|j||d} |r.| d} |dkr.t| dr,JdS| ogfd?t d7 d@dAgfdBt dCfdDt d7 dEdFgf|\} } |d!kr/|r'dGndH} | dI}nd4}t| | || |||dS)JNr/rTr0r)robservedr!rHcss|]}|jVqdSr)empty).0groupr r r Hsz;test_groupby_raises_category_on_category..r<rrFrIrJrKrLrrMrNrOzz(cummax is not supported for category dtype|category dtype not supported|category type does not support cummax operations)rPzz(cummin is not supported for category dtype|category dtype not supported|category type does not support cummin operations)rQz|(cumprod is not supported for category dtype|category dtype not supported|category type does not support cumprod operations)rRzz(cumsum is not supported for category dtype|category dtype not supported|category type does not support cumsum operations)rSrTrUrVrrWrXz(empty group due to unobserved categoriesrYrZr[r\rr^rr_r`rarbrcrrdr3rerfrrrrgrhrirrrjrrrkrrlrrrrrm)rrrnrorKgroupsvalues isinstancer#strrprqrtrrF)rArrrCrrr2r%rDrBZ empty_groupsr?r@rurEr r r(test_groupby_raises_category_on_category-s:      "#$+, / 23456789:;<=FGHQZ[d f rcCstdgdgdgd}d}tjt|d|jddd}Wdn1s&wYtjtd d |d WddS1sBwYdS) Nrr r)rrr z+DataFrame.groupby with axis=1 is deprecatedr4r)Zaxisz'Cannot subset columns when using axis=1r)rr9r:r8rnr=r>rt)r%r@rBr r r%test_subsetting_columns_axis_1_raisess "r)r3)+r*rrnumpyrr=ZpandasrrrrZpandas._testingZ_testingr9Zpandas.tests.groupbyrZfixturearraydictzipr"rrr&r+r.r2rFmarkZ parametrizervrrkr\rrrrrrrrrrr r r rsx            S   E