!hF ddlmZddlmZmZddlmZddlZddlm Z ddl m Z ddl m Z ddlmZddlZddlZdd lmZdd lmZmZddlmcmZddlZdd lmZmZm Z ddl!m"Z#dd l$m%Z%m&Z&dd l'm(Z(ddl)m*Z*ddl+m,Z,egdgddej-dgdZ.dZ/dZ0eddddddddddddddddddddddddd d d d d dd!d"d#d$d%dd&Z1d'Z2ej3d(d)g*d+Z4ej3ej5d,ej6d,-d.g*d/Z7d0Z8d1Z9d2Z:ej;j<ej;j=d3Z>d4Z?d5Z@d6ZAd7ZBd8ZCd9ZDd:ZEej;Fd;dZGej;Fd;d 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 Vc:\xampp_lite_8_4\www\timesheet\venv\Lib\site-packages\pandas/tests/io/xml/test_xml.pytest_literal_xml_deprecationrAs  : #M = = =##!"""##################sAAArbr)paramsc|jSNparamrequests r@moderK =r4)marksetreec|jSrFrGrIs r@parserrQ rLrMc tj5}t|dd5}||dddn #1swxYwYt |fi|cdddS#1swxYwYdS)Nwutf-8encoding)r: 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)NrC) compressionrSrTrU)rr:rWrXrYhandlereadr) comp_pathcompression_onlyr[handlesr\r]s r@read_xml_iterparse_comprfs 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)Nr4rQrObookcategorytitleyearauthorpricerQ iterparser8r9rr:assert_frame_equal) xml_books df_file_lxml df_file_etree df_iter_lxml df_iter_etrees r@test_parser_consistency_filery#s If555LYw777MKKKLL KKKLM , 666, 555, 66666rMc |tttt|}tt t|dgdi}t j||dS)Ncontentrhrowrrp) serve_contentr=rrrencoder:rs)rQ httpserverdf_xpathdf_iters r@test_parser_consistency_urlr8s%5666!1226BBBH ''))**7778G (G,,,,,rMct|||dkrdnd5}t||}dddn #1swxYwYtgdgdgdgdgd d }tj||dS NrCrTrUrhcookingchildrenwebzEveryday Italianz Harry Potterz Learning XMLzGiada De Laurentiisz J K. Rowlingz Erik T. Rayrig>@g= ףp=@gC@rkrlrnrmro)rXrrr:rs)rtrQrKr]df_file df_expecteds r@test_file_likerGs i43;;D I I I-Q1V,,,---------------666IIILLL&&&***   K';/////s 9==c~t|||dkrdnd5}|}dddn #1swxYwYtt|trt |nt ||}tgdgdgdgdgd d }tj ||dSr) rXrbr isinstancebytesrrrr:rs)rtrQrKr]xml_objdf_iors r@ test_file_iorXs% 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 NrCrTrUrBrhrrrrrr)rXrbrdecoderrr:rsrtrQrKr]rdf_strrs r@ test_file_buffered_reader_stringrns/ 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) rXnextrbrrrrr:rsrs 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<<中文標籤>12rhr)r*)c1c2r)indexrrrr:rs)rQtxtrrs r@test_string_charsetrsT HC hsmmF 3 3 3F1A..qc:::K&+.....rMct||}tgddddgddggdd}tj||dS) Nrh)uP問 若箇是邪而言破邪 何者是正而道(Sorry, this is Big5 only)申正u;問 既破有得申無得 亦應但破性執申假名以不uO問 既破性申假 亦應但破有申無 若有無兩洗 亦應性假雙破耶u<答 邪既無量 正亦多途 大略為言不出二種 謂u;有得與無得 有得是邪須破 無得是正須申 故uL答 不例 有無皆是性 所以須雙破 既分性假異 故有破不破)NuV答 性執是有得 假名是無得 今破有得申無得 即是破性執申假名也N)u問u答a)rrjoinr:rs)xml_doc_ch_utfrQrrs r@test_file_charsetrs~f555G VX ^ !  K2';/////rMct|d5}tt|||jrJ ddddS#1swxYwYdS)NrBrh)rXrrrbclosed)rtrQr]s r@test_file_handle_closers i  !""622228|s:AA AvalrrMchtjd}dddg}tj|j|5t |t rtt|dntt|dddddS#1swxYwYdS)N lxml.etree|zDocument is emptyzNone \(line 0\)r6r4rh) r8r9rraisesXMLSyntaxErrorrstrrrr)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 foundr6rOrh)r8rr 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)Nr5rZhtmlz books.xmlr6rh)osr\rr8rr<r)rQr?filenames r@test_wrong_file_pathrs : w||FFK88H    ** &)))) ******************sAA"%A"cdtjdt|d5}||t |jd}dddn #1swxYwYtgdgdgd gd gd d }tj ||dS) Nr4rTrUr{.//book[count(*)=4]xpathrrrrrr) r8r9rXr~rbrurlrr:rs)rxml_filer]df_urlrs r@test_urlrs!  h ) ) )GQ   222*.0EFFFGGGGGGGGGGGGGGG666IIILLL&&&***   K&+.....s?A11A58A5c|ddtjtd5t |jd|ddddS#1swxYwYdS)Nz NOT FOUNDi)codezHTTP Error 404: NOT FOUNDr6rrrQ)r~r8rrrr)rQrs r@test_wrong_urlrs[s333 y)D F F FMM' square 360 circle 360 triangle 180 string)rQdtyper})r"r r!)rQrqr)z 4 z 0 z 3 )z square z circle z" triangle ) 360 rz 180 rrrr^rr:rsrQxmlrrrs r@test_whitespacers C, fHEEEH  7778 G*** 988     K(K000';/////rMctjdtjtd5t |ddddddS#1swxYwYdS)Nr4xpath does not return any nodesr6z .//pythonrr8r9r ValueErrorrrts r@test_empty_xpath_lxmlrMs  z*K M M M>>+f====>>>>>>>>>>>>>>>>>>AAActjtd5t|ddddddS#1swxYwYdS)Nz/You have used an incorrect or unsupported XPathr6 .//[book]rOrr8r SyntaxErrorrrs r@test_bad_xpath_etreerSs M   ?? +g>>>>??????????????????<AActjd}tj|jd5t |ddddddS#1swxYwYdS)NrzInvalid expressionr6rr4rr8r9rXPathEvalErrorr)rtrs r@test_bad_xpath_lxmlrZs$\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 namespacesrQr}rrprr@nan@)rrr=r^rfloatr:rsrQdf_nmsprrs r@test_default_namespacerds!""./ G!7778G 555&5<<-  K';///';/////rMc,tttdddi|}tt|dgdi}t gdgd d t d d gd}t j||t j||dS) N .//doc:rowdocrrr}rrprrrrr)rrxml_prefix_nmspr^rrr:rsrs r@test_prefix_namespacer~s!!/0 G !5:W:W:W2XG555&5<<-  K';///';/////rMctjdtttdddid}tttdddid}t j||dS) Nr4rrrrrrrO)r8r9rrr=r:rsdf_lxmldf_etrees r@"test_consistency_default_namespacers !""./ G!""/0 H'8,,,,,rMctjdtttdddid}tttdddid}t j||dS)Nr4rrrrrO)r8r9rrrr:rsrs r@!test_consistency_prefix_namespacers !!/0 G!!/0 H'8,,,,,rMctjtd5t|d|ddddS#1swxYwYdS)Nrr6z .//Placemarkrr8rrrrtrQs r@*test_missing_prefix_with_default_namespacers z*K M M MAA.@@@@AAAAAAAAAAAAAAAAAArctjtd5t|ddddddS#1swxYwYdS)Nz'you used an undeclared namespace prefixr6.//kml:PlacemarkrOrr)kml_cta_rail_liness r@$test_missing_prefix_definition_etreer s {+T V V VOO#+=gNNNNOOOOOOOOOOOOOOOOOOrctjd}tj|jd5t |ddddddS#1swxYwYdS)NrzUndefined namespace prefixr6rr4rr)r rs r@#test_missing_prefix_definition_lxmlr s$\22J z09U W W WNN#+=fMMMMNNNNNNNNNNNNNNNNNNrkeyctjdtjtd5t t t d|didddddS#1swxYwYdS)Nr4z0empty namespace prefix is not supported in XPathr6rhttp://www.opengis.net/kml/2.2r)r8r9r TypeErrorrrr=)r s r@test_none_namespace_prefixrs  L       % & &$=>                       s(A%%A),A)ct||}t||dgdi}tgdgdgdgdgd d}tj||tj||dS) Nrhrirrprrrrrrrr:rsrtrQrrrs r@test_file_elems_and_attrsrsy000GKKKLG 666IIILLL&&&***   K';///';/////rMct|d|}t||ddgi}tdgdi}tj||tj||dS)NT) attrs_onlyrQrirkrprrrs r@test_file_only_attrsrsvyT&AAAGyFZL;QRRRGZ)G)G)GHIIK';///';/////rMct|d|}t||dgdi}tgdgdgdgd d}tj||tj||dS) NT) elems_onlyrQri)rlrnrmrorprrrrrrs r@test_file_only_elemsrsyT&AAAG???@G IIILLL&&&***   K';///';/////rMctjtd5t|dd|ddddS#1swxYwYdS)Nz3Either element or attributes can be parsed not bothr6T)rrrQr)r rQs r@test_elem_and_attrs_onlyrs D   VV #fUUUU VVVVVVVVVVVVVVVVVVs=AAcd}tjtd5tt |dd|ddddS#1swxYwYdS)NaU square 360 circle 360 triangle 180 -xpath does not return any nodes or attributesr6./rowT)rrrQr8rrrrrQrs r@test_empty_attrs_onlyr#s C >   OO #g$vNNNN OOOOOOOOOOOOOOOOOO!A  AAcd}tjtd5tt |dd|ddddS#1swxYwYdS)Nz rr6r T)rrrQr!r"s r@test_empty_elems_onlyr&2s C >   OO #g$vNNNN OOOOOOOOOOOOOOOOOOr$cVtjdd}tt|d}tt|dd}t |ddd gi }t |dddd gi }t j||t j||dS) Nr4a z .//stationrrOrstationNamecoordsrqrp)r8r9rrr^r:rs)rrr df_iter_lx df_iter_ets r@test_attribute_centric_xmlr.As  C(x}}L999G \'JJJH#CI?Q3RSSSJ# G FH3E'FJ'8,,,*j11111rMct|gd|}t||gddgdi}tgdgdgdgd gd d}tj||tj||dS) N)Col1Col2Col3Col4Col5namesrQrir)rQr6rqrrrrrrrs r@test_names_option_outputr7fsAAA&G666KKKL G222HHHJJJ&&&)))   K';///';/////rMcd}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_edgerrQr6r )typer.r=rQrqr62D3Drspherecurvedrrs r@test_repeat_namesrCs C 000 H! 4445000 Gt )"H-  K(K000';/////rMcd}tt|d|ddg}t||dddgiddg}tgd gd d }t j||t j||dS) NaB rectangle rectangle square rectangle ellipse ellipse circle ellipse r9r.groupr<r familyr>) rectanglerellipser)rGrGrHrH)r.rErrs r@test_repeat_values_new_namesrIs C& Zvw>OH! VX./w G@@@EEE  K(K000';/////rMc 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 r9)r.rFr!r"r<r )valuerKrKrKr>)rrr)rHpolygonrL)rrr)rrrrrs r@test_repeat_elementsrMs C* 444 H! @@@A444 G444777&YY   K(K000';/////rMctjtd5t|gd|ddddS#1swxYwYdS)Nznames does not match lengthr6)r0r1r2r5rrs r@test_names_option_wrong_lengthrOs z*G I I IKK":":":6JJJJKKKKKKKKKKKKKKKKKK>AActjtd5t|d|ddddS#1swxYwYdS)Nzis not a valid type for namesr6zCol1, Col2, Col3r5r8rrrrs r@test_names_option_wrong_typerSs y)H J J JEE"4VDDDDEEEEEEEEEEEEEEEEEErctjtd5t||ddddS#1swxYwYdS)Nz'utf-8' codec can't decoder6rhr8rUnicodeDecodeErrorrxml_baby_namesrQs r@test_wrong_encodingrY s )2N P P P00////000000000000000000 ;??ctjtd5t|d|ddddS#1swxYwYdS)NzIUTF-16 stream does not start with BOM|'utf-16-le' codec can't decode byter6zUTF-16rVrQ)r8r UnicodeErrorrrWs r@test_utf16_encodingr^s  2   CC (6BBBBCCCCCCCCCCCCCCCCCCrctjtd5t|d|ddddS#1swxYwYdS)Nzunknown encoding: UFT-8r6zUFT-8r\)r8r LookupErrorrrWs r@test_unknown_encodingras {+D F F FBB'&AAAABBBBBBBBBBBBBBBBBBrctjtd5t|d|ddddS#1swxYwYdS)Nz'ascii' codec can't decode byter6asciir\rUrWs r@test_ascii_encodingrd"s )2S U U UBB'&AAAABBBBBBBBBBBBBBBBBBrcPtjdt|dd}t|dd}t|dddgdi}t|dddgdi}tj||tj||tj||dS) Nr4z ISO-8859-1rQrVrOz iso-8859-1r})rankmalename femalename)rQrVrqrr)rX df_xpath_lxmldf_xpath_etreerwrxs r@%test_parser_consistency_with_encodingrl's ^F\RRRMnW|TTTN<<<= L <<<= M-888.-888, 66666rMctjdd}tjtd5t t |ddddddS#1swxYwYdS)Nr4- c z encoding Noner6rf)r8r9rrrr)rZs r@test_wrong_encoding_for_lxmlro>s  D y 8 8 8??$>>>>??????????????????s AA#&A#cd}tt|dd}tddgi}tj||dS)NrnrOrfrcr)rZresultexpecteds r@test_none_encoding_etreertKsQ D htnnWt D D DF#u&&H&(+++++rMctjtd5t|ddddS#1swxYwYdS)Nz7lxml not found, please install or use the etree parser.r6)r8r ImportErrorrrs r@test_default_parser_no_lxmlrw[s U    s 9==ctjtd5t|dddddS#1swxYwYdS)Nz,Values for parser can only be lxml or etree.r6bs4rhrrs r@test_wrong_parserrzcs I   ** 5))))******************rZctjdt|dddi|}t|dgdi}tjt |tjt |dS) Nr4.//k:Placemarkkrrr stylesheet Placemarkr,r+)r8r9rr:rsdf_kml)r xsl_flatten_docdf_stylers r@test_stylesheet_filerms 9:" H      G&(+++&'*****rMctjdt|||dkrdnd5}t|dddi|}dddn #1swxYwYt jt |dS Nr4rCrTrUr|r}rr~)r8r9rXrr:rsr)r rrKr]rs r@test_stylesheet_file_likers  otgg$ O O O ST "=>                   &(+++++sAAActjdt|||dkrdnd5}|dkr"t|}n!t |}dddn #1swxYwYt |dddi| }tjt|dS) Nr4rCrTrUrBr|r}rr~) r8r9rXrrbrrr:rsrr rrKr]xsl_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)r8r9rXrbrr:rsrrs r@test_stylesheet_buffered_readerrs  otgg$ O O OST&&((9: H&(+++++sAAActjdd}d}tt|}tt||}t j||dS)Nr4ru <根> r)r8r9rrr:rs)rxsldf_origrs r@test_style_charsetrse  HC C&x}}%%G #666H'8,,,,,rMctjd}tj|jd5t ||ddddS#1swxYwYdS)Nrzdocument is not a stylesheetr6rr8r9rXSLTParseErrorr)r rtrs r@test_not_stylesheetrs$\22J !*H   ;; # ::::;;;;;;;;;;;;;;;;;;sAAActjd}d}tj|jd5t ||ddddS#1swxYwYdS)Nra z(Extra content at the end of the documentr6rr8r9rrrr rrs r@test_incorrect_xsl_syntaxrs$\22J C( !*T   55 #4444555555555555555555AAActjd}d}tj|jd5t ||ddddS#1swxYwYdS)Nra zfailed to compiler6rrrs r@test_incorrect_xsl_evalrs$\22J C( z09L N N N55#4444555555555555555555rctjd}d}tj|jd5t ||ddddS#1swxYwYdS)Nrag zCannot resolve URIr6r)r8r9rXSLTApplyErrorrrs r@test_incorrect_xsl_applyrs$\22J C z09M O O O55#4444555555555555555555rctjd}|dz }tj|jd5t ||ddddS#1swxYwYdS)Nrz flatten.xslz!Start tag expected, '<' not foundr6rr)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)Nr4rCrTrUrBr)r8r9rXrrbrrr)r rrKr]rs r@test_stylesheet_file_closer7s  otgg$ O O OST 4<<affhh''GGqvvxx((G#88888|sA$B!!B%(B%ctjdtjtd5t |d|ddddS#1swxYwYdS)Nr4z*To use stylesheet, you need lxml installedr6rO)rQrr)r rs r@test_stylesheet_with_etreerHs  G   QQ #GPPPPQQQQQQQQQQQQQQQQQQrctjdd}tjddd}tjt |5t||ddddS#1swxYwYdS)Nr4r5rZrzcta_rail_lines.kmlr6r)r8r9rr\rrr<r)rr?kmls r@test_empty_stylesheetrPs  : ',,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||dSNrCrTrUr4z.reading file objects must return bytes objectsr6rirjrprrrrrr)rXr8rrrrr:rs)rtrQrKr] df_filelikers r@test_file_like_iterparser_s 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) rrrXrbr8rrrrr:rs)rtrQrKfuncIOr]b df_fileiors r@test_file_io_iterparsersXX'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) NrTrUr{)iterparse is designed for large XML filesr6r}r r!r"daterp)rXr~rbr8rr rr)rQrrr]s 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.ziprrQr`rr6r}rrQrqr`)r:rWgeom_dfto_xmlr8rr r)rQrdr\s 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 iterparser6rjrprRrs r@test_wrong_dict_typers y(P Q Q Q   FFF                      rPctjtd5t||ddiddddS#1swxYwYdS)Nz8 is not a valid type for value in iterparser6rirkrprRrs r@test_wrong_dict_valuers S   KK 6fj5IJJJJKKKKKKKKKKKKKKKKKKrPc 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.xmlrrSrTrUzDExtra content at the end of the document|junk after document elementr6rr}r)rQ parse_datesrq)r:rWrXrYr8rrr)rQbad_xmlr\r]s 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 r9rr r.r=rprrAr?r@r.r=rrs r@ test_commentrs C" ZGGGH  Fw0@&AGx(4L  K(K000';/////rMcd}tt|d|}t||dddgi}tdd gd d gd }t j||t j||dS) Na8 ]> circle 2D sphere 3D r9rr r.r=rprrAr?r@rrrs r@test_dtdr% C$ ZGGGH  Fw0@&AGx(4L  K(K000';/////rMcd}tt|d|}t||dddgi}tdd gd d gd }t j||t j||dS) Nam , , ?> circle 2D sphere 3D r9rr r.r=rprrAr?r@rrrs r@test_processing_instructionrIrrMctjtd5t||dgdiddddS#1swxYwYdS)Nz+No result from selected items in iterparse.r6nodeattr1elem1elem2elem3rp)r8rr rrs r@test_no_resultrms H       CCCD                      AAActjtd5t||dgdiddddS#1swxYwYdS)NzNo columns to parse from filer6rirrp)r8rr rrs r@test_empty_datarxs ~-L M M M   CCCD                      rc tjdd}d}tt|dddg|}t dd d d d d dddddd d}t j||dS)Nr4a 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]rlartist)rr6rzEmpire BurlesquezHide your heartz Greatest HitszStill got the bluesErosr(z Bob Dylanz Bonnie Tylerz Dolly Partonz Gary MoorezEros Ramazzotti)rlr)r8r9rrrr:rs)rrdf_xslrs r@test_online_stylesheetrs T Cj C2 -! F&$"( !!$   K&+v.....rMc Ttj5}t|d||t |||}t |||dgdi|}dddn #1swxYwYtj|ttj|tdS)NF)rrQr`rr}rr)r:rWrrrrfrs)rQrdrcrrs 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 decoderxzrr6)r8skipOSErrorr rr ZstdErrorrr:rWrrrr) rQr`rdactual_compressionattempted_compressionrrr error_cls error_strr\s 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 typer67zr)r8rrr:rWr)rQr\s 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 pyarrowxypythonrr)ArrowExtensionArrayzmode.string_storage)rQ dtype_backendr)r*Int64rg@Float64TFboolean) rrrqder]ghic ^i|])}||d*S)T) from_pandas)array).0colrrspas r@ z1test_read_xml_nullable_dtypes..!sK   (((3-T)R)RSS   rMr )r8r9rrrnpobject_r pandas.arraysrrpdoption_contextrrrrcolumnsr:rs) rQstring_storagerusing_infer_stringrZ string_arraystring_array_narrrrsrs @@@r@test_read_xml_nullable_dtypesr s` D4B   + +5bhhSz6J6JKK 83+9N9NOO 8 # #"28S#Jbj#I#I#IJJ %bhRy &K&K&KLL ) # #   + +555555**288S#J+?+?@@ --bhhT{.C.CDD  + +'#s(<(<== *288S$K+@+@AA 0. A AVV(4..}UUUVVVVVVVVVVVVVVVAg...c )444 Bw///b 333R000u Y777 9555   H !!   + +555555      #+      ,+BHHdD\,B,BCC &(+++++s" GGGcd}tjt|5tddddddS#1swxYwYdS)NzPdtype_backend numpy is invalid, only 'numpy_nullable' and 'pyarrow' are allowed.r6testnumpy)rrr>s r@test_invalid_dtype_backendr$+s ! z - - -00w////000000000000000000s=AA) __future__riorrrrrtarfiler urllib.errorrxml.etree.ElementTreer zipfiler r#rr8pandas.compat._optionalr pandas.errorsr r pandas.util._test_decoratorsutil_test_decoratorstdpandasrrrrpandas._testing_testingr:pandas.core.arraysrrpandas.core.arrays.string_arrowrpandas.io.commonr pandas.io.xmlrrrr=rrrAfixturerKrH skip_if_norQr^rfrymarknetwork single_cpurrrrrrrr parametrizerrrrrrrrrrrrrrr r rrrrrr#r&r.r7rCrIrMrOrSrYr^rardrlrortskip_if_installedrwrzrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr r$rMr@r@s """""" """""",,,,,, >>>>>>*)))))))) KJJJJJ''''''""""""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<<< - - -P,P,P,f00000rM