Pandas Extension Package used to read Excel files with limit rows
Project description
Description
Pandas Excel LimitedRows is a Python library used to optimize the Pandas's read_excel function, adding a max_row parameter if you need to read only the X first lines.
Installation
Use the package manager pip to install foobar.
pip install pandas-excel-limitedrows
Usage
import pandas_excel_limitedrows as pdlr
# Generate DataFrame with first 50 rows
df = pdlr.read_excel(file, max_rows=50)
# Instanciate ExcelFile with first 50 rows
excel_file = pdlr.RowLimitedExcelFile(file, max_rows=50)
Notes:
- If you use sheet_name as list to read more than one sheet, all dataframes will be generated with max_rows limit;
- All others pandas.read_excel() and pandas.ExcelFile() parameters can be used;
- This package uses Pandas, OpenpyXL, Pyxlsb and Xlrd dependencies and works these three engines.
Contributing
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
License
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Close
Hashes for pandas-excel-limitedrows-2.0.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | b3c060955b71e9f1c6f3262a10bbb64338d2dabe76788933fa52d075f18ab41d |
|
MD5 | 8a388e51ab846e9e1ee7dd7b301aae74 |
|
BLAKE2b-256 | ddf978078c17079a71db700bcbe1a3a3e8681673033003af449d60630d7cf045 |