bMh ddlmZddlmZmZddlmZddlZddlm Z ddl m Z ddl m Z ddlmZddlZddlZdd lmZdd lmZmZddlmcmZddlZdd lmZmZm Z ddl!m"Z#dd l$m%Z%dd l&m'Z'egdgddej(dgdZ)dZ*dZ+edddddddddddddddddddddddddddddddd d!d"d#dd$Z,d%Z-ej.d&d'g(d)Z/ej.ej0d*ej1d*+d,g(d-Z2d.Z3d/Z4d0Z5ej6j7ej6j8d1Z9d2Z:d3Z;d4Zd7Z?d8Z@ej6Ad9d:d;gd<ZBej6Ad9d:d;gd=ZCd>ZDej6j7ej6j8d?ZEej6j7ej6j8d@ZFdAZGdBZHdCZIdDZJdEZKdFZLdGZMdHZNdIZOdJZPdKZQej6AdLd:dgdMZRdNZSdOZTdPZUdQZVdRZWdSZXdTZYdUZZdVZ[dWZ\dXZ]dYZ^dZZ_d[Z`d\Zad]Zbd^Zcd_Zdd`ZedaZfejgd*dbZhdcZiddZjdeZkdfZldgZmdhZndiZodjZpdkZqdlZrdmZsdnZtdoZuej6Ad9d:d;gdpZvdqZwdrZxej6j7ej6j8dsZydtZzduZ{dvZ|dwZ}dxZ~dyZdzZd{Zd|Zd}Zd~ZdZdZej6j7ej6j8dZdZdZdS)) 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 coordinatesctjdd}tjt|5t t ddddS#1swxYwYdS)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_nmspmsgs \/var/www/html/test/jupyter/venv/lib/python3.11/site-packages/pandas/tests/io/xml/test_xml.pytest_literal_xml_deprecationr>s  : #M = = =##!"""##################sAAArbr)paramsc|jSNparamrequests r=moderH =r1)marksetreec|jSrCrDrFs r=parserrNrIrJc tj5}t|dd5}||dddn #1swxYwYt |fi|cdddS#1swxYwYdS)Nwutf-8encoding)r7 ensure_cleanopenwriter)datakwargspathfs r=read_xml_iterparser[ s   (d $g . . . ! GGDMMM               ''''((((((((((((((((((s3A-A  A- A A-A A--A14A1c t|d|5}tj5}t|dd5}||jdddn #1swxYwYt|fi|cdddcdddS#1swxYwY ddddS#1swxYwYdS)Nr@) compressionrPrQrR)rr7rTrUrVhandlereadr) comp_pathcompression_onlyrXhandlesrYrZs r=read_xml_iterparse_comprcs Is0@ A A A,W _   ,$dC'222 /a++--... / / / / / / / / / / / / / / /D++F++ , , , , , , ,,,,,,,,, , , , , , , , , ,,,,,,,,,,,,,,,,,,,sWB<B#-A3' B#3A7 7B#:A7 ;B# B<#B' 'B<*B' +B<<CCcHtjdt|d}t|d}t|ddgdi}t|ddgdi}tj||tj||tj||dS)Nr1rNrLbookcategorytitleyearauthorpricerN iterparser5r6rr7assert_frame_equal) xml_books df_file_lxml df_file_etree df_iter_lxml df_iter_etrees r=test_parser_consistency_filervs If555LYw777MKKKLL KKKLM , 666, 555, 66666rJc |tttt|}tt t|dgdi}t j||dS)Ncontentrerowrrm) serve_contentr:rrrencoder7rp)rN httpserverdf_xpathdf_iters r=test_parser_consistency_urlr3s%5666!1226BBBH ''))**7778G (G,,,,,rJct|||dkrdnd5}t||}dddn #1swxYwYtgdgdgdgdgd d }tj||dS Nr@rQrRrecookingchildrenwebzEveryday Italianz Harry Potterz Learning XMLzGiada De Laurentiisz J K. Rowlingz Erik T. Rayrig>@g= ףp=@gC@rhrirkrjrl)rUrrr7rp)rqrNrHrZdf_file df_expecteds r=test_file_likerBs i43;;D I I I-Q1V,,,---------------666IIILLL&&&***   K';/////s 9==c~t|||dkrdnd5}|}dddn #1swxYwYtt|trt |nt ||}tgdgdgdgdgd d }tj ||dSr) rUr_r isinstancebytesrrrr7rp)rqrNrHrZxml_objdf_iors r= test_file_iorSs% i43;;D I I IQ&&(( '77 N   Xg=N=N   E 666IIILLL&&&***   K%-----<AAct|||dkrdnd5}|}dddn #1swxYwY|dkr"t|}n|dkrt|}t ||}t gdgdgdgd gd d }t j||dS Nr@rQrRr?rerrrrrr)rUr_rdecoderrr7rprqrNrHrZrdf_strrs r= test_file_buffered_reader_stringris/ i43;;D I I IQ&&(( t||7>>++,, 7## gf - - -F666IIILLL&&&***   K&+.....rct|||dkrdnd5}t||}dddn #1swxYwY|dkr"t|}n|dkrt|}t ||}t gdgdgdgd gd d }tj||dSr) rUnextr_rrrrr7rprs r=,test_file_buffered_reader_no_xml_declarationrs: i43;;D I I IQ Q&&(( t||7>>++,, 7## gf - - -F666IIILLL&&&***   K&+.....s$A  AAcd}tt||}tddddg}tj||dS)N<<中文標籤>12rer&r')c1c2r)indexrrrr7rp)rNtxtrrs r=test_string_charsetrsT HC hsmmF 3 3 3F1A..qc:::K&+.....rJct||}tgddddgddggdd}tj||dS) Nre)uP問 若箇是邪而言破邪 何者是正而道(Sorry, this is Big5 only)申正u;問 既破有得申無得 亦應但破性執申假名以不uO問 既破性申假 亦應但破有申無 若有無兩洗 亦應性假雙破耶u<答 邪既無量 正亦多途 大略為言不出二種 謂u;有得與無得 有得是邪須破 無得是正須申 故uL答 不例 有無皆是性 所以須雙破 既分性假異 故有破不破)NuV答 性執是有得 假名是無得 今破有得申無得 即是破性執申假名也N)u問u答a)rrjoinr7rp)xml_doc_ch_utfrNrrs r=test_file_charsetrs~f555G VX ^ !  K2';/////rJct|d5}tt|||jrJ ddddS#1swxYwYdS)Nr?re)rUrrr_closed)rqrNrZs r=test_file_handle_closers i  !""622228s:AA AvalrrJchtjd}dddg}tj|j|5t |t rtt|dntt|dddddS#1swxYwYdS)N lxml.etree|zDocument is emptyzNone \(line 0\)r3r1re) r5r6rraisesXMLSyntaxErrorrstrrrr)r lxml_etreer<s r=test_empty_string_lxmlrs$\22J ((     C z0 < < <22 c3   2 Xc]]6 2 2 2 2 2 WS\\& 1 1 1 1 222222222222222222sAB''B+.B+ctjtd5t|trt t |dnt t|dddddS#1swxYwYdS)Nzno element foundr3rLre)r5rr rrrrr)rs r=test_empty_string_etreers z); < < <33 c3   3 Xc]]7 3 3 3 3 3 WS\\' 2 2 2 2 333333333333333333sAA<<BBcd}tjddd}tjt |5t ||ddddS#1swxYwYdS)Nr2rWhtmlz books.xmlr3re)osrYrr5rr9r)rNr<filenames r=test_wrong_file_pathrs : w||FFK88H    ** &)))) ******************sAA"%A"cdtjdt|d5}||t |jd}dddn #1swxYwYtgdgdgd gd gd d }tj ||dS) Nr1rQrRrx.//book[count(*)=4]xpathrrrrrr) r5r6rUr{r_rurlrr7rp)r}xml_filerZdf_urlrs r=test_urlrs!  h ) ) )GQ   222*.0EFFFGGGGGGGGGGGGGGG666IIILLL&&&***   K&+.....s?A11A58A5c|ddtjtd5t |jd|ddddS#1swxYwYdS)Nz NOT FOUNDi)codezHTTP Error 404: NOT FOUNDr3rrrN)r{r5rrrr)rNr}s r=test_wrong_urlr s[s333 y)D F F FMM' square 360 circle 360 triangle 180 string)rNdtyperz)rrr)rNrnr)z 4 z 0 z 3 )z square z circle z" triangle ) 360 rz 180 rrrr[rr7rprNxmlr~rrs r=test_whitespacers C, fHEEEH  7778 G*** 988     K(K000';/////rJctjdtjtd5t |ddddddS#1swxYwYdS)Nr1xpath does not return any nodesr3z .//pythonrr5r6r ValueErrorrrqs r=test_empty_xpath_lxmlrHs  z*K M M M>>+f====>>>>>>>>>>>>>>>>>>AAActjtd5t|ddddddS#1swxYwYdS)Nz/You have used an incorrect or unsupported XPathr3 .//[book]rLrr5r SyntaxErrorrrs r=test_bad_xpath_etreerNs M   ?? +g>>>>??????????????????<AActjd}tj|jd5t |ddddddS#1swxYwYdS)NrzInvalid expressionr3rr1rr5r6rXPathEvalErrorr)rqrs r=test_bad_xpath_lxmlrUs$\22J z09M O O O>>+f====>>>>>>>>>>>>>>>>>>rc,tttdddi|}tt|dgdi}t gdgd d t d d gd}t j||t j||dS) N .//ns:rownshttp://example.comr namespacesrNrzrrmrr@nan@)rrr:r[rfloatr7rprNdf_nmsprrs r=test_default_namespacer_s!""./ G!7778G 555&5<<-  K';///';/////rJc,tttdddi|}tt|dgdi}t gdgd d t d d gd}t j||t j||dS) N .//doc:rowdocrrrzrrmrrrrr)rrxml_prefix_nmspr[rrr7rprs r=test_prefix_namespacerys!!/0 G !5:W:W:W2XG555&5<<-  K';///';/////rJctjdtttdddid}tttdddid}t j||dS) Nr1rrrrrrrL)r5r6rrr:r7rpdf_lxmldf_etrees r="test_consistency_default_namespacers !""./ G!""/0 H'8,,,,,rJctjdtttdddid}tttdddid}t j||dS)Nr1rrrrrL)r5r6rrrr7rprs r=!test_consistency_prefix_namespacers !!/0 G!!/0 H'8,,,,,rJctjtd5t|d|ddddS#1swxYwYdS)Nrr3z .//Placemarkrr5rrrrqrNs r=*test_missing_prefix_with_default_namespacers z*K M M MAA.@@@@AAAAAAAAAAAAAAAAAArctjtd5t|ddddddS#1swxYwYdS)Nz'you used an undeclared namespace prefixr3.//kml:PlacemarkrLrr)kml_cta_rail_liness r=$test_missing_prefix_definition_etreers {+T V V VOO#+=gNNNNOOOOOOOOOOOOOOOOOOrctjd}tj|jd5t |ddddddS#1swxYwYdS)NrzUndefined namespace prefixr3rr1rr)rrs r=#test_missing_prefix_definition_lxmlr s$\22J z09U W W WNN#+=fMMMMNNNNNNNNNNNNNNNNNNrkeyctjdtjtd5t t t d|didddddS#1swxYwYdS)Nr1z0empty namespace prefix is not supported in XPathr3rhttp://www.opengis.net/kml/2.2r)r5r6r TypeErrorrrr:)r s r=test_none_namespace_prefixrs  L       % & &$=>                       s(A%%A),A)ct||}t||dgdi}tgdgdgdgdgd d}tj||tj||dS) Nrerfrrmrrrrrrrr7rprqrNrrrs r=test_file_elems_and_attrsrsy000GKKKLG 666IIILLL&&&***   K';///';/////rJct|d|}t||ddgi}tdgdi}tj||tj||dS)NT) attrs_onlyrNrfrhrmrrrs r=test_file_only_attrsrsvyT&AAAGyFZL;QRRRGZ)G)G)GHIIK';///';/////rJct|d|}t||dgdi}tgdgdgdgd d}tj||tj||dS) NT) elems_onlyrNrf)rirkrjrlrmrrrrrrs r=test_file_only_elemsrsyT&AAAG???@G IIILLL&&&***   K';///';/////rJctjtd5t|dd|ddddS#1swxYwYdS)Nz3Either element or attributes can be parsed not bothr3T)rrrNr)rrNs r=test_elem_and_attrs_onlyr s D   VV #fUUUU VVVVVVVVVVVVVVVVVVs=AAcd}tjtd5tt |dd|ddddS#1swxYwYdS)NaU square 360 circle 360 triangle 180 -xpath does not return any nodes or attributesr3./rowT)rrrNr5rrrrrNrs r=test_empty_attrs_onlyr s C >   OO #g$vNNNN OOOOOOOOOOOOOOOOOO!A  AAcd}tjtd5tt |dd|ddddS#1swxYwYdS)Nz rr3rT)rrrNrrs r=test_empty_elems_onlyr#-s C >   OO #g$vNNNN OOOOOOOOOOOOOOOOOOr!cVtjdd}tt|d}tt|dd}t |ddd gi }t |dddd gi }t j||t j||dS) Nr1a z .//stationrrLrstationNamecoordsrnrm)r5r6rrr[r7rp)rrr df_iter_lx df_iter_ets r=test_attribute_centric_xmlr+<s  C(x}}L999G \'JJJH#CI?Q3RSSSJ# G FH3E'FJ'8,,,*j11111rJct|gd|}t||gddgdi}tgdgdgdgd gd d}tj||tj||dS) N)Col1Col2Col3Col4Col5namesrNrfr)rNr3rnrrrrrrrs r=test_names_option_outputr4asAAA&G666KKKL G222HHHJJJ&&&)))   K';///';/////rJcd}tt|d|gd}t||dgdigd}tdd gd d gd d gd}t j||t j||dS) Nz circle curved sphere curved .//shape)type_dimr type_edgerrNr3r)typer+r:rNrnr32D3Drspherecurvedrrs r=test_repeat_namesr@zs C 000 H! 4445000 Gt )"H-  K(K000';/////rJcd}tt|d|ddg}t||dddgiddg}tgd gd d }t j||t j||dS) NaB rectangle rectangle square rectangle ellipse ellipse circle ellipse r6r+groupr9rfamilyr;) rectanglerellipser)rDrDrErE)r+rBrrs r=test_repeat_values_new_namesrFs C& Zvw>OH! VX./w G@@@EEE  K(K000';/////rJc d}tt|d|gd}t||dgdigd}tgdgd gd gd d}t j||t j||dS) Na circle ellipse 360 0 triangle polygon 180 3 square polygon 360 4 r6)r+rCrrr9r)valuerHrHrHr;)rrr)rEpolygonrI)rrr)rrrrrs r=test_repeat_elementsrJs C* 444 H! @@@A444 G444777&YY   K(K000';/////rJctjtd5t|gd|ddddS#1swxYwYdS)Nznames does not match lengthr3)r-r.r/r2rrs r=test_names_option_wrong_lengthrLs z*G I I IKK":":":6JJJJKKKKKKKKKKKKKKKKKK>AActjtd5t|d|ddddS#1swxYwYdS)Nzis not a valid type for namesr3zCol1, Col2, Col3r2r5rr rrs r=test_names_option_wrong_typerPs y)H J J JEE"4VDDDDEEEEEEEEEEEEEEEEEErctjtd5t||ddddS#1swxYwYdS)Nz'utf-8' codec can't decoder3rer5rUnicodeDecodeErrorrxml_baby_namesrNs r=test_wrong_encodingrVs )2N P P P00////000000000000000000 ;??ctjtd5t|d|ddddS#1swxYwYdS)NzLUTF-16 stream does not start with BOM|'utf-16(-le)?' codec can't decode byter3zUTF-16rSrN)r5r UnicodeErrorrrTs r=test_utf16_encodingr[ s  5   CC (6BBBBCCCCCCCCCCCCCCCCCCrctjtd5t|d|ddddS#1swxYwYdS)Nzunknown encoding: UFT-8r3zUFT-8rY)r5r LookupErrorrrTs r=test_unknown_encodingr^s {+D F F FBB'&AAAABBBBBBBBBBBBBBBBBBrctjtd5t|d|ddddS#1swxYwYdS)Nz'ascii' codec can't decode byter3asciirYrRrTs r=test_ascii_encodingras )2S U U UBB'&AAAABBBBBBBBBBBBBBBBBBrcPtjdt|dd}t|dd}t|dddgdi}t|dddgdi}tj||tj||tj||dS) Nr1z ISO-8859-1rNrSrLz iso-8859-1rz)rankmalename femalename)rNrSrnro)rU df_xpath_lxmldf_xpath_etreertrus r=%test_parser_consistency_with_encodingri"s ^F\RRRMnW|TTTN<<<= L <<<= M-888.-888, 66666rJctjdd}tjtd5t t |ddddddS#1swxYwYdS)Nr1- c z encoding Noner3rc)r5r6rr rr)rWs r=test_wrong_encoding_for_lxmlrl9s  D y 8 8 8??$>>>>??????????????????s AA#&A#cd}tt|dd}tddgi}tj||dS)NrkrLrcrcr)rWresultexpecteds r=test_none_encoding_etreerqFsQ D htnnWt D D DF#u&&H&(+++++rJctjtd5t|ddddS#1swxYwYdS)Nz7lxml not found, please install or use the etree parser.r3)r5r ImportErrorrrs r=test_default_parser_no_lxmlrtVs U    s 9==ctjtd5t|dddddS#1swxYwYdS)Nz,Values for parser can only be lxml or etree.r3bs4rerrs r=test_wrong_parserrw^s I   ** 5))))******************rWctjdt|dddi|}t|dgdi}tjt |tjt |dS) Nr1.//k:Placemarkkr rr stylesheet Placemarkr)r()r5r6rr7rpdf_kml)rxsl_flatten_docdf_stylers r=test_stylesheet_filerhs 9:" H      G&(+++&'*****rJctjdt|||dkrdnd5}t|dddi|}dddn #1swxYwYt jt |dS Nr1r@rQrRryrzr r{)r5r6rUrr7rpr~)rrrHrZrs r=test_stylesheet_file_likers  otgg$ O O O ST "=>                   &(+++++sAAActjdt|||dkrdnd5}|dkr"t|}n!t |}dddn #1swxYwYt |dddi| }tjt|dS) Nr1r@rQrRr?ryrzr r{) r5r6rUrr_rrr7rpr~rrrHrZxsl_objrs r=test_stylesheet_iors  otgg$ O O O)ST 4<<affhh''GGqvvxx((G ))))))))))))))) 9: H&(+++++sA BB  B ctjdt|||dkrdnd5}|}dddn #1swxYwYt |dddi|}t jt|dSr)r5r6rUr_rr7rpr~rs r=test_stylesheet_buffered_readerrs  otgg$ O O OST&&((9: H&(+++++sAAActjdd}d}tt|}tt||}t j||dS)Nr1ru <根> r|)r5r6rrr7rp)rxsldf_origrs r=test_style_charsetrse  HC C&x}}%%G #666H'8,,,,,rJctjd}tj|jd5t ||ddddS#1swxYwYdS)Nrzdocument is not a stylesheetr3rr5r6rXSLTParseErrorr)rrqrs r=test_not_stylesheetrs$\22J !*H   ;; # ::::;;;;;;;;;;;;;;;;;;sAAActjd}d}tj|jd5t ||ddddS#1swxYwYdS)Nra z(Extra content at the end of the documentr3rr5r6rrrrrrs r=test_incorrect_xsl_syntaxrs$\22J C( !*T   55 #4444555555555555555555AAActjd}d}tj|jd5t ||ddddS#1swxYwYdS)Nra zfailed to compiler3rrrs r=test_incorrect_xsl_evalrs$\22J C( z09L N N N55#4444555555555555555555rctjd}d}tj|jd5t ||ddddS#1swxYwYdS)Nrag zCannot resolve URIr3r)r5r6rXSLTApplyErrorrrs r=test_incorrect_xsl_applyrs$\22J C z09M O O O55#4444555555555555555555rctjd}|dz }tj|jd5t ||ddddS#1swxYwYdS)Nrz flatten.xslz!Start tag expected, '<' not foundr3rr)r xml_data_path xml_etreers r=test_wrong_stylesheetr&s#L11I - 'C  2   55 #4444 555555555555555555sAAAc\tjdt|||dkrdnd5}|dkr"t|}n!t |}t |||jrJ ddddS#1swxYwYdS)Nr1r@rQrRr?r)r5r6rUrr_rrr)rrrHrZrs r=test_stylesheet_file_closer2s  otgg$ O O OST 4<<affhh''GGqvvxx((G#88888sA$B!!B%(B%ctjdtjtd5t |d|ddddS#1swxYwYdS)Nr1z*To use stylesheet, you need lxml installedr3rL)rNr|r)rrs r=test_stylesheet_with_etreerCs  G   QQ #GPPPPQQQQQQQQQQQQQQQQQQrctjdd}tjddd}tjt |5t||ddddS#1swxYwYdS)Nr1r2rWrzcta_rail_lines.kmlr3r)r5r6rrYrrr9r)rr<kmls r=test_empty_stylesheetrKs  : ',,vu&: ; ;C }C 0 0 0&&%%%%&&&&&&&&&&&&&&&&&&sA22A69A6c t|||dkrdnd5}|dkr]|dkrWtjtd5t ||dgdi dddn #1swxYwY ddddSt ||dgdi } dddn #1swxYwYt gd gd gd gd gdd}t j||dSNr@rQrRr1z.reading file objects must return bytes objectsr3rfrgrmrrrrrr)rUr5rr rrr7rp)rqrNrHrZ df_filelikers r=test_file_like_iterparserZs i43;;D I I IQ 3;;6V++"R  ! P P P               #!#S#S#STKK(666IIILLL&&&***   K+{33333s;(B"A& B"&A* *B"-A* .B"?B""B&)B&c n|dkrtnt}t|||dkrdnd5}||5}|dkrh|dkrbt jt d5t||dgdi dddn #1swxYwY dddddddSt||dgdi } dddn #1swxYwYdddn #1swxYwYtgd gd gd gd gdd}tj ||dSr) rrrUr_r5rr rrr7rp)rqrNrHfuncIOrZb df_fileiors r=test_file_io_iterparser|sXX'F   CKKT    VAFFHH   s{{v//]&V  %"$T$T$T#                      &%! P P P                 6666IIILLL&&&***   K)[11111seC6 (C5B CB CB C$ C6<C C6C# #C6&C# 'C66C:=C:c Ft|d5}||tjt d5t |j|dgdidddn #1swxYwYddddS#1swxYwYdS) NrQrRrx)iterparse is designed for large XML filesr3rzrrrdaterm)rUr{r_r5rr rr)rNr}rrZs r=test_url_path_errorrs9 h ) ) ) Q   222 ]  K       "G"G"GH                                     s6ABA>2 B>B BB BBBc 0tjd5}t|||t jt d5t||dgdi|dddn #1swxYwYddddS#1swxYwYdS) Nz geom_xml.ziprrNr]rr3rzrrNrnr])r7rTgeom_dfto_xmlr5rr r)rNrarYs r=test_compression_errorrs2 . 1 1 1 TtF8HIII ]  K       "G"G"GH,                                      s59B A3' B 3A7 7B :A7 ;B  BBctjtd5t||gdddddS#1swxYwYdS)Nz&list is not a valid type for iterparser3rgrmrOrs r=test_wrong_dict_typers y(P Q Q Q   FFF                      rMctjtd5t||ddiddddS#1swxYwYdS)Nz8 is not a valid type for value in iterparser3rfrhrmrOrs r=test_wrong_dict_valuers S   KK 6fj5IJJJJKKKKKKKKKKKKKKKKKKrMc zd}tjd5}t|dd5}||dddn #1swxYwYt jt d5t||d gd gd i dddn #1swxYwYddddS#1swxYwYdS) Na square 00360 4.0 2020-01-01 circle 00360 2021-01-01 triangle 00180 3.0 2022-01-01 zbad.xmlrrPrQrRzDExtra content at the end of the document|junk after document elementr3rrzr)rN parse_datesrn)r7rTrUrVr5rrr)rNbad_xmlrYrZs r= test_bad_xmlrsG* ) , , , $g . . . ! GGG                  ] .     #H "G"G"GH                     sXB0A  B0 A B0A B03B B0B B0B B00B47B4cd}tt|d|}t||dddgi}tdd gd d gd }t j||t j||dS) Na- circle 2D sphere 3D r6rrr+r:rmrr>r<r=r+r:rrs r= test_commentrs C" ZGGGH  Fw0@&AGx(4L  K(K000';/////rJcd}tt|d|}t||dddgi}tdd gd d gd }t j||t j||dS) Na8 ]> circle 2D sphere 3D r6rrr+r:rmrr>r<r=rrrs r=test_dtdr  C$ ZGGGH  Fw0@&AGx(4L  K(K000';/////rJcd}tt|d|}t||dddgi}tdd gd d gd }t j||t j||dS) Nam , , ?> circle 2D sphere 3D r6rrr+r:rmrr>r<r=rrrs r=test_processing_instructionrDrrJctjtd5t||dgdiddddS#1swxYwYdS)Nz+No result from selected items in iterparse.r3nodeattr1elem1elem2elem3rm)r5rr rrs r=test_no_resultrhs H       CCCD                      AAActjtd5t||dgdiddddS#1swxYwYdS)NzNo columns to parse from filer3rfrrm)r5rr rrs r=test_empty_datarss ~-L M M M   CCCD                      rc tjdd}d}tt|dddg|}t dd d d d d dddddd d}t j||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]riartist)rr3r|zEmpire BurlesquezHide your heartz Greatest HitszStill got the bluesErosr%z Bob Dylanz Bonnie Tylerz Dolly Partonz Gary MoorezEros Ramazzotti)rir)r5r6rrrr7rp)rrdf_xslrs r=test_online_stylesheetr|s T Cj C2 -! F&$"( !!$   K&+v.....rJc Ttj5}t|d||t |||}t |||dgdi|}dddn #1swxYwYtj|ttj|tdS)NF)rrNr]rrzrr)r7rTrrrrcrp)rNrar`r~rs r=test_compression_readrs     i U6?O    IfBRSSS)  ;;;<(                    (G,,,'7+++++sA A))A-0A-c6|}|}||krtj|d|tdftdftdftdfd}t dd }| |jd f|d <t d d }| td f|d<||\}} tj 5} t | ||tj || 5t| ||dddn #1swxYwYddddS#1swxYwYdS)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 decoderxzrr3)r5skipOSErrorr rr ZstdErrorrr7rTrrrr) rNr]raactual_compressionattempted_compressionrrr error_cls error_strrYs r=test_wrong_compressionrs$,222 )FF/DFFGGG././45BC F &k( C C CD .*DEv %fX > > >D !#JKt !"78Iy   MdtF8JKKK ]9I 6 6 6 M M T&6K L L L L M M M M M M M M M M M M M M MMMMMMMMMMMMMMMMMMMs6#4DC6* D6C: :D=C: >DDDctjtd5tj5}t ||ddddn #1swxYwYddddS#1swxYwYdS)NzUnrecognized compression typer37zr)r5rrr7rTr)rNrYs r=test_unsuported_compressionrs z)H I I I<< _   <$ T&d ; ; ; ; < < < < < < < < < < < < < < <<<<<<<<<<<<<<<<<< x 1 4.0 x 2 4.0 True False y 2 5.0 False zmode.string_storage)rN dtype_backendpyarrowxyrr&r'Int64rg@Float64TFboolean) rrrnderZghir)ArrowExtensionArrayc ^i|])}||d*S)T) from_pandas)array).0colr rppas r= z1test_read_xml_nullable_dtypes.. sK   (((3-T)R)RSS   rJr)check_column_type)pdoption_contextrrr5r6 ArrowDtyper StringDtyperrr pandas.arraysr columnsr r7rp) rNstring_storagerusing_infer_stringrWro string_dtyper rprs @@@r=test_read_xml_nullable_dtypesrsk D4 0. A AVV(4..}UUUVVVVVVVVVVVVVVV !!   + +}RYY[[11 ~n55 c ,777Ag...c )444d <888Bw///b 333R000u Y777 9555   H !!   + +555555      #+      ,+BHHdD\,B,BCC &(eDDDDDDs AA A cd}tjt|5tddddddS#1swxYwYdS)NzPdtype_backend numpy is invalid, only 'numpy_nullable' and 'pyarrow' are allowed.r3testnumpy)rrr;s r=test_invalid_dtype_backendr s ! z - - -00w////000000000000000000s=AA) __future__riorrrrrtarfiler urllib.errorrxml.etree.ElementTreer zipfiler rnpr5pandas.compat._optionalr pandas.errorsr r pandas.util._test_decoratorsutil_test_decoratorstdpandasrrrrpandas._testing_testingr7pandas.io.commonr pandas.io.xmlrrrr:rr~r>fixturerHrE skip_if_norNr[rcrvmarknetwork single_cpurrrrrrrr parametrizerrrrrrrrrrrrrrrr rrrrrr r#r+r4r@rFrJrLrPrVr[r^rarirlrqskip_if_installedrtrwrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr rJr=r;s """""" """""",,,,,, >>>>>>*)))))))) ''''''""""""l )111"??RVQ   (*    )!!!!      Q1q11       999&9$ 9uI I =hhj j Z # # #c{###$#  V=2=3H3HIII7STTTUT(((,,,777* - - -000"...,///0///2///000>S **22+*2"S **33+*3 * * *///&MMM.0.0.0h>>> ???>>>0004000.---&---,AAA OOO NNNT ++   ,+  000*000000(VVVOOO0 O O O222J0002#0#0#0L'0'0'0T.0.0.0bKKK EEE000 CCCBBB BBB 777. ? ? ? , , , f***+++6 , , ,,,,, , , ,---:;;;555:5556555& 5 5 5"QQQS ** & &+* &444D'2'2'2T         KKK&&&R 0 0 0F!0!0!0H!0!0!0H      J/J/J/`,,,(MMM8<<< - - -CECECEL00000rJ