MhHSSKJr SSKJrJr SSKJrJrJrJ r SSK r SSK J r SSK r SSKJrJrJrJrJr SSKrSSKrSSKJr SSKJrJrJr SS KJr SS KJ r SS K!J"r"J#r#J$r$ SS K%J&r& SS K'J(r(J)r) SSK*J+r+J,r, \(aSSK-J.r.J/r/J0r0 SSK1J2r2J3r3 Sr4"SS\+5r5"SS\R5r6"SS\55r7SSjr8SSjr9g)) annotations)abc defaultdict)HashableIteratorMappingSequenceN)StringIO)IO TYPE_CHECKING DefaultDictLiteralcast)lib)EmptyDataError ParserError ParserWarning)cache_readonly)find_stack_level) is_bool_dtype is_integeris_numeric_dtype) is_dict_like) dedup_namesis_potential_multi_index) ParserBaseparser_defaults) ArrayLike ReadCsvBufferScalar)Index MultiIndexuc^\rSrSr%S\S'S!U4Sjjr\S"Sj5rS#SjrS$S%Sjjr S&Sjr S$S'S jjr S(S jr \S)S j5r S*S jr\S 5rS+SjrS,SjrS-SjrS.SjrS,SjrS/SjrS0SjrS1SjrS1SjrS1SjrS2SjrS1SjrS3SjrS4SjrS5SjrS$S6SjjrS7Sjr S8Sjr!S r"U=r#$)9 PythonParserGset[int]_no_thousands_columnsc >^[TT]U5 STl/TlSTlSTlUSTl[TR 5(aTR TlO U4SjTl[US5Tl USTl USTl [TR[5(a[TR5Tl USTlUS TlUS TlUS TlUS TlUS TlSTlSU;a USTlUSTlUSTlUSTlUSTl[U[45(a[7[8[U5TlO)[;US5(deTR=U5TlSTlTRA5unTl!Tl"TRGUTRH5uTl%Tl$Tl&n[5TRJ5Tl'TRP(d9TRS5unTl'Tl%STl*TRHcUTl$TR>c,[5[W[YTRJ555TlTR[TRJ5Tl.TR_5Tl0[YTR05S:wa [cS5eg)z> Workhorse function for processing nested list into DataFrame Nrskiprowsc">UTR;$N)r))xselfs Q/var/www/html/env/lib/python3.13/site-packages/pandas/io/parsers/python_parser.py'PythonParser.__init__..Zsa4==&8 skipfooter delimiter quotechar escapechar doublequoteskipinitialspacelineterminatorquotingskip_blank_linesFhas_index_namesverbose thousandsdecimalcommentreadlineTz'Only length-1 decimal markers supported)2super__init__databufposline_posr)callableskipfunc_validate_skipfooter_argr2r3r4 isinstancestrr5r6r7r8r9r:r;r<r=r>r?listrrhasattr _make_reader _col_indices_infer_columnsnum_original_columns unnamed_cols_extract_multi_indexer_columns index_namescolumns col_names orig_names_has_complex_date_col_get_index_name_name_processedrangelen_validate_parse_dates_presence_parse_date_cols_set_no_thousand_columnsr' ValueError)r-fkwdsrV_rU __class__s` r.rCPythonParser.__init__Js *.  Z( DMM " " MMDM8DM24 3EFk*k* dnnc * * 0DN|, . $%7 8"#34I $%7 8$  $#'(9#:D I k*I I  a  Xc]A.DI1j)) ))))!,DI/3    !    %    / /      L   N +/t||*< ));?;O;O;Q 8[$/4<#'D '#.    $ $U3t||+<%= >D  $ C CDLL Q%)%B%B%D" t||  !FG G "r1c[R"UR5nURcSUS3nO)[R"UR5nSUSUS3n[R"U5$)Nz^[\-\+]?[0-9]*(z [0-9]*)?([0-9]?(E|e)\-?[0-9]+)?$z^[\-\+]?([0-9]+z |[0-9])*()reescaper>r=compile)r-r>regexr=s r.numPythonParser.numsm))DLL) >> !&wi/OPE $..1I"9+Ywi@,- zz%  r1c^^^ TRm T b[T 5S:XGaTR(a [S5e"U4SjS[R 5nUnT b T UlGOpTR 5nTRU//5SnTRTR5(dU(dfT=RS- sl TR 5nTRU//5SnTRTR5(aM]U(dMf[[[U5nUSnT=RS- sl T=RS- sl [R"5RU5nURUl[R "[#U5US9nTR$R'[U55 [R "TUSS9n U $UU 4S jn U "5n U $) NrAz\rSrSrYRrYR rYR rYRrYRrYRr Sr Sr g),PythonParser._make_reader..MyDialect N) __name__ __module__ __qualname____firstlineno__r3r4r5r6r7r9r8__static_attributes__r-sr. MyDialectrpsC NN  NN !__ ".. #'#8#8 ,,!%r1rzr)dialectT)r{strictc3># TR5n[R"T5nURUR 55v TH$nURUR 55v M& g7fr+)r@rhrjsplitstrip)linepatrbseps r._read(PythonParser._make_reader.._readsRzz|jjoii --D))DJJL11sA3A6)r3r]r8racsvDialectr@_check_commentsrIrFrrMrLrGSniffersniffreaderr rEextend) r-rbrzdiarlines lines_strsniffedline_rdrrrrs `` @r.rOPythonParser._make_readersnn ;#c(a-"" R &CKK &C # zz|,,tfX6q9mmDHH--UHHMH::Uc URnURUS9$)N)r) chunksizer)r-sizes r. get_chunkPythonParser.get_chunkFs# <>>Dyydy##r1cURUR5nURUR5n0n0n[UR[ 5(amURH\nURUnUR Un[U[5(aX`R;aURUnXtU'XU'M^ OURnUR nURUUUURUU5$r+) _clean_mapping convertersrrK na_valuesdict na_fvaluesintrX_convert_to_ndarraysr<) r-rD clean_conv clean_dtypesclean_na_valuesclean_na_fvaluescolna_value na_fvalues r.rPythonParser._convert_dataPs ((9 **4::6  dnnd + +~~>>#. OOC0 c3''C,F//#.C'/$(1%&#nnO# ((    LL     r1cURcgURn[U[[[R 45(a[ U5S:$g)NFrA)headerrKrMtuplenpndarrayr])r-rs r._have_mi_columnsPythonParser._have_mi_columnsssA ;;  ftUBJJ7 8 8v;? "r1c 8 URnSnSn[5nURGbHURnURn[ U[ [ [R45(aU(a[ U5USS-/-nOU/n/n[U5GHupUR5n URU ::a"UR5n URU ::aM"/n/n[U 5HVunnUS :Xa9U(a SUSU3nOSU3nUR)U5 UR)U5 MEUR)U5 MX U(Gd+[-[.5n[1[#U55Vs/sH nUU;dM UPM snU-nUHnUUnUnUUnUS:aUS:a(US-UU'USU3nUU;aUS- nOUUnUS:aM(UR2b[5UR25(anUR2R7U5bRUR2R7U5c6UR2R9UUR2R7U505 UUU'US-UU'M OsU(alXS:Xad[#U5nUR:nUb [#U5OSn[#U5nUU:wa UU- U:dUS:XaSnS/U-nUR<S/UlUR)U5 UR9UVs1sHnUUiM sn5 [#U5S:XdGM[#U5nGM U(aUR'5 UbUR5nUcSO [#U5n[#U5[#US5:a[#U5U:a [%S5e[#U5S:a [?S5eUR@bURCXqU5 O [#U5nURDbM[#U5[#URD5:wa+[GURD5Vs/sHnUUPM sn/nOU/nOURCXwSU5nO[#URH5nUnU(d+[ [1U55/nURCXwSU5nOUR@b[#U5U:a URCU/UU5n[#U5nO_[KUR@5(d-[#U5[#UR@5:wa [%S5eU/nURCXwSU5 XrU4$![Gan SURs=:aU ::auO OrU(aXS:wac[ [[U(aUSSOU55n SSR!U 5S[#U 5S3n [%S U S URS 35U eU(aIU S:aCU(aUR'5 UR)S/[#US5-5 XrU4sSn A s $UR(d [+S 5U eURSSn Sn A GNSn A ff=fs snfs snf![a SnGN f=fs snf)NrTrA[,z ], len of z, zPassed header=z but only z lines in fileNo columns to parse from filez Unnamed: _level_.FzHNumber of passed names did not match number of header fields in the filez*Cannot pass names with multi-index columns)&rsetrrrKrMrrrr_buffered_linerG _next_linermaprLjoinr]ra _clear_bufferappendrrrr\rrgetupdaterrE TypeErrorusecols_handle_usecolsrPsorted _header_linerH)r-rrR clear_bufferrSrhave_mi_columnsrVlevelhrrerrjoimsg this_columnsthis_unnamed_colsrccol_namecountscol_loop_orderrold_col cur_countlcsicic unnamed_count first_linelen_first_data_rowncolss r.rQPythonParser._infer_columns~sQ   +.5 ;; "[[F"33O&4 ";<<"!&\VBZ!^,< -/BGm4KPRVWPW+0L,06B;L(, ~DH|,##>O$P>O\!_>O$PQw<1$+.|+<(Q/T""$ &!%!2J+5*wO0O 0 !'$$Waj%@l::y%)4==.B.+rBZ/?#3s?F3BKPV#WX !#((3- 3s8*BG(,SE' nF ##'26' ..0vGBK0@'@A&lJJ::,-LMSVV::a=D3)\&`%Q%&!%J&, MsPAU7 Y:Y:Y? #ZZ Y7$CY28Y7,Y22Y7 ZZcURbgUR5nU$![a7nUR(d [ S5UeURSSnSnAU$SnAff=f)Nr)rrrrr)r-rrs r.rPythonParser._header_line7sd ;; " !&&(D   !::$%DE3N::a=D  !s" A#,AA#c dURGba[UR5(aURURU5nO[SUR55(ay[ U5S:a [ S5e/nURHLn[ U[5(a#URURU55 M;URU5 MN OEURVs/sH oUU:dM UPM nnU(a[SUS35eURnUVVV s/sH*n[U5VV s/sHupX;dM U PM sn nPM, nnnn [U5UlU$![ a! URURU5 GM f=fs snfs sn nfs sn nnf)zJ Sets self._col_indices usecols_key is used if there are string usecols. c3B# UHn[U[5v M g7fr+)rKrL).0us r. /PythonParser._handle_usecols..Us>AZ3''srAz4If using multiple headers, usecols must be integers.z>>>w@#ll &%F )0E0tqA4D0E% !'{ 3D ) *T 88{SST #Fs<( E2. F ;F +F+? F%F%F+2&FF%F+cr[UR5S:aURS$UR5$)z8 Return a line from buffer, filling buffer if required. r)r]rErrys r.rPythonParser._buffered_linevs/ txx=1 88A; ??$ $r1crU(dU$[US[5(dU$US(dU$USSnU[:waU$USn[U5S:aRUSUR:Xa?SnUSnUSSR U5S-nX4Un[U5US-:a XsUS-S- nOUSSnU/nXSS-$)z Checks whether the file begins with the BOM character. If it does, remove it. In addition, if there is quoting in the field subsequent to the BOM, remove it as well because it technically takes place at the beginning of the name, not the middle of it. rrAN)rKrL_BOMr]r4r) r- first_row first_elt first_row_bomstartquoteendnew_row new_row_lists r._check_for_bomPythonParser._check_for_boms  )A,,, | aLO   !!  }  !mA&6$..&HE!!$E#))%014C$#.G=!C!G+q33$AB'G&-Y m++r1cBU(+=(d [SU55$)z Check if a line is empty or not. Parameters ---------- line : str, array-like The line of data to check. Returns ------- boolean : Whether or not the line is empty. c3.# UH o(+v M g7fr+rs)rr,s r.r.PythonParser._is_line_empty..s3duuds)all)r-rs r._is_line_emptyPythonParser._is_line_emptysx333d333r1c[UR[5(Ga;URUR5(a[UR[ UR5:aO7U=RS- slURUR5(aM[UR URUR/5SnU=RS- slUR(d9URURURS- 5(dU(aGOIUR(a URU/5nU(aUSnGOMURUR5(a[U=RS- slURce[UR5 URUR5(aM[URURS-S9nU=RS- slUbdUR U/5SnUR(a URU/5nU(aUSnO!OURU5(dU(aOMURS:XaURU5nU=RS- slUR R#U5 U$![a [ef=f)NrArrow_num)rKrDrMrIrFr]rr:r%_remove_empty_lines IndexErrorrnext_next_iter_linerrGrEr)r-rret orig_lines r.rPythonParser._next_lines: dii & &--))88s499~-A --)) (//4881D0EFqIDHHMH00++DIIdhhl,CDD,,"66v>#&q6D!"--))A yy,,,TYY --))  00A0F A (// #&q6D!,,Y774& 88q=&&t,D    C"(''(sB K)/KKcURURR:Xa [U5eURURR:Xa*[ R "SUSUS3[[5S9 gg)a Alert a user about a malformed row, depending on value of `self.on_bad_lines` enum. If `self.on_bad_lines` is ERROR, the alert will be `ParserError`. If `self.on_bad_lines` is WARN, the alert will be printed out. Parameters ---------- msg: str The error message to display. row_num: int The row number where the parsing error occurred. Because this row number is displayed, we 1-index, even though we 0-index internally. zSkipping line z: rr) stacklevelN) on_bad_linesBadLineHandleMethodERRORrWARNwarningswarnrr)r-rr)s r._alert_malformedPythonParser._alert_malformedso"    8 8 > > >c" "    8 8 = = = MM  C53+-  >r1cURce[UR5n[U[5(deU$![R anUR URRURR4;aD[U5nSU;dSU;aSnURS:a SnUSU-- nURXA5 SnAgSnAff=f)a Wrapper around iterating through `self.data` (CSV source). When a CSV error is raised, we check for specific error messages that allow us to customize the error message displayed to the user. Parameters ---------- row_num: int The row number of the line being parsed. Nz NULL bytezline contains NULzNULL byte detected. This byte cannot be processed in Python's native csv library at the moment, so please pass in engine='c' insteadrzError could possibly be due to parsing errors in the skipped footer rows (the skipfooter keyword is only applied after Python's csv library has parsed all rows).. ) rDr,rKrMrErrorr3r4r5r6rLr2r9)r-r)rerreasons r.r-PythonParser._next_iter_lines! 99( (( ?DdD)) ))Kyy   ((..((--%!f#%)<)C???Q&%4&=(C%%c35 sCCc|URcU$/nUHn/nUHn[U[5(aURU;dXPR;aUR U5 MJUSUR UR5n[ U5S:aUR U5 O UR U5 M U$r)r?rKrLrrfindr])r-rr.rrlr,s r.rPythonParser._check_commentsEs << LDB"1c**||1,NN*IIaL0AFF4<<01A1vz !  JJrN r1cUVs/sHWn[U5S:dC[U5S:XdM#[US[5(aUSR5(dMUUPMY nnU$s snf)a? Iterate through the lines and remove any that are either empty or contain only one whitespace value Parameters ---------- lines : list of list of Scalars The array of lines that we are to filter. Returns ------- filtered_lines : list of list of Scalars The same array of lines with the "empty" ones removed. rAr)r]rKrLr)r-rrr.s r.r* PythonParser._remove_empty_linesZsj$ D A t9>  $DGS11T!W]]_     s"A'.A'A'cTURcU$URXRSS9$)Nrrsearchreplace)r=_search_replace_num_columnsr-rs r._check_thousandsPythonParser._check_thousandsus2 >> !L//0  r1c~/nUHn/n[U5Hupx[U[5(aBX(;d=XpR;d.URR UR 55(dURU5 MoURURX#55 M URU5 M U$r+) rrKrLr'rlrIrrrJ) r-rrIrJr.rrCrr,s r.rK(PythonParser._search_replace_num_columns}sDB!$"1c**66688??177955IIaLIIaii89( JJrN r1chUR[S:XaU$URXRSS9$)Nr>rrH)r>rrKrLs r._check_decimalPythonParser._check_decimals9 <SY1J1J%JJ%)%D *:%;DN#xx|DH%d^q!,,"&gJ03G D-W44  "#'D ~~%!%e,?&@!AJ/3.E.E/ +ZDNw..i!    I s#FF0 F-,F-0 G?Gc URnUR(aU[UR5- n[ SU55nX2:GaURSLGaUR GcUR (a UR OSn/n[U5n[U5n/nUHup[U 5n X:a[UR5(a)URU 5n U bURU 5 MVMXURURRURR4;aNURXx- U-- n URX45 URURR:Xa OMMURU 5 M UHyupSUSU S-SU 3n UR(aA[UR5S:a(UR ["R$:wa SnU S U-- n UR'XS-5 M{ [)[*R,"XS 9R.5nUR (aUR0ceUR0nUR(aY[U5VVs/sH?unnU[UR5:dU[UR5- U;dM=UPMA nnnU$[U5VVs/sHunnUU;dMUPM nnnU$s snnfs snnf) Nc38# UHn[U5v M g7fr+)r])rrows r.r-PythonParser._rows_to_cols..s2'3c#hh'sFrz Expected z fields in line rAz, saw zXError could possibly be due to quotes being ignored when a multi-char delimiter is used.r<) min_width)rRrr]rmaxrr2rrHr3rr4r5r6rFr3r9r QUOTE_NONEr9rMrto_object_arrayTrP)r-rcol_lenmax_lenfooters bad_lines iter_content content_lenr_content actual_lennew_lr)rr?zipped_contentr as r.rPythonParser._rows_to_colss++    s4>>* *G2'22  e+ $)-dooaGI$W-Lg,KG+  ] ' 1 122 $ 1 1( ; ,#NN51-**00660055/#'((ko.G"H!((')>?,,0H0H0N0NN!ONN8,% ,((1#y(81 V!l$ NNDNN+a/ 6G4&=(C%%cQ;7#(1(c11'MOOP <<$$0 00++K##!*. 9" 91C//s4>>22kA  9"#,N";"";$!QqK?OA";"""s X&""'$% !"-1XX-Aq$m$(99#88#8&*499oG#'==1C#D#D &! %NI$OOG4%m(+8} #'#<#!$**d33r3r6r5r;rrUrGr8rRrXrFr4r9r:r2rIr7r)r=rSr<)rbzReadCsvBuffer[str] | listreturnNone)rz re.Pattern)rbIO[str] | ReadCsvBuffer[str]r+)r int | NonerRtuple[Index | None, Sequence[Hashable] | MultiIndex, Mapping[Hashable, ArrayLike]])rlist[np.ndarray]rz8tuple[Mapping[Hashable, np.ndarray], Sequence[Hashable]])rrrr)rDzMapping[Hashable, np.ndarray]rzMapping[Hashable, ArrayLike])rbool)rz9tuple[list[list[Scalar | None]], int, set[Scalar | None]])rVlist[list[Scalar | None]]r zlist[Scalar | None]rRrrr)r list[Scalar])rrrr)rrrr)rrLr)rrr)r)rrzlist[Scalar] | Nonerlist[list[Scalar]]rr)rrrIrLrJrLrr)rr)rz@tuple[Sequence[Hashable] | None, list[Hashable], list[Hashable]])rrrr)rrrr)rurrr)rr&)$rtrurvrw__annotations__rCrrlrOrrrrrrQrrrrr%rr9r-rr*rMrKrRrrZrrrtr`rx __classcell__)res@r.r$r$Gs##]H~ ! !>B"&4040 40l! B6"&$$ $! +!  &! Fw; Bw;r  .*.)." . # .`%3,j 46p4.`*6 '14?B & L/ IL/\TlO*b$$r1r$cv\rSrSrSrS S SjjrS S SjjrS SSjjrSSjrSr g)FixedWidthReaderiz A reader of fixed-width lines. Nc vXlSUlU(aSU-OSUlX@lUS:XaUR XeS9UlOX l[ UR [[45(d![S[U5R35eUR Hn[ U[[45(au[U5S:Xaf[ US[[R[S545(a4[ US[[R[S545(aM[S 5e g) Nz z infer) infer_nrowsr)z;column specifications must be a list or tuple, input was a rrrAzEEach column specification must be 2 element tuple or list of integers)rbbufferr3r?detect_colspecscolspecsrKrrMrtypertr]rrinteger)r-rbrr3r?r)rcolspecs r.rCFixedWidthReader.__init__s '+ /8)+i w  00'1DM%M$--%77#H~6679  }}G7UDM22LA%wqzCT$Z+HIIwqzCT$Z+HII:%r1cUc [5n/n/n[UR5H=upVXR;aURU5 URU5 [ U5U:dM= O [ U5UlU$)a1 Read rows from self.f, skipping as specified. We distinguish buffer_rows (the first <= infer_nrows lines) from the rows returned to detect_colspecs because it's simpler to leave the other locations with skiprows logic alone than to modify them to deal with the fact we skipped some rows here as well. Parameters ---------- infer_nrows : int Number of rows to read from self.f, not counting rows that are skipped. skiprows: set, optional Indices of rows to skip. Returns ------- detect_rows : list of str A list containing the rows to read. )rrrbrr]iterr)r-rr) buffer_rows detect_rowsrr`s r.get_rowsFixedWidthReader.get_rowssv2  uH  'FA ""3'   s #;;. ( ;' r1c SRURVs/sHnSU3PM sn5n[R"SUS35nUR X5nU(d [ S5e[ [[U55n[R"US-[S9nURb-UV s/sH oRUR5SPM" nn UH;n URU 5H#n SXR5U R!5&M% M= [R""US5n SU S'[R$"X- S:H5Sn ['[)U SSS 2U SSS 255n U $s snfs sn f) Nr\z([^z]+)z(No rows from which to infer column widthrA)rrr)rr3rhrjrrrcrr]rzerosrr? partitionfinditerrrrollwhererMr)r-rr)r, delimiterspatternrrhmaskr`mshiftededges edge_pairss r.r FixedWidthReader.detect_colspecssPWW?11#h?@ **s:,c23}}[3 !KL Lc#tn%xx! 3/ << #>BCdsMM$,,/2dDCC%%c*,-WWY)+''$" $.Q./2#eCaCj%1+67 !@Ds E:3'E?cPURb[UR5nO[UR5nURVVs/sH"up#XUR UR 5PM$ snn$![a SUl[UR5nNdf=fs snnfr+)rr,rrbrrr3)r-rfrom_tos r.__next__FixedWidthReader.__next__s ;; " $DKK( s r.r.Gs(E1z!S))6QWWY6s9;)r )r-rrs r.r*)FixedWidthFieldParser._remove_empty_lines=s7 EEE    s--)rrN)rbzReadCsvBuffer[str]rr)rbrrrr) rtrurvrwrrCrOr*rxrsr1r.rr's /    r1rc&[SU55$)Nc3:# UHoS:XdUbM Sv M g7f)rNrArs)rvs r.r#count_empty_vals..Ls7$Qr'Qqq$s  )sum)valss r.rrKs 7$7 77r1c^[U5(d [S5eUS:a [S5eU$)a Validate the 'skipfooter' parameter. Checks whether 'skipfooter' is a non-negative integer. Raises a ValueError if that is not the case. Parameters ---------- skipfooter : non-negative integer The number of rows to skip at the end of the file. Returns ------- validated_skipfooter : non-negative integer The original input if the validation succeeds. Raises ------ ValueError : 'skipfooter' was not a non-negative integer. zskipfooter must be an integerrzskipfooter cannot be negative)rra)r2s r.rJrJOs6* j ! !899A~899 r1)rr)r2rrr): __future__r collectionsrrcollections.abcrrrr rior rhtypingr r r rrr7numpyr pandas._libsr pandas.errorsrrrpandas.util._decoratorsrpandas.util._exceptionsrpandas.core.dtypes.commonrrrpandas.core.dtypes.inferencerpandas.io.commonrrpandas.io.parsers.base_parserrrpandas._typingrrr pandasr!r"rr$rrrrJrsr1r.rs"    34 6  g$:g$T#sWs||sWl! L! H8r1