o vh @sddlmZddlmZmZddlmZddlZddlm Z ddl m Z ddl m Z ddlmZddlZddlZdd lmZdd lmZmZddlmmZddlZdd lmZmZm Z ddl!m"Z#dd l$m%Z%dd l&m'Z'egdgddej(dgdZ)dZ*dZ+edddddddddddddddddddddddddddddddd d!d"d#dd$Z,d%d&Z-ej.d'd(gd)d*d+Z/ej.ej0d,e1d,d-d.gd)d/d0Z2d1d2Z3d3d4Z4d5d6Z5ej6j7ej6j8d7d8Z9d9d:Z:d;d<Z;d=d>ZdCdDZ?dEdFZ@ej6AdGdHdIgdJdKZBej6AdGdHdIgdLdMZCdNdOZDej6j7ej6j8dPdQZEej6j7ej6j8dRdSZFdTdUZGdVdWZHdXdYZIdZd[ZJd\d]ZKd^d_ZLd`daZMdbdcZNdddeZOdfdgZPdhdiZQej6AdjdHdgdkdlZRdmdnZSdodpZTdqdrZUdsdtZVdudvZWdwdxZXdydzZYd{d|ZZd}d~Z[ddZ\ddZ]ddZ^ddZ_ddZ`ddZaddZbddZcddZdddZeddZfegd,ddZhddZiddZjddZkddZlddZmddZnddZoddZpddZqddZrddZsddZtddZuej6AdGdHdIgddZvddZwddZxej6j7ej6j8ddZyddZzddZ{ddZ|ddZ}dd„Z~ddĄZddƄZddȄZddʄZdd̄Zdd΄ZddЄZdd҄Zej6j7ej6j8ddԄZddքZdd؄ZdS)) annotations)BytesIOStringIO) LZMAErrorN) ReadError) HTTPError) ParseError) BadZipFile)import_optional_dependency)EmptyDataError ParserError)NA DataFrameSeries) 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;Z/var/www/html/hyperkenya/venv/lib/python3.10/site-packages/pandas/tests/io/xml/test_xml.pytest_literal_xml_deprecations  "r=rbr)paramscC|jSNparamrequestr;r;r<moderGr/)marksetreecCrArBrCrEr;r;r<parserrHrKc Kstt,}t|ddd }||Wdn1swYt|fi|WdS1s3wYdS)Nwutf-8encoding)r5 ensure_cleanopenwriter)datakwargspathfr;r;r<read_xml_iterparse s  $rWc Kst|d|dK}t6}t|ddd}||jWdn1s'wYt|fi|WdWdS1sEwYWddS1sUwYdS)Nr?) compressionrLrMrN)rr5rPrQrRhandlereadr) comp_pathcompression_onlyrThandlesrUrVr;r;r<read_xml_iterparse_comps "r^cCsvtdt|dd}t|dd}t|ddgdid}t|ddgdid}t||t||t||dS)Nr/rKrJbookcategorytitleyearauthorpricerK iterparser3r4rr5assert_frame_equal) xml_books df_file_lxml df_file_etree df_iter_lxml df_iter_etreer;r;r<test_parser_consistency_files       rpcCsJ|jtdttt|d}ttt|dgdid}t||dS)Ncontentr_rowrrg) serve_contentr8rrrencoder5rj)rK httpserverdf_xpathdf_iterr;r;r<test_parser_consistency_url3s   rycCs~t|||dkr dndd}t||d}Wdn1swYtgdgdgdgdgd d }t||dS Nr?rMrNr_cookingchildrenwebzEveryday Italianz Harry Potterz Learning XMLzGiada De Laurentiisz J K. Rowlingz Erik T. Rayrig>@g= ףp=@gC@rbrcrerdrf)rQrrr5rj)rkrKrGrVdf_file df_expectedr;r;r<test_file_likeBs rcCst|||dkr dndd }|}Wdn1swYtt|tr+t|nt||d}tgdgdgdgdgd d }t ||dSrz) rQrZr isinstancebytesrrrr5rj)rkrKrGrVxml_objdf_iorr;r;r< test_file_ioSs   rcCst|||dkr dndd }|}Wdn1swY|dkr,t|}n|dkr4t|}t||d}tgdgdgdgd gd d }t||dS Nr?rMrNr>r_r{rrrrr)rQrZrdecoderrr5rjrkrKrGrVrdf_strrr;r;r< test_file_buffered_reader_stringis"   rcCst|||dkr dndd}t||}Wdn1s wY|dkr0t|}n|dkr8t|}t||d}tgdgdgdgd gd d }t||dSr) rQnextrZrrrrr5rjrr;r;r<,test_file_buffered_reader_no_xml_declarations$   rcCs8d}tt||d}tddddgd}t||dS)N<<中文標籤>12r_r%r&)c1c2r)indexrrrr5rj)rKtxtrrr;r;r<test_string_charsetsrcCsDt||d}tgddddgddggdd}t||dS) Nr_)uP問 若箇是邪而言破邪 何者是正而道(Sorry, this is Big5 only)申正u;問 既破有得申無得 亦應但破性執申假名以不uO問 既破性申假 亦應但破有申無 若有無兩洗 亦應性假雙破耶u<答 邪既無量 正亦多途 大略為言不出二種 謂u;有得與無得 有得是邪須破 無得是正須申 故uL答 不例 有無皆是性 所以須雙破 既分性假異 故有破不破)NuV答 性執是有得 假名是無得 今破有得申無得 即是破性執申假名也N)u問u答a)rrjoinr5rj)xml_doc_ch_utfrKrrr;r;r<test_file_charsets  rcCsNt|d}tt||d|jrJWddS1s wYdS)Nr>r_)rQrrrZclosed)rkrKrVr;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\)r1r/r_) r3r4rraisesXMLSyntaxErrorrstrrrr)r lxml_etreer:r;r;r<test_empty_string_lxmls  "rcCsptjtdd't|trtt|ddntt|ddWddSWddS1s1wYdS)Nzno element foundr1rJr_)r3rrrrrrr)rr;r;r<test_empty_string_etrees "rcCsTd}tjddd}tjt|dt||dWddS1s#wYdS)Nr0rShtmlz books.xmlr1r_)osrUrr3rr7r)rKr:filenamer;r;r<test_wrong_file_paths"rcCstdt|dd}|j|dt|jdd}Wdn1s%wYtgdgdgd gd gd d }t ||dS) Nr/rMrNrq.//book[count(*)=4]xpathr{rrrrr) r3r4rQrtrZrurlrr5rj)rvxml_filerVdf_urlrr;r;r<test_urls  rcCsR|jdddtjtddt|jd|dWddS1s"wYdS)Nz NOT FOUNDi)codezHTTP Error 404: NOT FOUNDr1rrrK)rtr3rrrr)rKrvr;r;r<test_wrong_url s"rcCsjd}tt||dd}t||dgdidd}tgdgdgd ddd }t||t||dS) Na square 360 circle 360 triangle 180 string)rKdtypers)rrr)rKrhr)z 4 z 0 z 3 )z square z circle z" triangle ) 360 rz 180 rrrrWrr5rjrKxmlrwrxrr;r;r<test_whitespaces"   rcCsLtdtjtddt|dddWddS1swYdS)Nr/xpath does not return any nodesr1z .//pythonrr3r4r ValueErrorrrkr;r;r<test_empty_xpath_lxmlHs "rcCBtjtddt|dddWddS1swYdS)Nz/You have used an incorrect or unsupported XPathr1 .//[book]rJrr3r SyntaxErrorrrr;r;r<test_bad_xpath_etreeNs "rcCNtd}tj|jddt|dddWddS1s wYdS)NrzInvalid expressionr1rr/rr3r4rXPathEvalErrorr)rkrr;r;r<test_bad_xpath_lxmlU "rcCltttdddi|d}tt|dgdid}tgdgd d td d gd}t||t||dS) N .//ns:rownshttp://example.comr namespacesrKrsrrgrr@nan@)rrr8rWrfloatr5rjrKdf_nmsprxrr;r;r<test_default_namespace_s&   rcCr) N .//doc:rowdocrrrsrrgrrrrr)rrxml_prefix_nmsprWrrr5rjrr;r;r<test_prefix_namespaceys"  rcCsJtdtttdddidd}tttdddidd}t||dS) Nr/rrrrrrrJ)r3r4rrr8r5rjdf_lxmldf_etreer;r;r<"test_consistency_default_namespace rcCsJtdtttdddidd}tttdddidd}t||dS)Nr/rrrrrJ)r3r4rrrr5rjrr;r;r<!test_consistency_prefix_namespacerrcCBtjtddt|d|dWddS1swYdS)Nrr1z .//Placemarkrr3rrrrkrKr;r;r<*test_missing_prefix_with_default_namespace"rcCr)Nz'you used an undeclared namespace prefixr1.//kml:PlacemarkrJrr)kml_cta_rail_linesr;r;r<$test_missing_prefix_definition_etreerrcCr)NrzUndefined namespace prefixr1rr/rr)rrr;r;r<#test_missing_prefix_definition_lxmlrrkeycCsVtdtjtddtttd|diddWddS1s$wYdS)Nr/z0empty namespace prefix is not supported in XPathr1rhttp://www.opengis.net/kml/2.2r)r3r4r TypeErrorrrr8)rr;r;r<test_none_namespace_prefixs "rcCsft||d}t||dgdid}tgdgdgdgdgd d}t||t||dS) Nr_r`rrgr{rrrrrrr5rjrkrKrrxrr;r;r<test_file_elems_and_attrss   rcCsNt|d|d}t||ddgid}tdgdi}t||t||dS)NT) attrs_onlyrKr`rbrgr{rrr;r;r<test_file_only_attrss  rcCsbt|d|d}t||dgdid}tgdgdgdgd d}t||t||dS) NT) elems_onlyrKr`)rcrerdrfrgrrrrrrr;r;r<test_file_only_elemss  rcCsDtjtddt|dd|dWddS1swYdS)Nz3Either element or attributes can be parsed not bothr1T)rrrKr)rrKr;r;r<test_elem_and_attrs_only s "rcCLd}tjtddtt|dd|dWddS1swYdS)NaU square 360 circle 360 triangle 180 -xpath does not return any nodes or attributesr1./rowT)rrrKr3rrrrrKrr;r;r<test_empty_attrs_onlys"rcCr)Nz rr1rT)rrrKrrr;r;r<test_empty_elems_only-s"rcCsvtdd}tt|dd}tt|ddd}t|ddd gid }t|dddd gid }t||t||dS) Nr/a z .//stationrrJrstationNamecoordsrhrg)r3r4rrrWr5rj)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)Col1Col2Col3Col4Col5namesrKr`r)rKrrhr{rrrrrrr;r;r<test_names_option_outputas&   rcCspd}tt|d|gdd}t||dgdigdd}tdd gd d gd d gd}t||t||dS) Nz circle curved sphere curved .//shape)type_dimr type_edgerrKrr)typer*rrKrhr2D3Drspherecurvedrrr;r;r<test_repeat_nameszs*   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*rrrr;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*rrrrr)valuer#r#r#r)rrr)r!polygonr$)rrr)rrrrrr;r;r<test_repeat_elementss,  r%cCsFtjtddt|gd|dWddS1swYdS)Nznames does not match lengthr1)r r r rrrr;r;r<test_names_option_wrong_lengths"r&cCr)Nzis not a valid type for namesr1zCol1, Col2, Col3rr3rrrrr;r;r<test_names_option_wrong_typerr(cCs@tjtddt||dWddS1swYdS)Nz'utf-8' codec can't decoder1r_r3rUnicodeDecodeErrorrxml_baby_namesrKr;r;r<test_wrong_encodings"r-cCr)NzLUTF-16 stream does not start with BOM|'utf-16(-le)?' codec can't decode byter1zUTF-16rOrK)r3r UnicodeErrorrr+r;r;r<test_utf16_encoding s "r0cCr)Nzunknown encoding: UFT-8r1zUFT-8r.)r3r LookupErrorrr+r;r;r<test_unknown_encodingrr2cCr)Nz'ascii' codec can't decode byter1asciir.r)r+r;r;r<test_ascii_encodingrr4cCs~tdt|ddd}t|ddd}t|dddgdid}t|dddgdid}t||t||t||dS) Nr/z ISO-8859-1rKrOrJz iso-8859-1rs)rankmalename femalename)rKrOrhri)r, df_xpath_lxmldf_xpath_etreernror;r;r<%test_parser_consistency_with_encoding"s$     r;cCsTtdd}tjtddtt|dddWddS1s#wYdS)Nr/- c z encoding Noner1r5)r3r4rrrr)rSr;r;r<test_wrong_encoding_for_lxml9s "r=cCs4d}tt|ddd}tddgi}t||dS)Nr<rJr5rcr)rSresultexpectedr;r;r<test_none_encoding_etreeFsrAcCs<tjtdd t|WddS1swYdS)Nz7lxml not found, please install or use the etree parser.r1)r3r ImportErrorrrr;r;r<test_default_parser_no_lxmlVs  "rCcCs@tjtddt|ddWddS1swYdS)Nz,Values for parser can only be lxml or etree.r1bs4r_rrr;r;r<test_wrong_parser^s "rEcCsNtdt|dddi|d}t|dgdid}tt|tt|dS) Nr/.//k:Placemarkkrrr stylesheet Placemarkr(r)r3r4rr5rjdf_kml)rxsl_flatten_docdf_stylerxr;r;r<test_stylesheet_filehs  rNcCshtdt|||dkrdndd}t|dddi|d}Wdn1s'wYtt|dS Nr/r?rMrNrFrGrrH)r3r4rQrr5rjrK)rrLrGrVrMr;r;r<test_stylesheet_file_likes rPcCstdt|||dkrdndd}|dkrt|}nt|}Wdn1s.wYt|dddi|d }tt |dS) Nr/r?rMrNr>rFrGrrH) r3r4rQrrZrrr5rjrKrrLrGrVxsl_objrMr;r;r<test_stylesheet_ios  rScCsptdt|||dkrdndd }|}Wdn1s!wYt|dddi|d}tt|dSrO)r3r4rQrZrr5rjrKrQr;r;r<test_stylesheet_buffered_readers  rTcCs>tdd}d}tt|}tt||d}t||dS)Nr/ru <根> rI)r3r4rrr5rj)rxsldf_origrMr;r;r<test_style_charsets  rXcCsLtd}tj|jddt||dWddS1swYdS)Nrzdocument is not a stylesheetr1rUr3r4rXSLTParseErrorr)rrkrr;r;r<test_not_stylesheets "r[cCPtd}d}tj|jddt||dWddS1s!wYdS)Nra z(Extra content at the end of the documentr1rUr3r4rrrrrrVr;r;r<test_incorrect_xsl_syntaxs "r_cCr\)Nra zfailed to compiler1rUrYr^r;r;r<test_incorrect_xsl_evals "r`cCr\)Nrag zCannot resolve URIr1rU)r3r4rXSLTApplyErrorrr^r;r;r<test_incorrect_xsl_applys  "rbcCsTtd}|d}tj|jddt||dWddS1s#wYdS)Nrz flatten.xslz!Start tag expected, '<' not foundr1rUr])r xml_data_path xml_etreerVr;r;r<test_wrong_stylesheet&s "recCstdt|||dkrdndd%}|dkrt|}nt|}t||d|jr/JWddS1s:wYdS)Nr/r?rMrNr>rU)r3r4rQrrZrrr)rrLrGrVrRr;r;r<test_stylesheet_file_close2s    "rfcCsLtdtjtddt|d|dWddS1swYdS)Nr/z*To use stylesheet, you need lxml installedr1rJ)rKrIr)rrLr;r;r<test_stylesheet_with_etreeCs "rgcCs^tdd}tjddd}tjt|dt||dWddS1s(wYdS)Nr/r0rSrzcta_rail_lines.kmlr1rU)r3r4rrUrrr7r)rr:kmlr;r;r<test_empty_stylesheetKs "ric Cst|||dkr dnddF}|dkrA|dkrAtjtddt||dgdid Wdn1s3wY WddSt||dgdid }Wdn1sVwYtgd gd gd gd gdd}t||dSNr?rMrNr/z.reading file objects must return bytes objectsr1r`rargr{rrrrr)rQr3rrrrr5rj)rkrKrGrV df_filelikerr;r;r<test_file_like_iterparseZs:   rlc Cs6|dkrtnt}t|||dkrdnddb}||L}|dkrV|dkrVtjtddt||dgdid Wdn1sBwY WdWddSt||dgdid }Wdn1skwYWdn1szwYtgd gd gd gd gdd}t ||dSrj) rrrQrZr3rrrrr5rj)rkrKrGfuncIOrVb df_fileiorr;r;r<test_file_io_iterparse|sP  rpc Cst|dd<}|j|dtjtddt|j|dgdidWdn1s-wYWddSWddS1sEwYdS) NrMrNrq)iterparse is designed for large XML filesr1rsrrrdaterg)rQrtrZr3rr rr)rKrvrrVr;r;r<test_url_path_errors "rtc Cstjdd<}tj|||dtjtddt||dgdi|dWdn1s-wYWddSWddS1sEwYdS) Nz geom_xml.ziprrKrXrqr1rsrrrKrhrX)r5rPgeom_dfto_xmlr3rr r)rKr\rUr;r;r<test_compression_errors "rzcCsFtjtddt||gddWddS1swYdS)Nz&list is not a valid type for iterparser1rargr'rr;r;r<test_wrong_dict_types"r{cCsFtjtddt||ddidWddS1swYdS)Nz8 is not a valid type for value in iterparser1r`rbrgr'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.xmlrurLrMrNzDExtra content at the end of the document|junk after document elementr1rsrsrr)rK parse_datesrh)r5rPrQrRr3rrr)rKbad_xmlrUrVr;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*rrgrrrrr*rrrr;r;r< test_comments rcCr) Na8 ]> circle 2D sphere 3D rrrr*rrgrrrrrrrr;r;r<test_dtd  rcCr) Nam , , ?> circle 2D sphere 3D rrrr*rrgrrrrrrrr;r;r<test_processing_instructionDrrcCJtjtddt||dgdidWddS1swYdS)Nz+No result from selected items in iterparse.r1nodeattr1elem1elem2elem3rg)r3rr rrr;r;r<test_no_resulths "rcCr)NzNo columns to parse from filer1r`rrg)r3rr rrr;r;r<test_empty_datass "rcCs`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]rcartist)rrrIzEmpire BurlesquezHide your heartz Greatest HitszStill got the bluesErosr$z Bob Dylanz Bonnie Tylerz Dolly Partonz Gary MoorezEros Ramazzotti)rcr)r3r4rrrr5rj)rrVdf_xslrr;r;r<test_online_stylesheet|s4 VrcCs~t%}tj|d||dt|||d}t|||dgdi|d}Wdn1s,wYt|tt|tdS)NF)rrKrXrvrsrrw)r5rPrxryrr^rj)rKr\r[rwrxr;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 decoderxzrvr1)r3skipOSErrorr rr ZstdErrorrr5rPrxryrr) rKrXr\actual_compressionattempted_compressionrrr error_cls error_strrUr;r;r<test_wrong_compressions0     "rc Csztjtdd,t}t||ddWdn1swYWddSWddS1s6wYdS)NzUnrecognized compression typer17zrv)r3rrr5rPr)rKrUr;r;r<test_unsuported_compressions "rcCsNtdtdd|jd}t|d|d}t|d|d}t||dS)Ns3fsr/zs3://z /books.xml)rKstorage_optionsrJ)r3r4r*rr5rj)s3_public_bucket_with_datas3sos3rrr;r;r<test_s3_parser_consistencys  rc sZd}td|tt|||d}Wdn1swY|dkr2tdt}nt|}t t ddg|dt dd gd dt d d gd dt ddg|dt d t gd dt d t gd dt t t gd dt ddgddt dt gddd |dkrtdddl m t fddjDddgd<tj|dddS)Na; x 1 4.0 x 2 4.0 True False y 2 5.0 False zmode.string_storage)rK dtype_backendpyarrowxyrr%r&Int64rg@Float64TFboolean) rrnr>derVghir)ArrowExtensionArraycs$i|]}|j|ddqS)T) from_pandas)array).0colrr@par;r< sz1test_read_xml_nullable_dtypes..r)check_column_type)pdoption_contextrrr3r4 ArrowDtyper StringDtyperrr pandas.arraysrcolumnsrr5rj)rKstring_storagerusing_infer_stringrSr? string_dtyper;rr<test_read_xml_nullable_dtypess<    rcCsDd}tjt|dtdddWddS1swYdS)NzPdtype_backend numpy is invalid, only 'numpy_nullable' and 'pyarrow' are allowed.r1testnumpy)rrr9r;r;r<test_invalid_dtype_backends "r) __future__riorrrrrtarfiler urllib.errorrxml.etree.ElementTreerzipfiler rnpr3pandas.compat._optionalr pandas.errorsr r pandas.util._test_decoratorsutil_test_decoratorstdpandasrr rrpandas._testing_testingr5pandas.io.commonr pandas.io.xmlrrrxr8rrKr=fixturerGrD skip_if_norKrWr^rpmarknetwork single_cpuryrrrrrrr parametrizerrrrrrrrrrrrrrrrrrrrrrrr rrr"r%r&r(r-r0r2r4r;r=rAskip_if_installedrCrErNrPrSrTrXr[r_r`rbrerfrgrirlrprtrzr{r|rrrrrrrrrrrrrr;r;r;r<sH          6   m           4   %&*1        "*   )#$$     F