Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

feat(python): Improve string → temporal parsing in read_excel and read_ods #20845

Merged
merged 1 commit into from
Jan 24, 2025

Conversation

alexander-beedie
Copy link
Collaborator

@alexander-beedie alexander-beedie commented Jan 22, 2025

Closes #20832.

  • Multiple improvements to parsing/loading Datetime, Date, and Time data from spreadsheets.
  • Added a new worksheet to the existing test files containing such data to ensure we have some coverage.

Note that we do not generate the other warnings mentioned - that is an upstream issue, and has been raised there.

@github-actions github-actions bot added enhancement New feature or an improvement of an existing feature python Related to Python Polars labels Jan 22, 2025
Copy link

codecov bot commented Jan 22, 2025

Codecov Report

Attention: Patch coverage is 74.69880% with 21 lines in your changes missing coverage. Please review.

Project coverage is 79.74%. Comparing base (6eafeb3) to head (ab2248b).
Report is 3 commits behind head on main.

Files with missing lines Patch % Lines
py-polars/polars/io/spreadsheet/functions.py 74.69% 12 Missing and 9 partials ⚠️
Additional details and impacted files
@@            Coverage Diff             @@
##             main   #20845      +/-   ##
==========================================
- Coverage   79.75%   79.74%   -0.01%     
==========================================
  Files        1566     1566              
  Lines      222536   222558      +22     
  Branches     2562     2572      +10     
==========================================
+ Hits       177475   177480       +5     
- Misses      44472    44486      +14     
- Partials      589      592       +3     

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

@alexander-beedie alexander-beedie marked this pull request as draft January 22, 2025 21:27
@alexander-beedie alexander-beedie marked this pull request as ready for review January 23, 2025 18:47
@alexander-beedie alexander-beedie changed the title feat(python): Improve internal string → date casts in read_excel feat(python): Improve internal string → temporal parsing in read_excel Jan 23, 2025
@alexander-beedie alexander-beedie changed the title feat(python): Improve internal string → temporal parsing in read_excel feat(python): Improve string → temporal parsing in read_excel Jan 23, 2025
@alexander-beedie alexander-beedie changed the title feat(python): Improve string → temporal parsing in read_excel feat(python): Improve string → temporal parsing in read_excel and read_ods Jan 23, 2025
@alexander-beedie alexander-beedie added the A-io-spreadsheet Area: reading/writing Excel/ODS files label Jan 23, 2025
@ritchie46 ritchie46 merged commit 88dd1e9 into pola-rs:main Jan 24, 2025
26 checks passed
@alexander-beedie alexander-beedie deleted the misc-excel-improvements branch January 24, 2025 08:29
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-io-spreadsheet Area: reading/writing Excel/ODS files enhancement New feature or an improvement of an existing feature python Related to Python Polars
Projects
None yet
Development

Successfully merging this pull request may close these issues.

read_excel warnings and errors (typing issues)
2 participants