o Ti @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 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 importorskiptmZassert_produces_warning FutureWarningrxml_default_nmspmsgr2\/var/www/html/evchargy.com/venv/lib/python3.10/site-packages/pandas/tests/io/xml/test_xml.pytest_literal_xml_deprecations  "r4rbr)paramscC|jSNparamrequestr2r2r3moder>r')ZmarksetreecCr8r9r:r<r2r2r3parser r?rAc Kstt,}t|ddd }||Wdn1swYt|fi|WdS1s3wYdS)Nwutf-8encoding)r- ensure_cleanopenwriter)datakwargspathfr2r2r3read_xml_iterparses  $rMc Kst|d|dK}t6}t|ddd}||jWdn1s'wYt|fi|WdWdS1sEwYWddS1sUwYdS)Nr6) compressionrBrCrD)rr-rFrGrHhandlereadr) comp_pathcompression_onlyrJZhandlesrKrLr2r2r3read_xml_iterparse_comps "rScCsvtdt|dd}t|dd}t|ddgdid}t|ddgdid}t||t||t||dS)Nr'rAr@bookcategorytitleyearauthorpricerA iterparser+r,rr-assert_frame_equal) xml_booksZ df_file_lxmlZ df_file_etree df_iter_lxml df_iter_etreer2r2r3test_parser_consistency_file"s       rccCsJ|jtdttt|d}ttt|dgdid}t||dS)NcontentrTrowrr\) serve_contentr/rrrencoder-r_)rA httpserverdf_xpathdf_iterr2r2r3test_parser_consistency_url7s   rlcCs~t|||dkr dndd}t||d}Wdn1swYtgdgdgdgdgd d }t||dS Nr6rCrDrTcookingchildrenZwebzEveryday Italianz Harry Potterz Learning XMLzGiada De Laurentiisz J K. Rowlingz Erik T. Rayrtig>@g= ףp=@gC@rWrXrZrYr[)rGrrr-r_)r`rAr>rLdf_file df_expectedr2r2r3test_file_likeFs rycCst|||dkr dndd }|}Wdn1swYtt|tr+t|nt||d}tgdgdgdgdgd d }t ||dSrm) rGrPr isinstancebytesrrrr-r_)r`rAr>rLxml_objZdf_iorxr2r2r3 test_file_ioWs   r}cCst|||dkr dndd }|}Wdn1swY|dkr,t|}n|dkr4t|}t||d}tgdgdgdgd gd d }t||dS Nr6rCrDr5rTrnrqrrrsrurv)rGrPrdecoderrr-r_r`rAr>rLr|df_strrxr2r2r3 test_file_buffered_reader_stringms"   rcCst|||dkr dndd}t||}Wdn1s wY|dkr0t|}n|dkr8t|}t||d}tgdgdgdgd gd d }t||dSr~) rGnextrPrrrrr-r_rr2r2r3,test_file_buffered_reader_no_xml_declarations$   rcCs8d}tt||d}tddddgd}t||dS)N<<中文標籤>12rTr"r#)c1c2r)indexrrrr-r_)rAtxtrrxr2r2r3test_string_charsetsrcCsDt||d}tgddddgddggdd}t||dS) NrT)uP問 若箇是邪而言破邪 何者是正而道(Sorry, this is Big5 only)申正u;問 既破有得申無得 亦應但破性執申假名以不uO問 既破性申假 亦應但破有申無 若有無兩洗 亦應性假雙破耶u<答 邪既無量 正亦多途 大略為言不出二種 謂u;有得與無得 有得是邪須破 無得是正須申 故uL答 不例 有無皆是性 所以須雙破 既分性假異 故有破不破)NuV答 性執是有得 假名是無得 今破有得申無得 即是破性執申假名也N)u問u答a)rrjoinr-r_)Zxml_doc_ch_utfrArwrxr2r2r3test_file_charsets  rcCsNt|d}tt||d|jrJWddS1s wYdS)Nr5rT)rGrrrPclosed)r`rArLr2r2r3test_file_handle_closes  "rvalrcCstd}dddg}tj|j|d't|tr#tt|ddntt |ddWddSWddS1s>wYdS)N lxml.etree|zDocument is emptyzNone \(line 0\)r)r'rT) r+r,rraisesXMLSyntaxErrorrzstrrrr)r lxml_etreer1r2r2r3test_empty_string_lxmls  "rcCsptjtdd't|trtt|ddntt|ddWddSWddS1s1wYdS)Nzno element foundr)r@rT)r+rrrzrrrr)rr2r2r3test_empty_string_etrees "rcCsTd}tjddd}tjt|dt||dWddS1s#wYdS)Nr(rIhtmlz books.xmlr)rT)osrKrr+rr.r)rAr1filenamer2r2r3test_wrong_file_paths"rcCstdt|dd}|j|dt|jdd}Wdn1s%wYtgdgdgd gd gd d }t ||dS) Nr'rCrDrd.//book[count(*)=4]xpathrnrqrrrsrurv) r+r,rGrgrPrurlrr-r_)rixml_filerLZdf_urlrxr2r2r3test_urls  rcCsR|jdddtjtddt|jd|dWddS1s"wYdS)Nz NOT FOUNDi)codezHTTP Error 404: NOT FOUNDr)rrrA)rgr+rrrr)rArir2r2r3test_wrong_url s"rcCsjd}tt||dd}t||dgdidd}tgdgdgd ddd }t||t||dS) Na square 360 circle 360 triangle 180 string)rAdtyperf)r rr)rAr]r)z 4 z 0 z 3 )z square z circle z" triangle ) 360 rz 180 rrrrMrr-r_rAxmlrjrkrxr2r2r3test_whitespaces"   rcCsLtdtjtddt|dddWddS1swYdS)Nr'xpath does not return any nodesr)z .//pythonrr+r,r ValueErrorrr`r2r2r3test_empty_xpath_lxmlLs "rcCBtjtddt|dddWddS1swYdS)Nz/You have used an incorrect or unsupported XPathr) .//[book]r@rr+r SyntaxErrorrrr2r2r3test_bad_xpath_etreeRs "rcCNtd}tj|jddt|dddWddS1s wYdS)NrzInvalid expressionr)rr'rr+r,rZXPathEvalErrorr)r`rr2r2r3test_bad_xpath_lxmlY "rcCltttdddi|d}tt|dgdid}tgdgd d td d gd}t||t||dS) N .//ns:rownshttp://example.comr namespacesrArfrr\rr@nan@)rrr/rMrfloatr-r_rAZdf_nmsprkrxr2r2r3test_default_namespacecs&   rcCr) N .//doc:rowdocrrrfrr\rrrrr)rrxml_prefix_nmsprMrrr-r_rr2r2r3test_prefix_namespace}s"  rcCsJtdtttdddidd}tttdddidd}t||dS) Nr'rrrrrrr@)r+r,rrr/r-r_df_lxmldf_etreer2r2r3"test_consistency_default_namespace rcCsJtdtttdddidd}tttdddidd}t||dS)Nr'rrrrr@)r+r,rrrr-r_rr2r2r3!test_consistency_prefix_namespacerrcCBtjtddt|d|dWddS1swYdS)Nrr)z .//Placemarkrr+rrrr`rAr2r2r3*test_missing_prefix_with_default_namespace"rcCr)Nz'you used an undeclared namespace prefixr).//kml:Placemarkr@rr)kml_cta_rail_linesr2r2r3$test_missing_prefix_definition_etreerrcCr)NrzUndefined namespace prefixr)rr'rr)rrr2r2r3#test_missing_prefix_definition_lxmlrrkeycCsVtdtjtddtttd|diddWddS1s$wYdS)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) NrTrUrvr\rnrqrrrsrurrr-r_r`rArwrkrxr2r2r3test_file_elems_and_attrss   rcCsNt|d|d}t||ddgid}tdgdi}t||t||dS)NT) attrs_onlyrArUrWr\rnrrr2r2r3test_file_only_attrss  rcCsbt|d|d}t||dgdid}tgdgdgdgd d}t||t||dS) NT) elems_onlyrArU)rXrZrYr[r\rqrrrsrurrr2r2r3test_file_only_elemss  rcCsDtjtddt|dd|dWddS1swYdS)Nz3Either element or attributes can be parsed not bothr)T)rrrAr)rrAr2r2r3test_elem_and_attrs_onlys "rcCLd}tjtddtt|dd|dWddS1swYdS)NaU square 360 circle 360 triangle 180 -xpath does not return any nodes or attributesr)./rowT)rrrAr+rrrrrArr2r2r3test_empty_attrs_onlys"rcCr)Nz rr)rT)rrrArrr2r2r3test_empty_elems_only1s"rcCsvtdd}tt|dd}tt|ddd}t|ddd gid }t|dddd gid }t||t||dS) Nr'a z .//stationrr@rstationNameZcoordsr]r\)r+r,rrrMr-r_)rrrZ df_iter_lxZ df_iter_etr2r2r3test_attribute_centric_xml@s  rcCsrt|gd|d}t||gddgdid}tgdgdgdgd gd d}t||t||dS) N)Col1Col2Col3ZCol4ZCol5namesrArUrv)rArr]rnrqrrrsrurrr2r2r3test_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_edgerrArr)typer&rrAr]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,  r cCsFtjtddt|gd|dWddS1swYdS)Nznames does not match lengthr))rrrrrrr2r2r3test_names_option_wrong_lengths"r cCr)Nzis not a valid type for namesr)zCol1, Col2, Col3rr+rrrrr2r2r3test_names_option_wrong_typerr cCs@tjtddt||dWddS1swYdS)Nz'utf-8' codec can't decoder)rTr+rUnicodeDecodeErrorrxml_baby_namesrAr2r2r3test_wrong_encoding s"rcCr)NzIUTF-16 stream does not start with BOM|'utf-16-le' codec can't decode byter)zUTF-16rErA)r+r UnicodeErrorrrr2r2r3test_utf16_encodings "rcCr)Nzunknown encoding: UFT-8r)zUFT-8r)r+r LookupErrorrrr2r2r3test_unknown_encodingrrcCr)Nz'ascii' codec can't decode byter)asciirrrr2r2r3test_ascii_encoding!rrcCs~tdt|ddd}t|ddd}t|dddgdid}t|dddgdid}t||t||t||dS) Nr'z ISO-8859-1rArEr@z iso-8859-1rf)ZrankZmalenameZ femalename)rArEr]r^)rZ df_xpath_lxmlZdf_xpath_etreerarbr2r2r3%test_parser_consistency_with_encoding&s$     rcCsTtdd}tjtddtt|dddWddS1s#wYdS)Nr'- c z encoding Noner)r)r+r,rrrr)rIr2r2r3test_wrong_encoding_for_lxml=s "rcCs4d}tt|ddd}tddgi}t||dS)Nrr@rrcr)rIresultexpectedr2r2r3test_none_encoding_etreeJsr!cCs<tjtdd t|WddS1swYdS)Nz7lxml not found, please install or use the etree parser.r))r+r ImportErrorrrr2r2r3test_default_parser_no_lxmlZs  "r#cCs@tjtddt|ddWddS1swYdS)Nz,Values for parser can only be lxml or etree.r)Zbs4rTrrr2r2r3test_wrong_parserbs "r$cCsNtdt|dddi|d}t|dgdid}tt|tt|dS) Nr'.//k:Placemarkkrrr stylesheetZ Placemarkr$r)r+r,rr-r_df_kml)rxsl_flatten_docdf_stylerkr2r2r3test_stylesheet_filels  r,cCshtdt|||dkrdndd}t|dddi|d}Wdn1s'wYtt|dS Nr'r6rCrDr%r&rr')r+r,rGrr-r_r))rr*r>rLr+r2r2r3test_stylesheet_file_likes r.cCstdt|||dkrdndd}|dkrt|}nt|}Wdn1s.wYt|dddi|d }tt |dS) Nr'r6rCrDr5r%r&rr') r+r,rGrrPrrr-r_r)rr*r>rLxsl_objr+r2r2r3test_stylesheet_ios  r1cCsptdt|||dkrdndd }|}Wdn1s!wYt|dddi|d}tt|dSr-)r+r,rGrPrr-r_r)r/r2r2r3test_stylesheet_buffered_readers  r2cCs>tdd}d}tt|}tt||d}t||dS)Nr'ru <根> r()r+r,rrr-r_)rxslZdf_origr+r2r2r3test_style_charsets  r5cCsLtd}tj|jddt||dWddS1swYdS)Nrzdocument is not a stylesheetr)r3r+r,rZXSLTParseErrorr)rr`rr2r2r3test_not_stylesheets "r7cCPtd}d}tj|jddt||dWddS1s!wYdS)Nra z(Extra content at the end of the documentr)r3r+r,rrrrrr4r2r2r3test_incorrect_xsl_syntaxs "r;cCr8)Nra zfailed to compiler)r3r6r:r2r2r3test_incorrect_xsl_evals "r<cCr8)Nrag zCannot resolve URIr)r3)r+r,rZXSLTApplyErrorrr:r2r2r3test_incorrect_xsl_applys  "r=cCsTtd}|d}tj|jddt||dWddS1s#wYdS)Nrz flatten.xslz!Start tag expected, '<' not foundr)r3r9)rZ xml_data_pathZ xml_etreer4r2r2r3test_wrong_stylesheet*s "r>cCstdt|||dkrdndd%}|dkrt|}nt|}t||d|jr/JWddS1s:wYdS)Nr'r6rCrDr5r3)r+r,rGrrPrrr)rr*r>rLr0r2r2r3test_stylesheet_file_close6s    "r?cCsLtdtjtddt|d|dWddS1swYdS)Nr'z*To use stylesheet, you need lxml installedr)r@)rAr(r)rr*r2r2r3test_stylesheet_with_etreeGs "r@cCs^tdd}tjddd}tjt|dt||dWddS1s(wYdS)Nr'r(rIrzcta_rail_lines.kmlr)r3)r+r,rrKrrr.r)rr1Zkmlr2r2r3test_empty_stylesheetOs "rAc Cst|||dkr dnddF}|dkrA|dkrAtjtddt||dgdid Wdn1s3wY WddSt||dgdid }Wdn1sVwYtgd gd gd gd gdd}t||dSNr6rCrDr'z.reading file objects must return bytes objectsr)rUrVr\rnrqrrrsrurv)rGr+rrrrr-r_)r`rAr>rLZ df_filelikerxr2r2r3test_file_like_iterparse^s:   rCc Cs6|dkrtnt}t|||dkrdnddb}||L}|dkrV|dkrVtjtddt||dgdid Wdn1sBwY WdWddSt||dgdid }Wdn1skwYWdn1szwYtgd gd gd gd gdd}t ||dSrB) rrrGrPr+rrrrr-r_)r`rAr>ZfuncIOrLbZ df_fileiorxr2r2r3test_file_io_iterparsesP  rEc Cst|dd<}|j|dtjtddt|j|dgdidWdn1s-wYWddSWddS1sEwYdS) NrCrDrd)iterparse is designed for large XML filesr)rfrrr dater\)rGrgrPr+rr rr)rArirrLr2r2r3test_url_path_errors "rIc Cstjdd<}tj|||dtjtddt||dgdi|dWdn1s-wYWddSWddS1sEwYdS) Nz geom_xml.ziprrArNrFr)rfrGrAr]rN)r-rFgeom_dfto_xmlr+rr r)rArRrKr2r2r3test_compression_errors "rOcCsFtjtddt||gddWddS1swYdS)Nz&list is not a valid type for iterparser)rVr\r rr2r2r3test_wrong_dict_types"rPcCsFtjtddt||ddidWddS1swYdS)Nz8 is not a valid type for value in iterparser)rUrWr\r rr2r2r3test_wrong_dict_values "rQc 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.xmlrJrBrCrDzDExtra content at the end of the document|junk after document elementr)rHrfrG)rAZ parse_datesr])r-rFrGrHr+rrr)rAZbad_xmlrKrLr2r2r3 test_bad_xmls&  "rRcC^d}tt|d|d}t||dddgid}tdd gd d gd }t||t||dS) Na- circle 2D sphere 3D rrrr&rr\rrrrr&rrrr2r2r3 test_comments rUcCrS) Na8 ]> circle 2D sphere 3D rrrr&rr\rrrrrTrrr2r2r3test_dtd$ rVcCrS) Nam , , ?> circle 2D sphere 3D rrrr&rr\rrrrrTrrr2r2r3test_processing_instructionHrWrXcCJtjtddt||dgdidWddS1swYdS)Nz+No result from selected items in iterparse.r)nodeZattr1Zelem1Zelem2Zelem3r\)r+rr rrr2r2r3test_no_resultls "r\cCrY)NzNo columns to parse from filer)rUr[r\)r+rr rrr2r2r3test_empty_dataws "r]cCs`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]rXartist)rrr(zEmpire BurlesquezHide your heartz Greatest HitszStill got the bluesZErosr!z Bob Dylanz Bonnie Tylerz Dolly Partonz Gary MoorezEros Ramazzotti)rXr^)r+r,rrrr-r_)rr4Zdf_xslrxr2r2r3test_online_stylesheets4 Vr_cCs~t%}tj|d||dt|||d}t|||dgdi|d}Wdn1s,wYt|tt|tdS)NF)rrArNrKrfrrL)r-rFrMrNrrSr_)rArRrQrjrkr2r2r3test_compression_reads   r`c 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)bz2gzipziptarZ zstandardignore)errorszUnknown frame descriptorzstdlzmaz%Input format not supported by decoderxzrKr))r+skipOSErrorr rr Z ZstdErrorrr-rFrMrNrr) rArNrRZactual_compressionZattempted_compressionrfrgrh error_clsZ error_strrKr2r2r3test_wrong_compressions0     "rmc Csztjtdd,t}t||ddWdn1swYWddSWddS1s6wYdS)NzUnrecognized compression typer)Z7zrK)r+rrr-rFr)rArKr2r2r3test_unsuported_compressions "rncCsNtdtdd|jd}t|d|d}t|d|d}t||dS)NZs3fsr'zs3://z /books.xml)rAZstorage_optionsr@)r+r,r&rr-r_)Zs3_public_bucket_with_dataZs3soZs3rrr2r2r3test_s3_parser_consistencys  roc 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 pythonxyrZpyarrowzmode.string_storage)rA dtype_backendr"r#ZInt64rg@ZFloat64TFboolean) rrDrderLghir)ArrowExtensionArraycs$i|]}|j|ddqS)T)Z from_pandas)array).0colrzr par2r3 sz1test_read_xml_nullable_dtypes..rw)rnpr{Zobject_r r+r,rpdZoption_contextrrrrZ pandas.arraysrzcolumnsr-r_)rAZstring_storagersrIZ string_arrayZstring_array_narr2r~r3test_read_xml_nullable_dtypess@   rcCsDd}tjt|dtdddWddS1swYdS)NzPdtype_backend numpy is invalid, only 'numpy_nullable' and 'pyarrow' are allowed.r)testnumpy)rsrr0r2r2r3test_invalid_dtype_backends "r) __future__riorrrhrrtarfiler urllib.errorrZxml.etree.ElementTreerzipfiler rrr+Zpandas.compat._optionalr Z pandas.errorsr r Zpandas.util._test_decoratorsutilZ_test_decoratorstdZpandasrr rrZpandas._testingZ_testingr-Zpandas.core.arraysrrZpandas.io.commonrZ pandas.io.xmlrrrMr/rr)r4Zfixturer>r;Z skip_if_norArMrSrcmarknetworkZ single_cpurlryr}rrrrrZ parametrizerrrrrrrrrrrrrrrrrrrrrrrrrrrr r r rrrrrrr!Zskip_if_installedr#r$r,r.r1r2r5r7r;r<r=r>r?r@rArCrErIrOrPrQrRrUrVrXr\r]r_r`rmrnrorrr2r2r2r3sJ          6   m           4   %&*1        "*   )#$$     E