ttj%dZddlmZddlmZmZmZmZmZddl Z ddl Z ddl Z ddl m Z mZmZddlZddlZddlmZddlmZddlmZdd lmZmZdd lmZmZmZm Z m!Z!ddl"m#cm$Z%dd l&m'Z'dd l(m)Z)m*Z*dd l+m,Z,e rddl-m.Z.m/Z/m0Z0m1Z1m2Z2ddlm3Z3GddZ4Gdde4Z5GddZ6GddZ7dS)zC Utilities for conversion to writer-agnostic Excel representation. ) annotations)CallableHashableIterableMappingSequenceN) TYPE_CHECKINGAnycast) is_list_like)find_stack_level)missing)is_float is_scalar) DataFrameIndex MultiIndexPeriod PeriodIndex) CSS4_COLORS) CSSResolver CSSWarning)get_level_lengths)ExcelWriterMergeCellsFilePath IndexLabelStorageOptionsWriteExcelBuffer ExcelWriterc&eZdZdZeZ d d d ZdS) ExcelCellrowcolvalstyle mergestartmergeendNr$intr%r( int | Noner)returnNonecZ||_||_||_||_||_||_dSNr#)selfr$r%r&r'r(r)s U/var/www/html/CA-Chatbot/venv/lib/python3.11/site-packages/pandas/io/formats/excel.py__init__zExcelCell.__init__Cs2 $  )NNN) r$r*r%r*r(r+r)r+r,r-)__name__ __module__ __qualname__ __fields__ __slots__r2r3r1r"r"?sBIJI!%#!!!!!!!r3r"c eZdZdfd ZxZS) CssExcelCellr$r*r%r' dict | None css_styles3dict[tuple[int, int], list[tuple[str, Any]]] | Nonecss_rowcss_col css_converterCallable | Noner,r-c  |rB|r@d|||fD} t| } || }tjd||||d| dS)Nc>i|]\}}||Sr9lower).0propr&s r1 z)CssExcelCell.__init__..cs3   &/dC c   r3r$r%r&r'r9) frozensetitemssuperr2) r0r$r%r&r'r=r?r@rAkwargsdeclaration_dictunique_declarations __class__s r1r2zCssExcelCell.__init__Us  7- 7  3=gw>N3O    #,,<,B,B,D,D"E"E !M"566EJScs%JJ6JJJJJr3)r$r*r%r*r'r<r=r>r?r*r@r*rArBr,r-)r4r5r6r2 __classcell__)rQs@r1r;r;TsGKKKKKKKKKKr3r;cleZdZUdZeZdddddddZdddddddddddddd Zdddd Zd d d d dZ ddDZ de d<dIdJdZ e ZdKdZdKdZdLdZdMd!ZdNd"ZdOd$ZdPd&ZdQd*ZdRd,ZdSd.ZdTd1ZdUd2ZdVd4ZdWd6ZdOd7ZdOd8ZdXd:ZdOd;Z dXd<Z!dYd>Z"dZdAZ#d[dCZ$d\dFZ%d]dGZ&d\dHZ'dS)^CSSToExcelConverteraK A callable for converting CSS declarations to ExcelWriter styles Supports parts of CSS 2.2, with minimal CSS 3.0 support (e.g. text-shadow), focusing on font styling, backgrounds, borders and alignment. Operates by first computing CSS styles in a fairly generic way (see :meth:`compute_css`) then determining Excel style properties from CSS properties (see :meth:`build_xlstyle`). Parameters ---------- inherited : str, optional CSS declarations understood to be the containing scope for the CSS processed by :meth:`__call__`. topcenterbottom)rUztext-topmiddlebaselinerWz text-bottomTF) boldbolder600700800900normallighter100200300400500)r`italicoblique)serifz sans-serifcursivefantasyc8i|]}||Sr9rE)rGr's r1rIzCSSToExcelConverter.s2   ur3) dashed mediumDashDot dashDotDothairdottedmediumDashDotDotdoubledashDot slantDashDot mediumDashedzdict[str, str] | None inheritedN str | Noner,r-c||||_nd|_tj|j|_dSr/) compute_cssr{ functoolscache_call_uncached _call_cached)r0r{s r1r2zCSSToExcelConverter.__init__sC  !--i88DNN!DN&OD,?@@r3 declarations str | frozenset[tuple[str, str]]dict[str, dict[str, str]]c,||S)a Convert CSS declarations to ExcelWriter style. Parameters ---------- declarations : str | frozenset[tuple[str, str]] CSS string or set of CSS declaration tuples. e.g. "font-weight: bold; background: blue" or {("font-weight", "bold"), ("background", "blue")} Returns ------- xlstyle : dict A style as interpreted by ExcelWriter when found in ExcelCell.style. )r)r0rs r1__call__zCSSToExcelConverter.__call__s&  ...r3cb|||j}||Sr/)r~r{ build_xlstyle)r0r propertiess r1rz"CSSToExcelConverter._call_uncacheds/%%lDNCC !!*---r3propsMapping[str, str]c||||||||||d}dfd ||S)N) alignmentborderfillfont number_formatddict[str, str | None]r,r-ct|D]0\}}|||= t|tr||s||=1dS)z4Remove key where value is None, through nested dictsN)listrL isinstancedict)rkv remove_nones r1rz6CSSToExcelConverter.build_xlstyle..remove_noneskQWWYY ! !19!4((!KNNN!aD  ! !r3)rrr,r-)build_alignment build_border build_fill build_fontbuild_number_format)r0routrs @r1rz!CSSToExcelConverter.build_xlstyles--e44''..OOE**OOE**!55e<<    ! ! ! ! ! !  C r3dict[str, bool | str | None]c|d||||dS)Nz text-align) horizontalvertical wrap_text)get_get_vertical_alignment_get_is_wrap_textr0rs r1rz#CSSToExcelConverter.build_alignmentsD ))L1144U;;//66   r3ch|d}|r|j|SdS)Nzvertical-align)r VERTICAL_MAP)r0rvertical_aligns r1rz+CSSToExcelConverter._get_vertical_alignments8#344  9$((88 8tr3 bool | Nonec^|ddSt|ddvS)Nz white-space)nowrapprezpre-line)rboolrs r1rz%CSSToExcelConverter._get_is_wrap_text s2 99] # # +4E-(0MMNNNr3 dict[str, dict[str, str | None]]c$fddDS)NcJi|]}|d|dd|dd|dd|ddS)zborder-z-stylez-widthz-color)r'color) _border_stylercolor_to_excel)rGsiderr0s r1rIz4CSSToExcelConverter.build_border..s     ++II444455II444455'' 2HD2H2H2H(I(IJJ ,,UYY7M7M7M7M-N-NOO     r3)rUrightrWleftr9rs``r1rz CSSToExcelConverter.build_borders6      ;    r3r'widthrc.|||dSdS|dvrdS||}|dS|dvr|S|dkrdS|dkr|dvrdSdS|dkr|dvrdSd S||jvr |j|Stjd |tt dS) Nnone)rhidden)Ngrooveridgeinsetoutsetsolidrwru)rtthinrvrqrzzUnhandled border style format:  stacklevel)_get_width_nameBORDER_STYLE_MAPwarningswarnrr )r0r'rr width_names r1rz!CSSToExcelConverter._border_styles" =U]}tv & & &6))%00  6 I I I  H  8 H  ---x%% H  ---x!> d+ + +(/ / M;%;;+--     6r3 width_inputc`||}|dkrdS|dkrdS|dkrdSdS)Ngh㈵>g?rgffffff@mediumthick)_width_to_float)r0rrs r1rz#CSSToExcelConverter._get_width_nameXsD$$[11 4<<4 S[[6 S[[8wr3floatc4|d}||S)N2pt) _pt_to_float)r0rs r1rz#CSSToExcelConverter._width_to_floatbs =E  '''r3 pt_stringstrct|dsJt|dS)Npt)endswithrrstrip)r0rs r1rz CSSToExcelConverter._pt_to_floatgs8!!$'''''Y%%d++,,,r3ch|d}|dvr||ddSdS)Nzbackground-color)N transparentrr)fgColor patternType)rr)r0r fill_colors r1rzCSSToExcelConverter.build_fillksFYY122 : : :#22:>>wWW W ; :r3rc|d}t|tr|ddn|}d|iS)Nz number-format§; format_code)rrrreplace)r0rfcs r1rz'CSSToExcelConverter.build_number_formatrsE YY ' '&0S&9&9 ARZZc " " "rr""r3$dict[str, bool | float | str | None]c ||}||}|r|dnd||||||||d|vrdndd|vpd||d||d S)Nr underlinesinglez line-throughr) namefamilysizerZrgrstrikershadow) _get_font_names_get_decoration_select_font_family_get_font_size _get_is_bold_get_is_italicrr _get_shadow)r0r font_names decorations r1rzCSSToExcelConverter.build_fontws))%00 ))%00 %/9JqMMT..z::''..%%e,,))%00&1Z&?&?((T%3<((7););<<&&u--   r3ch|d}|r|j|SdS)Nz font-weight)rBOLD_MAP)r0rweights r1rz CSSToExcelConverter._get_is_bolds6=))  -=$$V,, ,tr3ch|d}|r|j|SdS)Nz font-style)r ITALIC_MAP)r0r font_styles r1rz"CSSToExcelConverter._get_is_italics6YY|,,  3?&&z22 2tr3 Sequence[str]c\|d}||SdS)Nztext-decorationr9)rsplit)r0rrs r1rz#CSSToExcelConverter._get_decorations1YY011  !##%% %2r3c^d|vr(ttjd|dSdS)Nz text-shadowz ^[^#(]*[1-9])rresearchrs r1rzCSSToExcelConverter._get_shadows1 E ! ! .% 2FGGHH Htr3cptjd|dd}g}|D]}|dddkr|dddd}nA|dddkr|ddd d}n|}|r|||S) Nz(?x) ( "(?:[^"]|\\")+" | '(?:[^']|\\')+' | [^'",]+ )(?=,|\s*$) z font-familyri"z\"'z\')rfindallrrstripappend)r0rfont_names_tmprrs r1rz#CSSToExcelConverter._get_font_namess  IImR ( (    " ( (DBQBx3AbDz))%55bqbSAbDz))%55zz|| (!!$'''r3 float | Nonec^|d}||S||S)Nz font-size)rr)r0rrs r1rz"CSSToExcelConverter._get_font_sizes1yy%% <K  &&&r3rr+cPd}|D] }|j|}|rn!|Sr/) FAMILY_MAPr)r0rrrs r1rz'CSSToExcelConverter._select_font_familysD  D_((..F   r3r&c|dS||r||S |j|S#t$r.t jd|t tYnwxYwdS)NzUnhandled color format: r) _is_hex_color_convert_hex_to_excel NAMED_COLORSKeyErrorrrrr r0r&s r1rz"CSSToExcelConverter.color_to_excels ;4   c " " 3--c22 2 $S) )    M2322+--        ts =5A54A5 color_stringrcFt|dS)N#)r startswith)r0rs r1rz!CSSToExcelConverter._is_hex_colorsL++C00111r3c|d}||r5|ddz|ddzz|ddzzS|S)Nrrrjri)lstrip_is_shorthand_colorupperr0rcodes r1rz)CSSToExcelConverter._convert_hex_to_excelsm""3''  # #L 1 1 GaK$q'A+-Q! ;BBDD D::<< r3c|d}t|dkrdSt|dkrdStd|)zcCheck if color code is shorthand. #FFF is a shorthand as opposed to full #FFFFFF. rTFzUnexpected color )rlen ValueErrorr s r1rz'CSSToExcelConverter._is_shorthand_colorsV ""3'' t99>>4 YY!^^5???@@ @r3r/)r{r|r,r-)rrr,r)rrr,r)rrr,r)rrr,r|)rrr,r)rrr,r)r'r|rr|rr|r,r|)rr|r,r|)rr|r,r)rrr,r)rr)rrr,r)rrr,r)rrr,r)rrr,r)rrr,r+)r&r|r,r|)rrr,r)rrr,r)(r4r5r6__doc__rrrrrrr__annotations__r2rr~rrrrrrrrrrrrrrrrrrrrrrrrrr9r3r1rTrTms "L LH"J J  (%$$$AAAAA+--K////*.... 0     OOOO     7777r(((( ----XXXX####     $   4'''' "2222     A A A A A Ar3rTceZdZdZdZdZ d;dd&Zd?d)Zd=d*Zd@d+Z dAdBd:ZdS)CExcelFormattera> Class for formatting a DataFrame to a list of ExcelCells, Parameters ---------- df : DataFrame or Styler na_rep: na representation float_format : str, default None Format string for floating point numbers cols : sequence, optional Columns to write header : bool or sequence of str, default True Write out column names. If a list of string is given it is assumed to be aliases for the column names index : bool, default True output row names (index) index_label : str or sequence, default None Column label for index column(s) if desired. If None is given, and `header` and `index` are True, then the index names are used. A sequence should be given if the DataFrame uses MultiIndex. merge_cells : bool or 'columns', default False Format MultiIndex column headers and Hierarchical Rows as merged cells if True. Merge MultiIndex column headers only if 'columns'. .. versionchanged:: 3.0.0 Added the 'columns' option. inf_rep : str, default `'inf'` representation for np.inf values (which aren't representable in Excel) A `'-'` sign will be added in front of -inf. style_converter : callable, optional This translates Styler styles (CSS) into ExcelWriter styles. Defaults to ``CSSToExcelConverter()``. It should have signature css_declarations string -> excel style. This is only called for body cells. autofilter : bool, default False If True, add automatic filters to all columns. ii@rNTFinfna_repr float_formatr|colsSequence[Hashable] | NoneheaderSequence[Hashable] | boolindexr index_labelIndexLabel | None merge_cellsrinf_repstyle_converterrB autofilterr,r-c Vd|_||_t|ts?||_|j|j}| t} | |_nd|_d|_||_ |tt| |j stdtt| |j tt|krtd|||_ |j j |_ ||_||_||_||_t|t*s|dkrt-d|d||_| |_| |_dS)Nrz,passes columns are not ALL present dataframez.Not all names specified in 'columns' are found)columnsr:z!Unexpected value for merge_cells=.) rowcounterr,rrstyler_computedatarTr7dfr%r intersectionr:rsetreindexr-r2r3r0rr&r5r6r8) r0r@r,r-r.r0r2r3r5r6r7r8s r1r2zExcelFormatter.__init__s "i(( (DK K " " "B&"5"7"74CD DK#'D   uT{{// ;;<< OMNNN5;;++BJ7788CD NNJJOPPPjjj..DGw ( & +t,, F 1I1ID[DDDEE E& $r3clt|rtj|r|j}nht |rYtj|r|j}n=tj|r d|j}n|jt|j|z}t|ddtd|S)N-tzinfoz{Excel does not support datetimes with timezones. Please ensure that datetimes are timezone unaware before writing to Excel.) rrisnar,risposinf_scalarr6isneginf_scalarr-rgetattrr&rs r1 _format_valuezExcelFormatter._format_valueNs S>> 5gl3// 5+CC c]] 5&s++ 5l(-- 5($,((".D-344 3$ ' ' 3@   r3Iterable[ExcelCell]c#>K|jjdkr|jstd|js |jsdS|j}|jdv}||d}t|}d}d}|jr3t|j jtr|j jjdz }t|j D]\}}t|||dVtt||j|jd D]\}\}} } | | } |D]\\} } d \}}|r| dkr ||| z| z}}t)||| zdz| | dt+|jd d|| |j|| V]||_dS) Nriz]Writing to Excel with MultiIndex columns and no index ('index'=False) is not yet implemented.>Tr:Fsparsify include_namesrrJTstrictNN ctx_columns r$r%r&r'r=r?r@rAr(r))r:nlevelsr2NotImplementedError _has_aliasesr0r5 _format_multirrr@r enumeratenamesr"ziplevelscodestakerLr;rJr=r7r<)r0r: merge_columns level_strs level_lengths coloffsetlnumrspansr] level_codesvaluesispan_valr(r)s r1_format_header_miz ExcelFormatter._format_header_mi`s% < ! # #: )D ! T[  F,(,== **MQV*WW )*55   : 2*TW]J?? 2 -1I#GM22  JD$     3<  w~w}T J J J3 3    .D.5&+[[--F${{}}   8'1$ H JX\\+/Q1IJ"!A )q &t{M4HH "&"6)%          r3c #K|js|jr/d}|jr?d}t|jjt rt |jjj}|j}|jrtt|j|_t |jt |jkr:tdt |jdt |jd|j}t|D]A\}}t|j||z|dt|jddd||jV@dSdS)NrrizWriting z cols but got z aliasesrTr$r%r&r'r=r?r@rA)rXr0r2rr@rr%r[r:r rr&rZr;r<rJr=r7)r0rccolnamescolindexcolnames r1_format_header_regularz%ExcelFormatter._format_header_regularst     Iz 9 dgmZ889 #DGM$7 8 8I|H  '"8T[99 t{##s4<'8'888$>3t|#4#4>>#&t{#3#3>>> ;%.x%8%8  !'" 9,&t{M4HH$"&"6       '  $  r3ctjtr}n}d}jjjrdjjjDdgtjzz}tj dd|Dr+fdt|D}xj dz c_ tj||S)Nr9cg|]}||nd S)Nrr9rGxs r1 z1ExcelFormatter._format_header..s KKK! 112KKKr3rc |o|Sr/r9)rtys r1z/ExcelFormatter._format_header..s QW1r3c3"K|] }|dkV dS)rNr9rss r1 z0ExcelFormatter._format_header..s&6L6L1qBw6L6L6L6L6L6Lr3c3LK|]\}}tj||dVdSr/)r"r<)rGrnr&r0s r1rzz0ExcelFormatter._format_header..sK%#doxdCCr3ri)rr:rrjrpr@r2r[r%rreducerZr< itertoolschain)r0gengen2r$s` r1_format_headerzExcelFormatter._format_headers dlJ / / 0((**CC--//C$& 7=  %KKtw}7JKKKODL!!O""C 4 46L6L6L6L6LMM %)231$sD)))r3ct|jjtr|S|Sr/)rr@r2r_format_hierarchical_rows_format_regular_rowsr0s r1 _format_bodyzExcelFormatter._format_bodys< dgmZ 0 0 /1133 3,,.. .r3c #vK|js|jr|xjdz c_|jrs|jr@t |jt ttj tfr|jd}n@|jr"t |jtr|j}n|j jj d}t |jtr|xjdz c_|r%|jdurt!|jdz d|dV|j j}t |j jt"r|j j}t'|D]?\}}t)|j|zd|dt+|jdd|d|jV@d}nd}||Ed{VdS)NrirF ctx_indexrl)rXr0r<r2r3rrtuplenpndarrayrrr@r[r:rr"r to_timestamprZr;rJr=r7_generate_body)r0r3 index_valuesidxidxvalrcs r1rz#ExcelFormatter._format_regular_rowss   !  ! OOq OO :%  5J 4 E"B%% 5#.q1 ! 5j1A3&G&G 5". "gm1!4 $, 33 %1$ Kt{%77! 3Q TJJJJJ 7=L$'-55 <#w}99;; (66   V"#-&t{KFF"&"6       III&&y11111111111r3c#K|js|jr|xjdz c_d}|jr|jjj}|jr9t|jtttj tfr|j}t|j tr|xjdz c_tj|r:|jdur1t#|D]!\}}t%|jdz ||dV"|jrD|jdkr8|jjdd}t+|}t-||jjj|jjjdD]\}}} || |j|j} t| dt8r| } |D]d\} } d \} }| dkr|j| z| zdz } |}t?|j| z|| | dtA|j!d d| ||j"| | Ve|dz }nt-|jjd diD]}t#|D]h\}}t|t8r|}t?|j|z||dtA|j!d d|||j" Vi|dz }|#|Ed{VdS)NrirFr:TrNrQ) allow_fill fill_valuerSrrUrRrl)$rXr0r<r2r@r[r3rrrrrrr:rcom any_not_nonerZr"r5rYrr\r]r^r_ _can_hold_na _na_valuerrrLr;rJr=r7r)r0gcolidx index_labelscidxrrarbrer]rfrgrhrir(r) indexcolvalsr indexcolvals r1rz(ExcelFormatter._format_hierarchical_rowss   !  ! OOq OO :N !7=.L 0J 4 E"B%% 0 $/ $, 33 %1$. K4;e3K3K"+L"9"9KKJD$#DOa$7tTJJJJJJ; !D$4 $A$A!W]88!9 !2* = = 25!GM(GM' 333 ! !.E6; $[[##)#6#)#3)F "&)V447!'!4!4!6!6',{{}} 8/9, H#a<<)-1)'1%-       qLGGA !H%($Dt$D$D!!L,5l,C,C([%k6::E*5*B*B*D*DK* $# 5 ' +"&'.t{K'N'N$'$+*.*>       qLGG&&w///////////r3c*t|jS)z1Whether the aliases for column names are present.)r r0rs r1rXzExcelFormatter._has_aliasesTsDK(((r3rcr*c #"Ktt|jD]j}|jjdd|f}t |D]B\}}t |j|z||z|dt|j dd|||j VCkdS)Nctxrl) ranger%r:r@ilocrZr;r<rJr=r7)r0rccolidxseriesrhr&s r1rzExcelFormatter._generate_bodyYsC --..  FW\!!!V),F#F++  3"!+*&t{E4@@""&"6          r3c#Ktj||D]%}||j|_|V&dSr/)r}r~rrrKr&)r0cells r1get_formatted_cellsz"ExcelFormatter.get_formatted_cellsiseOD$7$7$9$94;L;L;N;NOO  D))$(33DHJJJJ  r3c|dkrtd|d}|dks|s0t|d\}}td|z|z}|dk.|0|S)a Convert 0-based column index to Excel column name. Parameters ---------- index : int The numeric column index to convert to an Excel column name. Returns ------- column_name : str The column name corresponding to the index. Raises ------ ValueError Index is negative rzIndex cannot be negative: rA)r&divmodchr)r0r2 column_name remainders r1 _num2excelzExcelFormatter._num2excelnsw& 199A%AABB B aii{i%eR00 E9b9n-- ;Kaii{ir3Sheet1rwriter)FilePath | WriteExcelBuffer | ExcelWriter sheet_namestartrowstartcol freeze_panestuple[int, int] | Noneenginestorage_optionsStorageOptions | None engine_kwargsr<c ddlm} |jj\} } | |jks | |jkr%t d| d| d|jd|j|jrd} d} | dkrd}n|jrd}t|jjtr*|j rt d|jjj dz }t|j tr1|j rt d|j j } |j j dz} nd}|||| z}||| z|z}||| z| z}|d |}nd }|i}|}t|| rd }n| |||| }d } ||||||||r|d Sd S#|r|wwxYw)a writer : path-like, file-like, or ExcelWriter object File path or existing ExcelWriter sheet_name : str, default 'Sheet1' Name of sheet which will contain DataFrame startrow : upper left cell row to dump data frame startcol : upper left cell column to dump data frame freeze_panes : tuple of integer (length 2), default None Specifies the one-based bottommost row and rightmost column that is to be frozen engine : string, default None write engine to use if writer is a path - you can also set this via the options ``io.excel.xlsx.writer``, or ``io.excel.xlsm.writer``. storage_options : dict, optional Extra options that make sense for a particular storage connection, e.g. host, port, username, password, etc. For HTTP(S) URLs the key-value pairs are forwarded to ``urllib.request.Request`` as header options. For other URLs (e.g. starting with "s3://", and "gcs://") the key-value pairs are forwarded to ``fsspec.open``. Please see ``fsspec`` and ``urllib`` for more details, and for more examples on storage options refer `here `_. engine_kwargs: dict, optional Arbitrary keyword arguments passed to excel engine. rrz-This sheet is too large! Your sheet size is: z, z Max sheet size is: rizwExcel filters merged cells by showing only the first row. 'autofilter' and 'merge_cells' cannot be used simultaneously.r:NF)rrrT)rrrautofilter_range)pandas.io.excelr r@shapemax_rowsmax_colsr&r8r2rrr5rVr:rr _write_cellsclose)r0rrrrrrrrr num_rowsnum_colsstartrowsoffset endrowsoffset indexoffsetstartautofilter_end_columnendrformatted_cells need_saves r1writezExcelFormatter.writesR 0/////!W]( dm # #x$-'?'?GGGHGG&*mGG7;}GG  ?& $OM1}}  ! dgmZ88@'@(6 '+gm&;a&? dlJ77 A' A(6 +/,*>(, (****,//// ,2,2,2,2\V0V0V0V0p)))X)  >#/3!15%)uuuuuuur3r*)8r' __future__rcollections.abcrrrrrrr}rtypingr r r rnumpyrpandas._libs.libr pandas.util._exceptionsr pandas.core.dtypesrpandas.core.dtypes.commonrrpandasrrrrrpandas.core.commoncorecommonrpandas.io.formats._color_datarpandas.io.formats.cssrrpandas.io.formats.formatrpandas._typingrrrrrr r"r;rTr*r9r3r1rs#"""""  ))))))444444&&&&&& ! 555555766666 ##"""""!!!!!!!!*KKKKK9KKK2CACACACACACACACAL LLLLLLLLLLr3