semvec/pypi-packages huggingface dataset:
pandas-excel-limitrows-test2 1.0.0
Pandas Extension Package used to read Excel files with limit rows
License: MIT
Keywords: dev,web,pandas,excel,data science

# Description

Pandas Excel LimitRows 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](https://pip.pypa.io/en/stable/) to install foobar.

```bash
pip install pandas-excel-limitrows
```

## Usage

```python
import pandas-excel-limitrows 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
[MIT](https://choosealicense.com/licenses/mit/)