
    I j7                       S SK Jr  S SKJrJr  S SKrS SKrS SKrS SK	J
s  Jr  S SKJrJrJr  S SKJr  S SKJr  S SKJr  \R0                  S 5       r\R0                  S 5       r\R0                  S	 5       rS
 r\R0                  " SS/S9S 5       r\R0                  " \R<                  " S\R>                  " S5      S9S/S9S 5       r S r!S r"S r#S r$S r%S r&\RN                  RQ                  S\)\*/5      S 5       r+Sr,S r-S r.S r/S r0S  r1S! r2S" r3S# r4S$ r5S% r6S& r7S' r8S( r9S) r:S* r;S+ r<S, r=S- r>S. r?S/ r@S0rAS1 rBS2 rC\RN                  RQ                  S3/ S4Q5      S5 5       rDS6 rES7 rFS8 rGS9 rH\R                  " S5      S: 5       rJS; rKS<rLS= rMS> rNS? rOS@ rP\RN                  RQ                  SA\" SB5      \" SC5      /5      SD 5       rQSE rRSF rSSG rTSH rUSI rVSJ rWSK rXSrYSL rZSM r[SN r\SO r]\RN                  R                  SP 5       r_g)Q    )annotations)BytesIOStringION)NA	DataFrameIndex)
get_handle)read_xmlc                 J    [        / SQ/ SQS[        R                  S/S.5      $ )N)squarecircletriangle)h  r            shapedegreessides)r   npnan     p/root/GenerationalWealth/GenerationalWealth/venv/lib/python3.13/site-packages/pandas/tests/io/xml/test_to_xml.pygeom_dfr   ;   s'    5&^	
 r   c                 2    [        / SQ/ SQ/ SQ/ SQS.5      $ )N)MercuryVenusEarthMarsJupiterSaturnUranusNeptune)terrestrialr&   r&   r&   	gas giantr'   	ice giantr(   )innerr)   r)   r)   outerr*   r*   r*   )g`|x ?gcAJx@g2r@gl?gh|@g	@gd]FU@g	hY@)planettypelocationmass)r   r   r   r   	planet_dfr/   F   s(    				?)	
+ +r   c                     g)Nac  <?xml version='1.0' encoding='utf-8'?>
<data>
  <row>
    <index>0</index>
    <category>cooking</category>
    <title>Everyday Italian</title>
    <author>Giada De Laurentiis</author>
    <year>2005</year>
    <price>30.0</price>
  </row>
  <row>
    <index>1</index>
    <category>children</category>
    <title>Harry Potter</title>
    <author>J K. Rowling</author>
    <year>2005</year>
    <price>29.99</price>
  </row>
  <row>
    <index>2</index>
    <category>web</category>
    <title>Learning XML</title>
    <author>Erik T. Ray</author>
    <year>2003</year>
    <price>39.95</price>
  </row>
</data>r   r   r   r   from_file_expectedr1   v   s    r   c                0    U b  U R                  SS5      n U $ )Nz%<?xml version="1.0" encoding="utf-8"?z%<?xml version='1.0' encoding='utf-8'?)replace)docs    r   equalize_declr5      s"    
kk33
 Jr   rbr)paramsc                    U R                   $ Nparamrequests    r   moder?          ==r   lxml)marksetreec                    U R                   $ r:   r;   r=   s    r   parserrE      r@   r   c                    [        XS9nUR                  X1S9  UR                  SS9R                  5       n[	        U5      nXR:X  d   eg NrE   utf-8encodingr
   to_xml	read_textstripr5   	xml_booksrE   r1   	temp_filedf_fileoutputs         r   test_file_output_str_readrU      L    y0GNN9N,  ' 288:F6"F'''r   c                    [        XS9nUR                  X1S9  UR                  SS9R                  5       n[	        U5      nXR:X  d   eg rG   rL   rP   s         r   test_file_output_bytes_readrX      rV   r   c                X    [        XS9nUR                  US9n[        U5      nXB:X  d   eg NrH   )r
   rM   r5   )rQ   rE   r1   rS   rT   s        r   test_str_outputr[      s2    y0G^^6^*F6"F'''r   c                    Sn[         R                  " [        SS9   UR                  X S9  S S S 5        g ! , (       d  f       g = f)Nz/my/fake/path/output.xmlz6Cannot save file into a non-existent directory: .*pathmatchrH   )pytestraisesOSErrorrM   )rE   r   paths      r   test_wrong_file_pathrc      s9    %D	H
 	t+	
 
 
s	   5
Ac                    Sn[        XS9nUR                  USUS9  UR                  SS9R                  5       n[	        U5      nXS:X  d   eg )Na$  <?xml version='1.0' encoding='utf-8'?>
<data>
  <row>
    <category>cooking</category>
    <title>Everyday Italian</title>
    <author>Giada De Laurentiis</author>
    <year>2005</year>
    <price>30.0</price>
  </row>
  <row>
    <category>children</category>
    <title>Harry Potter</title>
    <author>J K. Rowling</author>
    <year>2005</year>
    <price>29.99</price>
  </row>
  <row>
    <category>web</category>
    <title>Learning XML</title>
    <author>Erik T. Ray</author>
    <year>2003</year>
    <price>39.95</price>
  </row>
</data>rH   FindexrE   rI   rJ   rL   rQ   rE   rR   expectedrS   rT   s         r   test_index_falseri      sY    H4 y0GNN9E&N9  ' 288:F6"Fr   c                    Sn[        XS9nUR                  USSSUS9  UR                  SS9R                  5       n[	        U5      nXS:X  d   eg )	Na,  <?xml version='1.0' encoding='utf-8'?>
<books>
  <book>
    <category>cooking</category>
    <title>Everyday Italian</title>
    <author>Giada De Laurentiis</author>
    <year>2005</year>
    <price>30.0</price>
  </book>
  <book>
    <category>children</category>
    <title>Harry Potter</title>
    <author>J K. Rowling</author>
    <year>2005</year>
    <price>29.99</price>
  </book>
  <book>
    <category>web</category>
    <title>Learning XML</title>
    <author>Erik T. Ray</author>
    <year>2003</year>
    <price>39.95</price>
  </book>
</books>rH   Fbooksbook)rf   	root_namerow_namerE   rI   rJ   rL   rg   s         r    test_index_false_rename_row_rootro      se    H4 y0GNN'F6     ' 288:F6"Fr   typc                    Sn[        SS5       Vs/ s H
  oA" U5      PM     nnUR                  5       n[        U5      Ul        UR	                  SU S9n[        U5      nXs:X  d   egs  snf )z
Tests that the output does not contain the `<index>` field when the index of the
input Dataframe has an offset.

This is a regression test for issue #42458.
aD  <?xml version='1.0' encoding='utf-8'?>
<data>
  <row>
    <shape>square</shape>
    <degrees>360</degrees>
    <sides>4.0</sides>
  </row>
  <row>
    <shape>circle</shape>
    <degrees>360</degrees>
    <sides/>
  </row>
  <row>
    <shape>triangle</shape>
    <degrees>180</degrees>
    <sides>3.0</sides>
  </row>
</data>
      Fre   N)rangecopyr   rf   rM   r5   )rE   rp   r   rh   ioffset_indexoffset_geom_dfrT   s           r   (test_index_false_with_offset_input_indexry   %  sq    H& %*"bM2MqCFML2\\^N .N""v">F6"F 3s   A'a  <?xml version='1.0' encoding='utf-8'?>
<data>
  <row>
    <index>0</index>
    <shape>square</shape>
    <degrees>360</degrees>
    <sides>4.0</sides>
  </row>
  <row>
    <index>1</index>
    <shape>circle</shape>
    <degrees>360</degrees>
    <sides/>
  </row>
  <row>
    <index>2</index>
    <shape>triangle</shape>
    <degrees>180</degrees>
    <sides>3.0</sides>
  </row>
</data>c                P    UR                  U S9n[        U5      nU[        :X  d   eg rZ   rM   r5   na_expectedrE   r   rT   s      r   test_na_elem_outputr~   d  s*    ^^6^*F6"F[   r   c                R    UR                  SU S9n[        U5      nU[        :X  d   eg )N na_reprE   r{   r}   s      r   test_na_empty_str_elem_optionr   k  s,    ^^2f^5F6"F[   r   c                L    SnUR                  SU S9n[        U5      nX2:X  d   eg )Na  <?xml version='1.0' encoding='utf-8'?>
<data>
  <row>
    <index>0</index>
    <shape>square</shape>
    <degrees>360</degrees>
    <sides>4.0</sides>
  </row>
  <row>
    <index>1</index>
    <shape>circle</shape>
    <degrees>360</degrees>
    <sides>0.0</sides>
  </row>
  <row>
    <index>2</index>
    <shape>triangle</shape>
    <degrees>180</degrees>
    <sides>3.0</sides>
  </row>
</data>z0.0r   rM   r5   rE   r   rh   rT   s       r   test_na_empty_elem_optionr   r  s3    H. ^^5^8F6"Fr   c                P    SnUR                  / SQU S9n[        U5      nX2:X  d   eg )Nz<?xml version='1.0' encoding='utf-8'?>
<data>
  <row index="0" shape="square" degrees="360" sides="4.0"/>
  <row index="1" shape="circle" degrees="360"/>
  <row index="2" shape="triangle" degrees="180" sides="3.0"/>
</data>r   	attr_colsrE   r   r   s       r   test_attrs_cols_nan_outputr     s4    H ^^&CF^SF6"Fr   c                X    SnUR                  / SQSS0SU S9n[        U5      nX2:X  d   eg )Na>  <?xml version='1.0' encoding='utf-8'?>
<doc:data xmlns:doc="http://example.xom">
  <doc:row doc:index="0" doc:shape="square" doc:degrees="360" doc:sides="4.0"/>
  <doc:row doc:index="1" doc:shape="circle" doc:degrees="360"/>
  <doc:row doc:index="2" doc:shape="triangle" doc:degrees="180" doc:sides="3.0"/>
</doc:data>)rf   r   r   r   r4   zhttp://example.xom)r   
namespacesprefixrE   r   r   s       r   test_attrs_cols_prefixr     sH    	H ^^8/0	  F 6"Fr   c                    [         R                  " [        SS9   UR                  / SQU S9  S S S 5        g ! , (       d  f       g = f)Nno valid columnr]   r   degreer   r   r_   r`   KeyErrorrM   rE   r   s     r   test_attrs_unknown_columnr     .    	x(9	;!=fM 
<	;	;	   6
Ac                    [         R                  " [        SS9   UR                  SU S9  S S S 5        g ! , (       d  f       g = f)Nz!is not a valid type for attr_colsr]   "shape", "degree", "sides"r   r_   r`   	TypeErrorrM   r   s     r   test_attrs_wrong_typer     /    	y)L	N!=fM 
O	N	N	   4
Ac                R    SnUR                  S/ SQU S9n[        U5      nX2:X  d   eg )NaD  <?xml version='1.0' encoding='utf-8'?>
<data>
  <row>
    <degrees>360</degrees>
    <sides>4.0</sides>
    <shape>square</shape>
  </row>
  <row>
    <degrees>360</degrees>
    <sides/>
    <shape>circle</shape>
  </row>
  <row>
    <degrees>180</degrees>
    <sides>3.0</sides>
    <shape>triangle</shape>
  </row>
</data>F)r   r   r   )rf   	elem_colsrE   r   rE   r   elems_cols_expectedrT   s       r   test_elems_cols_nan_outputr     s?    ( ^^<V  F 6"F(((r   c                    [         R                  " [        SS9   UR                  / SQU S9  S S S 5        g ! , (       d  f       g = f)Nr   r]   r   r   rE   r   r   s     r   test_elems_unknown_columnr     r   r   c                    [         R                  " [        SS9   UR                  SU S9  S S S 5        g ! , (       d  f       g = f)Nz!is not a valid type for elem_colsr]   r   r   r   r   s     r   test_elems_wrong_typer     r   r   c                V    SnUR                  SSS/S/U S9n[        U5      nX2:X  d   eg )Na#  <?xml version='1.0' encoding='utf-8'?>
<data>
  <row shape="square">
    <degrees>360</degrees>
    <sides>4.0</sides>
  </row>
  <row shape="circle">
    <degrees>360</degrees>
    <sides/>
  </row>
  <row shape="triangle">
    <degrees>180</degrees>
    <sides>3.0</sides>
  </row>
</data>Fr   r   r   )rf   r   r   rE   r   r   s       r   test_elems_and_attrs_colsr     sJ    " ^^g&)	  F 6"F(((r   c                    SnUR                  SS/S/ SQSS9R                  S5      nUR                  U S	9n[        U5      nXB:X  d   eg )
Na  <?xml version='1.0' encoding='utf-8'?>
<data>
  <row>
    <location>inner</location>
    <type>terrestrial</type>
    <count_mass>4</count_mass>
    <sum_mass>11.81</sum_mass>
    <mean_mass>2.95</mean_mass>
  </row>
  <row>
    <location>outer</location>
    <type>gas giant</type>
    <count_mass>2</count_mass>
    <sum_mass>2466.5</sum_mass>
    <mean_mass>1233.25</mean_mass>
  </row>
  <row>
    <location>outer</location>
    <type>ice giant</type>
    <count_mass>2</count_mass>
    <sum_mass>189.23</sum_mass>
    <mean_mass>94.61</mean_mass>
  </row>
  <row>
    <location>All</location>
    <type/>
    <count_mass>8</count_mass>
    <sum_mass>2667.54</sum_mass>
    <mean_mass>333.44</mean_mass>
  </row>
</data>r-   r,   r.   countsummeanTrf   valuesaggfuncmargins   rH   )pivot_tableroundrM   r5   rE   r/   rh   pvtrT   s        r   test_hierarchical_columnsr     sh    HB 

6"(	   
 eAh  ZZvZ&F6"Fr   c                    SnUR                  SS/S/ SQSS9R                  S5      nUR                  [        UR	                  5       R
                  R                  5      U S	9n[        U5      nXB:X  d   eg )
Na  <?xml version='1.0' encoding='utf-8'?>
<data>
  <row location="inner" type="terrestrial" count_mass="4" sum_mass="11.81" mean_mass="2.95"/>
  <row location="outer" type="gas giant" count_mass="2" sum_mass="2466.5" mean_mass="1233.25"/>
  <row location="outer" type="ice giant" count_mass="2" sum_mass="189.23" mean_mass="94.61"/>
  <row location="All" type="" count_mass="8" sum_mass="2667.54" mean_mass="333.44"/>
</data>r-   r,   r.   r   Tr   r   r   )r   r   rM   listreset_indexcolumnsr   r5   r   s        r   test_hierarchical_attrs_columnsr   <  s    H 

6"(	   
 eAh  ZZ$s'8'@'@'G'G"HQWZXF6"Fr   c                    SnUR                  SS/5      S   R                  / SQ5      R                  S5      nUR                  U S9n[	        U5      nXB:X  d   eg )Na  <?xml version='1.0' encoding='utf-8'?>
<data>
  <row>
    <location>inner</location>
    <type>terrestrial</type>
    <count>4</count>
    <sum>11.81</sum>
    <mean>2.95</mean>
  </row>
  <row>
    <location>outer</location>
    <type>gas giant</type>
    <count>2</count>
    <sum>2466.5</sum>
    <mean>1233.25</mean>
  </row>
  <row>
    <location>outer</location>
    <type>ice giant</type>
    <count>2</count>
    <sum>189.23</sum>
    <mean>94.61</mean>
  </row>
</data>r-   r,   r.   r   r   rH   )groupbyaggr   rM   r5   rE   r/   rh   r   rT   s        r   test_multi_indexr   Z  sd    H6 	:v./7	%	&	q  ZZvZ&F6"Fr   c                   SnUR                  SS/5      S   R                  / SQ5      R                  S5      nUR                  [	        UR                  5       R                  R                  5      U S9n[        U5      nXB:X  d   eg )Na$  <?xml version='1.0' encoding='utf-8'?>
<data>
  <row location="inner" type="terrestrial" count="4" sum="11.81" mean="2.95"/>
  <row location="outer" type="gas giant" count="2" sum="2466.5" mean="1233.25"/>
  <row location="outer" type="ice giant" count="2" sum="189.23" mean="94.61"/>
</data>r-   r,   r.   r   r   r   )	r   r   r   rM   r   r   r   r   r5   r   s        r   test_multi_index_attrs_colsr     s    	H 	:v./7	%	&	q 
 ZZ$s'8'@'@'G'G"HQWZXF6"Fr   c                P    SnUR                  SS0U S9n[        U5      nX2:X  d   eg )Na  <?xml version='1.0' encoding='utf-8'?>
<data xmlns="http://example.com">
  <row>
    <index>0</index>
    <shape>square</shape>
    <degrees>360</degrees>
    <sides>4.0</sides>
  </row>
  <row>
    <index>1</index>
    <shape>circle</shape>
    <degrees>360</degrees>
    <sides/>
  </row>
  <row>
    <index>2</index>
    <shape>triangle</shape>
    <degrees>180</degrees>
    <sides>3.0</sides>
  </row>
</data>r   http://example.comr   rE   r   r   s       r   test_default_namespacer     s9    H. ^^,@'A&^QF6"Fr   c                R    SnUR                  SSS.U S9n[        U5      nX2:X  d   eg )Na  <?xml version='1.0' encoding='utf-8'?>
<data xmlns:oth="http://other.org" xmlns:ex="http://example.com">
  <row>
    <index>0</index>
    <shape>square</shape>
    <degrees>360</degrees>
    <sides>4.0</sides>
  </row>
  <row>
    <index>1</index>
    <shape>circle</shape>
    <degrees>360</degrees>
    <sides/>
  </row>
  <row>
    <index>2</index>
    <shape>triangle</shape>
    <degrees>180</degrees>
    <sides>3.0</sides>
  </row>
</data>http://other.orgr   )othexr   r   r   s       r   test_unused_namespacesr     sB    H. ^^-5IJ  F 6"Fr   c                R    SnUR                  SS0SU S9n[        U5      nX2:X  d   eg )Na  <?xml version='1.0' encoding='utf-8'?>
<doc:data xmlns:doc="http://example.com">
  <doc:row>
    <doc:index>0</doc:index>
    <doc:shape>square</doc:shape>
    <doc:degrees>360</doc:degrees>
    <doc:sides>4.0</doc:sides>
  </doc:row>
  <doc:row>
    <doc:index>1</doc:index>
    <doc:shape>circle</doc:shape>
    <doc:degrees>360</doc:degrees>
    <doc:sides/>
  </doc:row>
  <doc:row>
    <doc:index>2</doc:index>
    <doc:shape>triangle</doc:shape>
    <doc:degrees>180</doc:degrees>
    <doc:sides>3.0</doc:sides>
  </doc:row>
</doc:data>r4   r   r   r   rE   r   r   s       r   test_namespace_prefixr     sC    H. ^^/0v  F 6"Fr   c                    [         R                  " [        SS9   UR                  SS0SU S9  S S S 5        g ! , (       d  f       g = f)Nz!doc is not included in namespacesr]   r   r   r4   r   r   r   s     r   test_missing_prefix_in_nmspr     s<    	x(K	M01% 	 	
 
N	M	Ms	   7
Ac                T    SnUR                  SSS.SU S9n[        U5      nX2:X  d   eg )Na7  <?xml version='1.0' encoding='utf-8'?>
<doc:data xmlns:doc="http://other.org" xmlns="http://example.com">
  <doc:row>
    <doc:index>0</doc:index>
    <doc:shape>square</doc:shape>
    <doc:degrees>360</doc:degrees>
    <doc:sides>4.0</doc:sides>
  </doc:row>
  <doc:row>
    <doc:index>1</doc:index>
    <doc:shape>circle</doc:shape>
    <doc:degrees>360</doc:degrees>
    <doc:sides/>
  </doc:row>
  <doc:row>
    <doc:index>2</doc:index>
    <doc:shape>triangle</doc:shape>
    <doc:degrees>180</doc:degrees>
    <doc:sides>3.0</doc:sides>
  </doc:row>
</doc:data>r   r   )r   r4   r4   r   r   r   s       r   !test_namespace_prefix_and_defaultr     sE    H. ^^,5GH  F
 6"Fr   u  <?xml version='1.0' encoding='ISO-8859-1'?>
<data>
  <row>
    <index>0</index>
    <rank>1</rank>
    <malename>José</malename>
    <femalename>Sofía</femalename>
  </row>
  <row>
    <index>1</index>
    <rank>2</rank>
    <malename>Luis</malename>
    <femalename>Valentina</femalename>
  </row>
  <row>
    <index>2</index>
    <rank>3</rank>
    <malename>Carlos</malename>
    <femalename>Isabella</femalename>
  </row>
  <row>
    <index>3</index>
    <rank>4</rank>
    <malename>Juan</malename>
    <femalename>Camila</femalename>
  </row>
  <row>
    <index>4</index>
    <rank>5</rank>
    <malename>Jorge</malename>
    <femalename>Valeria</femalename>
  </row>
</data>c                    [        XSS9R                  S5      nUR                  SUS9nUb  UR                  SS5      nU[        :X  d   eg )N
ISO-8859-1)rE   rK      rK   rE   z*<?xml version="1.0" encoding="ISO-8859-1"?z*<?xml version='1.0' encoding='ISO-8859-1'?)r
   headrM   r3   encoding_expected)xml_baby_namesrE   rS   rT   s       r   test_encoding_option_strr   L  sW    ~|LQQRSTG^^\&^AF88

 &&&&r   c                j    [         R                  " S5        [        U SSS9nUR                  USSSS9  g NrA   r   r   F)rf   rK   rE   r_   importorskipr
   rM   )r   rR   rS   s      r   test_correct_encoding_filer   [  s2    
~VLGNN9ELNPr   rK   )zUTF-8zUTF-16r   c                h    [         R                  " S5        [        U SSS9nUR                  USX!S9  g r   r   )r   rE   rK   rR   rS   s        r   test_wrong_encoding_option_lxmlr   b  s0    
~VLGNN9EHNLr   c                    [         R                  " [        SS9   UR                  SU S9  S S S 5        g ! , (       d  f       g = f)Nzunknown encodingr]   zuft-8r   )r_   r`   LookupErrorrM   r   s     r   test_misspelled_encodingr   j  s.    	{+=	?7 
@	?	?r   c                `    [         R                  " S5        SnU R                  SS9nX!:X  d   eg )NrA   a\  <data>
  <row>
    <index>0</index>
    <shape>square</shape>
    <degrees>360</degrees>
    <sides>4.0</sides>
  </row>
  <row>
    <index>1</index>
    <shape>circle</shape>
    <degrees>360</degrees>
    <sides/>
  </row>
  <row>
    <index>2</index>
    <shape>triangle</shape>
    <degrees>180</degrees>
    <sides>3.0</sides>
  </row>
</data>F)xml_declaration)r_   r   rM   )r   rh   rT   s      r   !test_xml_declaration_pretty_printr   r  s5    
H, ^^E^2Fr   c                v    SnUR                  SU S9n[        U5      nUb  UR                  SS5      nX2:X  d   eg )Na4  <?xml version='1.0' encoding='utf-8'?>
<data><row><index>0</index><shape>square</shape><degrees>360</degrees><sides>4.0</sides></row><row><index>1</index><shape>circle</shape><degrees>360</degrees><sides/></row><row><index>2</index><shape>triangle</shape><degrees>180</degrees><sides>3.0</sides></row></data>F)pretty_printrE    />/>)rM   r5   r3   r   s       r   test_no_pretty_print_with_declr     sN    	  ^^v^>F6"F t,r   c                b    SnUR                  SSU S9nUb  UR                  SS5      nX2:X  d   eg )Na  <data><row><index>0</index><shape>square</shape><degrees>360</degrees><sides>4.0</sides></row><row><index>1</index><shape>circle</shape><degrees>360</degrees><sides/></row><row><index>2</index><shape>triangle</shape><degrees>180</degrees><sides>3.0</sides></row></data>F)r   r   rE   r   r   )rM   r3   r   s       r   test_no_pretty_print_no_declr     sF    	  ^^Ef^UF t,r   c                    [         R                  " [        SS9   U R                  5         S S S 5        g ! , (       d  f       g = f)Nz7lxml not found, please install or use the etree parser.r]   )r_   r`   ImportErrorrM   r   s    r   test_default_parser_no_lxmlr     s0    	U
 	
 
 
r   c                    [         R                  " [        SS9   U R                  SS9  S S S 5        g ! , (       d  f       g = f)Nz,Values for parser can only be lxml or etree.r]   bs4rH   r_   r`   
ValueErrorrM   r   s    r   test_unknown_parserr     s4    	I
 	e$
 
 
s	   3
Aa%  <?xml version="1.0" encoding="utf-8"?>
<data>
  <row>
    <field field="index">0</field>
    <field field="shape">square</field>
    <field field="degrees">360</field>
    <field field="sides">4.0</field>
  </row>
  <row>
    <field field="index">1</field>
    <field field="shape">circle</field>
    <field field="degrees">360</field>
    <field field="sides"/>
  </row>
  <row>
    <field field="index">2</field>
    <field field="shape">triangle</field>
    <field field="degrees">180</field>
    <field field="sides">3.0</field>
  </row>
</data>c                    [         R                  " S5        [        XUS:X  a  SOS S9 nUR                  US9[        :X  d   e S S S 5        g ! , (       d  f       g = fNrA   r7   rI   rJ   
stylesheetr_   r   openrM   xsl_expected)xsl_row_field_outputr?   r   fs       r   test_stylesheet_file_liker    sQ    
	W
	
~~~+|;;;
 
 
s   A
Ac                0   [         R                  " S5        [        XUS:X  a  SOS S9 nUS:X  a  [        UR	                  5       5      nO[        UR	                  5       5      nS S S 5        UR                  WS9nU[        :X  d   eg ! , (       d  f       N*= f)NrA   r7   rI   rJ   r6   r   )r_   r   r  r   readr   rM   r  )r  r?   r   r  xsl_objrT   s         r   test_stylesheet_ior
    s      
W
	
4<affh'Gqvvx(G
 ^^w^/F\!!!
 
s   :B
Bc                    [         R                  " S5        [        XUS:X  a  SOS S9 nUR                  US9nS S S 5        W[        :X  d   eg ! , (       d  f       N= fr   r  )r  r?   r   r  rT   s        r   test_stylesheet_buffered_readerr    sX    
	W
	
1-

 \!!!
 
s   A
Ac                    [         R                  " S5        [        R                  R	                  SSSS5      n[         R
                  " [        SS9   U R                  US9  S S S 5        g ! , (       d  f       g = f)	N
lxml.etreedoesnotexistzrow_field_output.xsltz$\[Errno 2\] No such file or directorr]   r   )r_   r   osrb   joinr`   FileNotFoundErrorrM   r   xsls     r   test_stylesheet_wrong_pathr    s[    
%
'',,vug/F
GC	!H
 	#&
 
 
s   A++
A9valr   r   c                    [         R                  " S5      nSR                  / SQ5      n[         R                  " UR                  US9   UR                  U S9  S S S 5        g ! , (       d  f       g = f)Nr  |)zDocument is emptyz!Start tag expected, '<' not foundzNone \(line 0\)r]   r   )r_   r   r  r`   XMLSyntaxErrorrM   )r  r   
lxml_etreemsgs       r   test_empty_string_stylesheetr    sU    $$\2J
((	
C 
z00	<#& 
=	<	<s   	A""
A0c                    [         R                  " S5      nSn[         R                  " UR                  SS9   U R	                  [        U5      S9  S S S 5        g ! , (       d  f       g = f)Nr  aR  <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="xml" encoding="utf-8" indent="yes" >
    <xsl:strip-space elements="*"/>

    <xsl:template match="@*|node()">
        <xsl:copy>
            <xsl:apply-templates select="@*|node()"/>
        </xsl:copy>
    </xsl:template>

    <xsl:template match="row/*">
        <field>
            <xsl:attribute name="field">
                <xsl:value-of select="name()"/>
            </xsl:attribute>
            <xsl:value-of select="text()"/>
        </field>
    </xsl:template>
</xsl:stylesheet>zOpening and ending tag mismatchr]   r   )r_   r   r`   r  rM   r   r   r  r  s      r   test_incorrect_xsl_syntaxr!  $  sW    $$\2JC* 
!!)J
 	(3-0
 
 
   A
A(c                    [         R                  " S5      nSn[         R                  " UR                  SS9   U R	                  [        U5      S9  S S S 5        g ! , (       d  f       g = f)Nr  aT  <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="xml" encoding="utf-8" indent="yes" />
    <xsl:strip-space elements="*"/>

    <xsl:template match="@*|node(*)">
        <xsl:copy>
            <xsl:apply-templates select="@*|node()"/>
        </xsl:copy>
    </xsl:template>

    <xsl:template match="row/*">
        <field>
            <xsl:attribute name="field">
                <xsl:value-of select="name()"/>
            </xsl:attribute>
            <xsl:value-of select="text()"/>
        </field>
    </xsl:template>
</xsl:stylesheet>zfailed to compiler]   r   )r_   r   r`   XSLTParseErrorrM   r   r   s      r   test_incorrect_xsl_evalr%  B  sO    $$\2JC* 
z008K	L(3-0 
M	L	Lr"  c                    [         R                  " S5      nSn[         R                  " UR                  SS9   U R	                  U[        U5      S9  S S S 5        g ! , (       d  f       g = f)Nr  ag  <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="xml" encoding="utf-8" indent="yes" />
    <xsl:strip-space elements="*"/>

    <xsl:template match="@*|node()">
        <xsl:copy>
            <xsl:copy-of select="document('non_existent.xml')/*"/>
        </xsl:copy>
    </xsl:template>
</xsl:stylesheet>zCannot resolve URIr]   r   )r_   r   r`   XSLTApplyErrorrM   r   )r   rR   r  r  s       r   test_incorrect_xsl_applyr(  ^  sQ    $$\2J
C 
z008L	MyXc]; 
N	M	Ms   A
A)c                    Sn[         R                  " [        SS9   U R                  S[	        U5      S9  S S S 5        g ! , (       d  f       g = f)NaI  <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="xml" encoding="utf-8" indent="yes" />
    <xsl:strip-space elements="*"/>

    <xsl:template match="@*|node(*)">
        <xsl:copy>
            <xsl:apply-templates select="@*|node()"/>
        </xsl:copy>
    </xsl:template>z*To use stylesheet, you need lxml installedr]   rC   )rE   r   )r_   r`   r   rM   r   r  s     r   test_stylesheet_with_etreer*  q  s;    	C 
z)U	Vg(3-@ 
W	V	Vs	   ?
Ac                    [         R                  " S5        SnU R                  SS9nUb  UR                  5       nU R	                  [        U5      S9nX#:X  d   eg )NrA   aQ  <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="text" indent="yes" />
    <xsl:strip-space elements="*"/>

    <xsl:param name="delim">,</xsl:param>
    <xsl:template match="/data">
        <xsl:text>,shape,degrees,sides&#xa;</xsl:text>
        <xsl:apply-templates select="row"/>
    </xsl:template>

    <xsl:template match="row">
        <xsl:value-of select="concat(index, $delim, shape, $delim,
                                     degrees, $delim, sides)"/>
         <xsl:text>&#xa;</xsl:text>
    </xsl:template>
</xsl:stylesheet>
)lineterminatorr   )r_   r   to_csvrO   rM   r   )r   r  out_csvout_xmls       r   test_style_to_csvr1    sZ    
C$ nnDn1G--/nnn6Gr   c                    [         R                  " S5        SnU R                  5       nU R                  S[	        U5      S9nX2:X  d   eg )NrA   a  <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="text" indent="yes" />
    <xsl:strip-space elements="*"/>

    <xsl:param name="delim"><xsl:text>               </xsl:text></xsl:param>
    <xsl:template match="/data">
        <xsl:text>      shape  degrees  sides&#xa;</xsl:text>
        <xsl:apply-templates select="row"/>
    </xsl:template>

    <xsl:template match="row">
        <xsl:value-of select="concat(index, ' ',
                                     substring($delim, 1, string-length('triangle')
                                               - string-length(shape) + 1),
                                     shape,
                                     substring($delim, 1, string-length(name(degrees))
                                               - string-length(degrees) + 2),
                                     degrees,
                                     substring($delim, 1, string-length(name(sides))
                                               - string-length(sides) + 2),
                                     sides)"/>
         <xsl:text>&#xa;</xsl:text>
    </xsl:template>
</xsl:stylesheet>NaN)r   r   )r_   r   	to_stringrM   r   )r   r  out_strr0  s       r   test_style_to_stringr6    sI    
C4 !GnnEhsmnDGr   c                    [         R                  " S5        SnU R                  5       nU R                  [	        U5      S9nX#:X  d   eg )NrA   a]  <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="text" indent="yes" />
    <xsl:strip-space elements="*"/>

    <xsl:param name="quot">"</xsl:param>

    <xsl:template match="/data">
        <xsl:text>{"shape":{</xsl:text>
        <xsl:apply-templates select="descendant::row/shape"/>
        <xsl:text>},"degrees":{</xsl:text>
        <xsl:apply-templates select="descendant::row/degrees"/>
        <xsl:text>},"sides":{</xsl:text>
        <xsl:apply-templates select="descendant::row/sides"/>
        <xsl:text>}}</xsl:text>
    </xsl:template>

    <xsl:template match="shape|degrees|sides">
        <xsl:variable name="val">
            <xsl:if test = ".=''">
                <xsl:value-of select="'null'"/>
            </xsl:if>
            <xsl:if test = "number(text()) = text()">
                <xsl:value-of select="text()"/>
            </xsl:if>
            <xsl:if test = "number(text()) != text()">
                <xsl:value-of select="concat($quot, text(), $quot)"/>
            </xsl:if>
        </xsl:variable>
        <xsl:value-of select="concat($quot, preceding-sibling::index,
                                     $quot,':', $val)"/>
        <xsl:if test="preceding-sibling::index != //row[last()]/index">
            <xsl:text>,</xsl:text>
        </xsl:if>
    </xsl:template>
</xsl:stylesheet>r   )r_   r   to_jsonrM   r   )r   r  out_jsonr0  s       r   test_style_to_jsonr:    sF    
#CJ  Hnnn6Gr   c                    UnUR                  X@US9  [        USUS9 nUR                  R                  5       nS S S 5        [	        W5      n[
        UR                  5       :X  d   eg ! , (       d  f       N4= f)NrE   compressionr7   r=  rM   r	   handler  r5   geom_xmlrO   )rE   compression_onlyr   rR   rb   
handle_objrT   s          r   test_compression_outputrD    sr    DNN44DNE	$
 
""'')
 6"Fv||~%%%
 
s   A''
A5c                   SX1   -   nXE-  nUR                  X`US9  [        USUS9 nUR                  R                  5       nS S S 5        [	        W5      n[
        UR                  5       :X  d   eg ! , (       d  f       N4= f)Nzxml.r<  r7   r>  r?  )	rE   rB  r   compression_to_extensiontmp_pathcompfilerb   rC  rT   s	            r   test_filename_and_suffix_comprI    s     0BBHDNN44DNE	$
 
""'')
 6"Fv||~%%%
 
s   A00
A>c                    Sn[        S[        /05      R                  U 5      nUR                  US9n[	        U5      R                  5       U:X  d   eg )Nzd<?xml version='1.0' encoding='utf-8'?>
<data>
  <row>
    <index>0</index>
    <a/>
  </row>
</data>arH   )r   r   astyperM   r5   rO   )any_numeric_ea_dtyperE   rh   dfresults        r   test_ea_dtypesrP  +  sS    H 
C";		&	&';	<BYYfY%F &&(H444r   c                    [         R                  " [        SS9   UnUR                  X0SS9  S S S 5        g ! , (       d  f       g = f)NzUnrecognized compression typer]   7zr<  r   )rE   r   rR   rb   s       r   test_unsupported_compressionrS  9  s3    	z)H	It= 
J	I	Ir   c                b   [         R                  " S5      n[         R                  " S5        [        R                  " [        [
        45         UR                  SS9nUR                  UR                  5        UR                  SUR                   S3SU S9  S S S 5        g ! , (       d  f       g = f)	Ns3fsrA   T)anonzs3://z	/geom.xmlzip)r=  rE   )
r_   r   tmexternal_error_raisedPermissionErrorr  S3FileSystemlsnamerM   )rE   s3_bucket_publicr   rU  fss        r   test_s3_permission_outputr`  B  s    v&D
		!	!?4E"F	GD)
##$$))*)4%PV 	 	
	 
H	G	Gs   A
B  
B.)`
__future__r   ior   r   r  numpyr   r_   pandas.util._test_decoratorsutil_test_decoratorstdpandasr   r   r   pandas._testing_testingrX  pandas.io.commonr	   pandas.io.xmlr
   fixturer   r/   r1   r5   r?   r<   
skip_if_norE   rU   rX   r[   rc   ri   ro   markparametrizeintstrry   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   skip_if_installedr   r   r  r  r
  r  r  r  r!  r%  r(  r*  r1  r6  r:  rA  rD  rI  rP  rS  
single_cpur`  r   r   r   <module>ru     s   " 
   ) ) 
  ' "J   , ,^  > c{# $ V2==3HI7ST U(((,"J$N c
+! ,!L0!!B.N
N):N
N
)@,^<$N4<H@
H! H'Q %FGM HM8:*, f %0<"&"' "ws| <=' >' 1<18<&A :D*`0& &&5> 

 

r   