pyjanitor
pyjanitor copied to clipboard
polars `xlsx_cells`
PR Description
Please describe the changes proposed in the pull request:
xlsx_cellsnow supports polars.
jn.xlsx_cells('../Downloads/worked-examples.xlsx',engine='polars',sheetnames='highlights',fill=True).get_column('fill')
Out[101]:
shape: (8,)
Series: 'fill' [struct[3]]
[
{null,{"00000000","rgb",0.0},{"00000000","rgb",0.0}}
{null,{"00000000","rgb",0.0},{"00000000","rgb",0.0}}
{null,{"00000000","rgb",0.0},{"00000000","rgb",0.0}}
{null,{"00000000","rgb",0.0},{"00000000","rgb",0.0}}
{"solid",{"FFFFFF00","rgb",0.0},{"FFFFFF00","rgb",0.0}}
{"solid",{"FFFFFF00","rgb",0.0},{"FFFFFF00","rgb",0.0}}
{null,{"00000000","rgb",0.0},{"00000000","rgb",0.0}}
{null,{"00000000","rgb",0.0},{"00000000","rgb",0.0}}
]
This PR relates to #1352.
PR Checklist
Please ensure that you have done the following:
- [x] PR in from a fork off your branch. Do not PR from
<your_username>:dev, but rather from<your_username>:<feature-branch_name>.
- [x] If you're not on the contributors list, add yourself to
AUTHORS.md.
- [x] Add a line to
CHANGELOG.mdunder the latest version header (i.e. the one that is "on deck") describing the contribution.- Do use some discretion here; if there are multiple PRs that are related, keep them in a single line.
Automatic checks
There will be automatic checks run on the PR. These include:
- Building a preview of the docs on Netlify
- Automatically linting the code
- Making sure the code is documented
- Making sure that all tests are passed
- Making sure that code coverage doesn't go down.
Relevant Reviewers
Please tag maintainers to review.
- @ericmjl
🚀 Deployed on https://deploy-preview-1358--pyjanitor.netlify.app