o %j @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 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_nmspmsgr0]/var/www/html/Deteccion_Ine/venv/lib/python3.10/site-packages/pandas/tests/io/xml/test_xml.pytest_literal_xml_deprecations  "r2rbr)paramscC|jSNparamrequestr0r0r1moder<r%)ZmarksetreecCr6r7r8r:r0r0r1parserr=r?c Kstt,}t|ddd }||Wdn1swYt|fi|WdS1s3wYdS)Nwutf-8encoding)r+ ensure_cleanopenwriter)datakwargspathfr0r0r1read_xml_iterparse s  $rKc Kst|d|dK}t6}t|ddd}||jWdn1s'wYt|fi|WdWdS1sEwYWddS1sUwYdS)Nr4) compressionr@rArB)rr+rDrErFhandlereadr) comp_pathcompression_onlyrHZhandlesrIrJr0r0r1read_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_etreer0r0r1test_parser_consistency_files       racCsJ|jtdttt|d}ttt|dgdid}t||dS)NcontentrRrowrrZ) serve_contentr-rrrencoder+r])r? httpserverdf_xpathdf_iterr0r0r1test_parser_consistency_url3s   rjcCs~t|||dkr dndd}t||d}Wdn1swYtgdgdgdgdgd d }t||dS Nr4rArBrRcookingchildrenZwebzEveryday Italianz Harry Potterz Learning XMLzGiada De Laurentiisz J K. Rowlingz Erik T. Rayrrig>@g= ףp=@gC@rUrVrXrWrY)rErrr+r])r^r?r<rJdf_file df_expectedr0r0r1test_file_likeBs rwcCst|||dkr dndd }|}Wdn1swYtt|tr+t|nt||d}tgdgdgdgdgd d }t ||dSrk) rErNr isinstancebytesrrrr+r])r^r?r<rJxml_objZdf_iorvr0r0r1 test_file_ioSs   r{cCst|||dkr dndd }|}Wdn1swY|dkr,t|}n|dkr4t|}t||d}tgdgdgdgd gd d }t||dS Nr4rArBr3rRrlrorprqrsrt)rErNrdecoderrr+r]r^r?r<rJrzdf_strrvr0r0r1 test_file_buffered_reader_stringis"   rcCst|||dkr dndd}t||}Wdn1s wY|dkr0t|}n|dkr8t|}t||d}tgdgdgdgd gd d }t||dSr|) rEnextrNrr}rrr+r]r~r0r0r1,test_file_buffered_reader_no_xml_declarations$   rcCs8d}tt||d}tddddgd}t||dS)N<<中文標籤>12rRr r!)c1c2r)indexrrrr+r])r?txtrrvr0r0r1test_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?rurvr0r0r1test_file_charsets  rcCsNt|d}tt||d|jrJWddS1s wYdS)Nr3rR)rErrrNclosed)r^r?rJr0r0r1test_file_handle_closes  "rvalrcCstd}dddg}tj|j|d't|tr#tt|ddntt |ddWddSWddS1s>wYdS)N lxml.etree|zDocument is emptyzNone \(line 0\)r'r%rR) r)r*rraisesXMLSyntaxErrorrxstrrrr)r lxml_etreer/r0r0r1test_empty_string_lxmls  "rcCsptjtdd't|trtt|ddntt|ddWddSWddS1s1wYdS)Nzno element foundr'r>rR)r)rrrxrrrr)rr0r0r1test_empty_string_etrees "rcCsTd}tjddd}tjt|dt||dWddS1s#wYdS)Nr&rGhtmlz books.xmlr'rR)osrIrr)rr,r)r?r/filenamer0r0r1test_wrong_file_paths"rcCstdt|dd}|j|dt|jdd}Wdn1s%wYtgdgdgd gd gd d }t ||dS) Nr%rArBrb.//book[count(*)=4]xpathrlrorprqrsrt) r)r*rErerNrurlrr+r])rgxml_filerJZdf_urlrvr0r0r1test_urls  rcCsR|jdddtjtddt|jd|dWddS1s"wYdS)Nz NOT FOUNDi)codezHTTP Error 404: NOT FOUNDr'rrr?)rer)rrrr)r?rgr0r0r1test_wrong_url s"rcCsjd}tt||dd}t||dgdidd}tgdgdgd ddd }t||t||dS) Na square 360 circle 360 triangle 180 string)r?dtyperd)rrr)r?r[r)z 4 z 0 z 3 )z square z circle z" triangle ) 360 rz 180 rrrrKrr+r]r?xmlrhrirvr0r0r1test_whitespaces"   rcCsLtdtjtddt|dddWddS1swYdS)Nr%xpath does not return any nodesr'z .//pythonrr)r*r ValueErrorrr^r0r0r1test_empty_xpath_lxmlHs "rcCBtjtddt|dddWddS1swYdS)Nz/You have used an incorrect or unsupported XPathr' .//[book]r>rr)r SyntaxErrorrrr0r0r1test_bad_xpath_etreeNs "rcCNtd}tj|jddt|dddWddS1s wYdS)NrzInvalid expressionr'rr%rr)r*rZXPathEvalErrorr)r^rr0r0r1test_bad_xpath_lxmlU "rcCltttdddi|d}tt|dgdid}tgdgd d td d gd}t||t||dS) N .//ns:rownshttp://example.comr namespacesr?rdrrZrr@nan@)rrr-rKrfloatr+r]r?Zdf_nmsprirvr0r0r1test_default_namespace_s&   rcCr) N .//doc:rowdocrrrdrrZrrrrr)rrxml_prefix_nmsprKrrr+r]rr0r0r1test_prefix_namespaceys"  rcCsJtdtttdddidd}tttdddidd}t||dS) Nr%rrrrrrr>)r)r*rrr-r+r]df_lxmldf_etreer0r0r1"test_consistency_default_namespace rcCsJtdtttdddidd}tttdddidd}t||dS)Nr%rrrrr>)r)r*rrrr+r]rr0r0r1!test_consistency_prefix_namespacerrcCBtjtddt|d|dWddS1swYdS)Nrr'z .//Placemarkrr)rrrr^r?r0r0r1*test_missing_prefix_with_default_namespace"rcCr)Nz'you used an undeclared namespace prefixr'.//kml:Placemarkr>rr)kml_cta_rail_linesr0r0r1$test_missing_prefix_definition_etreerrcCr)NrzUndefined namespace prefixr'rr%rr)rrr0r0r1#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-)rr0r0r1test_none_namespace_prefixs "rcCsft||d}t||dgdid}tgdgdgdgdgd d}t||t||dS) NrRrSrtrZrlrorprqrsrrr+r]r^r?rurirvr0r0r1test_file_elems_and_attrss   rcCsNt|d|d}t||ddgid}tdgdi}t||t||dS)NT) attrs_onlyr?rSrUrZrlrrr0r0r1test_file_only_attrss  rcCsbt|d|d}t||dgdid}tgdgdgdgd d}t||t||dS) NT) elems_onlyr?rS)rVrXrWrYrZrorprqrsrrr0r0r1test_file_only_elemss  rcCsDtjtddt|dd|dWddS1swYdS)Nz3Either element or attributes can be parsed not bothr'T)rrr?r)rr?r0r0r1test_elem_and_attrs_only s "rcCLd}tjtddtt|dd|dWddS1swYdS)NaU square 360 circle 360 triangle 180 -xpath does not return any nodes or attributesr'./rowT)rrr?r)rrrrr?rr0r0r1test_empty_attrs_onlys"rcCr)Nz rr'rT)rrr?rrr0r0r1test_empty_elems_only-s"rcCsvtdd}tt|dd}tt|ddd}t|ddd gid }t|dddd gid }t||t||dS) Nr%a z .//stationrr>rstationNameZcoordsr[rZ)r)r*rrrKr+r])rrrZ df_iter_lxZ df_iter_etr0r0r1test_attribute_centric_xml<s  rcCsrt|gd|d}t||gddgdid}tgdgdgdgd gd d}t||t||dS) N)Col1Col2Col3ZCol4ZCol5namesr?rSrt)r?rr[rlrorprqrsrrr0r0r1test_names_option_outputas&   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[r2D3DrsphereZcurvedrrr0r0r1test_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)rrrr)r$rrrr0r0r1test_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$rrrrr)valuerrrr)rrr)rpolygonr)rrr)rrrrrr0r0r1test_repeat_elementss,  rcCsFtjtddt|gd|dWddS1swYdS)Nznames does not match lengthr')rrrrrrr0r0r1test_names_option_wrong_lengths"r cCr)Nzis not a valid type for namesr'zCol1, Col2, Col3rr)rrrrr0r0r1test_names_option_wrong_typerr cCs@tjtddt||dWddS1swYdS)Nz'utf-8' codec can't decoder'rRr)rUnicodeDecodeErrorrxml_baby_namesr?r0r0r1test_wrong_encodings"rcCr)NzLUTF-16 stream does not start with BOM|'utf-16(-le)?' codec can't decode byter'zUTF-16rCr?)r)r UnicodeErrorrrr0r0r1test_utf16_encoding s "rcCr)Nzunknown encoding: UFT-8r'zUFT-8r)r)r LookupErrorrrr0r0r1test_unknown_encodingrrcCr)Nz'ascii' codec can't decode byter'asciirr rr0r0r1test_ascii_encodingrrcCs~tdt|ddd}t|ddd}t|dddgdid}t|dddgdid}t||t||t||dS) Nr%z ISO-8859-1r?rCr>z iso-8859-1rd)rankZmalenameZ femalename)r?rCr[r\)rZ df_xpath_lxmlZdf_xpath_etreer_r`r0r0r1%test_parser_consistency_with_encoding"s$     rcCsTtdd}tjtddtt|dddWddS1s#wYdS)Nr%- c z encoding Noner'r)r)r*rrrr)rGr0r0r1test_wrong_encoding_for_lxml9s "rcCs4d}tt|ddd}tddgi}t||dS)Nrr>rrcr)rGresultexpectedr0r0r1test_none_encoding_etreeFsr cCs<tjtdd t|WddS1swYdS)Nz7lxml not found, please install or use the etree parser.r')r)r ImportErrorrrr0r0r1test_default_parser_no_lxmlVs  "r"cCs@tjtddt|ddWddS1swYdS)Nz,Values for parser can only be lxml or etree.r'Zbs4rRrrr0r0r1test_wrong_parser^s "r#cCsNtdt|dddi|d}t|dgdid}tt|tt|dS) Nr%.//k:Placemarkkrrr stylesheetZ Placemarkr"r)r)r*rr+r]df_kml)rxsl_flatten_docdf_stylerir0r0r1test_stylesheet_filehs  r+cCshtdt|||dkrdndd}t|dddi|d}Wdn1s'wYtt|dS Nr%r4rArBr$r%rr&)r)r*rErr+r]r()rr)r<rJr*r0r0r1test_stylesheet_file_likes r-cCstdt|||dkrdndd}|dkrt|}nt|}Wdn1s.wYt|dddi|d }tt |dS) Nr%r4rArBr3r$r%rr&) r)r*rErrNrrr+r]r(rr)r<rJxsl_objr*r0r0r1test_stylesheet_ios  r0cCsptdt|||dkrdndd }|}Wdn1s!wYt|dddi|d}tt|dSr,)r)r*rErNrr+r]r(r.r0r0r1test_stylesheet_buffered_readers  r1cCs>tdd}d}tt|}tt||d}t||dS)Nr%ru <根> r')r)r*rrr+r])rxslZdf_origr*r0r0r1test_style_charsets  r4cCsLtd}tj|jddt||dWddS1swYdS)Nrzdocument is not a stylesheetr'r2r)r*rZXSLTParseErrorr)rr^rr0r0r1test_not_stylesheets "r6cCPtd}d}tj|jddt||dWddS1s!wYdS)Nra z(Extra content at the end of the documentr'r2r)r*rrrrrr3r0r0r1test_incorrect_xsl_syntaxs "r:cCr7)Nra zfailed to compiler'r2r5r9r0r0r1test_incorrect_xsl_evals "r;cCr7)Nrag zCannot resolve URIr'r2)r)r*rZXSLTApplyErrorrr9r0r0r1test_incorrect_xsl_applys  "r<cCsTtd}|d}tj|jddt||dWddS1s#wYdS)Nrz flatten.xslz!Start tag expected, '<' not foundr'r2r8)rZ xml_data_pathZ xml_etreer3r0r0r1test_wrong_stylesheet&s "r=cCstdt|||dkrdndd%}|dkrt|}nt|}t||d|jr/JWddS1s:wYdS)Nr%r4rArBr3r2)r)r*rErrNrrr)rr)r<rJr/r0r0r1test_stylesheet_file_close2s    "r>cCsLtdtjtddt|d|dWddS1swYdS)Nr%z*To use stylesheet, you need lxml installedr'r>)r?r'r)rr)r0r0r1test_stylesheet_with_etreeCs "r?cCs^tdd}tjddd}tjt|dt||dWddS1s(wYdS)Nr%r&rGrzcta_rail_lines.kmlr'r2)r)r*rrIrrr,r)rr/Zkmlr0r0r1test_empty_stylesheetKs "r@c Cst|||dkr dnddF}|dkrA|dkrAtjtddt||dgdid Wdn1s3wY WddSt||dgdid }Wdn1sVwYtgd gd gd gd gdd}t||dSNr4rArBr%z.reading file objects must return bytes objectsr'rSrTrZrlrorprqrsrt)rEr)rrrrr+r])r^r?r<rJZ df_filelikervr0r0r1test_file_like_iterparseZs:   rBc Cs6|dkrtnt}t|||dkrdnddb}||L}|dkrV|dkrVtjtddt||dgdid Wdn1sBwY WdWddSt||dgdid }Wdn1skwYWdn1szwYtgd gd gd gd gdd}t ||dSrA) rrrErNr)rrrrr+r])r^r?r<ZfuncIOrJbZ df_fileiorvr0r0r1test_file_io_iterparse|sP  rDc Cst|dd<}|j|dtjtddt|j|dgdidWdn1s-wYWddSWddS1sEwYdS) NrArBrb)iterparse is designed for large XML filesr'rdrrrdaterZ)rErerNr)rr rr)r?rgrrJr0r0r1test_url_path_errors "rHc Cstjdd<}tj|||dtjtddt||dgdi|dWdn1s-wYWddSWddS1sEwYdS) Nz geom_xml.ziprr?rLrEr'rdrFr?r[rL)r+rDgeom_dfto_xmlr)rr r)r?rPrIr0r0r1test_compression_errors "rNcCsFtjtddt||gddWddS1swYdS)Nz&list is not a valid type for iterparser'rTrZr rr0r0r1test_wrong_dict_types"rOcCsFtjtddt||ddidWddS1swYdS)Nz8 is not a valid type for value in iterparser'rSrUrZr rr0r0r1test_wrong_dict_values "rPc 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.xmlrIr@rArBzDExtra content at the end of the document|junk after document elementr'rGrdrF)r?Z parse_datesr[)r+rDrErFr)rrr)r?Zbad_xmlrIrJr0r0r1 test_bad_xmls&  "rQcC^d}tt|d|d}t||dddgid}tdd gd d gd }t||t||dS) Na- circle 2D sphere 3D rrrr$rrZrrrrr$rrrr0r0r1 test_comments rTcCrR) Na8 ]> circle 2D sphere 3D rrrr$rrZrrrrrSrrr0r0r1test_dtd  rUcCrR) Nam , , ?> circle 2D sphere 3D rrrr$rrZrrrrrSrrr0r0r1test_processing_instructionDrVrWcCJtjtddt||dgdidWddS1swYdS)Nz+No result from selected items in iterparse.r'nodeZattr1Zelem1Zelem2Zelem3rZ)r)rr rrr0r0r1test_no_resulths "r[cCrX)NzNo columns to parse from filer'rSrZrZ)r)rr rrr0r0r1test_empty_datass "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]rVartist)rrr'zEmpire BurlesquezHide your heartz Greatest HitszStill got the bluesZErosrz Bob Dylanz Bonnie Tylerz Dolly Partonz Gary MoorezEros Ramazzotti)rVr])r)r*rrrr+r])rr3Zdf_xslrvr0r0r1test_online_stylesheet|s4 Vr^cCs~t%}tj|d||dt|||d}t|||dgdi|d}Wdn1s,wYt|tt|tdS)NF)rr?rLrJrdrrK)r+rDrLrMrrQr])r?rPrOrhrir0r0r1test_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 decoderxzrJr')r)skipOSErrorr rr Z ZstdErrorrr+rDrLrMrr) r?rLrPZactual_compressionZattempted_compressionrerfrg error_clsZ error_strrIr0r0r1test_wrong_compressions0     "rlc Csztjtdd,t}t||ddWdn1swYWddSWddS1s6wYdS)NzUnrecognized compression typer'Z7zrJ)r)rrr+rDr)r?rIr0r0r1test_unsuported_compressions "rmcCsNtdtdd|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_dataZs3soZs3rrr0r0r1test_s3_parser_consistencys  rnc 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)r? dtype_backendZpyarrowxyrr r!ZInt64rg@ZFloat64TFboolean) rrCrderJghir)ArrowExtensionArraycs$i|]}|j|ddqS)T)Z from_pandas)array).0colrxrpar0r1 sz1test_read_xml_nullable_dtypes..ru)Zcheck_column_type)pdZoption_contextrrr)r*Z ArrowDtyperZ StringDtyperrr Z pandas.arraysrxcolumnsryr+r])r?Zstring_storageroZusing_infer_stringrGrZ string_dtyper0r|r1test_read_xml_nullable_dtypess<    rcCsDd}tjt|dtdddWddS1swYdS)NzPdtype_backend numpy is invalid, only 'numpy_nullable' and 'pyarrow' are allowed.r'testnumpy)rorr.r0r0r1test_invalid_dtype_backends "r) __future__riorrrgrrtarfiler urllib.errorrZxml.etree.ElementTreerzipfiler rnpr)Zpandas.compat._optionalr Z pandas.errorsr r Zpandas.util._test_decoratorsutilZ_test_decoratorstdZpandasrr rrZpandas._testingZ_testingr+Zpandas.io.commonrZ pandas.io.xmlrrrLr-rr(r2Zfixturer<r9Z skip_if_nor?rKrQramarknetworkZ single_cpurjrwr{rrrrrZ parametrizerrrrrrrrrrrrrrrrrrrrrrrrrrrrr r rrrrrrr Zskip_if_installedr"r#r+r-r0r1r4r6r:r;r<r=r>r?r@rBrDrHrNrOrPrQrTrUrWr[r\r^r_rlrmrnrrr0r0r0r1sH          6   m           4   %&*1        "*   )#$$     F