+
    xȇi^                     	   R t ^ RIHt ^ RIt^ RIt^ RIHt ^ RIH	t	H
t
Ht ^ RIHt ]P                  P!                  R4      t]P                  P%                  R4      t]P                  P%                  R4      tR tR	 t]P                  P/                  R
RR.R[R\.R\R[.R.R.R\.R[..4      ]P                  P/                  RRR.4      R 4       4       tR t]P                  P/                  R
RR..4      R 4       tR tR t]P                  P/                  R^ .]	! R]P:                  .R^.R^./]
! ^ .RR7      R7      3^ ^.]	! R]P:                  .R^./]P<                  ! R].RR.R7      R7      3RR.]	! R]P:                  .R^./]P<                  ! R].RR.R7      R7      3.4      R 4       t]P                  P/                  R/ R RR]P:                  RR!]P:                  R".R#. R^OR$R%R&R']P:                  R(]P:                  R)./3R
R . R$. /R*R+/R . R_OR#. R^OR$. R`O/3R
R.R*R+/R ]P:                  RR,RR!R-R".R#. R^OR$. R`O/3R
R . R$. //R RR]P:                  RR!]P:                  R".R#. R^OR$R%R&R']P:                  R(]P:                  R)./3.4      R. 4       t R/ t!R0 t"R1 t#]P                  P/                  R2R3R4.4      R5 4       t$]P                  P/                  R6R7^R .]P:                  ]P:                  .^R$..3R+R8R .R-R#.R9R$..3.4      R: 4       t%]R; 4       t&]P                  P/                  R<^]P:                  R=.R=]P:                  ..3R^R^/R>R=.]P:                  ]P:                  ..3.4      R? 4       t'R@ t(RA t)RB t*]P                  P/                  RC]+! Ra4      RD,           ]+! Rb4      ,           R
Ra./]+! Ra4      ]+! Rb4      .3]+! Ra4      RE,           RF,           / ]+! Ra4      ^.R,^..3]+! Ra4      RG,           R
Ra./]P:                  ^.3.4      RH 4       t,RI t-]P                  P/                  RJR+R,RK.3R7]P:                  RL.3.4      RM 4       t.RN t/]P                  P/                  ROR7R+.4      RP 4       t0]]P                  P/                  RQRcRdReRfRRRS.3RRRRS/3.4      RT 4       4       t1]RU 4       t2RV t3]RW 4       t4RX t5RY t6]]P                  P/                  R
RgRh.RhRg..4      RZ 4       4       t7R# )izg
Tests that NA values are properly handled during
parsing for all of the parsers defined in parsers.py
)StringION)STR_NA_VALUES)	DataFrameIndex
MultiIndexz=ignore:Passing a BlockManager to DataFrame:DeprecationWarningpyarrow_xfailpyarrow_skipc                 8   T pR pVP                  \        V4      4      p\        . ROR\        P                  R.\        P                  RR... R	OR7      pVP
                  R8X  d   RVP                  R
&   RVP                  R&   \        P                  ! W44       R# )zA,B,C
a,b,c
d,,f
,g,h
dfghcolumnspyarrowN)abcABC)   r   )   r   )	read_csvr   r   npnanengineloctmassert_frame_equalall_parsersparserdataresultexpecteds   &    u/Users/max/.openclaw/workspace/postharvest/venv/lib/python3.14/site-packages/pandas/tests/io/parser/test_na_values.pytest_string_nasr(      s    FD
 __Xd^,F	3,rvvsC.@AH }}	!#V#V&+    c                 X   T pR p\        RR.\        P                  R.\        P                  \        P                  ..RR.R7      pVP                  R8X  d#   RVP                  ^^.R3&   RVP                  R	&   VP                  \        V4      4      p\        P                  ! WC4       R# )
zA,B
foo,bar
NA,baz
NaN,nan
foobarbazr   r   r   r   Nr   r   )	r   r   r   r   r   r   r   r   r    )r"   r#   r$   r&   r%   s   &    r'   test_detect_string_nar/   .   s    FD
 
"&&%266266*:;c3ZH }}	!$(aVS[!#V__Xd^,F&+r)   	na_valuesz-999.0z-999r$   zA,B
-999,1.2
2,-999
3,4.5
z"A,B
-999,1.200
2,-999.000
3,4.500
c                    T p\        \        P                  R .R\        P                  .RR..RR.R7      pVP                  R8X  d   \        ;QJ d    R V 4       F  '       d   K   R	M	  R
M! R V 4       4      '       gN   Rp\
        P                  ! \        VR7      ;_uu_ 4        VP                  \        V4      VR7       RRR4       R# VP                  R8X  d9   RV9   d2   \
        P                  P                  RR7      pVP                  V4       VP                  \        V4      VR7      p\        P                  ! W4       R#   + '       g   i     R# ; i)g333333?       @      @g      @r   r   r   r   c              3   B   "   T F  p\        V\        4      x  K  	  R # 5i)N)
isinstancestr).0xs   & r'   	<genexpr>,test_non_string_na_values.<locals>.<genexpr>`   s     -T)QjC.@.@)s   FT9The 'pyarrow' engine requires all na_values to be stringsmatchr0   Nz-999.000z4pyarrow engined does not recognize equivalent floatsreason)r   r   r   r   allpytestraises	TypeErrorr   r   markxfailapplymarkerr   r    )	r"   r$   r0   requestr#   r&   msgrE   r%   s	   &&&&     r'   test_non_string_na_valuesrJ   ?   s   < F2663-#rvvc
CcSVZXH}}	!##-T)-T###-T)-T*T*TI]]9C00OOHTNiO@ 1	)	#
d(: {{  I ! 
 	D!__Xd^y_AF&+ 10s   (EE	c                   a	 0 RmpV\         8X  g   Q hT p\        V4      o	V	3R lp\        RP                  \	        V4       UUu. uF  w  rEV! WE4      NK  	  upp4      4      p\        \        P                  \        S	4      \        S	4      R7      pVP                  VRR7      p\        P                  ! W4       R# u uppi )-1.#INDc                    < V ^ 8X  d   RpM V ^ 8  d   RP                  R.V ,          4      pX V 2pV S^,
          8  d.   RP                  R.SV ,
          ^,
          ,          4      pV V 2pV# )     ,)join)ivbufjoinednvs   &&  r'   r   !test_default_na_values.<locals>.f   sr    6CU''3%!)$CaSkrAv:WWcUb1fqj12FE&"C
r)   
)r   indexN)header>   rO   NANaNr   NULLNonenull#NAN/An/a#N/A-NaN-nan<NA>1.#INDrL   1.#QNAN#N/A N/A-1.#QNAN)r   lenr   rQ   	enumerater   r   r   ranger   r   r    )
r"   
_NA_VALUESr#   r   rR   rS   r$   r&   r%   rV   s
   &        @r'   test_default_na_valuesro   r   s    J* &&&F	ZB DII9Z3HI3H41qw3HIJKDr%)DH__T$_/F&+	 Js   B<r-   c                    T pR p\        R\        P                  ^.\        P                  ^\        P                  .^^\        P                  ... ROR7      pVP                  R8X  dP   Rp\        P
                  ! \        VR7      ;_uu_ 4        VP                  \        V4      V^.R7       RRR4       R# VP                  \        V4      V^.R7      p\        P                  ! Wd4       R#   + '       g   i     R# ; i)	z3A,B,C
ignore,this,row
1,NA,3
-1.#IND,5,baz
7,8,NaN
      ?r   r   z@skiprows argument must be an integer when using engine='pyarrow'r<   )r0   skiprowsNr   r   r   r   r   rB   rC   
ValueErrorr   r   r   r    )r"   r0   r#   r$   r&   rI   r%   s   &&     r'   test_custom_na_valuesru      s    FD 
rvvq	BFFArvv.Arvv?H }}	!P]]:S11OOHTNi1#ON 2__Xd^yA3_OF&+ 21s   C..C?	c           
         R pT pVP                  \        V4      4      p\        R\        P                  ! R\        P
                  R.\        R7      R\        P                  ! RR\        P
                  .\        R7      R. R	O/4      pVP                  R8X  d   RVP                  R
&   RVP                  R&   \        P                  ! W44       R# )z1A,B,C
True,False,True
NA,True,False
False,NA,Truer   TFdtyper   r   r   N)TFT)r   r   r.   )r   r   r   r   arrayr   objectr   r   r   r    r"   r$   r#   r%   r&   s   &    r'   test_bool_na_valuesr|      s    D F__Xd^,F4/v>5$/v>$	
H }}	!#V#V&+r)   c                 P   R pT pVP                   R8X  dT   Rp\        P                  ! \        VR7      ;_uu_ 4        VP	                  \        V4      RR.RR./R7       R	R	R	4       R	# VP	                  \        V4      RR.RR./R7      p\        R\        P                  R\        P                  R.R\        P                  R\        P                  R.R
\        P                  R\        P                  R./4      p\        P                  ! WE4       R	#   + '       g   i     R	# ; i)z3A,B,C
foo,bar,NA
bar,foo,foo
foo,bar,NA
bar,foo,foor   z;pyarrow engine doesn't support passing a dict for na_valuesr<   r   r+   r   r,   r>   Nr   r   rB   rC   rt   r   r   r   r   r   r   r    r"   r$   r#   rI   dfr&   s   &     r'   test_na_value_dictr      s    D
 F}}	!K]]:S11OOHTNsUGS5'6ROS 2	$C%#w3O	PB"&&%/"&&%/"&&%/	
H "' 21s   #DD%	zindex_col,expectedr   r   r
   r   namerY   )namesc                     R pT pVP                  \        V4      \        4       VR7      p\        P                  ! WR4       R# )za,b,c,d
0,NA,1,5
)r0   	index_colN)r   r   setr   r    )r"   r   r&   r$   r#   r%   s   &&&   r'   test_na_value_dict_multi_indexr      s8    0D F__Xd^su	_RF&+r)   zkwargs,expectedr   er   r   r   onetwothreefivesevenkeep_default_naFrO   r   c                 0   R pT pVP                   R8X  d   RV9   dk   \        VR,          \        4      '       dN   Rp\        P                  ! \
        VR7      ;_uu_ 4        VP                  ! \        V4      3/ VB  RRR4       R# V'       d   RV9   d0   \        P                  P                  4       pVP                  V4       VP                  ! \        V4      3/ VB p	\        V4      p\        P                  ! W4       R#   + '       g   i     R# ; i)zAA,B,C
a,1,one
b,2,two
,3,three
d,4,nan
e,5,five
nan,6,
g,7,seven
r   r0   ?The pyarrow engine doesn't support passing a dict for na_valuesr<   N)r   r5   dictrB   rC   rt   r   r   rE   rF   rG   r   r   r    )
r"   kwargsr&   rH   using_infer_stringr$   r#   rI   rE   r%   s
   &&&&&     r'   test_na_values_keep_defaultr     s    P	D F}}	!& Z{0CT%J%JSCz559&9 6![F%:;;$$&D%__Xd^6v6F"H&+ 65s    DD	c           	          R pT pVP                  \        V4      RR7      p\        R. ROR. ROR. R	O/4      p\        P                  ! W44       R# )
zAA,B,C
a,1,None
b,2,two
,3,None
d,4,nan
e,5,five
nan,6,
g,7,seven
F)r   r   r   r   Nr   r   rO   r
   r   r   r   r   r                  )r^   r   r^   r   r   rO   r   )r   r   r   r   r    r{   s   &    r'   !test_no_na_values_no_keep_defaultr   H  sW    	D F__Xd^U_CF5&D	
H &+r)   c                    R pT pVP                   R8X  dR   Rp\        P                  ! \        VR7      ;_uu_ 4        VP	                  \        V4      RR./RR7       RRR4       R# VP	                  \        V4      RR./RR7      p\        R	R
.R\        P                  ./4      p\        P                  ! WE4       R#   + '       g   i     R# ; i)za,b
,2r   r   r<   r   2Fr0   r   Nr   rO   r~   )r"   r$   r#   rI   r%   r&   s   &     r'   &test_no_keep_default_na_dict_na_valuesr   b  s    DF}}	!O]]:S11OO3,   2 	__3,  F #tS266(34H&+ 21 	s   !B>>C	c                    R pT pVP                   R8X  dQ   Rp\        P                  ! \        VR7      ;_uu_ 4        VP	                  \        V4      R^/RR7       RRR4       R# VP	                  \        V4      R^/RR7      p\        R^.R\        P                  ./4      p\        P                  ! WE4       R#   + '       g   i     R# ; i)	za,b
1,2r   r   r<   r   Fr   Nr   r~   r   s   &     r'   -test_no_keep_default_na_dict_na_scalar_valuesr   v  s     DF}}	!O]]:S11OOHTNsAhPUOV 2	$C8U	SB#sC"&&23H"' 21s    B<<C	col_zero_na_valuesi 113125c                 <   R pT p\        ^ \        P                  R.^\        P                  R.^R\        P                  .^RR.^RR.^RR	.^\        P                  R
./4      pVP                  R8X  dX   Rp\        P
                  ! \        VR7      ;_uu_ 4        VP                  \        V4      RR^R	^R^R^ V/R7       RRR4       R# VP                  \        V4      RR^R	^R^R^ V/R7      p\        P                  ! Wd4       R#   + '       g   i     R# ; i)z_113125,"blah","/blaha",kjsdkj,412.166,225.874,214.008
729639,"qwer","",asdfkj,466.681,,252.373
g    ND&Aqwerz/blahakjsdkjasdfkjg-y@g7A`*}@z225.874rO   g-o@r   r   r<   NFz214.008blah)rZ   r   r0   rs   )r"   r   r$   r#   r&   rI   r%   s   &&     r'   1test_no_keep_default_na_dict_na_values_diff_reprsr     s(   D F!"&&!(#!	2 	

H }}	!O]]:S11OO %b!Y61>PQ	   2 	__b!Y616HI	  F &+ 21 	s   'D

D	zna_filter,row_dataT13c                 8   TpVP                   R 8X  dB   V'       d	   V'       g2   \        P                  P                  RR7      pV P	                  V4       RpVP                  \        V4      R.VR7      p\        VRR.R7      p	\        P                  ! W4       R# )	r   zpyarrow doesn't support this.r?   zA,B
1,A
nan,B
3,C
r   )r0   	na_filterr   r   N)
r   rB   rE   rF   rG   r   r   r   r   r    )
rH   r"   r   row_datar   r#   rE   r$   r%   r&   s
   &&&&&     r'   !test_na_values_na_filter_overrider     s     F}}	!"y;;$$,K$LD%D __Xd^u	_RFC:6H&+r)   c                 X   T pR pVP                  \        V4      4      p\        RRRRR\        P                  \        P                  \        P                  .RRRRR	\        P                  \        P                  \        P                  ... ROR
7      p\
        P                  ! W44       R# )zlDate,Currency,Symbol,Type,Units,UnitPrice,Cost,Tax
2012-03-14,USD,AAPL,BUY,1000
2012-05-12,USD,SBUX,SELL,500z
2012-03-14USDAAPLBUYi  z
2012-05-12SBUXSELLi  r   N)DateCurrencySymbolTypeUnits	UnitPriceCostTaxr   r   r   r   r   r   r    r!   s   &    r'   test_na_trailing_columnsr     s    F D
 __Xd^,F5&%rvvrvvrvvN5&&#rvvrvvrvvN	
	
H  &+r)   zna_values,row_datar2   rq   c                    T pR R.pRpVP                   R8X  dd   \        V\        4      '       dN   Rp\        P                  ! \
        VR7      ;_uu_ 4        VP                  \        V4      WAR7       RRR4       R# VP                   R8X  dN   Rp\        P                  ! \        VR7      ;_uu_ 4        VP                  \        V4      WAR7       RRR4       R# VP                  \        V4      WAR7      p\        W$R	7      p\        P                  ! Wx4       R#   + '       g   i     R# ; i  + '       g   i     R# ; i)
r   r   1,2
2,1r   r   r<   r   r0   Nr;   r   )r   r5   r   rB   rC   rt   r   r   rD   r   r   r    )	r"   r0   r   r#   r   r$   rI   r%   r&   s	   &&&      r'   test_na_values_scalarr     s     F#JED}}	!jD&A&AO]]:S11OOHTN%OM 2	)	#I]]9C00OOHTN%OM 1__Xd^5_NF1H&+ 21 10s   D4D/D,	/E 	c                    T pR ^R^/pVP                  4       pR R.pRp\        RR.\        P                  \        P                  ..VR7      pVP                  R8X  dN   Rp\
        P                  ! \        VR7      ;_uu_ 4        VP                  \        V4      WBR	7       R
R
R
4       R
# VP                  \        V4      WBR	7      p\        P                  ! W4       \        P                  ! W#4       R
#   + '       g   i     R
# ; i)r   r   r   rq   r2   r   r   r   r<   r   N)copyr   r   r   r   rB   rC   rt   r   r   r   r    assert_dict_equal)	r"   r#   r0   na_values_copyr   r$   r&   rI   r%   s	   &        r'   test_na_values_dict_aliasingr     s    Faa I^^%N#JED3*rvvrvv&67GH}}	!O]]:S11OOHTN%OM 2__Xd^5_NF&+3 21s   C66D	c                     T pR p. ROp\         P                  V\        4      pRRRRRR/pVP                  R8X  dS   Rp\        P
                  ! \        VR7      ;_uu_ 4        VP                  \        V4      ^ ^ VVVR	R
7       RRR4       R# \        RRR\        P                  .R. RO/\        . RO\        R7      R7      pVP                  \        V4      ^ ^ VVVR	R
7      p\        P                  ! W4       R#   + '       g   i     R# ; i)z,x,y

MA,1,2
NA,2,1
OA,,3Nr8   yrz   float64r   r   r<   F)r   rZ   rx   r   r0   r   rq   r2   rw   r   )Nr8   r   )r2   rq   r3   )MAr[   OA)r   fromkeysr   r   rB   rC   rt   r   r   r   r   r   r   rz   r   r    )	r"   r#   r$   r   r0   rx   rI   r&   r%   s	   &        r'   $test_na_values_dict_null_column_namer     s   F*DEe]3I8S)S)<E}}	!O]]:S11OO# %   2 		sC #7&f5H
 __  F &+7 21 	s   ""C<<D	c                    R pT p^ R/pVP                   R8X  dN   Rp\        P                  ! \        VR7      ;_uu_ 4        VP	                  \        V4      VR7       RRR4       R# VP	                  \        V4      VR7      p\        R\        P                  ^./4      p\        P                  ! WV4       R#   + '       g   i     R# ; i)za
foo
1r+   r   r   r<   r>   Nr   r~   )r"   r$   r#   r0   rI   r%   r&   s   &      r'   test_na_values_dict_col_indexr   C  s    DFE
I}}	!O]]:S11OOHTNiO@ 2__Xd^y_AF#{+,H&+ 21s    B88C		zdata,kwargs,expectedrX   z,1z
,2z
1c                    T pVP                   R 8X  dW   RV9   dP   Rp\        P                  ! \        VR7      ;_uu_ 4        VP                  ! \        V4      3RR/VB  RRR4       R# VP                   R 8X  d2   \        P                  P                  RR7      pVP                  V4       VP                  ! \        V4      3RR/VB p\        V4      p\        P                  ! W4       R#   + '       g   i     R# ; i)r   r0   r;   r<   rZ   Nz!Returns float64 instead of objectr?   )r   rB   rC   rD   r   r   rE   rF   rG   r   r   r    )	r"   r$   r   r&   rH   r#   rI   rE   r%   s	   &&&&&    r'   test_na_values_uint64r   T  s     F}}	!kV&;I]]9C00OOHTNB4B6B 1	)	#{{  (K LD!__Xd^CDCFCF"H&+ 10s   C--C>	c                     R pT p\        R^./\        R.RR7      R7      pVP                  \        V4      ^ RR7      p\        P
                  ! WC4       R# )	za,1
b,2r   r   r   r   r   F)r   r   N)r   r   r   r   r   r    )r"   r$   r#   r&   r%   s   &    r'   *test_empty_na_values_no_default_with_indexr   r  sM    DF#s5#S+ABH__Xd^q%_PF&+r)   zna_filter,index_data5g      @c                 F   T pR pVP                   R8X  d8   VRJ d2   \        P                  P                  RR7      pVP	                  V4       \        R^^.R^^./\        VRR7      R	7      pVP                  \        V4      ^.VR
7      p\        P                  ! W4       R# )a,b,c
1,,3
4,5,6r   Fzmismatched index resultr?   r   r   r   r   r   )r   r   N)r   rB   rE   rF   rG   r   r   r   r   r   r    )	r"   r   
index_datarH   r#   r$   rE   r&   r%   s	   &&&&     r'   test_no_na_filter_on_indexr   |  s     FD}}	!i5&8{{  (A BD!#1vsQF35RU;VWH__Xd^si_PF&+r)   c                     T pR pVP                  \        V4      ^ .RR.R7      p\        R^\        P                  .R^\        P                  ./\        ^^.RR7      R7      p\        P                  ! W44       R	# )
zidx,col1,col2
1,3,4
2,inf,-infinfz-inf)r   r0   col1col2idxr   r   N)r   r   r   r   r   r   r   r    )r"   r#   r$   outr&   s   &    r'   !test_inf_na_values_with_int_indexr     so    F-D //(4.QCE6?/
SC	!RVVfq"&&k2%AU:SH #(r)   r   c           	      ~   T pVP                   R 8X  d@   VRJ g	   V'       g2   \        P                  P                  RR7      pVP	                  V4       RpV'       d   \
        P                  MRp\        RRR.R	VR
.RRR./4      pVP                  \        V4      V\        R7      p	\        P                  ! W4       R# )r   Fzmismatched shaper?   r   rO   r   r   4r   r   r   r   6)r   rx   N)r   rB   rE   rF   rG   r   r   r   r   r   r6   r   r    )
r"   r   r   rH   r#   rE   r$   emptyr&   r%   s
   &&&&      r'   +test_na_values_with_dtype_str_and_na_filterr     s    
 F}}	!yE'9AS{{  (: ;D!D  BFFRE#Sz3cC:NOH__Xd^y_LF&+r)   zdata, na_valuesfalse,1
foo,1
truer+   c           
          T pR P                  RR.4      p\        P                  ! \        VR7      ;_uu_ 4        VP	                  \        V4      RRR.RR/VR7       RRR4       R#   + '       g   i     R# ; i)	|z(Bool column has NA values in column [0a]zRcannot safely convert passed user dtype of bool for object dtyped data in column 0r<   Nr   r   bool)rZ   r   rx   r0   )rQ   rB   rC   rt   r   r   )r"   r$   r0   r#   rI   s   &&&  r'   !test_cast_NA_to_bool_raises_errorr     sr     F
((66	
C 
z	-	-TN*- 	 	
 
.	-	-	-s   $A((A9	c                     T pR pVP                  \        V4      R. ROR\        R\        R\        /R7      P                  4       p\	        RRR.RRR	.RR
R./^^.R7      p\
        P                  ! W44       R# )zDFile: small.csv,,
10010010233,0123,654
foo,,bar
01001000155,4530,898Nr   r   col3)rZ   r   rx   100100102330100100015501234530654898r   )r   r   r   )r   r   r6   dropnar   r   r    r!   s   &    r'   test_str_nan_droppedr     s     FD
 __&sFC5	  
 fh  ]M2VV$UEN	

 !fH &+r)   c           
         T pR pVP                   R8X  dc   Rp\        P                  ! \        VR7      ;_uu_ 4        VP	                  \        V4      \        \        ^4      4      RR/R7       RRR4       R# VP	                  \        V4      \        \        ^4      4      RR/R7      p\        R^.R	^.R\        P                  ./4      p\        P                  ! WE4       R#   + '       g   i     R# ; i)
zA,B,B
X,Y,Z
1,2,infr   r   r<   r   )rZ   r0   N)r   Z)r   X)r   Y)r   rB   rC   rt   r   r   listrm   r   r   r   r   r    )r"   r#   r$   rI   r%   r&   s   &     r'   test_nan_multi_indexr     s    F"D}}	!O]]:S11OOtE!H~*eAT   2 	__tE!H~*e9L  F 	
H &+% 21 	s   2C##C4	c                     T pR p\         P                  ! \        RR7      ;_uu_ 4        VP                  \	        V4      RR7       RRR4       R#   + '       g   i     R# ; i)0
NaN
True
False
z	NA valuesr<   r   rw   N)rB   rC   rt   r   r   )r"   r#   r$   s   &  r'   test_bool_and_nan_to_boolr    sF     FD
 
z	5	5f5 
6	5	5	5s   AA!	c                    T pR pRpVP                   R8X  d   RpMVP                   R8X  d   Rp\        P                  ! \        VR7      ;_uu_ 4        VP	                  \        V4      RR7       R	R	R	4       R	#   + '       g   i     R	# ; i)
r  zycannot safely convert passed user dtype of int(64|32) for <class 'numpy.bool_?'> dtyped data in column 0 due to NA valuespythonz-Unable to convert column 0 to type int(64|32)r   zVint\(\) argument must be a string, a bytes-like object or a real number, not 'NoneTyper<   intrw   N)r   rB   rC   rt   r   r   )r"   r#   r$   rI   s   &   r'   test_bool_and_nan_to_intr    sx    FD	J  }} =	)	#) 	 
z	-	-e4 
.	-	-	-s   A99B
	c                     T pR pVP                  \        V4      RR7      p\        P                  ! R\        P
                  RR./4      p\        P                  ! W44       R# )r  floatrw   0rq   g        N)r   r   r   	from_dictr   r   r   r    r!   s   &    r'   test_bool_and_nan_to_floatr  0  sT    FD
 __Xd^7_;F""C"&&#s);#<=H&+r)   c                    T pR pVP                  \        V4      VR7      p\        R\        P                  \        P                  \        P                  \        P                  ./4      p\
        P                  ! WE4       R# )zA
-99
-99
-99.0
-99.0r>   r   Nr   )r"   r0   r#   r$   r%   r&   s   &&    r'   !test_na_values_dict_without_dtyper  =  s^     F	D __Xd^y_AF#?@AH&+r)   ig     8)rN   r   r   r   )r   r   r   r   r   rO   r   l            l           )zfalse,1
,1
trueN)zfalse,1
null,1
trueN)zfalse,1
nan,1
trueN)r   r+   g     Xi)8__doc__ior   numpyr   rB   pandas._libs.parsersr   pandasr   r   r   pandas._testing_testingr   rE   filterwarnings
pytestmarkusefixturesxfail_pyarrowskip_pyarrowr(   r/   parametrizerJ   ro   ru   r|   r   r   from_tuplesr   r   r   r   r   r   r   r   r   r   r   r   r6   r   r   r   r   r   r   r   r   r  r  r  r   r)   r'   <module>r     s  
    . 
 [[''C
 ''8{{&&~6,$," 	6	v		
			 
	
	,6,0-,` uug&67, 8,*,((2  CsRVVHcA3aS9sQTAUV	

 FrvvhaS) ,,fXc3ZH	
 #JrvvhaS) ,,fXc3ZH	
.,/.,  c3S"&&#>*eUGRVVVRVVWM	
 3C,.?G9*H	
 3%!2E:bffc2sC<*H	
 3C,-c3S"&&#>*eUGRVVVRVVWM	
3!$J,K$J,:,4,(($ -/AB$, C$,N 	C266266*QH56	#seS\C:67,,* , ,6 	
bffc]S"&&M*+
q#q	S#J(89:,,,4,%,P,"  JI.5'"ZY(	

 
Ud	V	#R3u:q/B7)CD	Ue	kE73bffa[A,,$, eb#Y/$1FG,, 
) tUm4, 5,( #'&'	%)	#u.


 
, , ,8,8 	6 	65.
, S\C< 
,	 

,r)   