ttj bddlmZddlmZmZddlmZddlZddlm Z ddl m Z ddl m Z ddlmZddlZddlZdd lmZdd lmZdd lmZmZddlmcmZddlZdd lm Z m!Z!m"Z"ddl#m$Z%dd l&m'Z'ddl(m)Z)e!gdgddej*dgdZ+dZ,dZ-e!ddddddddddddddddddddddddddddddd d!d"d#d$dd%e.d&'Z/d(Z0ej1d)d*g+d,Z2ej1ej3d-ej4d-.d/g+d0Z5d1Z6d2Z7d3Z8ej9j:ej9j;d4Zd7Z?d8Z@d9ZAd:ZBd;ZCej9Ddgd?ZEej9Ddgd@ZFej9GedABdCZHej9j:ej9j;dDZIej9j:ej9j;dEZJdFZKdGZLdHZMdIZNdJZOdKZPdLZQdMZRdNZSdOZTdPZUej9DdQd=dgdRZVdSZWdTZXdUZYdVZZdWZ[dXZ\dYZ]dZZ^d[Z_d\Z`d]Zad^Zbd_Zcd`ZddaZedbZfdcZgddZhdeZidfZjejkd-dgZldhZmdiZndjZodkZpdlZqdmZrdnZsdoZtdpZudqZvdrZwdsZxdtZyej9Dd<ed=ed>gduZzdvZ{dwZ|ej9j:ej9j;dxZ}dyZ~dzZd{Zd|Zd}Zd~ZdZdZdZdZdZdZdZej9j:ej9j;dZdZdZdS)) annotations)BytesIOStringIO) LZMAErrorN) ReadError) HTTPError) ParseError) BadZipFile)WASM)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 coordinatesindexctjddddg}tjtt f|5t tddddS#1swxYwYdS)Nlxml|z.*No such file or directoryz.*Invalid argumentmatch)pytest importorskipjoinraisesFileNotFoundErrorOSErrorrxml_default_nmspmsgs Z/var/www/html/CA-Chatbot/venv/lib/python3.11/site-packages/pandas/tests/io/xml/test_xml.pytest_literal_xml_raisesrCs  ((24IJ K KC )733 ? ? ?##!"""##################sA00A47A4rbr)paramsc|jSNparamrequests rBmoderM =r5)marksetreec|jSrHrIrKs rBparserrSrNrOc J||dt|fi|S)Nutf-8encoding) write_textr)data temp_pathkwargss rBread_xml_iterparser\ s1 000 I ( ( ( ((rOc t|d|5}||jdt |fi|cdddS#1swxYwYdS)NrE) compressionrUrV)rrXhandlereadr) comp_pathcompression_onlyrZr[handless rBread_xml_iterparse_comprds Is0@ A A A-WW^0022WEEE ,,V,,------------------s;AA"AcHtjdt|d}t|d}t|ddgdi}t|ddgdi}tj||tj||tj||dS)Nr5rSrQbookcategorytitleyearauthorpricerS iterparser9r:rtmassert_frame_equal) xml_books df_file_lxml df_file_etree df_iter_lxml df_iter_etrees rBtest_parser_consistency_filerxs If555LYw777MKKKLL KKKLM , 666, 555, 66666rOc |tttt|}tt t|dgdi}t j||dS)Ncontentrfrowrrn) serve_contentr?rrrencoderqrr)rS httpserverdf_xpathdf_iters rBtest_parser_consistency_urlr-s%5666!1226BBBH ''))**7778G (G,,,,,rOct|||dkrdnd5}t||}dddn #1swxYwYtgdgdgdgdgd d }tj||dS NrErUrVrfcookingchildrenwebzEveryday Italianz Harry Potterz Learning XMLzGiada De Laurentiisz J K. Rowlingz Erik T. Rayrig>@g= ףp=@gC@rirjrlrkrm)openrrrqrr)rsrSrMfdf_file df_expecteds rBtest_file_liker<s i43;;D I I I-Q1V,,,---------------666IIILLL&&&***   K';/////s 9==c~t|||dkrdnd5}|}dddn #1swxYwYtt|trt |nt ||}tgdgdgdgdgd d }tj ||dSr) rr`r isinstancebytesrrrrqrr)rsrSrMrxml_objdf_iors rB test_file_iorMs% 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 NrErUrVrDrfrrrrrr)rr`rdecoderrrqrrrsrSrMrrdf_strrs rB test_file_buffered_reader_stringrcs/ 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) rnextr`rrrrrqrrrs rB,test_file_buffered_reader_no_xml_declarationr{s: i43;;D I I IQ Q&&(( t||7>>++,, 7## gf - - -F666IIILLL&&&***   K&+.....s$A  AAcd}tt||}tdddtd}t j||dS)N<<中文標籤>12rfr'r()c1c2r2)rrrrangerqrr)rStxtrrs rBtest_string_charsetrsX HC hsmmF 3 3 3F1A..eAhh???K&+.....rOct||}tgddddgddggdd}tj||dS) Nrf)uP問 若箇是邪而言破邪 何者是正而道(Sorry, this is Big5 only)申正u;問 既破有得申無得 亦應但破性執申假名以不uO問 既破性申假 亦應但破有申無 若有無兩洗 亦應性假雙破耶u<答 邪既無量 正亦多途 大略為言不出二種 謂u;有得與無得 有得是邪須破 無得是正須申 故uL答 不例 有無皆是性 所以須雙破 既分性假異 故有破不破)NuV答 性執是有得 假名是無得 今破有得申無得 即是破性執申假名也N)u問u答a)rrr;rqrr)xml_doc_ch_utfrSrrs rBtest_file_charsetrs~f555G VX ^ !  K2';/////rOct|d5}tt|||jrJ ddddS#1swxYwYdS)NrDrf)rrrr`closed)rsrSrs rBtest_file_handle_closers i  !""622228|s:AA AvalrrOcNtjd}dddg}t|trt |}nt |}tj|j|5t|dddddS#1swxYwYdS)N lxml.etreer6zDocument is emptyzNone \(line 0\)r7r5rf) r9r:r;rstrrrr<XMLSyntaxErrorr)r lxml_etreerArYs rBtest_empty_string_lxmlrs$\22J ((     C#s}}s|| z0 < < <&&f%%%%&&&&&&&&&&&&&&&&&&s;BB!Bct|trt|}nt|}t jt d5t|dddddS#1swxYwYdS)Nzno element foundr7rQrf)rrrrr9r<r r)rrYs rBtest_empty_string_etreers#s}}s|| z); < < <''g&&&&''''''''''''''''''sA//A36A3z"limited file system access on WASM)reasonctjdddd}tjt d5t ||ddddS#1swxYwYdS)Ndoesnotexistz books.xml%\[Errno 2\] No such file or directoryr7rf)ospathr;r9r<r=r)rSfilenames rBtest_wrong_file_pathrsw||FE7K@@H !I   ** &))))******************sAA!$A!cdtjdt|d5}||t |jd}dddn #1swxYwYtgdgdgd gd gd d }tj ||dS) Nr5rUrVrz.//book[count(*)=4]xpathrrrrrr) r9r:rr}r`rurlrrqrr)rxml_filerdf_urlrs rBtest_urlrs!  h ) ) )GQ   222*.0EFFFGGGGGGGGGGGGGGG666IIILLL&&&***   K&+.....s?A11A58A5c|dd tjtd5}t |jd|dddn #1swxYwYt |jtr|jdSdS#t |jtr|jwwxYw)Nz NOT FOUNDi)codezHTTP Error 404: NOT FOUNDr7rrrS) r}r9r<rrrrvalueclose)rSrerrs rBtest_wrong_urlrs[s333 ]9-H J J J Qc Z^+@ P P P P Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q ci + +  IOO       :ci + +  IOO     s.BA BABA B6Ccd}tt||d}t|||dgdid}tgdgdgd dd }t j||t j||dS) Na square 360 circle 360 triangle 180 string)rSdtyper|)r rr)rSror)z 4 z 0 z 3 )z square z circle z" triangle ) 360 rz 180 rrrr\rrqrrrS temp_filexmlrrrs rBtest_whitespacers C, fHEEEH  7778 G*** 988     K(K000';/////rOctjdtjtd5t |ddddddS#1swxYwYdS)Nr5xpath does not return any nodesr7z .//pythonrr9r:r< ValueErrorrrss rBtest_empty_xpath_lxmlrFs  z*K M M M>>+f====>>>>>>>>>>>>>>>>>>AAActjtd5t|ddddddS#1swxYwYdS)Nz/You have used an incorrect or unsupported XPathr7 .//[book]rQrr9r< SyntaxErrorrrs rBtest_bad_xpath_etreerLs M   ?? +g>>>>??????????????????<AActjd}tj|jd5t |ddddddS#1swxYwYdS)NrzInvalid expressionr7rr5rr9r:r<XPathEvalErrorr)rsrs rBtest_bad_xpath_lxmlrSs$\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 namespacesrSr|rrnrr@nan@)rrr?r\rfloatrqrrrSrdf_nmsprrs rBtest_default_namespacer]s!""./ G!7778 G555&5<<-  K';///';/////rOc.tttdddi|}tt||dgdi}t gdgd d t d d gd}t j||t j||dS) N .//doc:rowdocrrr|rrnrrrrr)rrxml_prefix_nmspr\rrrqrrrs rBtest_prefix_namespacerxs!!/0 G !7778 G555&5<<-  K';///';/////rOctjdtttdddid}tttdddid}t j||dS) Nr5rrrrrrrQ)r9r:rrr?rqrrdf_lxmldf_etrees rB"test_consistency_default_namespacers !""./ G!""/0 H'8,,,,,rOctjdtttdddid}tttdddid}t j||dS)Nr5rrrrrQ)r9r:rrrrqrrrs rB!test_consistency_prefix_namespacers !!/0 G!!/0 H'8,,,,,rOctjtd5t|d|ddddS#1swxYwYdS)Nrr7z .//Placemarkrr9r<rrrsrSs rB*test_missing_prefix_with_default_namespacer s z*K M M MAA.@@@@AAAAAAAAAAAAAAAAAArctjtd5t|ddddddS#1swxYwYdS)Nz'you used an undeclared namespace prefixr7.//kml:PlacemarkrQrr)kml_cta_rail_liness rB$test_missing_prefix_definition_etreers {+T V V VOO#+=gNNNNOOOOOOOOOOOOOOOOOOrctjd}tj|jd5t |ddddddS#1swxYwYdS)NrzUndefined namespace prefixr7rr5rr)rrs rB#test_missing_prefix_definition_lxmlrs$\22J z09U W W WNN#+=fMMMMNNNNNNNNNNNNNNNNNNrkeyctjdtjtd5t t t d|didddddS#1swxYwYdS)Nr5z0empty namespace prefix is not supported in XPathr7rhttp://www.opengis.net/kml/2.2r)r9r:r< TypeErrorrrr?)rs rBtest_none_namespace_prefixrs  L       % & &$=>                       s(A%%A),A)ct||}t||dgdi}tgdgdgdgdgd d}tj||tj||dS) NrfrgrrnrrrrrrrrqrrrsrSrrrs rBtest_file_elems_and_attrsrsy000GKKKLG 666IIILLL&&&***   K';///';/////rOct|d|}t||ddgi}tdgdi}tj||tj||dS)NT) attrs_onlyrSrgrirnrrrs rBtest_file_only_attrsrsvyT&AAAGyFZL;QRRRGZ)G)G)GHIIK';///';/////rOct|d|}t||dgdi}tgdgdgdgd d}tj||tj||dS) NT) elems_onlyrSrg)rjrlrkrmrnrrrrrrs rBtest_file_only_elemsr!syT&AAAG???@G IIILLL&&&***   K';///';/////rOctjtd5t|dd|ddddS#1swxYwYdS)Nz3Either element or attributes can be parsed not bothr7T)r rrSr )rrSs rBtest_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 attributesr7./rowT)rrrSr9r<rrrrSrs rBtest_empty_attrs_onlyr)s C >   OO #g$vNNNN OOOOOOOOOOOOOOOOOO!A  AAcd}tjtd5tt |dd|ddddS#1swxYwYdS)Nz r%r7r&T)rr rSr'r(s rBtest_empty_elems_onlyr,/s C >   OO #g$vNNNN OOOOOOOOOOOOOOOOOOr*cZtjdd}tt|d}tt|dd}t ||ddd gi }t ||dddd gi }t j||t j||dS) Nr5a z .//stationrrQrstationNamecoordsrorn)r9r:rrr\rqrr)rrrr df_iter_lx df_iter_ets rBtest_attribute_centric_xmlr4>s  C(x}}L999G \'JJJH# Y9vx.@"AJ$ Yw9vx>P2QJ'8,,,*j11111rOct|gd|}t||gddgdi}tgdgdgdgd gd d}tj||tj||dS) N)Col1Col2Col3Col4Col5namesrSrgr)rSr<rorrrrrrrs rBtest_names_option_outputr=esAAA&G666KKKL G222HHHJJJ&&&)))   K';///';/////rOcd}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_edgerrSr<r)typer,rCrSror<2D3Drspherecurvedrrs rBtest_repeat_namesrI~s C 000 H! 4445000 Gt )"H-  K(K000';/////rOcd}tt|d|ddg}t|||dddgiddg}tgd gd d }t j||t j||dS) NaB rectangle rectangle square rectangle ellipse ellipse circle ellipse r?r,grouprBrfamilyrD) rectanglerellipser)rMrMrNrN)r,rKrrs rBtest_repeat_values_new_namesrOs C& Zvw>OH! VX./w G@@@EEE  K(K000';/////rOcd}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 r?)r,rLrr rBr)rrrrrD)rrr)rNpolygonrQ)rrr)rrrrrs rBtest_repeat_elementsrRs C* 444 H! @@@A444 G444777&YY   K(K000';/////rOctjtd5t|gd|ddddS#1swxYwYdS)Nznames does not match lengthr7)r6r7r8r;r r s rBtest_names_option_wrong_lengthrTs z*G I I IKK":":":6JJJJKKKKKKKKKKKKKKKKKK>AActjtd5t|d|ddddS#1swxYwYdS)Nzis not a valid type for namesr7zCol1, Col2, Col3r;r9r<rrr s rBtest_names_option_wrong_typerXs y)H J J JEE"4VDDDDEEEEEEEEEEEEEEEEEErctjtd5t||ddddS#1swxYwYdS)Nz'utf-8' codec can't decoder7rfr9r<UnicodeDecodeErrorrxml_baby_namesrSs rBtest_wrong_encodingr^s )2N P P P00////000000000000000000 ;??ctjtd5t|d|ddddS#1swxYwYdS)NzLUTF-16 stream does not start with BOM|'utf-16(-le)?' codec can't decode byter7zUTF-16rWrS)r9r< UnicodeErrorrr\s rBtest_utf16_encodingrcs  5   CC (6BBBBCCCCCCCCCCCCCCCCCCrctjtd5t|d|ddddS#1swxYwYdS)Nzunknown encoding: UFT-8r7zUFT-8ra)r9r< LookupErrorrr\s rBtest_unknown_encodingrfs {+D F F FBB'&AAAABBBBBBBBBBBBBBBBBBrctjtd5t|d|ddddS#1swxYwYdS)Nz'ascii' codec can't decode byter7asciirarZr\s rBtest_ascii_encodingri$s )2S U U UBB'&AAAABBBBBBBBBBBBBBBBBBrcPtjdt|dd}t|dd}t|dddgdi}t|dddgdi}tj||tj||tj||dS) Nr5z ISO-8859-1rSrWrQz iso-8859-1r|)rankmalename femalename)rSrWrorp)r] df_xpath_lxmldf_xpath_etreervrws rB%test_parser_consistency_with_encodingrq)s ^F\RRRMnW|TTTN<<<= L <<<= M-888.-888, 66666rOctjdd}tjtd5t t |ddddddS#1swxYwYdS)Nr5- c z encoding Noner7rk)r9r:r<rrr)rYs rBtest_wrong_encoding_for_lxmlrt@s  D y 8 8 8??$>>>>??????????????????s AA#&A#cd}tt|dd}tddgi}tj||dS)NrsrQrkrc)rrrrqrr)rYresultexpecteds rBtest_none_encoding_etreeryMsQ D htnnWt D D DF#u&&H&(+++++rOctjtd5t|ddddS#1swxYwYdS)Nz7lxml not found, please install or use the etree parser.r7)r9r< ImportErrorrrs rBtest_default_parser_no_lxmlr|]s U    s 9==ctjtd5t|dddddS#1swxYwYdS)Nz,Values for parser can only be lxml or etree.r7bs4rfr rs rBtest_wrong_parserres I   ** 5))))******************r_ctjdt|dddi|}t|dgdi}tjt |tjt |dS) Nr5.//k:Placemarkkrrr stylesheet Placemarkr*r1)r9r:rrqrrdf_kml)rxsl_flatten_docdf_stylers rBtest_stylesheet_fileros 9:" H      G&(+++&'*****rOctjdt|||dkrdnd5}t|dddi|}dddn #1swxYwYt jt |dS Nr5rErUrVrrrrr9r:rrrqrrrrrrMrrs rBtest_stylesheet_file_liker  otgg$ O O O ST "=>                   &(+++++AAActjdt|||dkrdnd5}|dkr"t|}n!t |}dddn #1swxYwYt |dddi| }tjt|dS) Nr5rErUrVrDrrrr) r9r:rrr`rrrqrrr)rrrMrxsl_objrs rBtest_stylesheet_iors  otgg$ O O O)ST 4<<affhh''GGqvvxx((G ))))))))))))))) 9: H&(+++++sA BB  B ctjdt|||dkrdnd5}t|dddi|}dddn #1swxYwYt jt |dSrrrs rBtest_stylesheet_buffered_readerrrrctjdd}d}tt|}tt|t|}t j||dS)Nr5ru <根> r)r9r:rrrqrr)rxsldf_origrs rBtest_style_charsetrsk  HC C&x}}%%G (3--@@@H'8,,,,,rOctjd}tj|jd5t ||ddddS#1swxYwYdS)Nrzdocument is not a stylesheetr7r)r9r:r<XSLTParseErrorr)rrsrs rBtest_not_stylesheetrs$\22J !*H   ;; # ::::;;;;;;;;;;;;;;;;;;sAAActjd}d}tj|jd5t |t |ddddS#1swxYwYdS)Nra z(Extra content at the end of the documentr7r)r9r:r<rrrrrrs rBtest_incorrect_xsl_syntaxrs$\22J C( !)S   ?? # >>>>??????????????????AA"%A"ctjd}d}tj|jd5t |t |ddddS#1swxYwYdS)Nra zfailed to compiler7r)r9r:r<rrrrs rBtest_incorrect_xsl_evalrs$\22J C( z08K L L L??# >>>>??????????????????rctjd}d}tj|jd5t |t |ddddS#1swxYwYdS)Nrag zCannot resolve URIr7r)r9r:r<XSLTApplyErrorrrrs rBtest_incorrect_xsl_applyrs$\22J C z08L M M M??# >>>>??????????????????rctjd|dz }tjtd5t ||ddddS#1swxYwYdS)Nrzflatten_doesnt_exist.xslrr7r)r9r:r<r=r)r xml_data_pathrs rBtest_wrong_stylesheetr+s  %%% 4 4C !I   55 #4444555555555555555555sAAAc\tjdt|||dkrdnd5}|dkr"t|}n!t |}t |||jrJ ddddS#1swxYwYdS)Nr5rErUrVrDr)r9r:rrr`rrr)rrrMrrs rBtest_stylesheet_file_closer6s  otgg$ O O OST 4<<affhh''GGqvvxx((G#88888|sA$B!!B%(B%ctjdtjtd5t |d|ddddS#1swxYwYdS)Nr5z*To use stylesheet, you need lxml installedr7rQ)rSrr)rrs rBtest_stylesheet_with_etreerGs  G   QQ #GPPPPQQQQQQQQQQQQQQQQQQrctjd}tj|j5t ||ddddS#1swxYwYdS)Nrr)r9r:r<rr)rrrs rBtest_empty_stylesheetrOs$\22J z0 1 155#4444555555555555555555sA  AAc t|||dkrdnd5}|dkr]|dkrWtjtd5t ||dgdi dddn #1swxYwY ddddSt ||dgdi } dddn #1swxYwYt gd gd gd gd gdd}t j||dSNrErUrVr5z.reading file objects must return bytes objectsr7rgrhrnrrrrrr)rr9r<rrrrqrr)rsrSrMr df_filelikers rBtest_file_like_iterparserWs 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) rrrr`r9r<rrrrqrr)rsrSrMfuncIOrb df_fileiors rBtest_file_io_iterparserysXX'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) NrUrVrz)iterparse is designed for large XML filesr7r|rrr datern)rr}r`r9r<rrr)rSrrrs rBtest_url_path_errorrs9 h ) ) ) Q   222 ]  K       "G"G"GH                                     s6ABA>2 B>B BB BBBc|dz }t|||tjtd5t ||dgdi|ddddS#1swxYwYdS)Nz geom_xml.ziprSr^rr7r|rrSror^)geom_dfto_xmlr9r<rr)rSrbtmp_pathrs rBtest_compression_errorrs n $D NN44DNEEE G       CCCD(                       sA##A'*A'ctjtd5t||gdddddS#1swxYwYdS)Nz&list is not a valid type for iterparser7rhrnrWr s rBtest_wrong_dict_typers y(P Q Q Q   FFF                      rUctjtd5t||ddiddddS#1swxYwYdS)Nz8 is not a valid type for value in iterparser7rgrirnrWr s rBtest_wrong_dict_valuers S   KK 6fj5IJJJJKKKKKKKKKKKKKKKKKKrUc d}||dtjtd5t ||dgdgdi ddddS#1swxYwYdS) Na square 00360 4.0 2020-01-01 circle 00360 2021-01-01 triangle 00180 3.0 2022-01-01 rUrVzDExtra content at the end of the document|junk after document elementr7rr|r)rS parse_datesro)rXr9r<rr)rSrbad_xmls rB test_bad_xmlrsG*7333 T        CCCD                       sAA"Acd}tt|d|}t|||dddgi}tdd gd d gd }t j||t j||dS) Na- circle 2D sphere 3D r?rrr,rCrnrrGrErFr,rCrrs rB test_commentrs C" ZGGGH  Yv'FF;K1LGx(4L  K(K000';/////rOcd}tt|d|}t|||dddgi}tdd gd d gd }t j||t j||dS) Na8 ]> circle 2D sphere 3D r?rrr,rCrnrrGrErFrrrs rBtest_dtdr C$ ZGGGH  Yv'FF;K1LGx(4L  K(K000';/////rOcd}tt|d|}t|||dddgi}tdd gd d gd }t j||t j||dS) Nam , , ?> circle 2D sphere 3D r?rrr,rCrnrrGrErFrrrs rBtest_processing_instructionr<rrOctjtd5t||dgdiddddS#1swxYwYdS)Nz+No result from selected items in iterparse.r7nodeattr1elem1elem2elem3rn)r9r<rrr s rBtest_no_resultr`s H       CCCD                      AAActjtd5t||dgdiddddS#1swxYwYdS)NzNo columns to parse from filer7rgrrn)r9r<r rr s rBtest_empty_datarks ~-L M M M   CCCD                      rc tjdd}d}tt|dddgt|}t dd d d d d dddddd d}t j||dS)Nr5a 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]rjartist)rr<rzEmpire BurlesquezHide your heartz Greatest HitszStill got the bluesErosr&z Bob Dylanz Bonnie Tylerz Dolly Partonz Gary MoorezEros Ramazzotti)rjr)r9r:rrrrqrr)rrdf_xslrs rBtest_online_stylesheetrts T Cj C2 -!C== F&$"( !!$   K&+v.....rOc  |dz }t|d||t|||}t||||dgdi|}t j|tt j|tdS)Nztest.xmlF)r3rSr^rr|rr)rrrrdrqrr)rSrbrrrarrs rBtest_compression_readrs:%I NN9E&FVNWWW &>NOOOH%7778$ G(G,,,'7+++++rOc|}|}||krtj|d|tdftdftdftdfd}t dd }| |jd f|d <t d d }| td f|d<||\} } t |||tj | | 5t|||ddddS#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 decoderxzrr7) r9skipr>r rr ZstdErrorrrrr<r) rSr^rbractual_compressionattempted_compressionrrr error_cls error_strs rBtest_wrong_compressionrs$,222 )FF/DFFGGG././45BC F &k( C C CD .*DEv %fX > > >D !#JKt !"78Iy NN9V9KNLLL y 2 2 2NN67LMMMMNNNNNNNNNNNNNNNNNNsC##C'*C'ctjtd5t||dddddS#1swxYwYdS)NzUnrecognized compression typer77zrr )rSrs rBtest_unsupported_compressionrs z)H I I I==6t<<<<==================rctjdtjdd|jd}t|d|}t|d|}t j||dS)Ns3fsr5zs3://z /books.xml)rSstorage_optionsrQ)r9r:r,rrqrr)s3_bucket_public_with_datas3sos3rrs rBtest_s3_parser_consistencyrs{   <+0 < < x 1 4.0 x 2 4.0 True False y 2 5.0 False zmode.string_storage)rS dtype_backendpyarrowxyrr'r(Int64rg@Float64TFboolean) rrrvderghir)ArrowExtensionArrayc ^i|])}||d*S)T) from_pandas)array).0colrrxpas rB z1test_read_xml_nullable_dtypes..sK   (((3-T)R)RSS   rOr )check_column_type)pdoption_contextrrr9r: ArrowDtyper StringDtyperrr pandas.arraysrcolumnsrrqrr) rSstring_storagerusing_infer_stringrYrw string_dtyperrxrs @@@rBtest_read_xml_nullable_dtypesr"sk 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.r7testnumpy)rr r@s rBtest_invalid_dtype_backendr& s ! z - - -00w////000000000000000000s=AA) __future__riorrrrrtarfiler urllib.errorrxml.etree.ElementTreer zipfiler r%npr9 pandas.compatr pandas.compat._optionalr pandas.errorsr rpandas.util._test_decoratorsutil_test_decoratorstdpandasrrrrpandas._testing_testingrqpandas.io.commonr pandas.io.xmlrrrr?rrrrCfixturerMrJ skip_if_norSr\rdrxmarknetwork single_cpurrrrrrrr parametrizerrskipifrrrrrrrrrrrr rrrrrr!r#r)r,r4r=rIrOrRrTrXr^rcrfrirqrtryskip_if_installedr|rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr"r&rOrBrCs """""" """""",,,,,, >>>>>>*)))))))) ''''''""""""l )111"??RVQ   (*    )!!!!      Q1q11       999&9$ 9uI I =hhR %((Uk k k \###c{###$#  V=2=3H3HIII7STTTUT))) ---777* - - -000"...,///0///2///000>S **&&+*&$S **''+*'D!EFF**GF*///&   /0/0/0j>>> ???>>>00060004---&---,AAA OOO NNNT ++   ,+  000*000000(VVVOOO0 O O O!2!2!2N0002$0$0$0N(0(0(0V/0/0/0dKKK EEE000 CCCBBB BBB 777. ? ? ? , , , f***+++6 , , ,,,,, , , ,---:;;;???:???6???&555"QQQ"wws|| <==55>=5444D'2'2'2T          KKK! ! ! H 0 0 0F!0!0!0H!0!0!0H      J/J/J/`,,,&NNN6===---CECECEL00000rO