pyjanitor icon indicating copy to clipboard operation
pyjanitor copied to clipboard

polars `xlsx_cells`

Open samukweku opened this issue 1 year ago • 1 comments

PR Description

Please describe the changes proposed in the pull request:

  • xlsx_cells now 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:

  1. [x] PR in from a fork off your branch. Do not PR from <your_username>:dev, but rather from <your_username>:<feature-branch_name>.
  1. [x] If you're not on the contributors list, add yourself to AUTHORS.md.
  1. [x] Add a line to CHANGELOG.md under 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

samukweku avatar May 01 '24 13:05 samukweku

🚀 Deployed on https://deploy-preview-1358--pyjanitor.netlify.app

ericmjl avatar May 01 '24 13:05 ericmjl