o gAq@s8dZddlmZddlmZddlZddlZddlmZm Z m Z m Z m Z m Z ddlZddlZddlmZddlmZmZddlmZdd lmZdd lmZmZdd lmZmZm Z m!Z!dd l"m#Z#ddl$m%m&Z'dd l(m)Z)ddl*m+Z+m,Z,ddl-m.Z.ddl/m0Z0GdddZ1GdddZ2GdddZ3dS)zC Utilities for conversion to writer-agnostic Excel representation. ) annotations)reduceN)CallableHashableIterableMappingSequencecast) is_list_like) IndexLabelStorageOptions)doc)missing)is_float is_scalar) DataFrameIndex MultiIndex PeriodIndex)generic) CSS4_COLORS) CSSResolver CSSWarning)get_level_lengths) pprint_thingc@s&eZdZdZeZ   d d d d ZdS) ExcelCellrowcolvalstyle mergestartmergeendNrintrr! int | Noner"cCs(||_||_||_||_||_||_dSNr)selfrrrr r!r"r'U/home/ubuntu/cloudmapper/venv/lib/python3.10/site-packages/pandas/io/formats/excel.py__init__8s   zExcelCell.__init__)NNN)rr#rr#r!r$r"r$)__name__ __module__ __qualname__ __fields__ __slots__r)r'r'r'r(r4src@sveZdZUdZeZdddddddZdddddddddddddd Zdddd Zd d d d dZ de d<d^d_ddZ e Z d`ddZdaddZdbd d!Zdcd"d#Zddd%d&Zded(d)Zdfd,d-Zdgd/d0Zdhd2d3Zdid5d6Zdjd7d8Zdkd:d;Zdld=d>Zddd?d@ZdddAdBZdmdDdEZdndGdHZdddIdJZdmdKdLZ dodNdOZ!dpdQdRZ"dqdTdUZ#drdXdYZ$dsdZd[Z%drd\d]Z&dS)tCSSToExcelConverteraK 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)r0ztext-topmiddlebaseliner2z text-bottomTF) boldbolder600700800900normallighter100200300400500)r;italicoblique)serifz sans-serifcursivefantasyzdict[str, str] | None inheritedN str | NonecCs"|dur |||_dSd|_dSr%) compute_cssrK)r&rKr'r'r(r)s zCSSToExcelConverter.__init__declarations_strstrreturndict[str, dict[str, str]]cCs|||j}||S)ax Convert CSS declarations to ExcelWriter style. Parameters ---------- declarations_str : str List of CSS declarations. e.g. "font-weight: bold; background: blue" Returns ------- xlstyle : dict A style as interpreted by ExcelWriter when found in ExcelCell.style. )rMrK build_xlstyle)r&rN propertiesr'r'r(__call__s zCSSToExcelConverter.__call__propsMapping[str, str]csH||||||||||d}dfdd ||S) N) alignmentborderfillfont number_formatddict[str, str]rPNonecsFt|D]\}}|dur||=qt|tr ||s ||=qdS)z4Remove key where value is None, through nested dictsN)listitems isinstancedict)r\kv remove_noner'r(rfs z6CSSToExcelConverter.build_xlstyle..remove_none)r\r]rPr^)build_alignment build_border build_fill build_fontbuild_number_format)r&rUoutr'rer(rRs  z!CSSToExcelConverter.build_xlstyledict[str, bool | str | None]cCs|d||||dS)Nz text-align) horizontalvertical wrap_text)get_get_vertical_alignment_get_is_wrap_textr&rUr'r'r(rgsz#CSSToExcelConverter.build_alignmentcC|d}|r |j|SdS)Nzvertical-align)rq VERTICAL_MAP)r&rUvertical_alignr'r'r(rr  z+CSSToExcelConverter._get_vertical_alignment bool | NonecCs"|ddur dSt|ddvS)Nz white-space)nowrapprezpre-line)rqboolrtr'r'r(rssz%CSSToExcelConverter._get_is_wrap_text dict[str, dict[str, str | None]]csfdddDS)Nc sPi|]$}|d|dd|dd|ddqS)zborder-z-stylez-widthz-color)r color) _border_stylerqcolor_to_excel).0siderUr&r'r( sz4CSSToExcelConverter.build_border..r0rightr2leftr'rtr'rr(rhs z CSSToExcelConverter.build_borderr widthcCs|dur |dur dS|dks|dkrdS||}|durdS|dvr%|S|dkr+dS|dkr7|dvr5dSdS|dkrC|dvrAdSd SdS) Nnonehidden)Ngrooveridgeinsetoutsetsoliddoubledotted)hairthinmediumDashDotDotdashed mediumDashed)_get_width_name)r&r r width_namer'r'r(rs( z!CSSToExcelConverter._border_style width_inputcCs2||}|dkr dS|dkrdS|dkrdSdS)Ngh㈵>g?rgffffff@mediumthick)_width_to_float)r&rrr'r'r(rs z#CSSToExcelConverter._get_width_namefloatcCs|durd}||S)N2pt) _pt_to_float)r&rr'r'r(rs z#CSSToExcelConverter._width_to_float pt_stringcCs|dsJt|dS)Npt)endswithrrstrip)r&rr'r'r(rsz CSSToExcelConverter._pt_to_floatcCs&|d}|dvr||ddSdS)Nzbackground-color)N transparentrr)fgColor patternType)rqr)r&rU fill_colorr'r'r(ris zCSSToExcelConverter.build_filldict[str, str | None]cCsd|diS)N format_codez number-format)rqrtr'r'r(rk z'CSSToExcelConverter.build_number_format*dict[str, bool | int | float | str | None]c Csv||}||}|r|dnd||||||||d|vr'dndd|vp-d||d||d S)Nr underlinesinglez line-throughr~) namefamilysizer5rBrstriker~shadow) _get_font_names_get_decoration_select_font_family_get_font_size _get_is_bold_get_is_italicrrq _get_shadow)r&rU font_names decorationr'r'r(rj#s   zCSSToExcelConverter.build_fontcCru)Nz font-weight)rqBOLD_MAP)r&rUweightr'r'r(r;rxz CSSToExcelConverter._get_is_boldcCru)Nz font-style)rq ITALIC_MAP)r&rU font_styler'r'r(rArxz"CSSToExcelConverter._get_is_italic Sequence[str]cCs|d}|dur |SdS)Nztext-decorationr')rqsplit)r&rUrr'r'r(rGs z#CSSToExcelConverter._get_decorationrcCsd|vrdSdS)Nrrr')r&rr'r'r(_get_underlineNsz"CSSToExcelConverter._get_underlinecCs d|vrttd|dSdS)Nz text-shadowz ^[^#(]*[1-9])r|researchrtr'r'r(rSszCSSToExcelConverter._get_shadowcCstd|dd}g}|D]3}|dddkr#|dddd}n|dddkr6|ddd d}n|}|rA||q|S) Nz(?x) ( "(?:[^"]|\\")+" | '(?:[^']|\\')+' | [^'",]+ )(?=,|\s*$) z font-familyrD"z\"'z\')rfindallrqreplacestripappend)r&rUfont_names_tmprrr'r'r(rXs   z#CSSToExcelConverter._get_font_names float | NonecCs |d}|dur |S||S)Nz font-size)rqr)r&rUrr'r'r(rrs  z"CSSToExcelConverter._get_font_sizer$cCs(d}|D] }|j|}|r|Sq|Sr%) FAMILY_MAPrq)r&rrrr'r'r(rxs z'CSSToExcelConverter._select_font_familyrcCsX|durdS||r||Sz|j|WSty+tdt|tYdSw)NzUnhandled color format: ) _is_hex_color_convert_hex_to_excel NAMED_COLORSKeyErrorwarningswarnreprrr&rr'r'r(rs    z"CSSToExcelConverter.color_to_excel color_stringr|cCst|dS)N#)r| startswith)r&rr'r'r(rrz!CSSToExcelConverter._is_hex_colorcCsD|d}||r|dd|dd|ddS|S)NrrrErD)lstrip_is_shorthand_colorupperr&rcoder'r'r(rs  (z)CSSToExcelConverter._convert_hex_to_excelcCs8|d}t|dkr dSt|dkrdStd|)zcCheck if color code is shorthand. #FFF is a shorthand as opposed to full #FFFFFF. rTFzUnexpected color )rlen ValueErrorrr'r'r(rs   z'CSSToExcelConverter._is_shorthand_colorr%)rKrL)rNrOrPrQ)rUrVrPrQ)rUrVrPrm)rUrVrPrL)rUrVrPry)rUrVrPr})r rLrrL)rrLrPrL)rrLrPr)rrOrPr)rUrV)rUrVrPr)rUrVrPr)rUrVrPr)rrrPrL)rUrVrPr)rPr$)rrLrPrL)rrOrPr|)rrOrPrO)'r*r+r,__doc__rrrvrrr__annotations__r)rrMrTrRrgrrrsrhrrrrrirkrjrrrrrrrrrrrrr'r'r'r(r/Isz           '             r/c@seZdZdZdZdZ         dd!d"Z d>d#d$Z d>d%d&Z d>d'd(Z d>d)d*Zd>d+d,Zed?d-d.Zd@d1d2Zd>d3d4Zeejd5d6 7 8 8   dAdBd:d;ZdS)CExcelFormattera9 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, default False Format MultiIndex and Hierarchical Rows as merged cells. 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. ii@rNTFinfna_reprO float_formatrLcolsSequence[Hashable] | NoneheaderSequence[Hashable] | boolindexr| index_labelIndexLabel | None merge_cellsinf_repstyle_converterCallable | Nonec Csd|_||_t|ts||_|j}| durt} | |_nd|_||_|durOt t | |j s4t dt t | |j t t|krHt d|j|d|_|jj |_ ||_||_||_||_||_| |_dS)Nrz,passes columns are not ALL present dataframez.Not all names specified in 'columns' are found)columns) rowcounterrrarstylerdatar/rdfrr intersectionrrsetreindexrrrrrr) r&rrrrrrrrrrr'r'r(r)s.     zExcelFormatter.__init__cCs ddidddddddddS) Nr5Trrr1r0)rnro)rZbordersrWr'r&r'r'r( header_styleszExcelFormatter.header_stylecCst|r t|r |j}n%t|r2t|r|j}nt|r&d|j}n |jdur2t |j|}t |dddur>t d|S)N-tzinfoz{Excel does not support datetimes with timezones. Please ensure that datetimes are timezone unaware before writing to Excel.) rrisnarrisposinf_scalarrisneginf_scalarrrgetattrrrr'r'r( _format_values   zExcelFormatter._format_valuerPIterable[ExcelCell]c csz|jjdkr|jstd|js|jsdS|j}|j|jddd}t|}d}d}|jr>t |j jt r>t |j jdd}|jrt |jD]\}}t||||jdVqFt t||j|jD]7\}\}}} || } |D]&\} } | dk} t||| d| | |j| r|nd| r|| | nddVqoq_n t t|D]\} } dtt| }t||| d||jVq||_dS) NrDz]Writing to Excel with MultiIndex columns and no index ('index'=False) is not yet implemented.Fsparsifyadjoinnamesrrrrr r.)rnlevelsrNotImplementedError _has_aliasesrformatrrrarrr enumerater rrziplevelscodestaker`joinmaprr)r&r level_strs level_lengths coloffsetlnumrspansr level_codesvaluesispan_valspans_multiple_cellsrdr'r'r(_format_header_misZ        z ExcelFormatter._format_header_miccs|js|jr]d}|jrd}t|jjtrt|jjd}|j}|jrHtt |j|_t|jt|jkrEt dt|jdt|jd|j}t |D]\}}t |j ||||jVqLdSdS)NrrDzWriting z cols but got z aliases)rrrrarrrrr rrrrrr)r&rcolnamescolindexcolnamer'r'r(_format_header_regularMs. z%ExcelFormatter._format_header_regularcstjtr }n}d}jjjrFddjjjDdgtj}t ddt dd|rFfdd t |D}j d 7_ t ||S) Nr'cSsg|] }|dur |ndqSNrr')rxr'r'r( nsz1ExcelFormatter._format_header..rcSs|o|Sr%r')r)yr'r'r(qz/ExcelFormatter._format_header..cSs|dkSr(r')r)r'r'r(r,qr-c3s&|]\}}tj||jVqdSr%)rrr)rr%rrr'r( ts  z0ExcelFormatter._format_header..rD)rarrr#r'rrr rrrrr itertoolschain)r&gengen2rr'rr(_format_headerfs     zExcelFormatter._format_headercCst|jjtr |S|Sr%)rarrr_format_hierarchical_rows_format_regular_rowsrr'r'r( _format_body{szExcelFormatter._format_bodyccs|js|jr|jd7_|jr|jr%t|jtttj t fr%|jd}n|jr2t|jt r2|j}n|j jj d}t|jtrF|jd7_|rY|jdurYt|jdd||jV|j j}t|j jtrj|j j}t|D]\}}t|j|d||jVqnd}nd}||EdHdS)NrDrF)rrrrrrar_tuplenpndarrayrrOrr rrrrr to_timestampr_generate_body)r&r index_valuesidxidxvalrr'r'r(r5s.    z#ExcelFormatter._format_regular_rowsc cs|js|jr|jd7_d}|jr|jjj}|jr)t|jtt t j t fr)|j}t|j tr9|jr9|jd7_tj|rX|jdurXt|D]\}}t|jd|||jVqG|jr|jjjdddd}t|}t||jjj|jjjD]@\}}} |j| |j|jd} |D](\} } | dk} t|j| || | |j| r|j| | dnd| r|nddVq|d7}qun#t|jjD]}t|D]\}}t|j||||jdVq|d7}q||EdHdS) NrDrFTr) allow_fill fill_valuerr )rrrrrr rrar_r7r8r9rrrrcom any_not_nonerrrrrrrrr _can_hold_na _na_valuer`r;)r&gcolidx index_labelscidxrrrrrrrr r!r" indexcolvalsr= indexcolvalr'r'r(r4sh     z(ExcelFormatter._format_hierarchical_rowscCs t|jS)z1Whether the aliases for column names are present.)r rrr'r'r(rs zExcelFormatter._has_aliasesrr#c cs|jdur d}n |jj}|sd}d}tt|jD]9}|jjdd|f}t|D](\}}|durGd dd|||fD}| |}t |j |||||Vq,qdS)N;css$|] \}}|dt|VqdS):N)rO)rardr'r'r(r.s"z0ExcelFormatter._generate_body..) r_computectxrangerrrilocrrrrr) r&rstylesxlstylecolidxseriesr rcssr'r'r(r;s    zExcelFormatter._generate_bodyccs4t||D] }||j|_|Vq dSr%)r/r0r3r6rr)r&cellr'r'r(get_formatted_cellss z"ExcelFormatter.get_formatted_cellsstorage_options)rXSheet1rr c Csddlm}|jj\} } | |jks| |jkr(td| d| d|jd|j|} t||r4d} n ||||d}d} z|j | ||||d W| rQ| d Sd S| rZ| ww) 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``, ``io.excel.xls.writer``, and ``io.excel.xlsm.writer``. .. deprecated:: 1.2.0 As the `xlwt `__ package is no longer maintained, the ``xlwt`` engine will be removed in a future version of pandas. {storage_options} .. versionadded:: 1.2.0 r) ExcelWriterz-This sheet is too large! Your sheet size is: z, z Max sheet size is: F)enginerXT)startrowstartcol freeze_panesN) pandas.io.excelrZrshapemax_rowsmax_colsrrWra write_cellsclose) r&writer sheet_namer\r]r^r[rXrZnum_rowsnum_colsformatted_cells need_saver'r'r(write s< &    zExcelFormatter.write) rNNTTNFrN)rrOrrLrrrrrr|rrrr|rrOrr)rPr)rPr|)rr#rPr)rYrrNNN)rXr )r*r+r,rrarbr)propertyrrr#r'r3r6r5r4rr;rWr r _shared_docsrkr'r'r'r(rsF  ,   8    &J   r)4r __future__r functoolsrr/rtypingrrrrrr rnumpyr8pandas._libs.libr pandas._typingr r pandas.util._decoratorsr pandas.core.dtypesrpandas.core.dtypes.commonrrpandasrrrr pandas.corerpandas.core.commoncorecommonrApandas.io.formats._color_datarpandas.io.formats.cssrrpandas.io.formats.formatrpandas.io.formats.printingrrr/rr'r'r'r(s2          _