Файловый менеджер - Редактировать - /home/digitalm/venv/lib/python3.7/site-packages/pandas/tests/io/excel/__pycache__/test_openpyxl.cpython-37.pyc
Назад
B �5�g]) � @ s d dl mZ d dlZd dlZd dlZd dlZd dlmZ d dl m Z d dl m Z mZ e�d�Zej�ddg�Zdd � Zd d � Zej�d d dg�dd� �Zej�d d dg�dd� �Zej�dddgfddddgfg�dd� �Zej�dd d d d gfd d!d"gfg�d#d$� �Zej�d%d&d'd(g�d)d*� �Zd+d,� Zej�d-d dg�d.d/� �Z ej�d0d ej d1d!d d2gej d3d4d5d6gej d7d8d9d:gd;�fd d!d d2gd4d5d6gd8d9d:gd<�fg�ej�d=d>d?d@g�ej�d-d ddg�dAdB� ���Z dCdD� Z ej�d-d ddg�dEdF� �Z ej�d-d ddg�dGdH� �Z!dS )I� )�PathN)� DataFrame)� ExcelWriter�_OpenpyxlWriter�openpyxl�extz.xlsxc C s4 ddl m} ddd�ddddd�dd d �d d d d�d�ddiddd�d�}|�d�}|jd|d�}|j|jjd�}|j||||d�}|jdd d �}|jd d d�}|j d |d�} d} |j ddd�} t � |�} | d |ks�t �| d |ks�t �| d |ks�t �| d | k�s t �| d | k�s t �| d | k�s0t �d S ) Nr )�styles�00FF0000T)�color�boldZthin)�top�right�bottom�left�centerr )� horizontal�verticalZsolidZ006666FFg333333�?)�rgbZtint)Z patternTypeZfgColorZ format_codez0.00F)�lockedZhidden)�font�borders� alignment�fill� number_format� protection)r r )�styler �borderr r r r )r r �ColorZFontZSider Z BORDER_THINZBorderZ AlignmentZ PatternFillZ Protectionr �_convert_to_style_kwargs�AssertionError) r r ZhstyleZ font_colorr Zsider r Z fill_colorr r r �kw� r! �Y/home/digitalm-up/venv/lib/python3.7/site-packages/pandas/tests/io/excel/test_openpyxl.py� test_to_excel_styleconverter s. r# c C s� ddl m} d}dddii}dddii}|ddd |d �|ddd |d �g}dd d d�i}t�|�}|d }|ddddd|d�g} t�| ��l} t| ��,} | j||d� | j| |d� | j| } W d Q R X | d } | d }| j|ks�t �|j|ks�t �W d Q R X d S )Nr )� ExcelCellZ merge_styledr r r Z0000FF00� �* )�col�row�valr �c Z000000FFT)r r �pandas)r' r( r) Z mergestartZmergeendr )� sheet_nameZB1�A2) Zpandas.io.formats.excelr$ r r �tm� ensure_cleanZ write_cellsZsheetsr r )r r$ r, Zsty_b1Zsty_a2Z initial_cellsZ sty_mergedZ sty_kwargsZopenpyxl_sty_mergedZ merge_cells�path�writerZwksZxcell_b1Zxcell_a2r! r! r" � test_write_cells_merge_styled6 s( r2 � write_onlyTFc C sr d|i}t �| ��V}t�d�}t jt|d��2 t|fddi|���}t� �|� W d Q R X W d Q R X W d Q R X d S )Nr3 z Use of **kwargs is deprecated)�match�enginer ) r. r/ �re�escapeZassert_produces_warning� FutureWarningr r �to_excel)r r3 �kwargs�f�msgr1 r! r! r" � test_kwargsX s r= c C sH d|i}t �| ��,}t|d|d��}t� �|� W d Q R X W d Q R X d S )Nr3 r )r5 � engine_kwargs)r. r/ r r r9 )r r3 r> r; r1 r! r! r" �test_engine_kwargse s r? z mode,expected�w�baz�a�foo�barc C s� t dgdgd�}t�| ���}t�� }d|jd _d|jd d _|�d� d|jd d _|� |� t |d|d ��}|j |dd d � W d Q R X t� |�}d d � |jD �}||ks�t �x,t|�D ] \} } |j| d j| ks�t �q�W W d Q R X d S )Nr% rA )�columnsrC r �A1rD r )r5 �modeF)r, �indexc S s g | ] }|j �qS r! )�title)�.0Zsheetr! r! r" � <listcomp>� s z*test_write_append_mode.<locals>.<listcomp>)r r. r/ r ZWorkbookZ worksheetsrI �valueZ create_sheet�saver r9 � load_workbookr � enumerate) r rG �expected�dfr; �wbr1 Zwb2�resultrH Z cell_valuer! r! r" �test_write_append_modep s rT z#if_sheet_exists,num_sheets,expected�new� �apple�banana�replacer% �pearc C s t dddgi�}t ddgi�}t�| ���}|j|dddd� t|dd |d ��}|j|ddd � W d Q R X t�|�}t|j�|ks�t �|jd dks�t �t j |ddd �} t | d �|ks�t �t|j�dkr�t j ||jd dd �} t� | |� |�� W d Q R X d S )N�fruitrW rX rZ r rC F)r5 r, rH rB )r5 rG �if_sheet_exists)r, rH r )r5 rV r% )r r. r/ r9 r r rN �lenZ sheetnamesr �pd� read_excel�list�assert_frame_equal�close) r r\ Z num_sheetsrP �df1�df2r; r1 rR rS r! r! r" �!test_if_sheet_exists_append_modes� s" re zif_sheet_exists,msg)�invalidz['invalid' is not valid for if_sheet_exists. Valid options are 'error', 'new' and 'replace'.)�errorzASheet 'foo' already exists and if_sheet_exists is set to 'error'.)NzASheet 'foo' already exists and if_sheet_exists is set to 'error'.c C s� t ddgi�}t�| ��`}tjtt�|�d��@ |j|ddd� t |dd|d��}|j|dd � W d Q R X W d Q R X W d Q R X d S ) Nr[ rZ )r4 rC r )r5 rB )r5 rG r\ )r, ) r r. r/ �pytestZraises� ValueErrorr6 r7 r9 r )r r\ r< rQ r; r1 r! r! r" �test_if_sheet_exists_raises� s rj c C sz t �| ��f}tdt�ddd�i�}tdt�ddd�i�}tj||gdd�}|j�dd� �� � }|j |d d � W d Q R X d S ) N�Ar% � �B� )Zaxisc S s d| dk rdnd S )Nz color: %sr �red�blackr! )r) r! r! r" �<lambda>� � z4test_to_excel_with_openpyxl_engine.<locals>.<lambda>r )r5 ) r. r/ r �npZlinspacer^ �concatr ZapplymapZ highlight_maxr9 )r �filenamerc rd rQ �styledr! r! r" �"test_to_excel_with_openpyxl_engine� s rw � read_onlyc C sP | dddd| �}t j||d�}tj|dd�}|�� t�|�}t�||� d S )N�io�data�excelZtest1)rx r )r5 )r rN r^ r_ rb r. ra )�datapathr rx ru rR rS rP r! r! r" �test_read_workbook� s r} zheader, expected_datark � rm � � � �C� � � )�Titlez Unnamed: 1z Unnamed: 2)rk rm r� ru Zdimension_missingZdimension_smallZdimension_largec C sl | ddd|� |� ��}|d kr.t j||d�}n&tj||d�} t j| d|d�}| �� t|�} t�|| � d S )Nry rz r{ )�header)rx r )r5 r� )r^ r_ r rN rb r r. ra ) r| r r� Z expected_dataru rx �requestr0 rS rR rP r! r! r" � test_read_with_bad_dimension� s r� c C s� t � }t�| ���}|j|dd� t|dddd��}|�|� W d Q R X t|��� }|�d�}|�d|d �}|�d|d �}|dkr�|dks�t�W d Q R X d S ) Nr )r5 rB rU )rG r5 r\ s docProps/app.xmlr% ���) r r. r/ r9 r r � read_bytes�findr )r rQ r; r1 rz �first�second�thirdr! r! r" �test_append_mode_file s r� c C s� | dddd|� ��}|d kr(t �|�}n$tj||d�}t j|dd�}|�� ttjdd d d gtjd d ddgtjddddgd��}t� ||� d S )Nry rz r{ Zempty_trailing_rows)rx r )r5 rk r% rV r~ rm r r� r� r� r� r� r� )r� z Unnamed: 1z Unnamed: 2) r^ r_ r rN rb r rs �nanr. ra )r| r rx r� r0 rS rR rP r! r! r" �"test_read_with_empty_trailing_rows s r� c C sb | dddd|� ��}|d kr(t �|�}n$tj||d�}t j|dd�}|�� t� }t�||� d S )Nry rz r{ Zempty_with_blank_row)rx r )r5 )r^ r_ r rN rb r r. ra )r| r rx r0 rS rR rP r! r! r" � test_read_empty_with_blank_row+ s r� )"�pathlibr r6 �numpyrs rh r+ r^ r Zpandas._testingZ_testingr. Zpandas.io.excelr r Z importorskipr �markZ parametrizeZ pytestmarkr# r2 r= r? rT re rj rw r} r� r� r� r� r� r! r! r! r" �<module> sN !" $ $
| ver. 1.4 |
Github
|
.
| PHP 8.3.23 | Генерация страницы: 0.05 |
proxy
|
phpinfo
|
Настройка