o ҷh @sddlmZddlmZmZddlmZddlZddlm Z ddl m Z ddl m Z ddlmZddlZddlZdd lmZdd lmZmZddlmmZddlZdd lmZmZm Z ddl!m"Z#dd l$m%Z%m&Z&dd l'm(Z(ddl)m*Z*egdgddej+dgdZ,dZ-dZ.eddddddddddddddddddddddddddddddd d!d"d#d$dd%Z/d&d'Z0ej1d(d)gd*d+d,Z2ej1ej3d-e4d-d.d/gd*d0d1Z5d2d3Z6d4d5Z7d6d7Z8ej9j:ej9j;d8d9Zd>d?Z?d@dAZ@dBdCZAdDdEZBdFdGZCej9DdHdIdJgdKdLZEej9DdHdIdJgdMdNZFdOdPZGej9j:ej9j;dQdRZHej9j:ej9j;dSdTZIdUdVZJdWdXZKdYdZZLd[d\ZMd]d^ZNd_d`ZOdadbZPdcddZQdedfZRdgdhZSdidjZTej9DdkdIdgdldmZUdndoZVdpdqZWdrdsZXdtduZYdvdwZZdxdyZ[dzd{Z\d|d}Z]d~dZ^ddZ_ddZ`ddZaddZbddZcddZdddZeddZfddZgddZhddZiejd-ddZkddZlddZmddZnddZoddZpddZqddZrddZsddZtddZuddZvddZwddZxej9DdHdIdJgddZyddZzddZ{ej9j:ej9j;ddZ|ddZ}ddZ~ddZddZddÄZddńZddDŽZddɄZdd˄Zdd̈́ZddτZddфZddӄZej9j:ej9j;ddՄZddׄZddلZdS)) annotations)BytesIOStringIO) LZMAErrorN) ReadError) HTTPError) ParseError) BadZipFile)import_optional_dependency)EmptyDataError ParserError)NA DataFrameSeries)ArrowStringArray StringArray) get_handle)read_xmlsquarecircletrianglehrshapedegreessidesa[ square 360 4 circle 360 triangle 180 3 a square 360 4.0 circle 360 triangle 180 3.0 ID_00001ID_00002ID_00003ID_00004ID_00005rrrzBlue Line (Forest Park)zRed, Purple Linez #LineStyle01clampedToGroundz-87.77678526964958,41.8708863930319,0 -87.77826234150609,41.87097820122218,0 -87.78251583439344,41.87130129991005,0 -87.78418294588424,41.87145055520308,0 -87.7872369165933,41.8717239119163,0 -87.79160214925886,41.87210797280065,0a\-87.65758750947528,41.96427269188822,0 -87.65802133507393,41.96581929055245,0 -87.65819033925305,41.96621846093642,0 -87.6583189819129,41.96650362897086,0 -87.65835858701473,41.96669002089185,0 -87.65838428411853,41.96688150295095,0 -87.65842208882658,41.96745896091846,0 -87.65846556843937,41.9683761425439,0 -87.65849296214573,41.96913893870342,0a-87.65492939166126,41.95377494531437,0 -87.65557043199591,41.95376544118533,0 -87.65606302030132,41.95376391658746,0 -87.65623502146268,41.95377379126367,0 -87.65634748981634,41.95380103566435,0 -87.65646537904269,41.95387703994676,0 -87.65656532461145,41.95396622645799,0 -87.65664760856414,41.95404201996044,0 -87.65671750555913,41.95416647054043,0 -87.65673983607117,41.95429949810849,0 -87.65673866475777,41.95441024240925,0 -87.6567690255541,41.95490657227902,0 -87.65683672482363,41.95692259283837,0 -87.6568900886376,41.95861070983142,0 -87.65699865558875,41.96181418669004,0 -87.65756347177603,41.96397045777844,0 -87.65758750947528,41.96427269188822,0ah-87.65362593118043,41.94742799535678,0 -87.65363554415794,41.94819886386848,0 -87.6536456393239,41.95059994675451,0 -87.65365831235026,41.95108288489359,0 -87.6536604873874,41.9519954657554,0 -87.65362592053201,41.95245597302328,0 -87.65367158496069,41.95311153649393,0 -87.65368468595476,41.9533202828916,0 -87.65369271253692,41.95343095587119,0 -87.65373335834569,41.95351536301472,0 -87.65378605844126,41.95358212680591,0 -87.65385067928185,41.95364452823767,0 -87.6539390793817,41.95370263886964,0 -87.6540786298351,41.95373403675265,0 -87.65430648647626,41.9537535411832,0 -87.65492939166126,41.95377494531437,0a -87.65345391792157,41.94217681262115,0 -87.65342448305786,41.94237224420864,0 -87.65339745703922,41.94268217746244,0 -87.65337753982941,41.94288140770284,0 -87.65336256753105,41.94317369618263,0 -87.65338799707138,41.94357253961736,0 -87.65340240886648,41.94389158188269,0 -87.65341837392448,41.94406444407721,0 -87.65342275247338,41.94421065714904,0 -87.65347469646018,41.94434829382345,0 -87.65351486483024,41.94447699917548,0 -87.65353483605053,41.9453896864472,0 -87.65361975532807,41.94689193720703,0 -87.65362593118043,41.94742799535678,0idnamestyleUrlextrude altitudeMode coordinatescCsJtdd}tjt|d ttWddS1swYdS)NlxmlPassing literal xml to 'read_xml' is deprecated and will be removed in a future version. To read from a literal string, wrap it in a 'StringIO' object.match)pytest importorskiptmassert_produces_warning FutureWarningrxml_default_nmspmsgr=O/var/www/html/venv/lib/python3.10/site-packages/pandas/tests/io/xml/test_xml.pytest_literal_xml_deprecations  "r?rbr)paramscC|jSNparamrequestr=r=r>moderIr1)marksetreecCrCrDrErGr=r=r>parser rJrMc Kstt,}t|ddd }||Wdn1swYt|fi|WdS1s3wYdS)Nwutf-8encoding)r7 ensure_cleanopenwriter)datakwargspathfr=r=r>read_xml_iterparses  $rYc Kst|d|dK}t6}t|ddd}||jWdn1s'wYt|fi|WdWdS1sEwYWddS1sUwYdS)NrA) compressionrNrOrP)rr7rRrSrThandlereadr) comp_pathcompression_onlyrVhandlesrWrXr=r=r>read_xml_iterparse_comps "r`cCsvtdt|dd}t|dd}t|ddgdid}t|ddgdid}t||t||t||dS)Nr1rMrLbookcategorytitleyearauthorpricerM iterparser5r6rr7assert_frame_equal) xml_books df_file_lxml df_file_etree df_iter_lxml df_iter_etreer=r=r>test_parser_consistency_file"s       rrcCsJ|jtdttt|d}ttt|dgdid}t||dS)Ncontentrarowrri) serve_contentr:rrrencoder7rl)rM httpserverdf_xpathdf_iterr=r=r>test_parser_consistency_url7s   r{cCs~t|||dkr dndd}t||d}Wdn1swYtgdgdgdgdgd d }t||dS NrArOrPracookingchildrenwebzEveryday Italianz Harry Potterz Learning XMLzGiada De Laurentiisz J K. Rowlingz Erik T. Rayrig>@g= ףp=@gC@rdrergrfrh)rSrrr7rl)rmrMrIrXdf_file df_expectedr=r=r>test_file_likeFs rcCst|||dkr dndd }|}Wdn1swYtt|tr+t|nt||d}tgdgdgdgdgd d }t ||dSr|) rSr\r isinstancebytesrrrr7rl)rmrMrIrXxml_objdf_iorr=r=r> test_file_ioWs   rcCst|||dkr dndd }|}Wdn1swY|dkr,t|}n|dkr4t|}t||d}tgdgdgdgd gd d }t||dS NrArOrPr@rar}rrrrr)rSr\rdecoderrr7rlrmrMrIrXrdf_strrr=r=r> test_file_buffered_reader_stringms"   rcCst|||dkr dndd}t||}Wdn1s wY|dkr0t|}n|dkr8t|}t||d}tgdgdgdgd gd d }t||dSr) rSnextr\rrrrr7rlrr=r=r>,test_file_buffered_reader_no_xml_declarations$   rcCs8d}tt||d}tddddgd}t||dS)N<<中文標籤>12rar'r()c1c2r)indexrrrr7rl)rMtxtrrr=r=r>test_string_charsetsrcCsDt||d}tgddddgddggdd}t||dS) Nra)uP問 若箇是邪而言破邪 何者是正而道(Sorry, this is Big5 only)申正u;問 既破有得申無得 亦應但破性執申假名以不uO問 既破性申假 亦應但破有申無 若有無兩洗 亦應性假雙破耶u<答 邪既無量 正亦多途 大略為言不出二種 謂u;有得與無得 有得是邪須破 無得是正須申 故uL答 不例 有無皆是性 所以須雙破 既分性假異 故有破不破)NuV答 性執是有得 假名是無得 今破有得申無得 即是破性執申假名也N)u問u答a)rrjoinr7rl)xml_doc_ch_utfrMrrr=r=r>test_file_charsets  rcCsNt|d}tt||d|jrJWddS1s wYdS)Nr@ra)rSrrr\closed)rmrMrXr=r=r>test_file_handle_closes  "rvalrcCstd}dddg}tj|j|d't|tr#tt|ddntt |ddWddSWddS1s>wYdS)N lxml.etree|zDocument is emptyzNone \(line 0\)r3r1ra) r5r6rraisesXMLSyntaxErrorrstrrrr)r lxml_etreer<r=r=r>test_empty_string_lxmls  "rcCsptjtdd't|trtt|ddntt|ddWddSWddS1s1wYdS)Nzno element foundr3rLra)r5rrrrrrr)rr=r=r>test_empty_string_etrees "rcCsTd}tjddd}tjt|dt||dWddS1s#wYdS)Nr2rUhtmlz books.xmlr3ra)osrWrr5rr9r)rMr<filenamer=r=r>test_wrong_file_paths"rcCstdt|dd}|j|dt|jdd}Wdn1s%wYtgdgdgd gd gd d }t ||dS) Nr1rOrPrs.//book[count(*)=4]xpathr}rrrrr) r5r6rSrvr\rurlrr7rl)rxxml_filerXdf_urlrr=r=r>test_urls  rcCsR|jdddtjtddt|jd|dWddS1s"wYdS)Nz NOT FOUNDi)codezHTTP Error 404: NOT FOUNDr3rrrM)rvr5rrrr)rMrxr=r=r>test_wrong_url s"rcCsjd}tt||dd}t||dgdidd}tgdgdgd ddd }t||t||dS) Na square 360 circle 360 triangle 180 string)rMdtyperu)r rr)rMrjr)z 4 z 0 z 3 )z square z circle z" triangle ) 360 rz 180 rrrrYrr7rlrMxmlryrzrr=r=r>test_whitespaces"   rcCsLtdtjtddt|dddWddS1swYdS)Nr1xpath does not return any nodesr3z .//pythonrr5r6r ValueErrorrrmr=r=r>test_empty_xpath_lxmlLs "rcCBtjtddt|dddWddS1swYdS)Nz/You have used an incorrect or unsupported XPathr3 .//[book]rLrr5r SyntaxErrorrrr=r=r>test_bad_xpath_etreeRs "rcCNtd}tj|jddt|dddWddS1s wYdS)NrzInvalid expressionr3rr1rr5r6rXPathEvalErrorr)rmrr=r=r>test_bad_xpath_lxmlY "rcCltttdddi|d}tt|dgdid}tgdgd d td d gd}t||t||dS) N .//ns:rownshttp://example.comr namespacesrMrurrirr@nan@)rrr:rYrfloatr7rlrMdf_nmsprzrr=r=r>test_default_namespacecs&   rcCr) N .//doc:rowdocrrrurrirrrrr)rrxml_prefix_nmsprYrrr7rlrr=r=r>test_prefix_namespace}s"  rcCsJtdtttdddidd}tttdddidd}t||dS) Nr1rrrrrrrL)r5r6rrr:r7rldf_lxmldf_etreer=r=r>"test_consistency_default_namespace rcCsJtdtttdddidd}tttdddidd}t||dS)Nr1rrrrrL)r5r6rrrr7rlrr=r=r>!test_consistency_prefix_namespacerrcCBtjtddt|d|dWddS1swYdS)Nrr3z .//Placemarkrr5rrrrmrMr=r=r>*test_missing_prefix_with_default_namespace"rcCr)Nz'you used an undeclared namespace prefixr3.//kml:PlacemarkrLrr)kml_cta_rail_linesr=r=r>$test_missing_prefix_definition_etreerrcCr)NrzUndefined namespace prefixr3rr1rr)rrr=r=r>#test_missing_prefix_definition_lxmlrrkeycCsVtdtjtddtttd|diddWddS1s$wYdS)Nr1z0empty namespace prefix is not supported in XPathr3rhttp://www.opengis.net/kml/2.2r)r5r6r TypeErrorrrr:)rr=r=r>test_none_namespace_prefixs "rcCsft||d}t||dgdid}tgdgdgdgdgd d}t||t||dS) Nrarbrrir}rrrrrrr7rlrmrMrrzrr=r=r>test_file_elems_and_attrss   rcCsNt|d|d}t||ddgid}tdgdi}t||t||dS)NT) attrs_onlyrMrbrdrir}rrr=r=r>test_file_only_attrss  rcCsbt|d|d}t||dgdid}tgdgdgdgd d}t||t||dS) NT) elems_onlyrMrb)rergrfrhrirrrrrrr=r=r>test_file_only_elemss  rcCsDtjtddt|dd|dWddS1swYdS)Nz3Either element or attributes can be parsed not bothr3T)rrrMr)rrMr=r=r>test_elem_and_attrs_onlys "rcCLd}tjtddtt|dd|dWddS1swYdS)NaU square 360 circle 360 triangle 180 -xpath does not return any nodes or attributesr3./rowT)rrrMr5rrrrrMrr=r=r>test_empty_attrs_onlys"rcCr)Nz rr3rT)rrrMrrr=r=r>test_empty_elems_only1s"rcCsvtdd}tt|dd}tt|ddd}t|ddd gid }t|dddd gid }t||t||dS) Nr1a z .//stationrrLrstationNamecoordsrjri)r5r6rrrYr7rl)rrr df_iter_lx df_iter_etr=r=r>test_attribute_centric_xml@s  r cCsrt|gd|d}t||gddgdid}tgdgdgdgd gd d}t||t||dS) N)Col1Col2Col3Col4Col5namesrMrbr)rMrrjr}rrrrrrr=r=r>test_names_option_outputes&   rcCspd}tt|d|gdd}t||dgdigdd}tdd gd d gd d gd}t||t||dS) Nz circle curved sphere curved .//shape)type_dimr type_edgerrMrr)typer,rrMrjr2D3Drspherecurvedrrr=r=r>test_repeat_names~s*   rcCsjd}tt|d|ddgd}t||dddgiddgd}tgd gd d }t||t||dS) NaB rectangle rectangle square rectangle ellipse ellipse circle ellipse rr,grouprrfamilyr) rectanglerellipser)r"r"r#r#)r,r rrr=r=r>test_repeat_values_new_namess"  r$cCsvd}tt|d|gdd}t||dgdigdd}tgdgd gd gd d}t||t||dS) Na circle ellipse 360 0 triangle polygon 180 3 square polygon 360 4 r)r,r!rr rr)valuer%r%r%r)rrr)r#polygonr&)rrr)rrrrrr=r=r>test_repeat_elementss,  r'cCsFtjtddt|gd|dWddS1swYdS)Nznames does not match lengthr3)r rrrrrr=r=r>test_names_option_wrong_lengths"r(cCr)Nzis not a valid type for namesr3zCol1, Col2, Col3rr5rrrrr=r=r>test_names_option_wrong_typerr*cCs@tjtddt||dWddS1swYdS)Nz'utf-8' codec can't decoder3rar5rUnicodeDecodeErrorrxml_baby_namesrMr=r=r>test_wrong_encoding s"r/cCr)NzIUTF-16 stream does not start with BOM|'utf-16-le' codec can't decode byter3zUTF-16rQrM)r5r UnicodeErrorrr-r=r=r>test_utf16_encodings "r2cCr)Nzunknown encoding: UFT-8r3zUFT-8r0)r5r LookupErrorrr-r=r=r>test_unknown_encodingrr4cCr)Nz'ascii' codec can't decode byter3asciir0r+r-r=r=r>test_ascii_encoding!rr6cCs~tdt|ddd}t|ddd}t|dddgdid}t|dddgdid}t||t||t||dS) Nr1z ISO-8859-1rMrQrLz iso-8859-1ru)rankmalename femalename)rMrQrjrk)r. df_xpath_lxmldf_xpath_etreerprqr=r=r>%test_parser_consistency_with_encoding&s$     r=cCsTtdd}tjtddtt|dddWddS1s#wYdS)Nr1- c z encoding Noner3r7)r5r6rrrr)rUr=r=r>test_wrong_encoding_for_lxml=s "r?cCs4d}tt|ddd}tddgi}t||dS)Nr>rLr7rcr)rUresultexpectedr=r=r>test_none_encoding_etreeJsrCcCs<tjtdd t|WddS1swYdS)Nz7lxml not found, please install or use the etree parser.r3)r5r ImportErrorrrr=r=r>test_default_parser_no_lxmlZs  "rEcCs@tjtddt|ddWddS1swYdS)Nz,Values for parser can only be lxml or etree.r3bs4rarrr=r=r>test_wrong_parserbs "rGcCsNtdt|dddi|d}t|dgdid}tt|tt|dS) Nr1.//k:Placemarkkrrr stylesheet Placemarkr*r )r5r6rr7rldf_kml)rxsl_flatten_docdf_stylerzr=r=r>test_stylesheet_filels  rPcCshtdt|||dkrdndd}t|dddi|d}Wdn1s'wYtt|dS Nr1rArOrPrHrIrrJ)r5r6rSrr7rlrM)rrNrIrXrOr=r=r>test_stylesheet_file_likes rRcCstdt|||dkrdndd}|dkrt|}nt|}Wdn1s.wYt|dddi|d }tt |dS) Nr1rArOrPr@rHrIrrJ) r5r6rSrr\rrr7rlrMrrNrIrXxsl_objrOr=r=r>test_stylesheet_ios  rUcCsptdt|||dkrdndd }|}Wdn1s!wYt|dddi|d}tt|dSrQ)r5r6rSr\rr7rlrMrSr=r=r>test_stylesheet_buffered_readers  rVcCs>tdd}d}tt|}tt||d}t||dS)Nr1ru <根> rK)r5r6rrr7rl)rxsldf_origrOr=r=r>test_style_charsets  rZcCsLtd}tj|jddt||dWddS1swYdS)Nrzdocument is not a stylesheetr3rWr5r6rXSLTParseErrorr)rrmrr=r=r>test_not_stylesheets "r]cCPtd}d}tj|jddt||dWddS1s!wYdS)Nra z(Extra content at the end of the documentr3rWr5r6rrrrrrXr=r=r>test_incorrect_xsl_syntaxs "racCr^)Nra zfailed to compiler3rWr[r`r=r=r>test_incorrect_xsl_evals "rbcCr^)Nrag zCannot resolve URIr3rW)r5r6rXSLTApplyErrorrr`r=r=r>test_incorrect_xsl_applys  "rdcCsTtd}|d}tj|jddt||dWddS1s#wYdS)Nrz flatten.xslz!Start tag expected, '<' not foundr3rWr_)r xml_data_path xml_etreerXr=r=r>test_wrong_stylesheet*s "rgcCstdt|||dkrdndd%}|dkrt|}nt|}t||d|jr/JWddS1s:wYdS)Nr1rArOrPr@rW)r5r6rSrr\rrr)rrNrIrXrTr=r=r>test_stylesheet_file_close6s    "rhcCsLtdtjtddt|d|dWddS1swYdS)Nr1z*To use stylesheet, you need lxml installedr3rL)rMrKr)rrNr=r=r>test_stylesheet_with_etreeGs "ricCs^tdd}tjddd}tjt|dt||dWddS1s(wYdS)Nr1r2rUrzcta_rail_lines.kmlr3rW)r5r6rrWrrr9r)rr<kmlr=r=r>test_empty_stylesheetOs "rkc Cst|||dkr dnddF}|dkrA|dkrAtjtddt||dgdid Wdn1s3wY WddSt||dgdid }Wdn1sVwYtgd gd gd gd gdd}t||dSNrArOrPr1z.reading file objects must return bytes objectsr3rbrcrir}rrrrr)rSr5rrrrr7rl)rmrMrIrX df_filelikerr=r=r>test_file_like_iterparse^s:   rnc Cs6|dkrtnt}t|||dkrdnddb}||L}|dkrV|dkrVtjtddt||dgdid Wdn1sBwY WdWddSt||dgdid }Wdn1skwYWdn1szwYtgd gd gd gd gdd}t ||dSrl) rrrSr\r5rrrrr7rl)rmrMrIfuncIOrXb df_fileiorr=r=r>test_file_io_iterparsesP  rrc Cst|dd<}|j|dtjtddt|j|dgdidWdn1s-wYWddSWddS1sEwYdS) NrOrPrs)iterparse is designed for large XML filesr3rurrr dateri)rSrvr\r5rr rr)rMrxrrXr=r=r>test_url_path_errors "rvc Cstjdd<}tj|||dtjtddt||dgdi|dWdn1s-wYWddSWddS1sEwYdS) Nz geom_xml.ziprrMrZrsr3rurtrMrjrZ)r7rRgeom_dfto_xmlr5rr r)rMr^rWr=r=r>test_compression_errors "r|cCsFtjtddt||gddWddS1swYdS)Nz&list is not a valid type for iterparser3rcrir)rr=r=r>test_wrong_dict_types"r}cCsFtjtddt||ddidWddS1swYdS)Nz8 is not a valid type for value in iterparser3rbrdrir)rr=r=r>test_wrong_dict_values "r~c Csd}tjddQ}t|ddd }||Wdn1s wYtjtddt||d gd gd id Wdn1sDwYWddSWddS1s\wYdS) Na square 00360 4.0 2020-01-01 circle 00360 2021-01-01 triangle 00180 3.0 2022-01-01 zbad.xmlrwrNrOrPzDExtra content at the end of the document|junk after document elementr3rururt)rM parse_datesrj)r7rRrSrTr5rrr)rMbad_xmlrWrXr=r=r> test_bad_xmls&  "rcC^d}tt|d|d}t||dddgid}tdd gd d gd }t||t||dS) Na- circle 2D sphere 3D rrrr,rrirrrrr,rrrr=r=r> test_comments rcCr) Na8 ]> circle 2D sphere 3D rrrr,rrirrrrrrrr=r=r>test_dtd$ rcCr) Nam , , ?> circle 2D sphere 3D rrrr,rrirrrrrrrr=r=r>test_processing_instructionHrrcCJtjtddt||dgdidWddS1swYdS)Nz+No result from selected items in iterparse.r3nodeattr1elem1elem2elem3ri)r5rr rrr=r=r>test_no_resultls "rcCr)NzNo columns to parse from filer3rbrri)r5rr rrr=r=r>test_empty_dataws "rcCs`tdd}d}tt|dddg|d}tdd d d d d dddddd d}t||dS)Nr1a Empire Burlesque Bob Dylan USA Columbia 10.90 1985 Hide your heart Bonnie Tyler UK CBS Records 9.90 1988 Greatest Hits Dolly Parton USA RCA 9.90 1982 Still got the blues Gary Moore UK Virgin records 10.20 1990 Eros Eros Ramazzotti EU BMG 9.90 1997 One night only Bee Gees UK Polydor 10.90 1998 Sylvias Mother Dr.Hook UK CBS 8.10 1973 Maggie May Rod Stewart UK Pickwick 8.50 1990 Romanza Andrea Bocelli EU Polydor 10.80 1996 When a man loves a woman Percy Sledge USA Atlantic 8.70 1987 Black angel Savage Rose EU Mega 10.90 1995 1999 Grammy Nominees Many USA Grammy 10.20 1999 For the good times Kenny Rogers UK Mucik Master 8.70 1995 Big Willie style Will Smith USA Columbia 9.90 1997 Tupelo Honey Van Morrison UK Polydor 8.20 1971 Soulsville Jorn Hoel Norway WEA 7.90 1996 The very best of Cat Stevens UK Island 8.90 1990 Stop Sam Brown UK A and M 8.90 1988 Bridge of Spies T`Pau UK Siren 7.90 1987 Private Dancer Tina Turner UK Capitol 8.90 1983 Midt om natten Kim Larsen EU Medley 7.80 1983 Pavarotti Gala Concert Luciano Pavarotti UK DECCA 9.90 1991 The dock of the bay Otis Redding USA Stax Records 7.90 1968 Picture book Simply Red EU Elektra 7.20 1985 Red The Communards UK London 7.80 1987 Unchain my heart Joe Cocker USA EMI 8.20 1987 a7

My CD Collection

Title Artist
z.//tr[td and position() <= 6]reartist)rrrKzEmpire BurlesquezHide your heartz Greatest HitszStill got the bluesErosr&z Bob Dylanz Bonnie Tylerz Dolly Partonz Gary MoorezEros Ramazzotti)rer)r5r6rrrr7rl)rrXdf_xslrr=r=r>test_online_stylesheets4 VrcCs~t%}tj|d||dt|||d}t|||dgdi|d}Wdn1s,wYt|tt|tdS)NF)rrMrZrxrurry)r7rRrzr{rr`rl)rMr^r]ryrzr=r=r>test_compression_reads   rc Cs|}|}||krt|d|tdftdftdftdfd}tddd }|dur2|jd f|d <td dd }|durBtd f|d<||\}} t 7} t j | ||dtj || dt | ||dWdn1snwYWddSWddS1swYdS)Nz == zInvalid data streamzNot a gzipped filezFile is not a zip filez%file could not be opened successfully)bz2gzipziptar zstandardignore)errorszUnknown frame descriptorzstdlzmaz%Input format not supported by decoderxzrxr3)r5skipOSErrorr rr ZstdErrorrr7rRrzr{rr) rMrZr^actual_compressionattempted_compressionrrr error_cls error_strrWr=r=r>test_wrong_compressions0     "rc Csztjtdd,t}t||ddWdn1swYWddSWddS1s6wYdS)NzUnrecognized compression typer37zrx)r5rrr7rRr)rMrWr=r=r>test_unsuported_compressions "rcCsNtdtdd|jd}t|d|d}t|d|d}t||dS)Ns3fsr1zs3://z /books.xml)rMstorage_optionsrL)r5r6r,rr7rl)s3_public_bucket_with_datas3sos3rrr=r=r>test_s3_parser_consistencys  rc szd}|dkrttjddgtjd}ttjdtgtjd}ntdtddg}tddg}t d|t t |||d}Wdn1sPwYt |t d d gd dt d d gdd|t d tgd dt d tgddt ttgd dt ddgddt dtgddd |dkrtdddlmt fddjDddgd<t|dS)Na; x 1 4.0 x 2 4.0 True False y 2 5.0 False pythonxyrpyarrowzmode.string_storage)rM dtype_backendr'r(Int64rg@Float64TFboolean) rrpr@derXghir)ArrowExtensionArraycs$i|]}|j|ddqS)T) from_pandas)array).0colrrBpar=r> sz1test_read_xml_nullable_dtypes..r)rnprobject_r r5r6rpdoption_contextrrrr pandas.arraysrcolumnsr7rl)rMstring_storagerrU string_arraystring_array_narAr=rr>test_read_xml_nullable_dtypess@   rcCsDd}tjt|dtdddWddS1swYdS)NzPdtype_backend numpy is invalid, only 'numpy_nullable' and 'pyarrow' are allowed.r3testnumpy)rrr;r=r=r>test_invalid_dtype_backends "r) __future__riorrrrrtarfiler urllib.errorrxml.etree.ElementTreerzipfiler rrr5pandas.compat._optionalr pandas.errorsr r pandas.util._test_decoratorsutil_test_decoratorstdpandasrr rrpandas._testing_testingr7pandas.core.arraysrrpandas.io.commonr pandas.io.xmlrrrzr:rrMr?fixturerIrF skip_if_norMrYr`rrmarknetwork single_cpur{rrrrrrr parametrizerrrrrrrrrrrrrrrrrrrrrrrr rrr$r'r(r*r/r2r4r6r=r?rCskip_if_installedrErGrPrRrUrVrZr]rarbrdrgrhrirkrnrrrvr|r}r~rrrrrrrrrrrrrr=r=r=r>sJ          6   m           4   %&*1        "*   )#$$     E