U
|
¬ý°dÕ ã @ sº U d dl mZ d dlmZmZmZmZmZmZm Z m
|
Z
|
m Z m Z d dl mZ d dlmZmZ erd dlmZ ee Ze deegef dZi Zded < d
|
d d d dZdFddddddZdd
|
dddZ dddddZ dd d d d Z e d d d!d"d#Z e d$d$d!d%d#Z e ddd!d&d#Z e d d d!d'd#Z d(d)d!d*d#Z e d+d,d-d.d/Z e d d0d-d1d/Z d2d3d-d4d/Z d5d6d7d8d9d:Z!d5d;d<d=d>d?Z"d@dAdAdBdCdDZ#dES )Gé )Ú annotations)
|
Ú TYPE_CHECKINGÚAnyÚCallableÚHashableÚIterableÚLiteralÚMutableMappingÚSequenceÚTypeVarÚoverload)Úimport_optional_dependency)Ú
|
is_integerÚ is_list_like)Ú ExcelWriterÚ usecols_func)Úboundz"MutableMapping[str, ExcelWriter_t]Ú_writersÚ ExcelWriter_tÚNone)ÚklassÚreturnc 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Ú
|
ValueErrorZ_enginer )r Ú engine_name© r úLd:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\pandas/io/excel/_util.pyÚregister_writer s
|
r ÚreaderÚstrz Literal[('reader', 'writer')])ÚextÚmoder c C s^ dddddd}ddddd}|dks*t |dkrRtd d
|
d }|rJd |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)ÚxlsxÚxlsmÚxlsbZxlsÚods)r" r# r$ r% )r Úwriterr& Ú
|
xlsxwriterÚwarn)Úerrorsr" N)ÚAssertionErrorr )r r! Z_default_readersZ_default_writersr' r r r Úget_default_engine0 s$ ûü r+ )r r c
|
C sD z
|
t | W S tk
|
r> } ztd| d|W 5 d }~X Y nX d S )NzNo Excel writer 'ú')r ÚKeyErrorr )r Úerrr r r Ú
|
get_writerY s
|
r/ Úint)Úxr c C sd d}| ¡ ¡ D ]J}t|}|tdk s4|tdkrBtd| |d | td d }q|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 )r1 ÚindexÚcÚcpr r r Ú
|
_excel2num` s r< z list[int])Úareasr c C s^ g }| d¡D ]J}d|krJ| d¡}| tt|d t|d d ¡ q| t|¡ q|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 r5 )ÚsplitÚextendÚranger< Úappend)r= ÚcolsÚrngZrngsr r r Ú _range2cols s
|
&rF zstr | list[int])Úusecolsr c C s d S ©Nr ©rG r r r Úmaybe_convert_usecols¡ s rJ z list[str]c C s d S rH r rI r r r rJ ¦ s c C s d S rH r rI r r r rJ « s c C s d S rH r rI r r r rJ ° s z1str | list[int] | list[str] | usecols_func | Nonez+None | list[int] | list[str] | usecols_funcc C s2 | dkr | S t | r tdt| tr.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 rF rI r r r rJ µ s ÿ
|
ztuple[int, int]z Literal[True])Ú freeze_panesr c C s d S rH r ©rL r r r Úvalidate_freeze_panesÔ s rN zLiteral[False]c C s d S rH r rM r r r rN Ù s ztuple[int, int] | NoneÚboolc C s6 | d k r2t | dkr*tdd | D r*dS tddS )Né c s s | ]}t |tV qd S rH )rK r0 )Ú.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 rM r r r rN Þ s ÿÿzlist[Hashable]z
|
list[bool]z!tuple[list[Hashable], list[bool]])ÚrowÚ control_rowr c C sf | d }t dt| D ]F}|| s*| | }| | dksB| | dkrL|| |< qd||< | | }q| |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 r5 Ú NF)rB rT )rV rW ÚlastÚir r r Úfill_mi_headerï s
|
|
r[ zint | Sequence[int]z&tuple[Hashable | None, list[Hashable]])rV Ú index_colr c C sp t |r t|tstt|}nt|tr.t|}| | }|dkrFdn|}|| 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.
|
rX Nr5 )r rK r r* Úmax)rV r\ rZ Ú header_namer r r Úpop_header_name s
|
r_ 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)ra rb Úresultr r r Úcombine_kwargs4 s
|
|
rf N)r )$Ú
|
__future__r Útypingr r r r r r r r
|
r r Zpandas.compat._optionalr Zpandas.core.dtypes.commonr r Zpandas.io.excel._baser Útyper Úobjectr r Ú__annotations__r r+ r/ r< rF rJ rN r[ r_ rf r r r r Ú<module> s> 0 ) ! #"
|
