Файловый менеджер - Редактировать - /home/digitalm/venv/lib/python3.7/site-packages/pandas/io/formats/__pycache__/excel.cpython-37.pyc
Назад
B �5�gAq � @ s8 d Z ddlmZ ddlmZ ddlZddlZddlmZm Z m Z m Z m Z m Z ddlZddlZddlmZ ddlmZmZ ddlmZ dd lmZ dd lmZm Z dd l m Z m Z m Z m!Z! dd l"m#Z# ddl$m% m&Z' dd l(m)Z) ddl*m+Z+m,Z, ddl-m.Z. ddl/m0Z0 G dd� d�Z1G dd� d�Z2G dd� d�Z3dS )zC Utilities for conversion to writer-agnostic Excel representation. � )� annotations)�reduceN)�Callable�Hashable�Iterable�Mapping�Sequence�cast)� is_list_like)� IndexLabel�StorageOptions)�doc)�missing)�is_float� is_scalar)� DataFrame�Index� MultiIndex� PeriodIndex)�generic)� CSS4_COLORS)� CSSResolver� CSSWarning)�get_level_lengths)� pprint_thingc @ s* e Zd ZdZeZdddddd�dd�ZdS ) � ExcelCell)�row�col�val�style� mergestart�mergeendN�intz int | None)r r r r! c C s( || _ || _|| _|| _|| _|| _d S )N)r r r r r r! )�selfr r r r r r! � r$ �M/home/digitalm-up/venv/lib/python3.7/site-packages/pandas/io/formats/excel.py�__init__8 s zExcelCell.__init__)NNN)�__name__� __module__� __qualname__Z __fields__� __slots__r& r$ r$ r$ r% r 4 s r c @ s e Zd ZU dZeZddddddd�Zdddddddddddddd� Zdddd �Zd d d d d�Z de d< d`dd�dd�Z e � Z ddd�dd�Zddd �d d �Zdd d �d d!�Zddd �d"d#�Zdd$d �d%d&�Zdd'd �d(d)�Zddd*�d+d,�Zddd-�d.d/�Zdd0d1�d2d3�Zdd0d4�d5d6�Zdd7�d8d9�Zdd:d �d;d<�Zdd=d �d>d?�Zdd$d �d@dA�Zdd$d �dBdC�Z ddDd �dEdF�Z dDddG�dHdI�Z dd$d �dJdK�Z ddDd �dLdM�Z ddNd �dOdP�Z!dQdR�dSdT�Z"dddU�dVdW�Z#ddXdY�dZd[�Z$dddY�d\d]�Z%ddXdY�d^d_�Z&dS )a�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__`. �top�center�bottom)r, ztext-top�middleZbaseliner. z text-bottomTF) �boldZbolderZ600Z700Z800Z900�normalZlighter�100Z200Z300Z400�500)r1 �italicZoblique� � � � )Zserifz sans-serifZcursiveZfantasyzdict[str, str] | None� inheritedNz str | None)r9 c C s |d k r| � |�| _nd | _d S )N)� compute_cssr9 )r# r9 r$ r$ r% r& � s z CSSToExcelConverter.__init__�strzdict[str, dict[str, str]])�declarations_str�returnc C s | � || 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. )r: r9 � build_xlstyle)r# r< � propertiesr$ r$ r% �__call__� s z CSSToExcelConverter.__call__zMapping[str, str])�propsr= c sN | � |�| �|�| �|�| �|�| �|�d�}ddd�� fdd� � � |� |S )N)� alignment�border�fill�fontZ number_formatzdict[str, str]�None)�dr= c sJ xDt | �� �D ]4\}}|dkr&| |= qt|t�r� |� |s| |= qW dS )z4Remove key where value is None, through nested dictsN)�list�items� isinstance�dict)rG �k�v)� remove_noner$ r% rN � s z6CSSToExcelConverter.build_xlstyle.<locals>.remove_none)�build_alignment� build_border� build_fill� build_font�build_number_format)r# rA �outr$ )rN r% r> � s z!CSSToExcelConverter.build_xlstylez dict[str, bool | str | None]c C s |� d�| �|�| �|�d�S )Nz text-align)� horizontal�vertical� wrap_text)�get�_get_vertical_alignment�_get_is_wrap_text)r# rA r$ r$ r% rO � s z#CSSToExcelConverter.build_alignmentc C s |� d�}|r| j� |�S d S )Nzvertical-align)rX � VERTICAL_MAP)r# rA Zvertical_alignr$ r$ r% rY � s z+CSSToExcelConverter._get_vertical_alignmentz bool | Nonec C s" |� d�d krd S t|d dk�S )Nz white-space)Znowrap�prezpre-line)rX �bool)r# rA r$ r$ r% rZ � s z%CSSToExcelConverter._get_is_wrap_textz dict[str, dict[str, str | None]]c s � �fdd�dD �S )Nc sP i | ]H}�� � �d |� d��� �d |� d������ �d |� d���d�|�qS )zborder-z-stylez-widthz-color)r �color)� _border_stylerX �color_to_excel)�.0Zside)rA r# r$ r% � <dictcomp>� s z4CSSToExcelConverter.build_border.<locals>.<dictcomp>)r, �rightr. �leftr$ )r# rA r$ )rA r# r% rP � s z CSSToExcelConverter.build_border)r �widthc C s� |d kr|d krd S |dks$|dkr(d S | � |�}|d kr>d S |dkrJ|S |dkrVdS |dkrn|dkrjdS dS |dkr�|dkr�dS d S d S ) N�noneZhidden)NZgrooveZridgeZinsetZoutset�solid�doubleZdotted)Zhair�thinZmediumDashDotDotZdashedZ mediumDashed)�_get_width_name)r# r re Z width_namer$ r$ r% r_ � s& z!CSSToExcelConverter._border_style)� width_inputr= c C s2 | � |�}|dk rd S |dk r"dS |dk r.dS dS )Ng�h㈵��>g�������?ri gffffff@ZmediumZthick)�_width_to_float)r# rk re r$ r$ r% rj s z#CSSToExcelConverter._get_width_name�float)re r= c C s |d kr d}| � |�S )NZ2pt)� _pt_to_float)r# re r$ r$ r% rl s z#CSSToExcelConverter._width_to_float)� pt_stringr= c C s |� d�st�t|�d��S )N�pt)�endswith�AssertionErrorrm �rstrip)r# ro r$ r$ r% rn s z CSSToExcelConverter._pt_to_float)rA c C s& |� d�}|dkr"| �|�dd�S d S )Nzbackground-color)N� transparentrf rg )ZfgColorZ patternType)rX r` )r# rA Z fill_colorr$ r$ r% rQ s z CSSToExcelConverter.build_fillzdict[str, str | None]c C s d|� d�iS )NZ format_codez number-format)rX )r# rA r$ r$ r% rS s z'CSSToExcelConverter.build_number_formatz*dict[str, bool | int | float | str | None]c C sv | � |�}| �|�}|r |d nd | �|�| �|�| �|�| �|�d|krNdnd d|kpZd | �|�d��| �|�d� S )Nr � underline�singlez line-throughr^ ) �name�family�sizer0 r4 ru �striker^ Zshadow) �_get_font_names�_get_decoration�_select_font_family�_get_font_size� _get_is_bold�_get_is_italicr` rX � _get_shadow)r# rA � font_names� decorationr$ r$ r% rR # s z CSSToExcelConverter.build_fontc C s |� d�}|r| j� |�S d S )Nz font-weight)rX �BOLD_MAP)r# rA �weightr$ r$ r% r ; s z CSSToExcelConverter._get_is_boldc C s |� d�}|r| j� |�S d S )Nz font-style)rX � ITALIC_MAP)r# rA Z font_styler$ r$ r% r� A s z"CSSToExcelConverter._get_is_italicz Sequence[str]c C s" |� d�}|d k r|�� S dS d S )Nztext-decorationr$ )rX �split)r# rA r� r$ r$ r% r| G s z#CSSToExcelConverter._get_decoration)r� r= c C s d|kr dS d S )Nru rv r$ )r# r� r$ r$ r% �_get_underlineN s z"CSSToExcelConverter._get_underlinec C s d|kr t t�d|d ��S d S )Nz text-shadowz ^[^#(]*[1-9])r] �re�search)r# rA r$ r$ r% r� S s z CSSToExcelConverter._get_shadowc C s� t �d|�dd��}g }xn|D ]f}|d d� dkrH|dd� �dd�}n.|d d� dkrn|dd� �d d�}n|�� }|r |�|� q W |S ) Nz�(?x) ( "(?:[^"]|\\")+" | '(?:[^']|\\')+' | [^'",]+ )(?=,|\s*$) z font-family� r5 �"���z\"�'z\')r� �findallrX �replace�strip�append)r# rA Zfont_names_tmpr� rw r$ r$ r% r{ X s z#CSSToExcelConverter._get_font_namesz float | Nonec C s |� d�}|d kr|S | �|�S )Nz font-size)rX rn )r# rA ry r$ r$ r% r~ r s z"CSSToExcelConverter._get_font_sizez int | None)r= c C s( d }x |D ]}| j �|�}|r P q W |S )N)� FAMILY_MAPrX )r# r� rx rw r$ r$ r% r} x s z'CSSToExcelConverter._select_font_family)r r= c C sZ |d kr d S | � |�r | �|�S y | j| S tk rT t�dt|�� �t� Y nX d S )NzUnhandled color format: )� _is_hex_color�_convert_hex_to_excel� NAMED_COLORS�KeyError�warnings�warn�reprr )r# r r$ r$ r% r` � s z"CSSToExcelConverter.color_to_excelr] )� color_stringr= c C s t |�d��S )N�#)r] � startswith)r# r� r$ r$ r% r� � s z!CSSToExcelConverter._is_hex_colorc C sH |� d�}| �|�r<|d d |d d |d d �� S |�� S d S )Nr� r r6 r5 )�lstrip�_is_shorthand_color�upper)r# r� �coder$ r$ r% r� � s (z)CSSToExcelConverter._convert_hex_to_excelc C s< |� d�}t|�dkrdS t|�dkr*dS td|� ���dS )zcCheck if color code is shorthand. #FFF is a shorthand as opposed to full #FFFFFF. r� � T� FzUnexpected color N)r� �len� ValueError)r# r� r� r$ r$ r% r� � s z'CSSToExcelConverter._is_shorthand_color)N)'r' r( r) �__doc__r r� r[ r� r� r� �__annotations__r& r r: r@ r> rO rY rZ rP r_ rj rl rn rQ rS rR r r� r| r� r� r{ r~ r} r` r� r� r� r$ r$ r$ r% r+ I sp ' r+ c @ s� e Zd ZdZdZdZd4d d d d d dd d dd� dd�Zedd� �Zdd� Z dd�dd�Z dd�dd �Z dd�d d �Z dd�d d �Z dd�d!d"�Zdd�d#d$�Zed d�d%d&��Zd'dd(�d)d*�Zdd�d+d,�Zeejd- d.�d5d1d.�d2d3��ZdS )6�ExcelFormattera9 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. i i @ r� NTF�infr; z str | NonezSequence[Hashable] | NonezSequence[Hashable] | boolr] zIndexLabel | NonezCallable | None) �na_rep� float_format�cols�header�index� index_label� merge_cells�inf_rep�style_converterc C s� d| _ || _t|t�s8|| _|j}| d kr0t� } | | _nd | _|| _|d k r�t t |�� |j ��sht d��t t |�� |j ��t t|��kr�t d��|j|d�| _| jj | _ || _|| _|| _|| _|| _| | _d S )Nr z,passes columns are not ALL present dataframez.Not all names specified in 'columns' are found)�columns)� rowcounterr� rJ r �styler�datar+ r� �dfr� r � intersectionr� r� �setZreindexr� r� r� r� r� r� ) r# r� r� r� r� r� r� r� r� r� r� r$ r$ r% r& � s. zExcelFormatter.__init__c C s ddiddddd�ddd�d�S ) Nr0 Tri )r, rc r. rd r- r, )rU rV )rE ZbordersrB r$ )r# r$ r$ r% � header_style� s zExcelFormatter.header_stylec C s� t |�rt�|�r| j}nJt|�rdt�|�r4| j}n0t�|�rLd| j� �}n| jd k rdt | j| �}t |dd �d k r|t d��|S )N�-�tzinfoz{Excel does not support datetimes with timezones. Please ensure that datetimes are timezone unaware before writing to Excel.) r r Zisnar� r Zisposinf_scalarr� Zisneginf_scalarr� rm �getattrr� )r# r r$ r$ r% � _format_value s z ExcelFormatter._format_valuezIterable[ExcelCell])r= c c s� | j jdkr| jstd��| js*| js*d S | j }|j| jddd�}t|�}d}d}| jrzt | j jt �rzt | j jd �d }| j�r@x*t |j�D ] \}}t|||| jd�V q�W x�t t||j|j��D ]v\}\}}} |�| �} x\|�� D ]P\} } | dk} t||| d | | | j| �r|nd | �r,|| | nd d�V q�W q�W nFxDt t|� �D ]4\} } d�tt| ��}t||| d || j�V �qNW || _d S ) Nr5 z]Writing to Excel with MultiIndex columns and no index ('index'=False) is not yet implemented.F)�sparsify�adjoin�namesr )r r r r )r r r r r r! �.)r� Znlevelsr� �NotImplementedError� _has_aliasesr� �formatr� r rJ r� r r� � enumerater� r r� �zip�levels�codes�takerI �join�mapr r� )r# r� � level_strs� level_lengths� coloffset�lnumrw �spansr� � level_codes�values�i�span_val�spans_multiple_cellsrM r$ r$ r% �_format_header_mi sJ & z ExcelFormatter._format_header_mic c s� | j s | jr�d}| jr8d}t| jjt�r8t| jjd �}| j}| j r�tt | j�| _t| j�t| j�kr�t dt| j�� dt| j�� d���n| j}x,t |�D ] \}}t | j || || j�V q�W d S )Nr r5 zWriting z cols but got z aliases)r� r� r� rJ r� r r� r� r r r� r� r r� r� )r# r� Zcolnames�colindexZcolnamer$ r$ r% �_format_header_regularM s "z%ExcelFormatter._format_header_regularc s� t � jt�r� �� }n� �� }d}� jjjr�dd� � jjjD �dgt� j� }t dd� t dd� |��r�� fdd �t |�D �}� j d 7 _ t �||�S ) Nr$ c S s g | ]}|d k r|nd�qS )Nr� r$ )ra �xr$ r$ r% � <listcomp>n s z1ExcelFormatter._format_header.<locals>.<listcomp>r� c S s | o|S )Nr$ )r� �yr$ r$ r% �<lambda>q � z/ExcelFormatter._format_header.<locals>.<lambda>c S s | dkS )Nr� r$ )r� r$ r$ r% r� q r� c 3 s$ | ] \}}t � j||� j�V qd S )N)r r� r� )ra r� r )r# r$ r% � <genexpr>u s z0ExcelFormatter._format_header.<locals>.<genexpr>r5 )rJ r� r r� r� r� r� r� r� r r� r� r� � itertools�chain)r# �genZgen2r r$ )r# r% �_format_headerf s z ExcelFormatter._format_headerc C s" t | jjt�r| �� S | �� S d S )N)rJ r� r� r �_format_hierarchical_rows�_format_regular_rows)r# r$ r$ r% � _format_body{ s zExcelFormatter._format_bodyc c s | j s | jr| jd7 _| j�r| jrJt| jtttj t f�rJ| jd }n(| jrdt| jt �rd| j}n| j jj d }t| jt�r�| jd7 _|r�| jdk r�t| jd d|| j�V | j j}t| j jt�r�| j j�� }x,t|�D ] \}}t| j| d|| j�V q�W d}nd}| �|�E d H d S )Nr5 r F)r� r� r� r� r� rJ rH �tuple�np�ndarrayr r; r� r� r� r r r� r Z to_timestampr� �_generate_body)r# r� Z index_values�idxZidxvalr� r$ r$ r% r� � s* z#ExcelFormatter._format_regular_rowsc c s� | j s | jr| jd7 _d}| j�r�| jjj}| jrRt| jtt t j t f�rR| j}t| j t�rr| jrr| jd7 _tj|� r�| jdk r�x,t|�D ] \}}t| jd ||| j�V q�W | j�r�| jjjdddd�}t|�}x�t|| jjj| jjj�D ]�\}}} |j| |j|j d�} xb|� � D ]V\} } | dk} t| j| || | | j| �rX| j| | d nd | �rd|nd d�V �qW |d7 }q�W nRxPt| jj� D ]@}x0t|�D ]$\}}t| j| ||| jd�V �q�W |d7 }�q�W | � |�E d H d S ) Nr5 r FT)r� r� r� )Z allow_fillZ fill_value)r r r r r r! )r r r r ) r� r� r� r� r� r� r� rJ rH r� r� r� r r� r r� �comZ any_not_noner� r r� r� r r� r� r� r� Z _can_hold_naZ _na_valuerI r� )r# ZgcolidxZ index_labelsZcidxrw r� r� r� r� r� r� r� r� r� Z indexcolvalsr� Z indexcolvalr$ r$ r% r� � sV z(ExcelFormatter._format_hierarchical_rowsc C s t | j�S )z1Whether the aliases for column names are present.)r r� )r# r$ r$ r% r� � s zExcelFormatter._has_aliasesr" )r� r= c c s� | j d krd }n| j �� j}|s$d }d }x�tt| j��D ]v}| jjd d �|f }x\t|�D ]P\}}|d k r�d� dd� |||f D ��}| � |�}t | j | || ||�V qZW q8W d S )N�;c s s" | ]\}}|d t |� V qdS )�:N)r; )ra �arM r$ r$ r% r� s z0ExcelFormatter._generate_body.<locals>.<genexpr>) r� Z_compute�ctx�ranger� r� r� Zilocr� r� r� r r� ) r# r� �stylesZxlstyleZcolidxZseriesr� r �cssr$ r$ r% r� � s z ExcelFormatter._generate_bodyc c s6 x0t �| �� | �� �D ]}| �|j�|_|V qW d S )N)r� r� r� r� r� r )r# �cellr$ r$ r% �get_formatted_cells s z"ExcelFormatter.get_formatted_cells�storage_options)r� �Sheet1r r c C s� ddl m} | jj\} } | | jks,| | jkrPtd| � d| � d| j� d| j� ���| �� } t||�rhd} n||||d�}d} z|j | ||||d � W d | r�|� � X d S ) 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 <https://pypi.org/project/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)�enginer� T)�startrow�startcol� freeze_panesN) Zpandas.io.excelr� r� �shape�max_rows�max_colsr� r� rJ Z write_cells�close) r# �writerZ sheet_namer� r� r� r� r� r� Znum_rowsZnum_colsZformatted_cellsZ need_saver$ r$ r% �write s( & " zExcelFormatter.write) r� NNTTNFr� N)r� r r NNN)r' r( r) r� r� r� r& �propertyr� r� r� r� r� r� r� r� r� r� r� r r Z _shared_docsr r$ r$ r$ r% r� � s< ! 8&J r� )4r� � __future__r � functoolsr r� r� �typingr r r r r r r� �numpyr� Zpandas._libs.libr Zpandas._typingr r Zpandas.util._decoratorsr Zpandas.core.dtypesr Zpandas.core.dtypes.commonr r Zpandasr r r r Z pandas.corer Zpandas.core.common�core�commonr� Z pandas.io.formats._color_datar Zpandas.io.formats.cssr r Zpandas.io.formats.formatr Zpandas.io.formats.printingr r r+ r� r$ r$ r$ r% �<module> s0 _
| ver. 1.4 |
Github
|
.
| PHP 8.3.23 | Генерация страницы: 0.06 |
proxy
|
phpinfo
|
Настройка