+
    xȇi                     (   R t ^ RIt^ RIt^ RIHtHtHtHtH	t	H
t
HtHtHt ^ RIHt R tR t]P&                  P(                  ]P&                  P+                  RRR.4      ]P&                  P+                  R^
^2.4      ]P&                  P+                  R	^^.4      ]P&                  P+                  R
RRRR..]R7      ]P&                  P+                  RR^ ^..]R7      ]P&                  P+                  RRR.4      ]P&                  P+                  RRSRT.4      R 4       4       4       4       4       4       4       4       t]P&                  P+                  RRR.4      R 4       t]P&                  P+                  RRR.. RUO.4      R 4       t]P&                  P+                  RRR.. RUO.4      R 4       tR tR t]P:                  R 4       tR tR t R  t!]P&                  P+                  R!. RVO4      ]P&                  P+                  RRSRT.4      ]P&                  P+                  R". RWO4      ]P&                  P+                  R#RR.4      R$ 4       4       4       4       t"]P&                  P+                  R%RR.4      ]P&                  P+                  R&RR. RXO. RYO. RZO3RR. R[O. R\O. R]O3RR. R^O. R_O. R`O3.4      R' 4       4       t#]P&                  P+                  R(RRRR. RaO. RcO3RRRR. RdO. ReO3RRRR. RfO. RgO3RRRR. RhO. RgO3.4      R) 4       t$]P&                  P+                  R*RR. RiO. RjO3RR. RkO. RlO3RR. RmO. RnO3RR. RoO. RpO3.4      R+ 4       t%]P&                  P+                  R,R^^.]
PL                  ! . RqO. RrOR/7      3R. RsO]
! ]	! ^.4      ]	! . RtO4      ]	! R.R-]PN                  .4      .. RuO. RvO. RwO.. RrOR07      3.4      ]P&                  P+                  RRTRS.4      R1 4       4       t(]P&                  P+                  R2RR.4      ]P&                  P+                  R3RR]PR                  ! . RxO]PT                  R47      3RR]PR                  ! . RyO4      3.4      R5 4       4       t+R6 t,]P&                  P+                  R3RR]PR                  ! . RxO]PT                  R47      3RR]PR                  ! . RyO4      3.4      R7 4       t-]P&                  P+                  R3RR]PR                  ! . RzO]PT                  R47      3RR]PR                  ! . R{O4      3.4      R8 4       t.]P&                  P+                  R9R. R|O3R. R}O3.4      ]P&                  P+                  R3RR]PR                  ! . R~O]PT                  R47      3RR]PR                  ! . RO4      3.4      R: 4       4       t/]P&                  P+                  R2RR.4      ]P&                  P+                  R3RR]PR                  ! . RxO]PT                  R47      3RR]PR                  ! . RyO4      3.4      R; 4       4       t0]P&                  P+                  R<RR. RbO3RR. RpO3.4      R= 4       t1]P&                  P+                  R>R?]2! R@4      . RO3RA. ]2! RB4      ORCN. RO3.4      RD 4       t3]P&                  P+                  RERTRS.4      RF 4       t4RG t5RH t6RI t7RJ t8RK t9]P&                  P+                  RRR.4      RL 4       t:RM t;]P&                  P+                  RNRR.4      ]P&                  P+                  R%RR.4      RO 4       4       t<]P&                  P+                  RNRR.4      ]P&                  P+                  R%RR.4      RP 4       4       t=]P&                  P+                  RQRR.4      RR 4       t>R# )z
these are systematically testing all of the args to value_counts
with different size combinations. This is to ensure stability of the sorting
and proper parameter handling
N)	CategoricalCategoricalIndex	DataFrameGrouperIndex
MultiIndexSeries
date_rangeto_datetimec                  z   \        R R.RR./4      p V R ,          P                  R4      V R &   V P                  R4      R ,          P                  4       p\        RR..RR .R7      pVR ,          P                  R4      VR &   \        P
                  ! V4      p\        ^.VRR7      p\        P                  ! W4       R# )	genderfemalecountryUScategorycolumnscountindexnameN)	r   astypegroupbyvalue_countsr   
from_framer   tmassert_series_equal)dfresultdf_mi_expectedmi_expectedexpecteds        ~/Users/max/.openclaw/workspace/postharvest/venv/lib/python3.14/site-packages/pandas/tests/groupby/methods/test_value_counts.py.tests_value_counts_index_names_category_columnr#      s    	xjv	

B h<&&z2BxLZZ	"8,99;F x 01Ix;PQN-h7>>zJN8''7Kqc7;H6,    c                    \        R ^
R7      p\        R\        P                  P	                  ^4      P                  \        R4      V4      R\        P                  P	                  ^4      P                  W14      R\        P                  P	                  ^4      P                  ^V^,           V4      /4      pV '       d   VR,          P                  R4      VR&   \        P                  VP                  R&   \        P                  VP                  R&   \        P                  VP                  R	&   \        P                  VP                  R
&   \        P                  VP                  R&   V# )z
2015-08-24)periods1stabcd2nd3rdfloat):   N   r'   ):   N   r)   ):   N   r*   ):   Nr1   r*   ):	   Nr1   r*   )r	   r   nprandomdefault_rngchoicelistintegersr   nanloc)	seed_nansnmdaysframes   &&&  r"   seed_dfrA   ,   s   lB/D299((+224<C299((+224;299((+44QAqA	
E U|**73e"$&&		,"$&&		,"$&&		,"$&&		,"$&&		,Lr$   r<   TFnum_rowsmax_intkeysr'   r)   )idsbinsisortznormalize, name
proportionr   c           
         \        WV4      pR  pRVRVRV	RV
RV/pVP                  W5R7      pVR,          P                  ! R	/ VB pVP                  W5R7      pVR,          P                  ! \        P                  3/ VB p. VP
                  P                  RR
 ORNVP
                  n        VP                  V4      p\        WV34      w  pp\        P                  ! VP                  4       VP                  4       4       R# )c                     \        \        V P                  P                  \	        V P                  P
                  4      4      4      p\        P                  ! WP                  P                  R 7      V n        V # )names)	r8   mapr   get_level_valuesrangenlevelsr   from_arraysrL   )r   arrs   & r"   rebuild_index7test_series_groupby_value_counts.<locals>.rebuild_indexZ   sK    3rxx00%8H8H2IJK))#XX^^D	r$   	normalizesort	ascendingdropnarF   rV   r*   N )rA   r   r   applyr   r   rL   renamerM   r   r   
sort_index)r<   rB   rC   rD   rF   rG   rU   r   rV   rW   rX   r   rS   kwargsgrleftrights   &&&&&&&&&&&      r"    test_series_groupby_value_countsrc   C   s    * 
g	.B 	YY&F 
D	%Be9!!+F+D	D	%BuIOOF//:6:E8%++++CR08%8EKKLLE mE]3KD%4??,e.>.>.@Ar$   utcc                    \        R . R	OR. R
O/4      P                  ^.4      p\        VR ,          V RR7      VR&   VP                  \	        RRR7      4      pVR,          P                  4       P                  4       pVR,          P                  \        P
                  4      P                  4       pVP                  P                  VP                  n
        VP                  R4      p\        P                  ! W44       R# )	TimestampFoodsrd   unitDatetime1Dfreqkeyr   NiGI]i)J]iJ]iK]i)<M]iU=M]iN]applerr   bananars   orangert   pear)r   dropr
   r   r   r   r^   r\   r   r   rL   r]   r   r   )rd   r   dfgr   r!   s   &    r"   -test_series_groupby_value_counts_with_grouperrx   u   s     
  V	

 dA3i  !KcDBzN
**W$J7
8C [%%'224F6{  !4!45@@BH!<<--HNNw'H6,r$   r   ABc                 8   \        V R 7      pVP                  V RR 4      pW R,          ,          P                  4       p\        . VP                  RR7      p\
        P                  ! . .\        V 4      ,          V R7      Vn        \        P                  ! W44       R# )r   Nr   )dtyper   rK   r[   )r   r   r   r   r|   r   rQ   lenr   r   r   r   r   rw   r   r!   s   &    r"   &test_series_groupby_value_counts_emptyr      sv     
7	#B
**WSb\
"C**,Fb7;H++RD3w<,?wOHN6,r$   c                     \        \        \        V 4      4      .V R 7      pVP                  V RR 4      pW R,          ,          P	                  4       pVP	                  4       p\
        P                  ! W44       R# ))datar   Nr[   )r   rO   r}   r   r   r   r   r~   s   &    r"   (test_series_groupby_value_counts_one_rowr      s_     
s7|,-w	?B
**WSb\
"C**,F H6,r$   c                  >   \        \        R .R R.R7      4      p V P                  ^ .4      P                  4       p\        ^^ .\        P
                  ! \        P                  ! ^ ^ .4      \        R R.R R.RRR7      .4      RR7      p\        P                  ! W4       R# )	ab)
categoriesFr   )r   orderedr|   r   r   r   r   N)r   r   r   r   r   rQ   r4   arrayr   r   r   )rh   r   r!   s      r"   /test_series_groupby_value_counts_on_categoricalr      s     	{C5c3Z89AYYs^((*FV$$!Q  #JC:uJ
 H$ 6,r$   c            	          \        R . ROR. ROR. RO/4      p V P                  RR .RR7      R,          pVP                  RR7      p\        RR.RR.. RO.. RO. RO. RO.. ROR	7      p\	        . ROVR
R7      p\
        P                  ! W$4       R# )r   maler   	educationr   r   FRFrY   levelscodesrL   r   r   Nr   r   r   r   r   r   lowmediumhighr   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,   r,   r   r,   )r   r   r   r   r   r   r   )r   gbr   r   r!   s        r"   (test_series_groupby_value_counts_no_sortr      s    	JH;	

B 
Y)	6{	CB__%_(Ftvx02KLA0E
 oUAH6,r$   c            	      0    \        R . ROR. ROR. RO/4      # )r   r   r   r   r   r   )r   rZ   r$   r"   education_dfr      s&    JH;	
 r$   c                     V P                  R 4      p\        P                  ! \        RR7      ;_uu_ 4        VP	                  R .R7       RRR4       R#   + '       g   i     R# ; i)r   subsetmatchr   N)r   pytestraises
ValueErrorr   )r   gps   & r"   test_bad_subsetr      sB    			i	(B	z	2	2
	{+ 
3	2	2	2s   AA%	c                 :   VP                  \        P                  P                  R RR7      4       V P	                  R4      RR.,          P                  RR7      p\        . RO\        P                  ! . RO. ROR7      R	R
7      p\        P                  ! W#4       R# )Ypandas default unstable sorting of duplicatesissue with numpy>=1.25 with AVX instructionsFreasonstrictr   r   r   TrU   rK   rH   r   N)      ?      ?r   r   r   )r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   )applymarkerr   markxfailr   r   r   r   from_tuplesr   r   )r   requestr   r!   s   &&  r"   
test_basicr      s    ?  	 	
 !!),h-DERR S F ($$ 5	
 H 6,r$   c                 4    W,          P                  W#VR 7      # )rU   rV   rW   )r   )r   rD   rU   rV   rW   s   &&&&&r"   _frame_value_countsr     s    8  99 UUr$   r   zsort, ascendingr@   c
                   a  V'       dA   V'       d9   V'       d1   VP                  \        P                  P                  R RR7      4       RRRS R,          P                  RV 3R l/V,          p
S P                  WR7      pVR	R
.,          P                  W$VR7      pV'       d   VP                  \        R	R
.W$V4      pV'       d   \        P                  ! W4       R# V'       d   RMRpVP                  4       P                  ^ V/^R7      pVR9   d-   V'       g%   V'       d   VP                  ^ RVR,          R7       MVP                  ^ RVR,          R7       \        P                  ! W4       R# S R	,          R,           S R
,          ,           S R&   VR,          P                  W$VR7      pW=n        V'       Edb   VP                   P#                  RR7      pVR,          P$                  P'                  R4      P$                  P)                  ^ 4      VR	&   VR,          P$                  P'                  R4      P$                  P)                  ^4      VR
&   VR,          P*                  pVP-                  R	VR
V/4      pVR VP                  ^ R/^R7      p\.        P0                  ! V4      Vn        VP2                  P5                  4       ^ ,          '       d0   R.VP                   P6                  R,          OVP                   n        \        P                  ! W4       R# VP                  ^R	VR,          P$                  P'                  R4      P$                  P)                  ^ 4      4       VP                  ^R
VR,          P$                  P'                  R4      P$                  P)                  ^4      4       V	'       d   VP-                  R	RR
R/4      pVR \        P                  ! W4       R# )r   Fr   columnr   r   functionc                 *   < SR ,          V ,          R8H  # )r   r   rZ   )xr   s   &r"   <lambda>6test_against_frame_and_seriesgroupby.<locals>.<lambda><  s    l95a8D@r$   )byas_indexr   r   r   rH   r   )axislevel_0)r;   r   value-bothr   N:r,   NNstr)r   r   )r   r   r   r   valuesr   r   r\   r   r   r   reset_indexr]   insertassert_frame_equalr   r   to_framer   splitgetr|   r   r   r   r   isnarL   )r   r   rU   r   rV   rW   r   r@   r   using_infer_stringr   r   r   r!   index_frame
both_dtypeindex_frame2s   f&&&&&&&&&       r"   $test_against_frame_and_seriesgroupbyr     s]   > )KKC   	
 	)i(//@
 	
B 
				7B;'(55) 6 F 88(K!8)9
 ""64#,<'D++-44aYQ4GH//eAivi?PQAivi?PQ!!&3  ,H5;l;>WWVf:**i + 
 8"..111>K$/$7$;$;$A$A#$F$J$J$N$Nq$QK!'26':'>'>'D'DS'I'M'M'Q'QRS'TK$$V,22J%,,:{J?K F#&--q$ia-@L'22<@HN##((*1-- )-'Hx~~/C/CB/G'H$""64OOAx&)9)=)=)C)CC)H)L)L)P)PQR)STOOA{HV,<,@,@,F,Fs,K,O,O,S,STU,VW!#??He[%+PQ !!&3r$   rU   zCsort, ascending, expected_rows, expected_count, expected_group_sizec	                    Tp	V P                  V	4      p V P                  P                  V	4      V n        V P                  R R.RRR7      p
V
R,          P                  WVR7      p\	        4       pR FU  pV Uu. uF  qV,          V,          NK  	  upW&   VP                  V	4      pVP                  P                  V	4      Vn        KW  	  V'       d<   W\R&   VR;;,          V,          uu&   V	R8X  d   VR,          P                  4       VR&   M%W\R&   V	R8X  d   VR,          P                  4       VR&   V'       d#   V	\        8X  d   VP                  R R	RR	RR	/4      p\        P                  ! W4       R
# u upi )r   r   Fr   rV   r   r   rH   zstring[pyarrow]r   r   Nr   )	r   r   r   r   r   convert_dtypesobjectr   r   )r   rU   rV   rW   expected_rowsexpected_countexpected_group_sizeany_string_dtyper   r|   r   r   r!   r   rows   &&&&&&&&&      r"   test_compoundr   u  sn   ( E&&u-L'//66u=L			y(3e%		PB_))) * F {H4ANO#055O??5)#++2259 5 !/"55%%%-l%;%J%J%LH\"*%% ( 1 @ @ BHWevo??xUC
 &+% Ps   7E3z?sort, ascending, normalize, name, expected_data, expected_indexc           	      J   \        R . ROR. R	OR. R
O/. ROR7      pVP                  WVR7      p\        V\        P                  ! V. ROR7      VR7      p\
        P                  ! Wx4       VP                  R 4      P                  WVR7      p	\
        P                  ! W4       R# )ro   num_legs	num_wingsr   )rV   rW   rU   rK   r   Nr,   r,   r,   r,   )r      r      )r   r   r   r   )falcondogcatant)ro   r   r   )r   r   r   r   rQ   r   r   r   )
rV   rW   rU   r   expected_dataexpected_index
animals_dfresult_framer!   result_frame_groupbys
   &&&&&&    r"   test_data_frame_value_countsr     s    * 	j,\R-J **) + L $$"B
 H <2%--e4AA) B  /:r$   z:group_dropna, count_dropna, expected_rows, expected_valuesc                    V '       g1   VP                  \        P                  P                  R RR7      4       \	        R^^\
        P                  ^\
        P                  ^^^^.	R^^^\
        P                  \
        P                  ^^^^.	R^^^^^^\
        P                  ^\
        P                  .	R^^^^^^^\
        P                  \
        P                  .	/4      pVP                  RR.V R7      pVP                  RRVR	7      p\	        4       pVP                   F$  p	V U
u. uF  qV	,          V
,          NK  	  up
W&   K&  	  \        P                  ! V4      p\        W;R
R7      p\        P                  ! W|4       R# u up
i )r   Fr   ry   rz   CD)rX   T)rU   rV   rX   rH   r   N)r   r   r   r   r   r4   r:   r   r   r   r   r   r   r   r   )group_dropnacount_dropnar   expected_valuesr   nulls_dfr   r   r   r   r   r   r!   s   &&&&&        r"   test_dropna_combinationsr     s_   " KKC   	
 !Q2661aA6!Q2662661aA6!Q1aBFFArvv6!Q1aArvvrvv6		
H 
		3*\		:B__t$|_LFkG""<IJMSF+C00MJ #!!'*E?lKH6, Ks   &Fz%dropna, expected_data, expected_indexSmithLouiserK   r   c                 V   \        R . ROR. R	ORRW R./4      pVP                  WR7      p\        VVVR7      pV'       d   V\        \	        V4      4      ,          p\
        P                  ! Wx4       VP                  R 4      P                  WR7      p	\
        P                  ! W4       R# )
ro   
first_namemiddle_namer   r   )rX   rU   r   Nr   )JohnAnner  Beth)r   r   r   r+   r}   r   r   r   )
nulls_fixturerX   rU   r   r   r   names_with_nulls_dfr   r!   r   s
   &&&&&&    r"   #test_data_frame_value_counts_dropnar	    s    B $<:G]8L	
 '3363WLH
 E#m,--<2.66u=JJ K  /:r$   observedznormalize, name, expected_datar|   c                 v   VP                  \        P                  P                  R RR7      4       V P	                  R4      P                  RWR7      pVP                  VR7      p\        P                  ! . RO. ROR7      p	\        VV	VR7      p
\        ^4       FI  pV
P                  P                  \        V
P                  P                  V,          4      VR	7      V
n        KK  	  V'       d   \        P                   ! W4       R# T
P#                  V'       d   R
MRR7      p\        P$                  ! W4       R# )r   Fr   r   r   r   r
  r   rK   r   levelrH   r   r   N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   r   r   r   r   r   r   r   r   rO   r   
set_levelsr   r   r   r   r   r   r   r   r
  rU   r   r   r   r   r   r   expected_seriesir!   s   &&&&&&&      r"   =test_categorical_single_grouper_with_only_observed_categoriesr  ;  s$   * ?  	 	
 
		Z	(	0	0H 
1 
B __y_1F++	
 1N$ O
 1X / 5 5 @ @_2299!<=Q !A !
 
 
v7"..!* / 
 	f/r$   c                    V P                  4       P                  R 4      p V R,          P                  P                  R.4      V R&   V P	                  RWR7      pVP                  VR7      p\        V\        P                  ! V. R
OR7      VR7      p	\        ^4       F}  p
\        V	P                  P                  V
,          4      pV
^ 8X  d-   VP                  V R,          P                  P                  4      pV	P                  P                  WR7      V	n        K  	  V'       d   \         P"                  ! W4       R	# V	P%                  VR7      p\         P&                  ! W4       R	# )r   r   ASIAr  r   rK   r   r  r  Nr   )copyr   r   add_categoriesr   r   r   r   r   rO   r   r   r   set_categoriesr   r  r   r   r   r   )r   r   r
  r   rU   r   r   r   r   r  r  index_levelr!   s   &&&&&&&      r"   !assert_categorical_single_grouperr$    s4     $$&--j9L +9599HH&RL			i(		NB__y_1F$$4
 O 1X&'<'<'C'CA'FG6%44Y'++66K !0 5 5 @ @ @ V  
v7"..D.9
f/r$   c           
          VP                  \        P                  P                  R RR7      4       . ROp\	        V VRVVVVR7       R# )r   Fr   Tr   r   r
  r   rU   r   r   Nr  r   r   r   r   r$  r   r   rU   r   r   r   r   s   &&&&&& r"   -test_categorical_single_grouper_observed_truer)    sY    ( ?  	 	
N &!%#r$   c           
          VP                  \        P                  P                  R RR7      4       . ROp\	        V VRVVVVR7       R# )r   Fr   r&  N)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   r   r'  r(  s   &&&&&& r"   .test_categorical_single_grouper_observed_falser+    sZ    V ?  	 	
N* &!%#r$   zobserved, expected_indexc                    V P                  4       p V R ,          P                  R4      V R &   V R,          P                  R4      V R&   V P                  R R.WR7      pVP                  VR7      p\	        V'       d   WfR8  ,          MT\
        P                  ! V. ROR7      VR7      p	\        ^4       FI  p
V	P                  P                  \        V	P                  P                  V
,          4      V
R7      V	n        KK  	  V'       d   \        P                  ! W4       R# T	P                  V'       d   R	MR
R7      p\        P                  ! W4       R# )r   r   r   r  r           rK   r   r  rH   r   r  N)r   r   r   )r   r   r   r   r   r   r   rO   r   r  r   r   r   r   r   r   )r   r   r
  r   rU   r   r   r   r   r  r  r!   s   &&&&&&&     r"   "test_categorical_multiple_groupersr.  4  s3   l  $$&L*95<<ZHL ,[ 9 @ @ LL				K 8 
 
B __y_1F3;]3./$$4
 O 1X / 5 5 @ @_2299!<=Q !A !
 
 
v7"..!* / 
 	f/r$   c                    VP                  \        P                  P                  R RR7      4       V P	                  4       p V R,          P                  R4      V R&   V R,          P                  R4      V R&   V P                  RWR7      pVP                  VR7      p. ROp	\        V\        P                  ! V	. ROR	7      VR
7      p
\        ^^4       FI  pV
P                  P                  \        V
P                  P                  V,          4      VR7      V
n        KK  	  V'       d   \         P"                  ! W4       R# T
P%                  V'       d   RMRR7      p\         P&                  ! W4       R# )r   Fr   r   r   r   r   r  r   rK   r   r  rH   r   r  Nr  r   )r   r   r   r   r   r   r   r   r   r   r   rO   r   r  r   r   r   r   r   r   r  s   &&&&&&&      r"   test_categorical_non_groupersr0    sV   . ?  	 	
  $$&L)(3:::FL ,[ 9 @ @ LL			i(		NB__y_1FN $$4
 O 1a[ / 5 5 @ @_2299!<=Q !A !
 
 
v7"..!* / 
 	f/r$   z*normalize, expected_label, expected_valuesc                    \        R . ROR. RO/4      pVP                  . ROR R .RR7      pVP                  RV R7      p\        R\        P                  ! . RO\
        R7      R . ROR	. ROR. ROW/4      p\        P                  ! WV4       R
# )ry   rz   c                     V ^8X  d   ^# ^# )r,   rZ   )r  s   &r"   r   &test_mixed_groupings.<locals>.<lambda>  s    AFq/A/Ar$   Fr   TrV   rU   r   r  level_2Nr,   r   r,   r,   r   r.   )r      r   )r   r   r9  r,   r,   r   )r2   r2   r0   )r,   r.   r   )r   r   r   r4   r   intr   r   )rU   expected_labelr   r   r   r   r!   s   &&&    r"   test_mixed_groupingsr=    s     
CC3	4B	Y%ABU	SB__$)_<Frxx	5y	
H &+r$   ztest, columns, expected_namesrepeatabbder  r(   level_1c                    \        . RO. RO.VR7      pRR.pR\        P                  ! ^ ^.\        P                  R7      R.pVP	                  WcR7      P                  4       pV'       d=   \        R\        P                  ! VVR7      RR7      p\        P                  ! Wx4       R
# V U	u. uF  p	. \        V	4      O^NNK  	  pp	\        V4      p
R	V
^&   V
P                  R4       \        WZR7      p\        P                  ! Wx4       R
# u up	i )r,   r   r   r  dr4  rK   r   r   r@  N)r,   r.   r9  r0   r3   )r   r   r   r2   
   )r,   r   r0   r.   r9  r3   )r   r,   r2   r   r   rC  r,   r,   )r   r4   r   int64r   r   r   r   r   r   r   r8   appendr   )testr   expected_namesr   r   r   rD   r   r!   r   expected_columnss   &&&&       r"   test_column_label_duplicatesrJ    s     
O%56	HB')<=M1a&137DZZZ0==?F(($ 
 	v04ABMS49aMB/'(]E
f/ Cs   +D
znormalize, expected_labelc                     \        . RO.RRV.R7      P                  RRR7      pRV R2p\        P                  ! \        VR7      ;_uu_ 4        VP                  V R	7       R
R
R
4       R
#   + '       g   i     R
# ; i)r,   r   r   r   Fr4  zColumn label 'z' is duplicate of result columnr   r   Nr8  )r   r   r   r   r   r   )rU   r<  r   msgs   &&  r"   test_result_label_duplicatesrM    so     
I;c>(B	C	K	Ke 
L 
B >**I
JC	z	-	-
), 
.	-	-	-s   A,,A=	c                  2   \        R ^^./4      p V P                  \        P                  ! ^^.\        P                  R7      4      pVP                  4       p\        ^.\        P                  ! ^^..RR .R7      RR7      p\        P                  ! W#4       R# )r   r  NrK   r   r   )r   r   r4   r   rE  r   r   r   r   r   r   )r   r   r   r!   s       r"   test_ambiguous_groupingrO    s{    	C!Q=	!B	BHHaV2884	5B__F	
:))Aq6(4+FWH 6,r$   c                      \        R . ROR. RO/. R	OR7      p Rp\        P                  ! \        VR7      ;_uu_ 4        V P	                  R 4      P                  R .R7       RRR4       R#   + '       g   i     R# ; i)
c1c2r   z;Keys {'c1'} in subset cannot be in the groupby column keys.r   r   Nr   r   cr   yrV  r   r,   r,   r   r   r   r   r   r   r   rL  s     r"   "test_subset_overlaps_gb_key_raisesrZ  *  sX    	D/4A	SB
GC	z	-	-


4%%dV%4 
.	-	-	-   #A++A<	c                      \        R . ROR. R	O/. R
OR7      p Rp\        P                  ! \        VR7      ;_uu_ 4        V P	                  R 4      P                  R.R7       RRR4       R#   + '       g   i     R# ; i)rQ  rR  r   z4Keys {'c3'} in subset do not exist in the DataFrame.r   c3r   NrS  rU  rW  rX  rY  s     r"   !test_subset_doesnt_exist_in_framer^  2  sX    	D/4A	SB
@C	z	-	-


4%%dV%4 
.	-	-	-r[  c                     \        R . ROR. RO/. ROR7      p V P                  ^ R7      P                  R.R7      p\        ^^.\        P
                  ! ^ ^.RR..RR.R7      R	R
7      p\        P                  ! W4       R# )rQ  rR  r   rV  r   r  r   NrK   r   r   rS  rU  rW  r   r   r   r   r   rQ   r   r   r   r   r!   s      r"   test_subsetrb  :  s|    	D/4A	SBZZaZ --dV-<F	
A$$q!fsCj%9$NH
 6,r$   c            	         \        . RO. RO. RO.. RO. ROR7      p V P                  ^ R7      P                  R.R7      p\        ^^.\        P
                  ! ^ ^.RR.RR... ROR7      R	R
7      p\        P                  ! W4       R# )r   r   rV  rR  )r   r   r  r   NrK   r   r   )r   r   r   )r   rV  rV  rW  )rQ  rR  rR  )NrR  rR  r`  ra  s      r"   test_subset_duplicate_columnsrd  F  s    		/?;"
B
 ZZaZ --dV-<F	
A$$Vc3Z#s,4F
 H 6,r$   c                     \        R . ROR. RO/4      P                  ^.4      p\        VR ,          V RR7      P                  P	                  V4      VR&   VP                  \        RRR7      4      pVP                  4       p\        . ROV R7      P	                  V4      pVR ,          P                  4       p\        WV. RO.. RO\        ^4      . RO.. ROR7      p\        ^VR	R
7      p\        P                  ! WH4       R# )rf   rg   rh   ri   rk   rl   rm   )rd   r   r   r   Nrp   rq   )z
2019-08-06z
2019-08-07z
2019-08-09z
2019-08-10)rr   rs   rt   ru   )r   r,   r,   r   r   r.   )r   r   r,   r   r   r.   )rk   rf   rg   )r   rv   r
   dtas_unitr   r   r   uniquer   rO   r   r   r   )	rd   rj   r   r   r   dates
timestampsr   r!   s	   &&       r"   test_value_counts_time_grouperrk  X  s     
  V	

 dA3i  !KcDGGOOPTUBzN	G:6	7B__F@cgdm 
 K'')J#HI!58-?@/E
 au73H6,r$   c            
          \        ^. RO^. RO^. RO/4      p V P                  ^^.RRR7      pV^,          P                  4       p\        ^. RO^. RO^. ROR^/4      p\        P                  ! W#4       R# )r,   Fr   r   N)r   r   r   )r   r   rB  rS  )r   r   r   r   r   )r   r   r   r!   s       r"   !test_value_counts_integer_columnsrm  z  sq    	A?AO	PB	QFU	7BU!F	
OQOWaPH &+r$   vc_sortc                    \        R . RO^ . R	O/4      pVP                  R V R7      pVP                  WR7      pV'       d   . R
OpM. ROp\        ^^.^^... RO. RO.R ^ .R7      p\	        YgV'       d   RMRR7      pV '       d   V'       d   . ROp	M.V '       d   V'       g   . ROp	MV '       g   V'       d   . ROp	M. ROp	VP                  V	4      p\        P                  ! WX4       R# )r   rY   r5  r   rH   r   r   Nr   r,   r,   r,   r.   r   r.   r.   )UUUUUU?UUUUUU?      ?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   taker   r   )
rV   rn  rU   r   r   r   r   r   r!   takers
   &&&       r"   test_value_counts_sortrx    s     
Cq,7	8B	Cd	#B__'_?F$AA	9'=c1XE f	wWH	gg}}U#H6,r$   c           	         \        R . R	O^ . R
O/RR7      pVP                  R V RR7      pVP                  WR7      pV'       d   . ROpM. ROpV'       d   RMRp\        R \        . RO4      ^ \        . RO4      Wv/4      P	                  R ^ .4      V,          pV '       d   V'       d   . ROp	M.V '       d   V'       g   . ROp	MV '       g   V'       d   . ROp	M. ROp	VP                  V	4      p\        P                  ! WX4       R# )r   r   r  T)rV   r
  r5  rH   r   Nrp  rq  )rr  rs  rt  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   	set_indexrv  r   r   )
rV   rn  rU   r   r   r   r   r   r!   rw  s
   &&&       r"   "test_value_counts_sort_categoricalr{    s     
Cq,7z	JB	CdT	2B__'_?F)$<'D\*{<(	
 ia$ H 	gg}}U#H6,r$   groupby_sortc                    \        R . ROR\        P                  /4      pVP                  R VR7      pVP	                  WR7      pR^^.\        P                  ..RR R./pV'       d   . p\        RR. . ./VB pM?V'       g!   V '       g   ^^.p\        RR^^ .^ ^ ../VB pM^^.p\        RR^ ^.^ ^ ../VB p\        WxRRR	7      p	\        P                  ! WY4       R
# )r   r   rY   )rV   rX   r   rL   r   rE  r   )r   r|   r   Nru  rZ   )	r   r4   r:   r   r   r   r   r   r   )
rV   rX   r|  r   r   r   r_   r   r   r!   s
   &&&       r"   test_value_counts_all_nar~    s     
CC0	1B	Cl	+B__$_6F!Q"&&*Gc3Z@F4"b4V4$1v<1a&1a&!1<V<1v<1a&1a&!1<V<dwWEH6,r$   )TrH   )Fr   )ry   rz   r   )r   r   r   ))FN)TT)TF)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   r   r.   )r,   r,   r,   r,   r   )r,   r.   r,   r,   r.   r7  r,   r,   r,   )r  )r   r   r   r   r   r   r:  )r  )r   r   r   r  ru  )r  )r   r   r   )r   r   r   )r   r   r   )	r   r,   r.   r9  r   r0   r2   r   r   )	r   r   rt  r   r   r   r   rt  rt  )r   r,   r.   r9  r   r   )r   r   rt  rt  rt  rt  )r   r,   r9  r   r0   r2   )r   r   r   r   r   r   )r   r,   r9  )r   r   rt  )rD  )r  r  )r   r   )ro   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   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   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   )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  r  r  r  )r,   r   r   r   r,   r   r,   r   r,   r   r   r   )rt  r-  rt  r-  rt  r-  rt  r-  rt  r-  r-  r-  )r   NrB  r   r   e)r   NrB  r   rT  r@  )?__doc__numpyr4   r   pandasr   r   r   r   r   r   r   r	   r
   pandas._testing_testingr   r#   rA   r   slowparametrizereprrc   rx   r   r   r   r   fixturer   r   r   r   r   r   r   r   rQ   r:   r	  r   rE  r  r$  r)  r+  r.  r0  r=  r8   rJ  rM  rO  rZ  r^  rb  rd  rk  rm  rx  r{  r~  rZ   r$   r"   <module>r     s    
 
 
 -(. tUm4b"X.QG,%!?TJ$AT:4-0*-ACS,TU'B V 1 ; K - / 5 'BT u.- /-< c3Z$AB	- C	- c3Z$AB- C--6-(  ,->V $CD*-ACS,TU 4-0W4 1 V EW4t tUm4I	oH	uoH	t_oG', 5',T E	eWi1RS	tUGY0QR	ueWi1RS-	
	 ;! ;8 @ '=		
 
(*HI	u(*LM	tY0
--> + F""?:	
 1#J238Wbff56
 $\<@:	
4 *-=?S,TU; V56;> eT]3$ HH9J	
 HHST	
60 4 60r 0F $ HH9J	
 HHST	
&&R $ HHFbhh	
 HH	
"%L,M%L,^  	
$ 		
%@ $ HH9J	
 HHQR		
 "0!A`"0J eT]3$ HH9J	
 HHST		
 80! 4"80v 0	#	|_-,," #	4="AB	,DL,),.ST004 ---55	--$ u.- /-B, T5M2tUm4- 5 3-6 T5M2tUm4- 5 3-> $7- 8-r$   