Файловый менеджер - Редактировать - /home/digitalm/venv/lib/python3.7/site-packages/pandas/io/excel/__pycache__/_util.cpython-37.pyc
Назад
B �5�g| � @ s� U d dl mZ d dlmZmZ d dlmZ d dlmZm Z i Z de d< dd� Z d%d d �Z d d � Zddd�dd�Zddd�dd�Zdd� Zdd� Zdd � Zd d � Zd d d d!�d"d#�Zd$S )&� )� annotations)�Any�MutableMapping)�import_optional_dependency)� is_integer� is_list_likezMutableMapping[str, str]�_writersc C s" t | �std��| j}| t|< dS )z� Add engine to the excel writer registry.io.excel. You must use this method to integrate with ``to_excel``. Parameters ---------- klass : ExcelWriter z&Can only register callables as enginesN)�callable� ValueErrorZenginer )�klass� engine_name� r �K/home/digitalm-up/venv/lib/python3.7/site-packages/pandas/io/excel/_util.py�register_writer s r �readerc C s` dddddd�}dddddd�}|dks,t �|dkrTtd d d �}|rLd |d < || S || S d S )a� Return the default reader/writer for the given extension. Parameters ---------- ext : str The excel file extension for which to get the default engine. mode : str {'reader', 'writer'} Whether to get the default engine for reading or writing. Either 'reader' or 'writer' Returns ------- str The default engine for the extension. ZopenpyxlZpyxlsbZxlrdZodf)�xlsxZxlsmZxlsbZxlsZodsZxlwt)r �writerr � xlsxwriter�warn)�errorsr N)�AssertionErrorr )�ext�modeZ_default_readersZ_default_writersr r r r �get_default_engine" s" r c C sB yt | S tk r< } ztd| � d��|�W d d }~X Y nX d S )NzNo Excel writer '�')r �KeyErrorr )r �errr r r � get_writerL s r �str�int)�x�returnc C sh d}xZ| � � �� D ]J}t|�}|td�k s6|td�krDtd| � ���|d | td� d }qW |d S )ai Convert Excel column name like 'AB' to 0-based column index. Parameters ---------- x : str The Excel column name to convert to a 0-based column index. Returns ------- num : int The column index corresponding to the name. Raises ------ ValueError Part of the Excel column name was invalid. r �A�ZzInvalid column name: � � )�upper�strip�ordr )r �index�c�cpr r r � _excel2numS s r, z list[int])�areasr! c C sb g }xX| � d�D ]J}d|krL|� d�}|�tt|d �t|d �d �� q|�t|�� qW |S )a� Convert comma separated list of column names and ranges to indices. Parameters ---------- areas : str A string containing a sequence of column ranges (or areas). Returns ------- cols : list A list of 0-based column indices. Examples -------- >>> _range2cols('A:E') [0, 1, 2, 3, 4] >>> _range2cols('A,C,Z:AB') [0, 2, 25, 26, 27] �,�:r r% )�split�extend�ranger, �append)r- �cols�rngZrngsr r r � _range2colss s &r6 c C s2 | dkr | S t | �r td��t| t�r.t| �S | S )a Convert `usecols` into a compatible format for parsing in `parsers.py`. Parameters ---------- usecols : object The use-columns object to potentially convert. Returns ------- converted : object The compatible format of `usecols`. Nz}Passing an integer for `usecols` is no longer supported. Please pass in a list of int from 0 to `usecols` inclusive instead.)r r � isinstancer r6 )Zusecolsr r r �maybe_convert_usecols� s r8 c C s6 | d k r2t | �dkr*tdd� | D ��r*dS td��dS )N� c s s | ]}t |t�V qd S )N)r7 r )�.0�itemr r r � <genexpr>� s z(validate_freeze_panes.<locals>.<genexpr>TzLfreeze_panes must be of form (row, column) where row and column are integersF)�len�allr )Z freeze_panesr r r �validate_freeze_panes� s r? c C sj | d }xXt dt| ��D ]F}|| s,| | }| | dksD| | dkrN|| |< qd||< | | }qW | |fS )a� Forward fill blank entries in row but only inside the same parent index. Used for creating headers in Multiindex. Parameters ---------- row : list List of items in a single row. control_row : list of bool Helps to determine if particular column is in same parent index as the previous value. Used to stop propagation of empty cells between different indexes. Returns ------- Returns changed row and control_row r r% � NF)r2 r= )�rowZ control_row�last�ir r r �fill_mi_header� s rD c C sR t |�s |nt|�}| | }|dkr(dn|}|| d|� dg | |d d� fS )a� Pop the header name for MultiIndex parsing. Parameters ---------- row : list The data row to parse for the header name. index_col : int, list The index columns for our data. Assumed to be non-null. Returns ------- header_name : str The extracted header name. trimmed_row : list The original data row with the header name removed. r@ Nr% )r �max)rA Z index_colrC � header_namer r r �pop_header_name� s rG zdict[str, Any] | None�dict)� engine_kwargs�kwargsr! c C s$ | dkri }n| � � }|�|� |S )a Used to combine two sources of kwargs for the backend engine. Use of kwargs is deprecated, this function is solely for use in 1.3 and should be removed in 1.4/2.0. Also _base.ExcelWriter.__new__ ensures either engine_kwargs or kwargs must be None or empty respectively. Parameters ---------- engine_kwargs: dict kwargs to be passed through to the engine. kwargs: dict kwargs to be psased through to the engine (deprecated) Returns ------- engine_kwargs combined with kwargs N)�copy�update)rI rJ �resultr r r �combine_kwargs� s rN N)r )� __future__r �typingr r Zpandas.compat._optionalr Zpandas.core.dtypes.commonr r r �__annotations__r r r r, r6 r8 r? rD rG rN r r r r �<module> s * ! !
| ver. 1.4 |
Github
|
.
| PHP 8.3.23 | Генерация страницы: 0.06 |
proxy
|
phpinfo
|
Настройка