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 another pd.read_excel() and pd.ExcelFile() parameters can be used;
- This package use Pandas and OpenpyXL dependencies and works only with openpyxl engine.
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
Built Distribution
Close
Hashes for pandas-excel-limitedrows-1.0.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 86a9bdd8b3dddeaf52446f1dbfd470739804f78f94f36e26ad0f1eab277a1ca9 |
|
MD5 | 84ad6e5e6780135b302c00433a5b1209 |
|
BLAKE2b-256 | 223432dc2b93964715b957257cd1edc2563f92a73a8217c38600ce12489e655b |
Close
Hashes for pandas_excel_limitedrows-1.0.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | df4b1c69f10a3b3c99e26b6633c44b45bb6e75a0399061294716b8d7f43ed7dd |
|
MD5 | 4491e8ea0446aede777eada5cc7226f5 |
|
BLAKE2b-256 | 68e144b11a5abd58f4cb0a1f4e0d07ccaf5e8d3854c8fd682a89044b23c5caa0 |