a  d @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 ZID_00001ZID_00002ZID_00003ZID_00004ZID_00005rrrzBlue Line (Forest Park)zRed, Purple Linez #LineStyle01ZclampedToGroundz-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,0idnameZstyleUrlZextrudeZ altitudeModeZ coordinatescCsHtdd}tjt|dttWdn1s:0YdS)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 importorskiptmZassert_produces_warning FutureWarningrxml_default_nmspmsgr2e/var/www/html/stable-diffusion-webui/venv/lib/python3.9/site-packages/pandas/tests/io/xml/test_xml.pytest_literal_xml_deprecations  r4rbr)paramscCs|jSNparamrequestr2r2r3modesr=r')ZmarksetreecCs|jSr8r9r;r2r2r3parser sr?c KsttX}t|ddd}||Wdn1s80Yt|fi|WdS1sf0YdS)Nwutf-8encoding)r- ensure_cleanopenwriter)datakwargspathfr2r2r3read_xml_iterparses (rKc Kst|d|d}tl}t|ddd }||jWdn1sN0Yt|fi|WdWdS1s0YWdn1s0YdS)Nr6) compressionr@rArB)rr-rDrErFhandlereadr) comp_pathcompression_onlyrHZhandlesrIrJr2r2r3read_xml_iterparse_comps  .rQcCsvtdt|dd}t|dd}t|ddgdid}t|ddgdid}t||t||t||dS)Nr'r?r>bookcategorytitleyearauthorpricer? iterparser+r,rr-assert_frame_equal) xml_booksZ df_file_lxmlZ df_file_etree df_iter_lxml df_iter_etreer2r2r3test_parser_consistency_file"s        racCsJ|jtdttt|d}ttt|dgdid}t||dS)NcontentrRrowrrZ) serve_contentr/rrrencoder-r])r? httpserverdf_xpathdf_iterr2r2r3test_parser_consistency_url7s   rjcCs~t|||dkrdndd}t||d}Wdn1s<0Ytgdgdgdgdgd d }t||dS Nr6rArBrRZcookingchildrenZwebzEveryday Italianz Harry Potterz Learning XMLzGiada De Laurentiisz J K. Rowlingz Erik T. Rayrqig>@g= ףp=@gC@rUrVrXrWrY)rErrr-r])r^r?r=rJdf_file df_expectedr2r2r3test_file_likeFs* rvcCst|||dkrdndd}|}Wdn1s80Ytt|trVt|nt||d}tgdgdgdgdgd d }t ||dSrk) rErNr isinstancebytesrrrr-r])r^r?r=rJxml_objZdf_iorur2r2r3 test_file_ioWs& rzcCst|||dkrdndd}|}Wdn1s80Y|dkrXt|}n|dkrht|}t||d}tgdgdgdgd gd d }t||dS Nr6rArBr5rRrlrnrorprrrs)rErNrdecoderrr-r]r^r?r=rJrydf_strrur2r2r3 test_file_buffered_reader_stringms &  rcCst|||dkrdndd }t||}Wdn1s@0Y|dkr`t|}n|dkrpt|}t||d}tgdgdgdgd gd d }t||dSr{) rEnextrNrr|rrr-r]r}r2r2r3,test_file_buffered_reader_no_xml_declarations"&  rcCs8d}tt||d}tddddgd}t||dS)N<<中文標籤>12rRr"r#)Zc1c2r)indexrrrr-r])r?txtr~rur2r2r3test_string_charsetsrcCsDt||d}tgddddgddggdd}t||dS) NrR)uP問 若箇是邪而言破邪 何者是正而道(Sorry, this is Big5 only)申正u;問 既破有得申無得 亦應但破性執申假名以不uO問 既破性申假 亦應但破有申無 若有無兩洗 亦應性假雙破耶u<答 邪既無量 正亦多途 大略為言不出二種 謂u;有得與無得 有得是邪須破 無得是正須申 故uL答 不例 有無皆是性 所以須雙破 既分性假異 故有破不破)NuV答 性執是有得 假名是無得 今破有得申無得 即是破性執申假名也N)u問u答a)rrjoinr-r])Zxml_doc_ch_utfr?rtrur2r2r3test_file_charsets  rcCsLt|d.}tt||d|jr*JWdn1s>0YdS)Nr5rR)rErrrNclosed)r^r?rJr2r2r3test_file_handle_closes rvalrcCsxtd}dddg}tj|j|d<t|trFtt|ddntt |ddWdn1sj0YdS)N lxml.etree|zDocument is emptyzNone \(line 0\)r)r'rR) r+r,rraisesXMLSyntaxErrorrwstrrrr)r lxml_etreer1r2r2r3test_empty_string_lxmls  rcCs^tjtdd<t|tr,tt|ddntt|ddWdn1sP0YdS)Nzno element foundr)r>rR)r+rrrwrrrr)rr2r2r3test_empty_string_etrees rcCsRd}tjddd}tjt|dt||dWdn1sD0YdS)Nr(rGhtmlz books.xmlr)rR)osrIrr+rr.r)r?r1filenamer2r2r3test_wrong_file_pathsrcCstdt|dd.}|j|dt|jdd}Wdn1sJ0Ytgdgdgd gd gd d }t ||dS) Nr'rArBrb.//book[count(*)=4]xpathrlrnrorprrrs) r+r,rErerNrurlrr-r])rgxml_filerJZdf_urlrur2r2r3test_urls , rcCsP|jdddtjtdd t|jd|dWdn1sB0YdS)Nz NOT FOUNDi)codezHTTP Error 404: NOT FOUNDr)rrr?)rer+rrrr)r?rgr2r2r3test_wrong_url srcCsjd}tt||dd}t||dgdidd}tgdgdgd ddd }t||t||dS) Na square 360 circle 360 triangle 180 string)r?dtyperd)r rr)r?r[r)z 4 z 0 z 3 )z square z circle z" triangle ) 360 rz 180 rrrrKrr-r]r?xmlrhrirur2r2r3test_whitespaces"   rcCsJtdtjtddt|dddWdn1s<0YdS)Nr'xpath does not return any nodesr)z .//pythonrr+r,r ValueErrorrr^r2r2r3test_empty_xpath_lxmlLs rcCs@tjtddt|dddWdn1s20YdS)Nz/You have used an incorrect or unsupported XPathr) .//[book]r>rr+r SyntaxErrorrrr2r2r3test_bad_xpath_etreeRsrcCsLtd}tj|jddt|dddWdn1s>0YdS)NrzInvalid expressionr)rr'rr+r,rZXPathEvalErrorr)r^rr2r2r3test_bad_xpath_lxmlYs rcCsltttdddi|d}tt|dgdid}tgdgd d td d gd}t||t||dS) N .//ns:rownshttp://example.comr namespacesr?rdrrZrr@nan@)rrr/rKrfloatr-r]r?Zdf_nmsprirur2r2r3test_default_namespacecs&   rcCsltttdddi|d}tt|dgdid}tgdgd d td d gd}t||t||dS) N .//doc:rowdocrrrdrrZrrrrr)rrxml_prefix_nmsprKrrr-r]rr2r2r3test_prefix_namespace}s"  rcCsJtdtttdddidd}tttdddidd}t||dS) Nr'rrrrrrr>)r+r,rrr/r-r]df_lxmldf_etreer2r2r3"test_consistency_default_namespaces rcCsJtdtttdddidd}tttdddidd}t||dS)Nr'rrrrr>)r+r,rrrr-r]rr2r2r3!test_consistency_prefix_namespaces rcCs@tjtddt|d|dWdn1s20YdS)Nrr)z .//Placemarkrr+rrrr^r?r2r2r3*test_missing_prefix_with_default_namespacesrcCs@tjtddt|dddWdn1s20YdS)Nz'you used an undeclared namespace prefixr).//kml:Placemarkr>rr)kml_cta_rail_linesr2r2r3$test_missing_prefix_definition_etreesrcCsLtd}tj|jddt|dddWdn1s>0YdS)NrzUndefined namespace prefixr)rr'rr)rrr2r2r3#test_missing_prefix_definition_lxmls rkeycCsTtdtjtdd(tttd|diddWdn1sF0YdS)Nr'z0empty namespace prefix is not supported in XPathr)rhttp://www.opengis.net/kml/2.2r)r+r,r TypeErrorrrr/)rr2r2r3test_none_namespace_prefixs rcCsft||d}t||dgdid}tgdgdgdgdgd d}t||t||dS) NrRrSrsrZrlrnrorprrrrr-r]r^r?rtrirur2r2r3test_file_elems_and_attrss    rcCsNt|d|d}t||ddgid}tdgdi}t||t||dS)NT) attrs_onlyr?rSrUrZrlrrr2r2r3test_file_only_attrss  rcCsbt|d|d}t||dgdid}tgdgdgdgd d}t||t||dS) NT) elems_onlyr?rS)rVrXrWrYrZrnrorprrrrr2r2r3test_file_only_elemss  rcCsBtjtdd t|dd|dWdn1s40YdS)Nz3Either element or attributes can be parsed not bothr)T)rrr?r)rr?r2r2r3test_elem_and_attrs_onlys rcCsJd}tjtdd$tt|dd|dWdn1s<0YdS)NaU square 360 circle 360 triangle 180 -xpath does not return any nodes or attributesr)./rowT)rrr?r+rrrrr?rr2r2r3test_empty_attrs_onlys rcCsJd}tjtdd$tt|dd|dWdn1s<0YdS)Nz rr)rT)rrr?rrr2r2r3test_empty_elems_only1s rcCsvtdd}tt|dd}tt|ddd}t|ddd gid }t|dddd gid }t||t||dS) Nr'a z .//stationrr>rZstationNameZcoordsr[rZ)r+r,rrrKr-r])rrrZ df_iter_lxZ df_iter_etr2r2r3test_attribute_centric_xml@s  rcCsrt|gd|d}t||gddgdid}tgdgdgdgd gd d}t||t||dS) N)Col1Col2Col3ZCol4ZCol5namesr?rSrs)r?rr[rlrnrorprrrrr2r2r3test_names_option_outputes&   rcCspd}tt|d|gdd}t||dgdigdd}tdd gd d gd d gd}t||t||dS) Nz circle curved sphere curved .//shape)Ztype_dimrZ type_edgerr?rr)typer&rr?r[r2D3DrsphereZcurvedrrr2r2r3test_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)rrrr)r&rrrr2r2r3test_repeat_values_new_namess"  rcCsvd}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&rrr rr)valuerrrr)rrr)rpolygonr)rrr)rrrrrr2r2r3test_repeat_elementss,  rcCsDtjtdd"t|gd|dWdn1s60YdS)Nznames does not match lengthr))rrrrrrr2r2r3test_names_option_wrong_lengthsrcCs@tjtddt|d|dWdn1s20YdS)Nzis not a valid type for namesr)zCol1, Col2, Col3rr+rrrrr2r2r3test_names_option_wrong_typesrcCs>tjtddt||dWdn1s00YdS)Nz'utf-8' codec can't decoder)rRr+rUnicodeDecodeErrorrxml_baby_namesr?r2r2r3test_wrong_encoding srcCs@tjtddt|d|dWdn1s20YdS)NzIUTF-16 stream does not start with BOM|'utf-16-le' codec can't decode byter)zUTF-16rCr?)r+r UnicodeErrorrrr2r2r3test_utf16_encodings rcCs@tjtddt|d|dWdn1s20YdS)Nzunknown encoding: UFT-8r)zUFT-8r)r+r LookupErrorrrr2r2r3test_unknown_encodingsr cCs@tjtddt|d|dWdn1s20YdS)Nz'ascii' codec can't decode byter)asciirrrr2r2r3test_ascii_encoding!sr cCs~tdt|ddd}t|ddd}t|dddgdid}t|dddgdid}t||t||t||dS) Nr'z ISO-8859-1r?rCr>z iso-8859-1rd)ZrankZmalenameZ femalename)r?rCr[r\)rZ df_xpath_lxmlZdf_xpath_etreer_r`r2r2r3%test_parser_consistency_with_encoding&s$     rcCsRtdd}tjtdd"tt|dddWdn1sD0YdS)Nr'- c z encoding Noner)r )r+r,rrrr)rGr2r2r3test_wrong_encoding_for_lxml=s rcCs4d}tt|ddd}tddgi}t||dS)Nrr>r rcr)rGresultexpectedr2r2r3test_none_encoding_etreeJsrcCs:tjtddt|Wdn1s,0YdS)Nz7lxml not found, please install or use the etree parser.r))r+r ImportErrorrrr2r2r3test_default_parser_no_lxmlZsrcCs>tjtddt|ddWdn1s00YdS)Nz,Values for parser can only be lxml or etree.r)Zbs4rRrrr2r2r3test_wrong_parserbsrcCsNtdt|dddi|d}t|dgdid}tt|tt|dS) Nr'.//k:Placemarkkrrr stylesheetZ Placemarkr$r)r+r,rr-r]df_kml)rxsl_flatten_docdf_stylerir2r2r3test_stylesheet_filels  rcCshtdt|||dkrdndd$}t|dddi|d}Wdn1sN0Ytt|dS Nr'r6rArBrrrr)r+r,rErr-r]r)rrr=rJrr2r2r3test_stylesheet_file_likes $r!cCstdt|||dkrdndd2}|dkrtdd}d}tt|}tt||d}t||dS)Nr'ru <根> r)r+r,rrr-r])rxslZdf_origrr2r2r3test_style_charsets   r(cCsJtd}tj|jddt||dWdn1s<0YdS)Nrzdocument is not a stylesheetr)r&r+r,rZXSLTParseErrorr)rr^rr2r2r3test_not_stylesheets  r*cCsNtd}d}tj|jddt||dWdn1s@0YdS)Nra z(Extra content at the end of the documentr)r&r+r,rrrrrr'r2r2r3test_incorrect_xsl_syntaxs  r-cCsNtd}d}tj|jddt||dWdn1s@0YdS)Nra zfailed to compiler)r&r)r,r2r2r3test_incorrect_xsl_evals r.cCsNtd}d}tj|jddt||dWdn1s@0YdS)Nrag zCannot resolve URIr)r&)r+r,rZXSLTApplyErrorrr,r2r2r3test_incorrect_xsl_applys  r/cCsRtd}|d}tj|jddt||dWdn1sD0YdS)Nrz flatten.xslz!Start tag expected, '<' not foundr)r&r+)rZ xml_data_pathZ xml_etreer'r2r2r3test_wrong_stylesheet*s r0cCstdt|||dkrdnddH}|dkr)r?rr)rrr2r2r3test_stylesheet_with_etreeGs  r2cCs\tdd}tjddd}tjt|dt||dWdn1sN0YdS)Nr'r(rGrzcta_rail_lines.kmlr)r&)r+r,rrIrrr.r)rr1Zkmlr2r2r3test_empty_stylesheetOs  r3c Cst|||dkrdndd}|dkr|dkrtjtdd&t||dgdid Wdn1sf0YWddSt||dgdid }Wdn1s0Ytgd gd gd gd gdd}t||dSNr6rArBr'z.reading file objects must return bytes objectsr)rSrTrZrlrnrorprrrs)rEr+rrrrr-r])r^r?r=rJZ df_filelikerur2r2r3test_file_like_iterparse^s4$ $ r5c Cs4|dkr tnt}t|||dkr"dndd}||}|dkr|dkrtjtdd&t||dgdid Wdn1s0YWdWddSt||dgdid }Wdn1s0YWdn1s0Ytgd gd gd gd gdd}t ||dSr4) rrrErNr+rrrrr-r])r^r?r=ZfuncIOrJbZ df_fileiorur2r2r3test_file_io_iterparsesD$B r7c Cst|ddf}|j|dtjtdd(t|j|dgdidWdn1sZ0YWdn1sx0YdS) NrArBrb)iterparse is designed for large XML filesr)rdrrr daterZ)rErerNr+rr rr)r?rgrrJr2r2r3test_url_path_errors r;c Cstjddf}tj|||dtjtdd(t||dgdi|dWdn1sZ0YWdn1sx0YdS) Nz geom_xml.ziprr?rLr8r)rdr9r?r[rL)r-rDgeom_dfto_xmlr+rr r)r?rPrIr2r2r3test_compression_errors rAcCsDtjtdd"t||gddWdn1s60YdS)Nz&list is not a valid type for iterparser)rTrZrrr2r2r3test_wrong_dict_types rBcCsDtjtdd"t||ddidWdn1s60YdS)Nz8 is not a valid type for value in iterparser)rSrUrZrrr2r2r3test_wrong_dict_valuesrCc Csd}tjdd}t|ddd}||Wdn1s@0Ytjtdd*t||d gd gd id Wdn1s0YWdn1s0YdS) Na square 00360 4.0 2020-01-01 circle 00360 2021-01-01 triangle 00180 3.0 2022-01-01 zbad.xmlr<r@rArBzDExtra content at the end of the document|junk after document elementr)r:rdr9)r?Z parse_datesr[)r-rDrErFr+rrr)r?Zbad_xmlrIrJr2r2r3 test_bad_xmls( rDcCs^d}tt|d|d}t||dddgid}tdd gd d gd }t||t||dS) Na- circle 2D sphere 3D rrrr&rrZrrrrr&rrrr2r2r3 test_comments rFcCs^d}tt|d|d}t||dddgid}tdd gd d gd }t||t||dS) Na8 ]> circle 2D sphere 3D rrrr&rrZrrrrrErrr2r2r3test_dtd$s rGcCs^d}tt|d|d}t||dddgid}tdd gd d gd }t||t||dS) Nam , , ?> circle 2D sphere 3D rrrr&rrZrrrrrErrr2r2r3test_processing_instructionHs rHcCsHtjtdd&t||dgdidWdn1s:0YdS)Nz+No result from selected items in iterparse.r)nodeZattr1Zelem1Zelem2Zelem3rZ)r+rr rrr2r2r3test_no_resultls rKcCsHtjtdd&t||dgdidWdn1s:0YdS)NzNo columns to parse from filer)rSrJrZ)r+rr rrr2r2r3test_empty_dataws  rLcCs`tdd}d}tt|dddg|d}tdd d d d d dddddd d}t||dS)Nr'a 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]rVartist)rrrzEmpire BurlesquezHide your heartz Greatest HitszStill got the bluesZErosr!z Bob Dylanz Bonnie Tylerz Dolly Partonz Gary MoorezEros Ramazzotti)rVrM)r+r,rrrr-r])rr'Zdf_xslrur2r2r3test_online_stylesheets4 VrNcCs~tJ}tj|d||dt|||d}t|||dgdi|d}Wdn1sX0Yt|tt|tdS)NF)rr?rLr=rdrr>)r-rDr?r@rrQr])r?rPrOrhrir2r2r3test_compression_reads  $ rOc Cs|}|}||kr$t|d|tdftdftdftdfd}tddd }|durd|jd f|d <td dd }|durtd f|d<||\}} t \} t j | ||dtj || dt | ||dWdn1s0YWdn1s0YdS)Nz == zInvalid data streamzNot a gzipped filezFile is not a zip filez%file could not be opened successfully)bz2gzipziptarZ zstandardignore)errorszUnknown frame descriptorzstdlzmaz%Input format not supported by decoderxzr=r))r+skipOSErrorr rr Z ZstdErrorrr-rDr?r@rr) r?rLrPZactual_compressionZattempted_compressionrUrVrWZ error_clsZ error_strrIr2r2r3test_wrong_compressions(     r[c CshtjtddFt}t||ddWdn1s<0YWdn1sZ0YdS)NzUnrecognized compression typer)Z7zr=)r+rrr-rDr)r?rIr2r2r3test_unsuported_compressions r\cCsNtdtdd|jd}t|d|d}t|d|d}t||dS)NZs3fsr'zs3://z /books.xml)r?Zstorage_optionsr>)r+r,r&rr-r])Zs3_public_bucket_with_dataZs3soZs3rrr2r2r3test_s3_parser_consistencys   r]c s|d}|dkr>ttjddgtjd}ttjdtgtjd}n.tdtddg}tddg}t d|"t t |||d}Wdn1s0Yt |t d d gd dt d d gdd|t d tgd dt d tgddt ttgd dt ddgddt dtgddd |dkrltdddlmt fddjDddgd<t|dS)Na; x 1 4.0 x 2 4.0 True False y 2 5.0 False pythonxyrZpyarrowzmode.string_storage)r? dtype_backendr"r#ZInt64rg@ZFloat64TFboolean) rr6rderJghir)ArrowExtensionArraycs$i|]}|j|ddqS)T)Z from_pandas)array).0colrhrpar2r3 sz1test_read_xml_nullable_dtypes..re)rnpriZobject_r r+r,rpdZoption_contextrrrrZ pandas.arraysrhcolumnsr-r])r?Zstring_storagerarGZ string_arrayZstring_array_narr2rlr3test_read_xml_nullable_dtypess> 0   rrcCsBd}tjt|dtdddWdn1s40YdS)NzPdtype_backend numpy is invalid, only 'numpy_nullable' and 'pyarrow' are allowed.r)testnumpy)rarr0r2r2r3test_invalid_dtype_backendsru) __future__riorrrWrrtarfiler urllib.errorrxml.etree.ElementTreerzipfiler rtror+Zpandas.compat._optionalr Z pandas.errorsr r Zpandas.util._test_decoratorsutilZ_test_decoratorstdZpandasrpr rrZpandas._testingZ_testingr-Zpandas.core.arraysrrZpandas.io.commonrZ pandas.io.xmlrrr?r/rrr4Zfixturer=r:Z skip_if_nor?rKrQramarknetworkZ single_cpurjrvrzrrrrrZ parametrizerrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr r rrrZskip_if_installedrrrr!r$r%r(r*r-r.r/r0r1r2r3r5r7r;rArBrCrDrFrGrHrKrLrNrOr[r\r]rrrur2r2r2r3sH          6   m          4   %&*1        "*  )#$$    E