o ۭj\@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)Nrrr 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!r T categoriesordered)rr#rr%r r rdf_with_cat_colSs r4c 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)Nr5matchmethodagg) FutureWarningtmassert_produces_warninggetattrr9 transformpytestraises)klassmsghowgb groupby_funcargswarn_msg warn_klassr r r_call_and_checkds2 "rIrC)r8r9r>c CsH|}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|\} } |r|d2vrd3|d4} |d5vrt} n0|d#kr|djj d6krd7} n!|dkr|djj d6krd8} n|d9vr| d:d;} n|dkrd<} |dkr|rd=nd>} | d?} nd@} t | | ||||| dS)ANrr"corrwithallNr5anybfillzCould 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 typeffillfillnafirstidxmaxidxminlastmaxmeanz-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]quantilez4dtype 'object' does not support operation 'quantile'ranksemz!could not convert string to floatshiftsizeskewstdsumvarz%agg function failed [how->var,dtype->) rer_r`rUrTrlrhrnrkrfz(dtype 'str' does not support operation '')rhrlrkpyarrowzBoperation 'truediv' not supported for dtype 'str' with dtype 'str'z>operation 'sub' not supported for dtype 'str' with dtype 'str')rSrRobjectstrz1Cannot perform reduction 'mean' with string dtyperrGroupBy.fillna is deprecatedr5) rgroupbyhasattr TypeErrorNotImplementedErrorreescape ValueErrordtypestoragereplacerI) rCrrrEr'using_infer_stringr&rFrDrArBkindrGr r rtest_groupby_raises_stringxs   #'()*+/01234567;=    rr9r>cCf|}|j|d}|r|d}dd}tjtddt|||WddS1s,wYdS)NrJr"cStdNTest error messagervr r r rfuncz,test_groupby_raises_string_udf..funcrr6rtr?r@rvr=)rCrrr'r&rDrr r rtest_groupby_raises_string_udf "rgroupby_func_npc Csv|}|j|d}|r|d}tjdtjtdfi|\}} |r'|tjur%t}d} |r,d} nd} t|| |||d| d dS) NrJr"rMzEagg function failed|Cannot perform reduction 'mean' with string dtypez-dtype 'str' does not support operation 'mean'using SeriesGroupBy.[sum|mean]!using DataFrameGroupBy.[sum|mean]r rG)rtnprmr_rvrI) rCrrrr'r~r&rDrArBrGr 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)8NrJr"rKrLrMrNrOz+cannot perform __mul__ with this index typerPrQrRrSrTz3datetime64 type does not support cumprod operationsrUz2datetime64 type does not support cumsum operationsrVrXrYrZr[r\r]r^r_r`rarbrcrdz/cannot perform __truediv__ with this index typerez%datetime64 type does not support prodrfrgrhrirjrk|z1dtype datetime64\[ns\] does not support reductionz0datetime64 type does not support skew operationsrlrm/datetime64 type does not support sum operationsrnz/datetime64 type does not support var operations)rNrLroz&' with datetime64 dtypes is deprecatedrrrsr5r)rrtrurvjoinrI) rCrrrEr,r&rFrDrArBrGrr r rtest_groupby_raises_datetimes       ()*+-  rcCr)NrJr"cSrrrr r r rrmrz.test_groupby_raises_datetime_udf..funcrr6r)rCrrr,r&rDrr r r test_groupby_raises_datetime_udferrc Cs`|}|j|d}|r|d}tjtdftjdi|\}}|r!d} nd} t|||||d| ddS) NrJr"rrMrrr rrtrrmrvr_rI) rCrrrr,r&rDrArBrGr r rtest_groupby_raises_datetime_npts  rr)rerTrkrncCs&|}|jdd}ttdd||gdS)NrrJz/timedelta64 type does not support .* operationsr8)rtrIrv)rr/r&rDr r rtest_groupby_raises_timedeltas 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)BNrJr"rKrLrMrNrO=unsupported operand type\(s\) for \*: 'Categorical' and 'int'rPrQrRzz(category type does not support cummax operations|category dtype not supported|cummax is not supported for category dtype)rSzz(category type does not support cummin operations|category dtype not supported|cummin is not supported for category dtype)rTz|(category type does not support cumprod operations|category dtype not supported|cumprod is not supported for category dtype)rUzz(category type does not support cumsum operations|category dtype not supported|cumsum is not supported for category dtype)rVzDunsupported operand type\(s\) for -: 'Categorical' and 'Categorical'rXrYSCannot setitem on a Categorical with a new category \(0\), set the categories firstrZr[r\r]r^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'rarbrcrdzDunsupported operand type\(s\) for /: 'Categorical' and 'Categorical're.category type does not support prod operationsrfNo matching signature foundrgrh1'Categorical' .* does not support reduction 'sem'1category dtype does not support aggregation 'sem'rirjrk0dtype category does not support reduction 'skew'.category type does not support skew operationsrl1'Categorical' .* does not support reduction 'std'1category dtype does not support aggregation 'std'rm-category type does not support sum operationsrn1'Categorical' .* does not support reduction 'var'1category dtype does not support aggregation 'var'rrrsr5)rrtrurvrwrrI) rCrrrEusing_copy_on_writer4r&rFrDrArBrrGr r rtest_groupby_raises_categorys2    "&'./0123<EFGHLMNOXYZclmvx  rcCr)NrJr"cSrrrr r r rr4rz.test_groupby_raises_category_udf..funcrr6r)rCrrr4r&rDrr r r test_groupby_raises_category_udf+s "rc Csd|}|j|d}|r|d}tjtdftjtdfi|\}}|r#d} nd} t|||||d| ddS) NrJr"rrrrr rr) rCrrrr4r&rDrArBrGr r rtest_groupby_raises_category_np;s   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}ndJ}t| | || |||dS)KNr0r Tr1r)robservedr"rKcss|]}|jVqdSr)empty).0groupr r r qsz;test_groupby_raises_category_on_category..r>rrFrLrMrNrOrrPrQrRzz(cummax is not supported for category dtype|category dtype not supported|category type does not support cummax operations)rSzz(cummin is not supported for category dtype|category dtype not supported|category type does not support cummin operations)rTz|(cumprod is not supported for category dtype|category dtype not supported|category type does not support cumprod operations)rUzz(cumsum is not supported for category dtype|category dtype not supported|category type does not support cumsum operations)rVrWrXrYrrZr[z(empty group due to unobserved categoriesr\r]r^r_rr`rrarbrcrdrerrfrrgrhrrrrirjrkrrrlrrrmrrnrrrrrsr5)rrrtrurNgroupsvalues isinstancer$rrrvrwrzrrI)rCrrrErrr4r&rFrD empty_groupsrArBrrGr r r(test_groupby_raises_category_on_categoryVs:      "#$+, / 23456789:;<=FGHQZ[d f rcCstdgdgdgd}d}tjt|d|jddd}Wdn1s&wYtjtd d |d WddS1sBwYdS) Nrr r)rrr!z+DataFrame.groupby with axis=1 is deprecatedr6r)axisz'Cannot subset columns when using axis=1r)rr;r<r:rtr?r@rz)r&rBrDr r r%test_subsetting_columns_axis_1_raisess "r)r5)+r+rxnumpyrr?pandasrrrrpandas._testing_testingr;pandas.tests.groupbyrfixturearraydictzipr#rrr'r,r/r4rImark parametrizerrrmr_rrrrrrrrrrr r r rsx            r  # E