Файловый менеджер - Редактировать - /home/digitalm/venv/lib/python3.7/site-packages/pandas/io/excel/__pycache__/_odfreader.cpython-37.pyc
Назад
B �5�g� � @ s\ d dl mZ d dlZd dlmZmZmZ d dlm Z d dl Z d dl m Z G dd� de �ZdS )� )� annotationsN)�FilePathOrBuffer�Scalar�StorageOptions)�import_optional_dependency)�BaseExcelReaderc s� e Zd ZdZd+ddd�� fdd� Zedd � �Zdd �d d �Zed d�dd��Zedd�dd��Z dd�dd�Z d d�dd�Z dd d �d d �Z dd�d d!�Z dd�d"d#�Zdd�d$d%�Zdd&d �d'd(�Zd d�d)d*�Z� ZS ),� ODFReadera" Read tables out of OpenDocument formatted files. Parameters ---------- filepath_or_buffer : str, path to be parsed or an open readable stream. storage_options : dict, optional passed to fsspec for appropriate URLs (see ``_get_filepath_or_buffer``) Nr r )�filepath_or_buffer�storage_optionsc s t d� t� j||d� d S )NZodf)r )r �super�__init__)�selfr r )� __class__� �P/home/digitalm-up/venv/lib/python3.7/site-packages/pandas/io/excel/_odfreader.pyr s zODFReader.__init__c C s ddl m} |S )Nr )� OpenDocument)�odf.opendocumentr )r r r r r �_workbook_class% s zODFReader._workbook_class)r c C s ddl m} ||�S )Nr )�load)r r )r r r r r r � load_workbook+ s zODFReader.load_workbook�str)�returnc C s dS )z'Property for compat with other readers.� r )r r r r � empty_value0 s zODFReader.empty_valuez list[str]c C s& ddl m} | j�|�}dd� |D �S )z4Return a list of sheet names present in the documentr )�Tablec S s g | ]}|� d ��qS )�name)� getAttribute)�.0�tr r r � <listcomp>; s z)ODFReader.sheet_names.<locals>.<listcomp>)� odf.tabler �book�getElementsByType)r r �tablesr r r � sheet_names5 s zODFReader.sheet_names�int)�indexc C s* ddl m} | �|� | j�|�}|| S )Nr )r )r r Zraise_if_bad_sheet_by_indexr! r" )r r& r r# r r r �get_sheet_by_index= s z ODFReader.get_sheet_by_index)r c C s^ ddl m} | �|� | j�|�}x |D ]}|�d�|kr(|S q(W | �� td|� d���d S )Nr )r r zsheet z not found)r r Zraise_if_bad_sheet_by_namer! r" r �close� ValueError)r r r r# �tabler r r �get_sheet_by_nameD s zODFReader.get_sheet_by_name�boolzlist[list[Scalar]])� convert_floatr c s� ddl m}m}m} |� j}|� j}||h� |�|�}d} d} g } �x|D ]�} � fdd�| jD �} d}g }xn| D ]f}|j|kr�| �||�}n| j}| � |�}|| jkr�||7 }qp|� | jg| � d}|� |g| � qpW | t |�k r�t |�} | � | �}| � | ��r| |7 } qJ| � | jgg| � d} x t|�D ]}| �|� �q0W qJW x6| D ].}t |�| k �rN|� | jg| t |� � �qNW | S )z9 Parse an ODF Table into a list of lists r )�CoveredTableCell� TableCell�TableRowc s g | ]}|j � kr|�qS r )�qname)r �x)� cell_namesr r r f s z,ODFReader.get_sheet_data.<locals>.<listcomp>)r r. r/ r0 r1 r" � childNodes�_get_cell_valuer �_get_column_repeat�extend�len�_get_row_repeat� _is_empty_row�range�append)r Zsheetr- r. r/ r0 Zcovered_cell_nameZtable_cell_nameZ sheet_rowsZ empty_rowsZ max_row_lenr* Z sheet_rowZ sheet_cellsZ empty_cellsZ table_rowZ sheet_cell�valueZ column_repeatZ row_repeat�_�rowr )r3 r �get_sheet_dataQ sF zODFReader.get_sheet_datac C s" ddl m} t|j�|dfd��S )z� Return number of times this row was repeated Repeating an empty row appeared to be a common way of representing sparse rows in the table. r )�TABLENSznumber-rows-repeated� )�odf.namespacesrA r% � attributes�get)r r? rA r r r r9 � s zODFReader._get_row_repeatc C s" ddl m} t|j�|dfd��S )Nr )rA znumber-columns-repeatedrB )rC rA r% rD rE )r �cellrA r r r r6 � s z ODFReader._get_column_repeatc C s& x |j D ]}t|j �dkrdS qW dS )z4 Helper function to find empty rows r FT)r4 r8 )r r? �columnr r r r: � s zODFReader._is_empty_rowr c C s@ ddl m} t|�dkr tjS |j�|df�}|dkrJt|�dkrFdS dS |d krX| jS |d kr�t|j�|d f��}|r�t |�}||kr�|S |S |d kr�|j�|d f�}t|�S |d kr�| � |�S |d kr�|j�|d f�}t|�S |dk�r|j�|df�}t � |�S |dk�r&t � t|��}|� � S | �� td|� ���d S )Nr )�OFFICENSz#N/Az value-type�boolean�TRUETF�floatr= � percentage�string�currency�datez date-value�timezUnrecognized type )rC rH r �np�nanrD rE r rK r% �_get_cell_string_value�pd� to_datetimerP r( r) )r rF r- rH Z cell_typeZ cell_value�valZstampr r r r5 � sB zODFReader._get_cell_valuec C s� ddl m} ddlm} ddlm} |� j}g }xh|jD ]^}t||�r�|j|krvt |j � |dfd��}|� d| � q�|� | � |�� q8|� t|�� q8W d�|�S ) z� Find and decode OpenDocument text:s tags that represent a run length encoded sequence of space characters. r )�Element)�TEXTNS)�S�crB � r )Z odf.elementrW rC rX Zodf.textrY r1 r4 � isinstancer% rD rE r< rS r �join) r rF rW rX rY Ztext_sr= �fragment�spacesr r r rS � s z ODFReader._get_cell_string_value)N)�__name__� __module__� __qualname__�__doc__r �propertyr r r r$ r' r+ r@ r9 r6 r: r5 rS � __classcell__r r )r r r s = (r )� __future__r �numpyrQ Zpandas._typingr r r Zpandas.compat._optionalr ZpandasrT Zpandas.io.excel._baser r r r r r �<module> s
| ver. 1.4 |
Github
|
.
| PHP 8.3.23 | Генерация страницы: 0.03 |
proxy
|
phpinfo
|
Настройка